Pass ID value one by one from table and concatenate

[qliklearnervir]

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?

[mfchmielowski]

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.