Question

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

  • 14 July 2021
  • 1 reply
  • 8 views

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”}

]

}

}

 

 


1 reply

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?

 

Reply