how to download JSON from Looker?

[robraven9]

I have a json payload to download and show case it exactly in looker and how do it ?

[ArkadyZagdan]

@robraven9 
There are mutliple various of ways hwo to do this.

If its ad-hoc work you can use some cconnectors. Just create a blank report and try any of the below:

If you seek to automate the process and run many time an option would be to ingest data by BiGQuery and then using JSON.Extract function coinvert it to tabular view and then push it into Looker Studio as View, Materialized View or table dependant of the frequency of usage and size of the data.

You can go more fancy and automate whhole process with cloud function, Cloud Run or Cloud Composer.

[robraven9]

Arkady - We have a restricted environment, where we can't connect to any of these connectors and so can you elaborate as how it can be done through composer and looker combination.