How do I properly delete all DB entries using http functions

Ask the community
,
1

Hi all,

following scenario: I habe a Data Collection that contains around 8000 Items. I am trying to automatically update the data at least once a day using http functions. Bulk inserting data works well (at least in junks of 1000 items each) but the deletion part is giving me a hard time. Using an admin site with a button, the function wixData.truncate( “MyDB”) is doing exactly what I need. However if I try this in an http function, I get:
WDE0027: The current user does not have permissions to truncate on the PreiseBoataround collection.
Is there a way to register as a certain user when calling the http function or can I somehow set that inside the function? If I try the other workarounds that are around, like querying all existing items and deleting them, it only deletes a few hundred items, even if I try calling the function multiple times.

Please note that the DB collection access rights are set to “anyone” for all actions.

Thanks and regards,
Felix

2

This will override the collection permission
wixData . truncate ( “myCollection”, {suppressAuth:true} );

https://www.wix.com/corvid/reference/wix-data.html#truncate

3

Works like a charm, thanks a lot!