Momoka_Tachibana | 2022-02-19 00:53:49 UTC | #1
After API call data was flattened at data action, we have multiple arrays of data as shown below, I want to organize each element according to the order of the arrays. By the way, the number of data in this array will always change because this array data is dynamic.
{ "result.resultBody.USTimeTable": [ [ "0000", "1111", "2222", "3333", "4444" ], [ "2222", "3333", "4444", "5555", ], [ "0000", "0123", "1445", "1567", "1456", "1345" ] ],
"result.resultBody.USDate": [ "20220220", "20220221", "20220222" ],
What I am expecting is to be organized at Architect like below
20220220 "0000", "1111", "2222", "3333", "4444" 20220221 "2222", "3333", "4444", "5555", 20220222 "0000", "0123", "1445", "1567", "1456", "1345"
Could you please help to check?
Anton_Vroon | 2022-02-20 20:18:15 UTC | #2
Assuming before being flattened they were part of the same object result.resultBody.USTimeTable[0] will be related to result.resultBody.USDate[0] result.resultBody.USTimeTable[1] will be related to result.resultBody.USDate[1] etc
So in Architect if you want the USTimeTable results for 20220222 you can just do Int Task.PositionIndex = 3 (or whatever you are using it iterate through or select specific items) Date = GetAt(UsDate, Task.PositionIndex) to get the Date, and then TimeTable Collection = GetAt(USTimeTable, Task.PositionIndex)
system | 2022-03-23 20:18:18 UTC | #3
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: 13643