POST 1000 records in a collection

Hi,

I am new th XANO and trying to make some tests. My main goal here is to use Xano instead of the PostgreSQL we have, in order to be able to deploy some apps in a bettrer way.

I have a table of transactions that I need to update every day. It is around 15k rows. I Managed to Bulk Add Records with this wonderfull video : https://docs.xano.com/working-with-data/functions/database-requests/bulk-add-records

It works for small amount of records, but not for more than 10 rows at a time. I have this error message.

Here is the data workflow :

1. I receive a weired excel file

2. I use n8n to format and chunk

3. I was planing on sending POST for every 1000 rows to create new rows

I thought about few solutions but I am wondering if there is other better options :

1. Would it be possible to insert directly in the Postgre DB ?

2. Maybe I can instead format and send a file to Xano API ?

😁