What is an array?
An array is a data structure that collects elements of the same data type. Arrays work on an index system starting from 0 to (n-1), where n is the size of the array. For the sake of simplicity, we can think of arrays similar to linked lists.
Why store data in an array?
One of the benefits to using an array instead of a linked list is that arrays are more memory efficient.
How array data is used in Openprise:
Current (default) handling of array data: Array(object) - Openprise will return the first 3 values in the array.
Example array(object)
Array(string) - Openprise will concatenate array values into 1 output field to a character limit of 30K bytes.
Example array(string)
New Options (6.1 - March 31, 2024)
The Write to field output option is similar to the current array(string) results, and will concatenate the values in the array and place in the first field for each object up to a 30K byte limit. Data that exceeds this limitation will be truncated. This option is only different behavior for array(object).
The Write to MDS/Reference File option will write all array values to a reference source. All values in the array will be represented in the MDS file in it’s own row. No limits on how many values can be returned.