What is the best way to perform a batch delete operation on an AppSheet database via the API? I’m looking for an efficient way to remove multiple rows at once and would like to know the correct request format and any limitations.
I am consuming the API using Python:
chunk_size = 500
for chunk in split_dataframe(json_data, chunk_size):
data = {
"Action": "Delete",
"Properties": {
"Locale": "pt-BR",
"Timezone": "America/Sao_Paulo"
},
"Rows": [{"key_column": json_data[0]["key_column"]}]
}
response = requests.post(url, headers=headers, data=json.dumps(data))
if response.status_code == 200:
print(f"Chunk OK! {chunk.index[0]} - {chunk.index[-1]}")
else:
print(f"Chunk Error: {response.status_code}, {response.text}")
(In this project, I am using an AppSheet database.)
The scope of the deletion I need to perform quickly involves approximately 30,000 rows from a table with around 40 to 50 columns.
The project requires frequent updates to the app’s data since it changes dynamically. This involves managing approximately 10 databases with similar structures and scales.
Currently, I have an efficient method for batch additions, but I am facing challenges with large-scale deletions, such as potential API rate limits, timeouts, or excessive processing time.
What would be the best approach to handle these mass deletions efficiently? Are there any best practices or alternative strategies (e.g., chunking, optimizing API usage, or combining operations) that you would recommend?
LinkedIn
Twitter
