Hi, I am using a 3rd party ETL application to add and update records in my xano table.
Each time I run I will need to add/update potentially 100s of 000s of records.
Ive gotten my head around using the post method of the api so far to do insertions, but I doubt I can hit it that hard so want to use the bulk add method.
So far though (in my noobness) I can't quite join the dots between the bulk add feature and the the api post method, and how to combine the 2 of them and with my 3rd party app's outputting process.
At a guess, I'm thinking I'll have to turn the final output in my 3rd party ETL app into json, and then batch the records up into arrays of x,000 at a time, and then post the batches to the api/function or whatever. Maybeeeeee????
Can anyone give a noob a push in the right direction?
Many thnx
W