Best practice importing and updating rows


#1

Hi,

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


#2

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.


#3

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.