Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a table with some IDs. I am looking to iterate these IDs one by one and pass it to an REST API URL.
[Table]:
LOAD
ID
FROM [Sample.qvd]
(qvd);
FOR Each a in FieldValueList('ID')
LOAD '$(a)' as ID1 AutoGenerate 1;
Let vID=FieldValue(ID1);
Let vURL=somevalue/$(vID)/somevalue;
But vID doesn't pick up any values from the Table. Any help is appreciated.
I made it work.
I used Let vID='$(a)' instead