topic JsonGet Script Function's Syntax in App Development

JsonGet Script Function's Syntax

dikshaQlik — Wed, 15 Mar 2023 09:52:05 GMT

Hi Guys,

I am trying to use JsonGet script function defined below

https://help.qlik.com/en-US/sense/February2023/Subsystems/Hub/Content/Sense_Hub/Scripting/StringFunctions/JsonGet.htm

Somehow I am not able to figure out its syntax

Let value = JsonGet('{"a":{"foo":"bar"},"b":[123,"abc","ABC"]}', '/a/foo');

The above gives me error saying

The following error occurred:

Unexpected token: '(', expected one of: ':', 'OPERATOR_PLUS', 'OPERATOR_MINUS', 'OPERATOR_MULTIPLICATION', 'OPERATOR_DIVISION', 'OPERATOR_STRING_CONCAT', 'like', ...

The error occurred here:

Let value = JsonGet>>>>>>(<<<<<<'{"a":{"foo":"bar"},"b":[123,"abc","ABC"]}', '/a/foo')

Can someone please help me here?

Thanks in advance!!

Re: JsonGet Script Function's Syntax

rpennacchi — Wed, 15 Mar 2023 23:45:38 GMT

Hello, DikshaQlik,

What is your Qlik Sense version? Because this feature it is just avaible from August-2022.

I've loaded the sample you gave and I got the expected result. ("bar")

Re: JsonGet Script Function's Syntax

dikshaQlik — Thu, 16 Mar 2023 07:03:57 GMT

Hi Rpennachi,

Thanks for your reply. I am using May 2022 version and yes this is not available in that version.

May 2022 version is our firmwide used version and the upgrades are going to take much longer time. But I have an immediate use case where I need to parse a json which is nested. How do I parse this json in qlik sense 2022 version.

eg:

{
"abc":"val1",
"pqr":"val2",
"xyz":val3,
"nestedAttribute":{
"a1":true,
"b1":true,
"c1":"val4",
"someDate":"2021-03-24",
"someArray":[],
"someArray2":[{
"d1":{
"e1":123456,
"f1":"val5",
"g1":"val6"
}}],}
}