I have such pipeline:
-
In Script activity I am selecting list of IDs difference between two tables:
SELECT id
FROM a
where not exists (
select * from b where a.id= b.id
) -
In ForEach activity I have (Items = @activity(‘Script1’).output.resultSets[0].rows):
Set pipeline variable activity = activity(‘Script1’).output.resultSets[0].rows[0].IDCopy data activity = I can call API (several ids, separated by comma as well can be called as well), currently the requested body is like this:
@concat(‘{“id”:[‘, ‘”‘, activity(‘Script1’).output.resultSets[0].rows[0].id, ‘”‘, ‘]}’)
I want the pipeline to iterate through the list that I am getting when select IDs. How can I achieve that? Currently, it is not working, and taking the same ID endless amount of times.