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 
<4d_tech@lists.4d.com<mailto:4d_tech@lists.4d.com>>のメール:

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:4d_tech-unsubscr...@lists.4d.com
**********************************************************************

Reply via email to