I am trying to build a flow that will take output from parsed JSON and...
IF JSON_ITEM_NUMBER exists in SQL_ITEM_NUMBER then UPDATE a SQL row.
IF JSON_ITEM_NUMBER does not exist in SQL_ITEM_NUMBER then INSERT SQL row.
This is as far as I have been able to get. No matter what, no rows are inserted or updated. Surely I'm missing a simple step.
I don't believe this is any limitation to the SQL connector. I am able to insert or update from my JSON output without problem. Demonstrated by a manually entered condition:
The issue I am having is trying to figure out the condition, because I want to compare each item_number from the JSON output to the item_number I'm returning from GetRows.
It seems that the inner loop array is empty, that's why the condition isn't running.
Test to see if the database rows count is 0 if so the insert the json without the testing the number, if the database rows count > 0 then run the flow as you have it
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.
At the monthly call, connect with other leaders and find out how community makes your experience even better.
If you are a small business ISV/Reseller, share your thoughts with our research team.