Invalid value while running iterative macro

Question

Hi, I have iterative macro that takes data from API.

However on some random iteration I am getting this Warning:

Error message: Invalid value. at character position: 0

After that remining iterations do not work properly and I am getting duplicate values

danilang · Answer

Hi @adamasj

The Error message: Invalid value. at character position: 0 message is coming from your JSON parse tool when there is nothing to process, i.e. the download tool returns no data.  Make sure that you have the the looping criteria set up properly and that your math is not miscalculating the total number of iterations.

Dan

aatalai · Answer

can you try updating this workflow for the 1124 record and see what the output looks like? Will help with some trouble shooting

adamasj · Answer

Yes, its working, I had 1196 iterations to run and on the 1124 I got that warning and after that all values were duplicates