Bulk edit records

Hi 🙂

I have recuring xlsx file that is sent by email from a supplier. The file is approximately 15k rows.

My objective here is to Add or Update my collection shippment_profile_report. The many solutions I tried are very slow for the amount of data.

For now I have the data transformed in n8n. Here is the different workflows I tried :

1. send everyting to XANO by batch of 500 records then have a For Each loop with an Add or Edit Record function.

   1. ❌Very slow

   2. ❌I did not manade to ged the id form the input. Indeed, the rows generated create the XANO id and cannot use the input id

2. send everyting to XANO by batch of 500 records then have a For Each loop with an Get Record function then an Conditional If to Add record or Edit record .

   1. ❌Very slow

   2. 👌it can handle the Add record using my id

3. split the data in n8n then use a Bulk add record function and a For Each loop with a PUT endpoint for the updated records.

   1. 👌Add is very fast

   2. ❌update is very slow

   3. 👌it can handle the Add record using my id

Is there a solution tu bulk edit ? Like the Add bulk record function ?

If you have any ideas on this, do not hesitate 🙂