How to connect data from JSON/CSV/XML files

Select your file's data type. See "File setup" below for more details on the specific requirements for each type of file.

This is the address for your file. It can be a URL to any service as long as it gives a file to process.

The max length for the URL is 2082 characters. This is a limitation set by Google Apps Script. If your URL is longer, use a URL shortener.

Make sure that the file can be accessed directly from a URL. Alternatively, upload the file to a Google Drive location. If you use Google Drive, update the sharing setting of the file to "Anyone with the link can view".

Add dates in the URL or Drive path with these placeholders, using edate instead of sdate for the end date: 

• #sdate# for a start date in Y-M-D
• #sdate_ymd# for a start date as YMD
• #sdate_u# for a start date as a Unix timestamp

Learn how to use dynamic date selections with files that support end dates.

If you're fetching data from an API, the post string is a parcel of data that will be sent to the endpoint you specify.

If you need to, for example, provide your login credentials, they are typically given here in JSON format. This field can usually be left blank, but if you know you do need to use it, try:
{ "yourUsernameToken":"yourUserName", "yourPasswordToken":"yourPassword" }

This allows you to specify a relative path to JSON data you want to access, if it's not by default on first level of address you gave in first field. Usually, none is needed.

Before you can connect your data to Google Sheets, you need to install the Supermetrics add-on.

1. Open a new Google Sheets file. 
2. Click Extensions → Supermetrics → Launch sidebar to open the sidebar.
3. Under Data source, select JSON/CSV/XML.
4. Under Report configuration, fill in the URL where your CSV file is located to the Type URL field.
   If your CSV file is located in Google Drive, use the Get link sharing option. Make sure the sharing link enables Anyone with the link to view the file.
5. Under Data type, select CSV or other type you need.
6. Fill in your parameters.
7. Finally, click Get data. Your data will be inserted starting from the cell you have selected in the spreadsheet.

1. Log in to Looker Studio.
2. Click Create → Data source.
3. Search for JSON/CSV/XML by Supermetrics, and select the connector.
4. Click Authorize.
5. Log in with the Google Account you use with Supermetrics.
6. Click Authorize.
7. Verify in the opening pop-up window that the authorization was successful, and close the window.
8. In the Parameters view, fill in the details for the configuration. Learn more about parameters.
   1. Select a Supermetrics team.
   2. Under Data type, select your file type.
   3. Fill in your parameters, especially the Source URL.
9. Click Connect in the top right corner.

The headers from your data will be set as dimension fields in the data source file. You can now create a report and start using your CSV data with the data source file.