Description
Get an EntityCollection from a JSON document
Signature
GetVarJsonEC('selecttoken')
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')
)
)
Parameters
| Name | Type | Description | Required |
|---|---|---|---|
| selecttoken | xxxx | xxxx | xxxx |