Hi folks,
I've been checking other use cases but I feel I have something wrong with my workflow. If let's say I have three items I want to retrieve, I should see the highlighted below to show 1, 2, 3, right?. But in my below pull, everything shows 0. Could someone please advise what is the correct way to pull?
I have attached a sample workflow. Thank you!
Solved! Go to Solution.
Hi @jillv
These numbers are being generated by alteryx when you use the Parse tool. You have 3 records to parse, so it is basically saying "for this record, this is the first time (0) that the figi/name/ticker appears". You just have 1 occurrence for each record, so it will always be 0.
0.data.0.figi
0.data.0.name
0.data.0.ticker
What i like to do is removing the first part (0.data.0.) before transposing, so you get the real name of the column.
You made 3 api calls, right? you got 3 rows as response.