AnsweredAssumed Answered

Help parsing JSON Data

Question asked by edensfe on Feb 5, 2019
Latest reply on Feb 7, 2019 by fmpdude


I'm trying to parse some data in Filemaker, but I'm having a difficult time, particularly with the array that I have in the data. I'm sure it's incredibly simple once you know how, but I can't seem to find a clean and clear example of syntax for how to actually parse an array in Filemaker. Can someone help me parse out the following data?

 

{

  "Line": [

    {

      "Amount": 100.00,

      "DetailType": "SalesItemLineDetail",

      "SalesItemLineDetail": {

        "ItemRef": {

          "value": "1",

          "name": "Services"

        }

      }

    }

  ],

  "CustomerRef": {

    "value": "1"

  }

}

Outcomes