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.

The 2 steps to complete the setup

  1. Set up your data source
  2. 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


Host: "developer.mozilla.org"  User-Agent: "Mozilla/5.0"<br>

Authorization: Bearer xoxb-1h345kj24tr34kj35y63kjn243kjn2tf2N 
Content-Type: application/json

1.5. Fill out the "URL query string" field

Specify the Query string that is part of a URL that assigns values to specified parameters by entering each of them in a new line. Learn more


limit: 100  
offset: 20

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.


customer_id: 1  
customer_email: email@example.com
dateRangeStart: '2020-01-01T00:00:00.000Z'
dateRangeEnd: '2020-01-07T23:59:59.999Z'
sortOrder: ASCENDING description: '' 
rounding: false 
withoutDescription: false
userLocale: en_US 
    group: PROJECT   
    subgroup: TIME exportType: CSV

1.7. Fill out the "Fields" 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.   TitleStatus).

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'.

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.

Did this answer your question? Thanks for the feedback There was a problem submitting your feedback. Please try again later.