Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik and ServiceNow Partner to Bring Trusted Enterprise Context into AI-Powered Workflows. Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
suvbin
Creator III
Creator III

Json data extraction

Hi , 

 

Is there any way to extract json column information and load into different columns in target table

Example input : '{"name":"John", "age":30, "car":null}'

output: 3 columns in table 

Name: John

Age: 30 

Car: Null

Labels (3)
2 Replies
sureshkumar
Support
Support

Hello @suvbin 

Please refer below white paper documentation for the json data extract

 

Regards,

Suresh

 

mufas12
Contributor
Contributor

There is JSON data in there from what I see, but you won't see it in your network activity. This is because this JSON data is embedded inside the HTML itself. Specifically, the JSON data is stored in the "q-data" attribute of the element with id="vue-match-centre". I'm not sure which scraping framework you use, but you will have to get the value of the "q-data".