Replace or replace contents of table in Data sources

Ask for Help
1

I found this endpoint in the api docs:

Without testing it, is the result the same as “select all rows in a table, delete, import new data”?

Client has realised they can do this manually as stated above, but I’d prefer to automate this to keep it controlled.

Please let me know if you have experience using this endpoint so I can understand the behaviour before spending time testing. Thanks in advance :handshake:

PS: If I clear table data so there is only the header row, then upload/replace the data with a .csv file with say 5,000 records, what does the API usage look like?

2

Yes, that’s correct. I’m using this everyday to refresh data coming from another source.

Do you mean uploading manually?

3

If I replace a table (remove the table using api then replace, which I haven’t looked at how to do yet), then is that one API credit per row replaced/imported?

4

Depends which version of the API you use.

With V1, which works with any tables, it’s one update per mutation (add/edit/delete).
With V2, which only works with Big Tables, it’s 0.01 updates per row changed.

Note: if you manually import a CSV file via the Data Editor, that’s zero updates regardless of the type of table or number of rows.

1 Like
5

Great, so 50 updates for 5,000 rows