BuildJSONArray(MemoryTableObject: Object [, IncludeProperties: String, ExcludeProperties: String]): Object
Returns a JSON object based on the MemoryTableObject, including properties in the IncludeProperties semi-colon separated string, and excluding properties in the ExcludeProperties semi-colon separated string.
BuildJSONArray function has these named arguments:
Parameter |
Description |
Memory Table Object |
Required. An Accredo Memory Table Object to use as the base of the JSON object. |
Include Properties |
Optional. A semi-colon delimited string containing properties to be included. |
Exclude Properties |
Optional. A semi-colon delimited string containing properties to be excluded. |
The following sample code creates a JSON Object from a Memory Table.
Sample code:
Dim Table as Object
Table = ExecuteSQL("Select CustomerCode, CustomerName From ARCUST")
JSONArray = BuildJSONArray(Table)
Print JSONStringify(JSONArray)