AnsweredAssumed Answered

FM15 Processing JSON issues

Question asked by DavidZakary on Jun 6, 2017
Latest reply on Jun 6, 2017 by beverly

I'm trying to process a JSON result from a web service in FM 15. I'm using the JSON examples from modularfilemaker.org as my toolset. The JSON appears to be valid, according to jsonlint.com anyway.

 

When I extract info from the top level of the JSON, it works. If I try to extract anything from a lower level the results come back with part of the raw JSON file, not the expected data.

 

The JSON has top levels of "metadata", "totalAvailableSearchCount" and "result". I can pull data from any of the "metadata" nodes. If I try to get data from "result" (which is where the data I need is), the data can't be extracted.

 

I'm new to JSON stuff. Can anybody suggest places to look?

 

Dave Zakary

Outcomes