JSON Universal Connector

Pull data using JSON with Dataddo.

About JSON Universal Connector

JSON Universal Connector allows you to connect your data from any service that provides JSON-base API. You just need the URL and transformational pipeline.

How to Create New Source with Json Universal Connector

1. Sign in to your Dataddo account and click on Sources at the top of the page.

2. Click on Create Source in the top right corner.

3. From the list of sources, choose JSON Universal. You can type the name of the connector into the search bar to find it faster.
   

4. Insert the API URL and set up all the fields as needed: HTTP Method,  Authorization, Snapshotting, Name, Transformation Pipeline, HTTP Headers, HTTP Body, and optionally Source whose configuration you want to Clone.
   NOTE: Read more about Universal Connectors and more detail on how to configure them here. 
   

5. Click on Schedule to set up the synchronization time and period, when your data will be pulled.

6. You can preview a sample of the data by entering the array (square brackets [ ] ) symbols in the Transformation Pipeline section.

7. Check the box Split view if you want to see Request and Response Previews next to each other. 
   

   1. You can test your transformation and see a preview table of it by clicking on Get Data.
   2. If you need to start over, select Reset form (click on the arrow next to the blue button in the top right corner)

8. Click on Create a Source (click on the arrow next to the blue Get Data button in the top right corner) to save your selection.