I’m trying to create a workflow that pulls data from ClickUp and either inserts or updates a table in Postgres depending if the record already exists or not. There are times that the server where I’m hosting the Postgres database crashes so this workflow is to manually update/insert data that was updated in ClickUp during downtime.
I’m basically pulling the data from ClickUp and then searching each record individually using the split batch node. If the record exists already in the database then I should carry out the update operation with the data obtained from ClickUp. If the record doesn’t exist then I do an insert operation.
What I noticed though is that if I fetch the data and then search for the record, the output will now be replaced with whatever that query returns, losing all the information I had fetched from clickup previously.
I need help setting this up, specially on how to carry out the if operation and also persisting all the data that has been fetched from clickup.
Any help is appreciated.