topic Re: Upload json array to KVStore in Knowledge Management

Upload json array to KVStore

potluri_88 — Mon, 14 Jan 2019 17:47:29 GMT

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?

Re: Upload json array to KVStore

bjoernjensen — Tue, 15 Jan 2019 08:31:40 GMT

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

Re: Upload json array to KVStore

kamlesh_vaghela — Wed, 16 Jan 2019 12:47:40 GMT

@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

Re: Upload json array to KVStore

potluri_88 — Wed, 16 Jan 2019 13:10:23 GMT

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

Cheers!!

Re: Upload json array to KVStore

kamlesh_vaghela — Wed, 16 Jan 2019 13:16:03 GMT

Glad to help you @potluri_88

!!Happy Splunking!!