Batch Insert/Delete by API?

[tony1233465]

I have more than 5000 records from single table of MYSQL.
And I tried to insert each of them into Xibo Dataset by API.
(Swagger UI)

I found that it needs over 5 minutes to insert all of them. Moreover I cannot clear all rows or a range of rows.
In order to clear all rows without delete the dataset, I have to get the first and last rows’s id and set a for loop to delete them one by one.

As I add row by Postman, I used form-data and it seems only 1 row can be added per request.

Here’s part of my ASP.NET Application, I used for loop to insert these data.

for (int i = 0; i < dt.Rows.Count; i++)
{
      //Use 
      Task.Run(async () => { await AddRowAsync(dataSetId, formdata); }).Wait();
}

Is there any way I can perform batch insert and also batch delete by API?
For example, modifying the API header, parameters?

[alex]

You can batch insert via CSV, and overwrite the existing data in that same operation. So you’d just send in the dataset as you want it to appear all in one call:

Xibo 1.8.2 csv to dataset API import

Using Xibo 1.8.2 on Windows 10 with docker (new install) Trying to import CSV’s into a dataset via the API using postman It seems to read the file (header + records) and then puts in that many rows but they are all blank. IE if the file has the header and 10 records, the dataset will have 11 rows all blank. Suggestions? I had this working on perl in 1.7 but even with a clean 1.8.2 install it doesn’t seem to be working right for me.

[tony1233465]

Inserting CSV seems to be a good idea.
But I am wondering if there’s too many changes on the dataset.
Will some data be inserted to the dataset instead of overwriting?

[alex]

You choose as a parameter to your call.

Either the CSV you upload replaces the dataset in its entirety, or it is appended to it. There’s no half-way option.

[tony1233465]

I see your point, thank you!