I’m trying to parse string to JSONARRAY. It contains array of JSONOBJECT but running into parsing error. I’m not sure if it’s an issue with my syntax or if it is not allowed to pass array of JSONOBJECT in JSONARRAY string. Can someone please please help with this issue or any work around for this structure?
@dhruva A run-time error can occur if the input string cannot be converted into a JSON object or a JSON array. To be properly formatted, besides having the proper nesting and matching of curly braces { } and brackets [ ], each value field must be one of the following: a string (in double quotes "), a number, a boolean ( true or false ), or a JSONOBJECT or JSONARRAY. Each key of a key:value pair must be a string in double quotes.
@Jon_Herke Tyty for the response I read that part of the documentation and was following those steps but I need help with the jsonarray parsable string formation. I’m trying following string which is of format [jsonobject - {keyA: “”, keyB: “”}] but it’s giving parsing error. My questions is around jsonarray can only parse string of format [int], [int, string], etc ? or does it support complex structure like [jsonobject]
I tried those 2 strings within the query but when I use parse_json_array, it give run time error.
Update: I was able to resolve this issue by using combination of double and single quotes. (my bad) It was getting confused with how I was using the double quotes for 2 separate reasons.