Bulk Import with "String" (instead of File) / Add Multiple Rows
I would like the ability to add multiple rows in a single API call.
My API code runs in a cloud task worker environment and I have a list of JSON objects in memory, that I can easily marshall / convert into a string ... I would like to be able to pass that String (list of rows to be added) to the API.
Due to the restrictions of my virtual cloud file, I am not even allowed to create a temp file, to dump this list ot a file and then IMPORT the file.
I am currently iterating the list calling the ReportClient Add row...and the performance is becoming a bit of an issue for me ...
It takes me about 18 seconds to load 25 records... or 0.72 seconds per record. One of my data loads is about 9,000 records ... so that is 9K * 0.72 ~ 6,500 seconds ... so between 1h 30m and 2hrs of processing ....
Basically I am calling 1 API and extracting data...but their output is not a file, it is a JSON object.... and my runtime environment does not allow me to create a file...and I need to get that data into Zoho Reports.
I did not see any capability documented in the current API documentation.
Any suggestions ?
Thanks in advance.
It takes me about 18 seconds to load 25 records... or 0.72 seconds per record. One of my data loads is about 9,000 records ... so that is 9K * 0.72 ~ 6,500 seconds ... so between 1h 30m and 2hrs of processing ....
Basically I am calling 1 API and extracting data...but their output is not a file, it is a JSON object.... and my runtime environment does not allow me to create a file...and I need to get that data into Zoho Reports.
I did not see any capability documented in the current API documentation.
Any suggestions ?
Thanks in advance.