I have managed to get the following information out of the JSON array. Does anyone know how I can then get "Bronze Level" from the following array....
thanks for you help
Paul
I have managed to get the following information out of the JSON array. Does anyone know how I can then get "Bronze Level" from the following array....
thanks for you help
Paul
Paul.
I don't know why you have both "answer .17" and "answer.1".
Without seeing the complete json it's really hard to figure out. So I'll hazard a guess and you can see how it works.
JSONGetElement ( Jotform::APIresponse ;
"content[0].answer.17.name
In the content[0] array in the first element of the array
get subelement answer - if this were an array answer[17]
get subelement 17 - This looks wrong because it seems unlikely you have a table name 17.
get subelement name
I suggest using the JSONFormatElement() command on the JSON data so you can properly see how it is nested.
Possibly?:
JSONGetElement ( Jotform::APIresponse ;
"content[0].answer.name
You should be able to add ".name" to what you have.
Seeing all the JSON would be helpful.
ch0c0halic there seems to be "answers" and "answer". Not a great naming system but they do appear to be separate things in the JSON.
Thank you - how do I post directly there in future? Thanks
I worked it out thanks for the help - I just needed to nest JSON Get Elements as there was a 2nd string in the original string.
You wouldn't need nest the function, add path.
"content[0].answers.17.answer.1.name"
Please mark your answer as correct, so we know what you did to solve the problem!
Beverly
musicteacher:
I'm going to move this thread from the FileMaker Community Feedback Space (which is specifically for input on the Community itself) to the Discussions Space where you might receive more views and potentially more feedback on this topic!
TSPigeon
FileMaker, Inc.