Nested JSON Object REST API Support

CrateDB
1

I know it wasn’t supported before, has this changed?

Can I do an update to a record with Array of Objects using REST post?

2

Hi @IM_DB,

Thanks for your question? Did you try sth like this:

curl 'http://localhost:4200/_sql' --data '{"stmt":"Insert into a (a) values ([{},{}])"}'

Please let me know if that helps!
Best Roman

3

Yes it does

{“stmt”:“Insert into leads (lead_id, test) values (?,?)”,
“args” : [“abcdddd”, [{“a”:1},{“a”:2}]]
}

Works like a charm. Thank you