Multiple API calls to different JSONs

[cutehappybear]

EDITED AT THE BOTTOM

Hello everyone,

I have an API call which receives 3 url's (in the future, it will be more). I get 3 rows in my DownloadData column, which then go through a JSON parse, then a select and a filter until I have just 1 column with the data that I want.

However, I want to have 3 columns instead of 1 column - I want to know which data came out of which url.

How can I automatize this? I've noticed that if I output my JSON parse to a .csv file, I get different files, because I am using this:

Based on my column "type", it know to which of the 3 urls it refers to.

However, I don't want anything file-based.

How can I separate the output of my JSON Parse directly to the number of url's that I have? If not possible from the JSON Parse onwards, it could also be from the Download tool forward, when I have 3 DownloadData rows.

Thank you very much for your help.

EDIT:

Okay, I realized that I already have the data more or less how I want it. In my final table, I have 2 columns, one with the url from which the data was taken, and another one with the data returned. How do I now split this table into 3 tables? Of course I want this to work as well when I increase the number of urls.

[mceleavey]

Hi @cutehappybear  (great name),

can you post the data (mock is fine) showing what you're trying to do?

M.

[cutehappybear]

Of course @mceleavey!

A	123456
A	4535435
A	343242
B	988798797
B	87876
B	713123
C	23424
C	32432

Currently what I have is a table that looks like that, and I want to split it to 3 tables, one for type A, one for type B and one for type C.

But in an automized why, in which if I have more types, it will still work.