Hello World!
I am building a flow using an Infusionsoft connection (Type: When there is a new order).
When there is a new order (trigger), I would like to add a new row to my Contact table (action). I can successfully parse the json and create the new row. I have created a custom column called, tvi_keapid, in my Contact table to keep track of the contact ID that is sent from Infusionsoft.
However, if there is already a record of the same name/id in my Contacts table, my flow creates a duplicate record.
I would like a flow that checks first to see if there is a record, if true then do one thing and if false, then do something else.
I think I can use a List Rows (action) and XML query, but am lost as to the syntax. Here is an image:
Thank you!
