API question

[jillv]

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! 

[Felipe_Ribeir0 · Accepted 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.