Hey experts!
I have an issue where I have created two different HTTP request methods (GET). The first is to call an endpoint where it filters based on a status. In the JSON of this endpoint, it gives a sampleID. In order for me to isolate this sampleID I have created a Regex which works fine and is then stored in a column called AllSAmples_ID. The issue stems in the second endpoint, where I need to use this sampleID as a parameter. Basically the second endpoint has the format: rest/samples?queryid1=[sampleid];[sampleid2]; (a multi-lookup endpoint) where sampleid has to be created dynamically based on all the records in the column AllSamples_ID (as mentioned, I'm storing all the sampleID's in this column that I have received from the first http method).
If I hardcode a sampleID to the second endpoint, it works fine, but the entire point is to do this dynamicall, so it automatically can extract a sampleID and "insert" it to the parameter.
In plain english, loop through the column named AllSamples_ID, add the records to the parameter of the second endpoint separated by a semicolon, and stop when there are no more sampleID's left in the column.
It seems like it is not possible to create some type of a for loop in Alteryx, so what would the alternative be to accomplish my challenge?
I hope my question make sense - and thanks in advance!