you are confusing property names and array positions.
$lastName:=$convertedObject[“ID”][“6015906”][“Last Name”]
this would infer
{"ID":{"6015906":{"Last Name":__here_}}}
if the target is
[
[ID,First Name,Last Name],
[5912029,Sannyasin,Siddhanathaswami],
[6015906,Mayuran,Sokkan]
]
then the notation should be
$convertedObject[2][2] //Sokkan
2018/11/26 17:39、Sannyasin Siddhanathaswami via 4D_Tech
<[email protected]<mailto:[email protected]>>のメール:
It’s a JSON array of arrays from the Google Sheet that has the headers in the
first “row” of the array "values[0]”:
[
[ID,First Name,Last Name],
[5912029,Sannyasin,Siddhanathaswami],
[6015906,Mayuran,Sokkan]
]
My goal is to be able to reference this new object by doing something like:
$lastName:=$convertedObject[“ID”][“6015906”][“Last Name”]
I don’t really know what I’m doing. Would that even work?
**********************************************************************
4D Internet Users Group (4D iNUG)
Archive: http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub: mailto:[email protected]
**********************************************************************
