How to get data into Google Data Studio?

[mohan_n]

I have used your ‘power query’ tutorial as a template to create this step-by-step tutorial for Google Data Studio(GDS)

For seamless data analysis, you can leverage the KoBo API to pull your data into other tools for data analysis. This article covers how to connect to the API to pull your data into Google Data Studio.
KoBo API

1. Login to your account.

2. Next, go to the API for your account by going to either https://kc.humanitarianresponse.info/api/v1 or https://kc.kobotoolbox.org/api/v1/ . Select the URL for the instance in which your account is located.

3. Under the Data heading, click on /api/v1/data
   

   

4. Click on “GET” and select “json”.
   

   

5. This action will open a webpage having links to json files of all your projects.

6. Next, locate your project’s data structure inside the data file. It will be in the following format: description,id,id_string,title,url
   For example:
   MIRA_DO,1314,MIRA_DO,MIRA_DO,https://kc.humanitarianresponse.info/api/v1/data/1314?format=json

7. Before transitioning over the Google Data Studio, make sure that there is a) at least 1 record stored in your data table in KoboToolbox and b) under the Project’s settings, set it to “share data publicly”.
   Google Data Studio

8. In Google Data Studio, click on Create > Data Source
   

   

9. Type “custom json/csv/xml” in the search bar and select the first search result.
   

   

10. Now, in the emerging webpage, select ‘json’ for the “Data Type” field and paste url of your json file that you have noted in step 6 into the ‘Source URL or Google Drive path” field.
    

    

11. Click “Connect”

12. Now, you can see all the fields of your form. Select “Explore” or ‘Create Report” and you are good to go.