GetVarJsonEC

Description

Get an EntityCollection from a JSON document

Signature

GetVarJsonEC('selecttoken', 'inputjson')

Example

Converts the string of JSON data to an entity collection and then loops over the 3 records and outputs the values.

ForEachRecord(

  GetVarJsonEC('.', 
    '[{"Key":"local_id","Value":"X604541"},{"Key":"local_category","Value":"IPF"},{"Key":"local_subcategory","Value":"XYS"}]'), 

  OutputToTrace(CurrentRecord('Key') + 
    ' :: ' +
    CurrentRecord('Value') 
  )
)