Edit

JSON_Parse (jsonText)

Result type:  JSON object handle

Definition:  Parses the JSON and returns a JSON object handle that can be used to query the resulting object.

Example: 

    // get original description from JSON transaction (see below)
    let jsonObjectHandle = JSON_Parse(jsontext)
    // access description from item 0 in the transaction array
    let subObject = JSON_Get(jsonObjectHandle, "transaction", 0, "description")
    let s = JSON_Get(subObject, "original")
    JSON_Free(subObject)
    JSON_Free(jsonObjectHandle)

Returns "0150 Amazon Santa Ana CA 55.73USD" when jsontext is:

{
   "transaction": [
   {
      "CONTAINER": "bank",
      "id": 2829798,
      "amount": {
        "amount": 12345.12,
        "currency": "USD"
      },
      "description":{
        "original": "0150 Amazon  Santa Ana CA 55.73USD",
        "consumer": "Electronic Purchases",
        "simple": "Amazon Purchase"
      }
   }
   ]
}

Free the JSON object handle with JSON_Free() when you are finished with it.

See Also:

JSON_AsXML: Convert JSON to XML

JSON_Free: Free a parsed JSON structure

ParamsFromArray: Expand array values to a variable parameter list