Views:

Description

Get an EntityCollection from a JSON document

Signature

GetVarJsonEC('selecttoken')

Example 1

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') )
    )  
 

Parameters

Name Type Description Required
selecttoken xxxx xxxx xxxx

Notes: