jsonxmlfilemaker

How to parse JSON response in filemaker script

I am calling a rest api through filemaker script 'insert from url' . I am getting an xml response in browser but json response in my filemaker record. How is this happening :O.

Anyway I would like to parse this json response in filemaker. How can i accomplish that?

here is the api

Thanks in advance

Solution

  • There are several plugins that can help you handle JSON: BaseElements, bBox, MBS and probably others.

    The FileMaker Community discussion on Script from FM to pull and parse a JSON file has links to these, as well as some Custom Functions for native parsing.