Supermetrics Support Forum

Solved

Data Studio: How to connect via JSON/CSV Connector with API Key

I've come across https://supermetrics.com/blog/custom-json-data-studio, but am not entirely sure how to retrieve data from an API endpoint (JSON format) with API key requirement to access the data?

Can anyone give advise on where the key is supposed to be entered in the DS connector interface?


Thanks,
M

  • Hi M,


    It depends on the API you are using to get the data as they can all have different requirements, but in most cases it's part of the URL request itself.


    For example with Google Books API, you need to put the API key in the URL here:

    https://www.googleapis.com/books/v1/volumes?q=flowers+inauthor:keyes&key=xxxxxxxxxxxx


    If it's part of the URL request, then it's added to the "Source URL or Google Drive path" section:


    And that's it. That's all that is needed to get it to work with this particular API.


    As noted above, each API's requirements may be different, so you have to read their documentation to find out how the key fits into their request, even they even use keys (some don't).


    -Thank you

    Supermetrics Team

Login to post a comment