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.