I did try that first, but the data query would never display if placed there. The condition is that if {{settlementTimeUTC}} from the API exists, do the validation and insert into the database, otherwise do nothing. {{settlementTimeUTC}} should always exist.
Sorry if I am sking silly questions.
Does the query appears as a step when debugging?
Maybe by mistake the output option in the query is not checked
If data is not there, and ‘then’ step runs, you also see the display query afterwards?
Or it is never displayed
Try the following.
Instead of validating…
1.When data is retrieved from the API
2.Run a query (for exapmple apiquery) which will be looking for the value inside yout database
3.The in the condition check 'apiquery.length<1)
4.IInside the ‘then’ step add the value from the API in the database.
By validating like this your query won’t stop if value already exists
You might consider enforcing these unique values via an index on the database instead of using code. Then when it errors on the insert, you can just skip over the error on go to the next record.
Insert the query that searches for duplicate inside the repeat. Just above the condition.
Pass the value that are validating with, inside the repeat, and vlidate with it the query