fineas

Problem Parsing JSON from Dropbox

Discussion created by fineas on Jun 25, 2017
Latest reply on Jun 26, 2017 by beverly

Hi All,

 

I am a novice when it comes to working with JSON.  I didn't even know what it was two weeks ago.  However, I have been learning what I can and am experimenting with the Dropbox API.

 

Through much trial and error, I have been able to connect and use the list_folder function to get back a JSON response.  I am able to parse most of it using Filemaker 16's new functions.    However one of the keys begins with a dot ".".   Specifically, it is ".tag" which returns as values either "file" or "folder".   The dot is throwing me off.  None of their other keys has this dot.    How would I write the JSONGetElement step to retrieve a value where the key is ".tag"?   Why would they use the "dot" in the first place?

 

To get the other values, I am using, for example-   JSONGetElement ( $$JSON ; "entries[1].name" ).   

 

JSONGetElement ( $$JSON ; "entries[1]..tag" )  does not work.

 

I would greatly appreciate anyone's help with this.

Outcomes