Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
qliklearnervir
Creator
Creator

Pass ID value one by one from table and concatenate

Hi,

I have 1 table with ID values, where I have to send each ID in Rest API to fetch individual data and concatenate with the previous one.

ID_Table :

LOAD ID

Resident ID Table ;

 

THE rest API URL is Like https://test.net/GeneratedId?ID='123'

 

so I have to pass the ID column one by one as loop and append the table.

there is a restriction as we cant pass all values in one run in the API.

Please suggest?

 

Labels (1)
1 Reply
mfchmielowski
Creator II
Creator II

Hi.

You can use FieldValueList() in for each loop like this:

for each vID in FieldValueList('ID')
	// doSomeApiRequestHere
	// https://test.net/GeneratedId?ID=$(vID)
next vId;

You dont need to create other table for holding ID.