This is not an official Google product
This Data Studio Community Connector lets users query data from a JSON data source.
To use this Community Connector in Data Studio there is a one-time setup to deploy your own personal instance of the connector using Apps Script.
Follow the deployment guide to deploy the Community Connector.
Once you've set up and deployed the connector, follow the Use a Community Connector guide to use the connector in Data Studio.
Note: After using the connector in Data Studio, as long as you do not revoke access, it will remain listed in the connector list for easy access when creating a new data source.
Enter the URL of a JSON data source. (Demo content: https://jsonplaceholder.typicode.com/comments)
In case of a "Invalid JSON format" error, validate your JSON using a validation tool like JSONLint.com.
Note: The first row of the dataset is used to determine the data schema.
Enable caching by checking the 'Cache response' checkbox. This is usefull with large datasets. The cache will expire after ten minutes. The rows in your dataset may not exceed 100KB
When authorizing the community connector, if you are presented with an "unverified" warning screen see This app isn't verified for details on how to proceed.