Forum | Appery.io

I'm using Oracle DB to POST thousands of records/objects into Appery collections. However, as I'm doing this record by record, it takes a major time (e.g. 2 hours to insert 4,000 records) and sometimes breaks in the middle.

Alternatively, I wrote all records in one variable (CLOB in oracle) and want to send it over POST http as chunks of 32KB each. The format of the data is as follows:

pre{"UserId":"54f04566e4b0266e547f734f", "Outlet_Code":"22000004", "MPD_Month":"Feb-15", "MPD_Sales":"0", "MPD_Visibility":"0", "MPD_Interact":"0", "MPD_Bonus":"0", "MPD_Points_Carried_Forward":"0", "MPD_Points_Month":"0"},{"UserId":"54f0457de4b0266e547f736c", "Outlet_Code":"55000001", "MPD_Month":"Feb-15", "MPD_Sales":"0", "MPD_Visibility":"0", "MPD_Interact":"0", "MPD_Bonus":"0", "MPD_Points_Carried_Forward":"0", "MPD_Points_Month":"0"},{"UserId":"54f04557e4b0266e547f7347", "Outlet_Code":"88000002", "MPD_Month":"Feb-15", "MPD_Sales":"0", "MPD_Visibility":"0", "MPD_Interact":"0", "MPD_Bonus":"0", "MPD_Points_Carried_Forward":"0", "MPD_Points_Month":"0"}/pre

Of course it much bigger, this is just a sample. What I get is only one object/record is written in Appery collection. My questions are:

1) Is it possible to POST more than 1 object in each http request the same way I explained above?
2) What is the data format I should follow in order to post all objects and not only one? (e.g. do I need to add data between square brackets [ ... ]?)

Many thanks,

Hello,

Unfortunately, current Appery.io Database implementation doesn't have public API for any bulk actions.

So what is the best way of doing it? POST object by object ?

Hello!

The only way is to send one by one, like you do it right now.