JSON data source

Learn how to set up a JSON data source and then move this data to one of the supported by Coupler.io data destinations.

Video tutorial:

The 2 steps to complete the setup

Set up your data source
Set up your data destination

1. Set up your data source

1.1. Select an application: JSON

1.2. Fill out the "JSON URL" field

Paste the JSON URL to import data from.

1.3. Select an HTTP Method

Select a method to indicate the desired action to be performed for a given data source. Learn more

1.4. Fill out the "Request headers" field

Specify the Request header, which can be used in an HTTP request to provide information about the request context so that the server can tailor the response. Learn more

1.5. Fill out the "URL query parameters" field

Specify the query parameters to narrow your results. Learn more.
This field supports macro. Learn more.

1.6. Fill out the "Request body" field

Specify the Request body, which is part of an HTTP request and contains data sent to API. It is only supported by these HTTP methods: POST, PUT, PATCH, and DELETE.

Example:

dateRangeStart: '2020-01-01T00:00:00.000Z'
dateRangeEnd: '2020-01-07T23:59:59.999Z'
sortOrder: ASCENDING description: '' 
rounding: false 
withoutDescription: false
userLocale: en_US 
customFields:  
weeklyFilter:   
    group: PROJECT   
    subgroup: TIME exportType: CSV

1.7. Fill out the "Columns" field

Specify a comma-separated list of fields and their order to be imported to Google Sheets. By default, Coupler.io will select all fields (e.g. Title, Status).

1.8. Fill out the "Path" field

Enter a string joined by dots to select nested objects from the JSON response (e.g. path.to.object). By default, Coupler.io will select all objects.

For example, all JSON objects look as follows:

{   
   "data": { 
     "items": [      
	{"id": 1, "name": "First"},       
	{"id": 2, "name": "Second"}     
     ]   
   },  
  "page": 1,  
  "per_page": 1 
}

In the case above you need to specify path 'data.items' to receive columns with headers 'id' and 'name'. If you leave the field empty you will get 'data.items.id', 'data.items.name', 'page', 'per page'.

Read more about how to define "Path" in a separate article: How to define the path to selecting JSON objects?

2. Set up your data destination

Continue setting up the integration depending on the system where you want to import data to. See full list of supported data destinations and follow set up guide for chosen one.