LIST_TO_JSON

Converts a list of business objects into a JSON string. Specified attributes of each list member are printed out.

LIST_TO_JSON (list[, order], attribute[, attribute…])

1. A list to print out or a query finding business objects to print
2. If a list is specified an additional parameter can be optionally specified to contain sorting criteria in the Rule Language format.
3. Second, third, fourth and other parameters - attribute specification to include in JSON.
   1. Attribute specification consists of an attribute name, optionally followed by a JSON name and format separated by @ delimiter.
   2. If an attribute name starts with the # symbol the content of the attribute value is already a JSON formatted string which just needs to be inserted.

Text: the list members' chosen attributes converted to a JSON string.

LIST_TO_JSON (Client.Children, 'ORDER BY Client.Name DESC', 'FirstName', 'LastName', 'Age', 'ID@My id', 'Date@Date@MMM dd yyyy')

This produces the following string:

{
   "FirstName": "Jane",
   "LastName" : "Allison",
   "Age" : 15,
   "My id" : "some value",
   "Date": "Jan 2 2024"
},
{
   "FirstName": "Bob",
   "LastName" : "Fisk",
   "Age" : 30,
   "My id" : "some other value",
   "Date": "Feb 12 2024"
}
...

PARSE_JSON, PARSE_JSON2, LIST, LIST_LINE