Pass string to parse it as JSONARRAY

GSQL
3

@Jon_Herke Tyty for the response :slight_smile: 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]

> str_1 = "[{\"keyA\":\"%test1%\",\"keyB\":\"test1\"},{\"keyA\":\"%test2%\",\"keyB\":\"test2\"}]"
> str_2 = "[\"{\"keyA\":\"%test1%\",\"keyB\":\"test1\"}\",\"{\"keyA\":\"%test2%\",\"keyB\":\"test2\"}\"]"

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.

Solution:

  1. When used within the query:

STRING str = "[\"{'keyA':'%test1%','keyB':'test1'}\",\"{'keyA':'%test2%','keyB':'test2'}\"]";

  1. When sent in GraphStudio params:

[“{‘keyA’:‘%test1%’,‘keyB’:‘test1’}”,“{‘keyA’:‘%test2%’,‘keyB’:‘test2’}”]