Invalid value while running iterative macro

[adamasj]

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

[aatalai]

@adamasj 

is it possible to see a screenshot of the workflow and macro? Or could you upload them all together?

[adamasj]

Unfortunately I cannot attach workflow as it has some sensitive data

[aatalai]

Ok thanks does it work when you run just the macro/the workflow you shared above?

[adamasj]

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

[aatalai]

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

[danilang]

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