Best practice importing and updating rows


Question, is it possible to delete all rows in a table with the API? I am creating a jira connection, but sometimes jira’s webhook doens’t work. So i want to build a full sync option.

Full sync can means, Delete all rows and import or is there a REPLACE api call. just like in MySql, is the row does not excists it will create it?

Greetings gijs

Currently there’s no delete all API call, only delete calls for individual records. For replace calls, you should be able to do a GET call first to retrieve the record with a specific key to see if the record exist, and update it if it exists with a POST call to update an existing record.

1 Like

Thanks Jeff, i will do that. I was hoping to make the API call load less now i have to make two call for one update. Hope this is not a problem.

1 Like