Error with Bulk Create Upload

JavaScript
1

Hi Folks.

I want to allow people to upload a CSV file to my portal, convert that to a JSON value and then bulk upload that to the table. I have the importer working, with the following output to a variable:

  var OutputData = JSON.stringify(result.validData, null, 2)
  console.log("This is Output Data \n" + OutputData)

This is Output Data
[
{
“Open”: “A First Test”,
“Location”: “Test 1”,
“Details”: “Test 1”,
“Notes”: “Test 1”
},
{
“Open”: “A Second Test”,
“Location”: “Test 2”,
“Details”: “Test 2”,
“Notes”: "Test 2 "
}
]

Which (as far as i tell) matches the required format for the bulkUpload function. However when i run the bulk upload i get the following error:

Backendless.Data.of("Testing_Table").bulkCreate(OutputData).then(function(result) {
console.log("Items Saved")}).catch(function(error) { 
console.log(error)})

Error: Invalid bulkCreate argument. The first argument must contain only array of objects.

Any Ideas at all? As i’m properly stumped!

2

Hi Alex,

The object you pass into the bulkCreate call is obtained from the stringify() function, there it is a string and not an array. Instead, try passing result.validData into bulkCreate.

Cheers,
Mark

3

Its always the little things that you just miss… Thank you very much, that’s done the trick nicely!