Loop Through REST Connector

[pankaj999]

Hi,

I have connected Asana API with QlikSense via REST connector and I have a table of all the tasks and their task_ids under a project in Asana as shown below:

What I want to do next is that iterate all the tasks_ids through this link `(https://app.asana.com/api/1.0/tasks/{task_id}/stories)` to get all the activities related to tasks.

 Basically, I need to loop in all the task_ids I have in a table called `asana_tasks` through the above link via REST connector.

Thanks

[seanbruton]

Hi There,

After you loaded the table asana_tasks then add the below just chnage the connection on the detail part to work in your confiquration enviroment. I use a fixed configuration and the connections string is a variable. I did mark in red.

The trick is the loop and variable part in your string url now $(vTaskId ):

let vNumofRowsCampaign = NoOfRows('asana_tasks)-1;
set vConcatenate = '';

for i = 0 to $(vNumofRowsCampaign)

let vTaskId = peek('id',$(i),'asana_tasks');

 TasksDetail:
LOAD * 
FROM [$(vQwcConnectionName)]
(URL IS [https://app.asana.com/api/1.0/tasks/$(vTaskId )/stories],
;

set vConcatenate = concatenate(MailChimpConnectorV2_CampaignReport);

next ;

Good Luck and enjoy.

[jordimtb]

Hi!

sorry for reusing your theme.
How did you get the REST-API connection? Are there any special settings?
I'm configuring exactly the same as in Postman but it's giving me a connection error.

thanks