Upload json array to KVStore

[potluri_88]

Hi,

I'm trying to upload a json array with multiple objects to a kvstore using curl command as below.

curl -k -u admin:**** https://localhost:8089/servicesNS/nobody/test/storage/collections/data/hosts -H 'Content-Type: application/json' -d '[{"env": "dev", "zone": "Z1"},{"env": "dev", "zone": "Z1"}]'

Error is as below
JSON in the request is invalid. (
JSON parse error at offset 0 of file "[ {"env": "dev", "zone": "Z1"},{ "env": "dev", "zone": "Z1"}]": Expecting an object but got an array.

How do upload multiple object json without using an array?

[kamlesh_vaghela · Accepted solution]

@potluri_88

Have you tried batch_save ??

storage/collections/data/{collection}/batch_save

POST: Run one or more save (insert and replace) operations in a specific collection

Run multiple save operations:

Sample CURL Command:

curl -k -u admin:yourpassword \
    https://localhost:8089/servicesNS/nobody/kvstoretest/storage/collections/data/kvstorecoll/batch_save \
    -H 'Content-Type: application/json' \
    -d '[{"name": "Splunk Sweden"}, {"name": "Splunk Singapore"}]'

Check below link for more info:

http://dev.splunk.com/view/webframework-developapps/SP-CAAAEZG

Thanks

[potluri_88]

This really helped @kamlesh_vaghela .. thanks for your time..

Cheers!!

[kamlesh_vaghela]

Glad to help you @potluri_88

!!Happy Splunking!!

[bjoernjensen]

Hi,

Since your collection expects a certain JSON object you have to use curl multiple times.

What should not work: using an object that contains your array that contains your objects.

Maybe that helps,
Björn