[Web] 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

Example:

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

Example:

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.

Example:

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 
customFields:  
weeklyFilter:   
    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 
}
			

2. Set up your data destination

Continue setting up the integration depending on the system where you want to import data to. Choose a data destination that you want to import data to:

Book a free onboarding call! 
For any questions, feel free to email our team at   contact@coupler.io

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