PARSE JSON DATA

[cloudwar]

Hi,I am facing trouble to parse JSON data into new table. I want to extract the fields and its corresponding value from JSON data.

Help me out

Data	PERIOD	SEALID
{"SId":"420","applDetail":{"sName":"Sap","slob":"sCIB","caf":"sfalse","sGroup":null,"sprod":null},"smetrics":{"shfd":[{"numICADeploys":"0","numNonICADeploys":"10","totNumOfDeploys":"10","spercentageValue":"0"}],"sarc":[{"numAIMDeploys":"8","totNumOfDeploys":"10","spercentageValue":"80"}],"ssta":[{"numNIODeploys":"2","totNumOfDeploys":"10","spercentageValue":"20"}]}}	2021-04	1,420.00000000000000

[anat · Accepted solution]

R u trying to read JSON data using REST Connector, 

https://help.qlik.com/en-US/connectors/Subsystems/REST_connector_help/Content/Connectors_REST/REST-c...

[cloudwar]

Thank you,

Do we have any other alternative to figure out