ChadE | 2022-10-19 06:14:59 UTC | #1
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 (ApplicationID, OFFERSTATUS, CUSTOMER_ID) JSON FLATTEN example from data action test
], "Applications.APPLICATIONID": [ 383931, 383505, 383502, 381351 ], "Applications.OFFERSTATUS": [ "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.
system | 2022-11-19 06:15:35 UTC | #2
This topic was automatically closed 31 days after the last reply. New replies are no longer allowed.
This post was migrated from the old Developer Forum.
ref: 16774