How do you access json object from a json file inside a view

[maclynn147]

I have a json file with a key value and i want to use this variable in a view how do i achieve this with Looker.

#########File########

{

"params” :

{

"country2char” : [

{"id” : "US”, "name”: "United States”},

{"id” : "UK”, "name” : "United Kingdom”}

]

}

}

[Chris_Tinnon]

My understand of your question is you want to extract the values within the country2char node.

This should be something you’re actually solving on the database side. If it’s modern, it should have functions for parsing unstructured data. What are you using?