Hi all,
Hoping someone can assist me. I have a data action that has a number of objects in an array output which works successfully (Application_ID, OFFER_STATUS, CUSTOMER_ID)
JSON FLATTEN example from data action test
],
"Applications.APPLICATION_ID": [
383931,
383505,
383502,
381351
],
"Applications.OFFER_STATUS": [
"ACCEPTED",
"ACCEPTED",
"ACCEPTED",
null
],
"Applications.CUSTOMER_ID": [
"65432188",
"VD95425",
null,
"855541A"
]
There can be a maximum of 5 separate applications within the array but there may be less.
I am attempting to present each item/object in separate fields (as the Application_ID will also be URL to an external system on the agent script).
For Example, the below is what I want on the script using 5 link fields for the Application_ID and 10 text fields:
383931 ACCEPTED 65432188
383505 ACCEPTED VD95425
383502 ACCEPTED null
381351 null 855541A
null null null
I can get all of the outputs in single text boxes using a list variable which appear as follows
383931,383505,383502,381351
ACCEPTED,ACCEPTED,ACCEPTED,
65432188,VD95425,,855541A
However I am not able to show single items. I have tried a number of ways and not sure if it is just not possible or just my noob/incorrect formatting.
I have enables list push on the script properties.
I have attempted the following insert variables on the script fields.
({{AppIDs}}[1])
{{AppIDs}}[1]
{{AppIDs}},[1]
Any help would be appreciated!
Thanks.