Re: Extracting JSON Arrays from inside Json Objects

2016-07-18 Thread Sannyasin Brahmanathaswami
hmm… the introduction of that left bracket was a typo… I don't know enough about this to insist on anything (hehe) just feeling my way. On 7/18/16, 9:59 AM, "use-livecode on behalf of Mark Wieder" wrote: Sannyasin Brahmanathaswami writes: > so this would translated into, using y

Re: Extracting JSON Arrays from inside Json Objects

2016-07-18 Thread Mark Wieder
Sannyasin Brahmanathaswami writes: > so this would translated into, using your model > > {"file_id": "p6_rajam", > "formats": [ > { >"2531x4000": { > "filename": "p6_rajam_ful.jpg", > "isbn": null, > "item_format_id": 43430, >

Re: Extracting JSON Arrays from inside Json Objects

2016-07-15 Thread Sannyasin Brahmanathaswami
mark wrote: BR: I actually think I like using a nested object M: Right. I wasn't suggesting *not* using a nested object, just changing the format slightly: { "file_id": "gr_1999-01-11_the-path-to-god", "file_size": null, "file_type": null, "format": n

Re: Extracting JSON Arrays from inside Json Objects

2016-07-15 Thread Mark Wieder
On 07/15/2016 11:28 AM, Sannyasin Brahmanathaswami wrote: I actually think I like using a nested object Right. I wasn't suggesting *not* using a nested object, just changing the format slightly: { "file_id": "gr_1999-01-11_the-path-to-god", "file_size": null, "file_type"

Re: Extracting JSON Arrays from inside Json Objects

2016-07-15 Thread Sannyasin Brahmanathaswami
We do have control over the formation of the JSON, which is done by our web server API. for every media item record in the "item" table, there is a corresponding series of records in the "item_formats" table. So the JSON is returning the values for all the records in the item_formats table that

Re: Extracting JSON Arrays from inside Json Objects

2016-07-15 Thread Mark Wieder
Sannyasin Brahmanathaswami writes: > Thanks Peter.. I get it… I think… In the following we actually have a nested object. Hence the need to use [1]. Exactly. Although the [1] is not because it's a nested object, but because it's (in this case) a collection of one nested JSON object. You have se

Re: Extracting JSON Arrays from inside Json Objects

2016-07-15 Thread Sannyasin Brahmanathaswami
aLiveCodeArray["formats"][1]["filename"] Peter Thanks Peter.. I get it… I think… In the following we actually have a nested object. Hence the need to use [1]. As per the JSON "rules" for what an array may contain An array is an ordered collection of

Re: Extracting JSON Arrays from inside Json Objects

2016-07-14 Thread Peter TB Brett
On 15/07/2016 06:28, Sannyasin Brahmanathaswami wrote: aLiveCodeArray["formats"]["filename"] would be my expectation; but that is empty aLiveCodeArray["formats"][1]["filename"] Peter -- Dr Peter Brett LiveCode Technical Project Manager LiveCode 2

Re: Extracting JSON Arrays from inside Json Objects

2016-07-14 Thread stephen barncard
On Thu, Jul 14, 2016 at 10:28 PM, Sannyasin Brahmanathaswami < bra...@hindu.org> wrote: > aLiveCodeArray["formats"]["filename"] would be my expectation; but that > is empty > lose the quotes on array keys? Stephen Barncard - Sebastopol Ca. USA - mixstream.org ___