Integrating with third-party software applications and internal databases provides valuable data, but creates a maintenance burden and distracts development teams from focusing on improving their core product. Connect simplifies that by providing:

Programmatic data integration

Create accounts, connect to data sources, and specify destinations, either directly from the Connect API or using a JavaScript library.

Hassle-free data pipeline

We take care of scheduling, auto-scaling, API version management, warehouse load optimization, and credential management.

Interested in seeing how Connect could work with your application?

Get in touch

Stitch Connect components

Work with the API directly, or use the JavaScript client to create and access Stitch client accounts, extract data, and load data into warehouses.

api-a-1

Connect API

For example, this is how you would create a Stitch client using the Connect API:

curl -X POST https://api.stitchdata.com/v3/accounts
-H "Authorization: Bearer <ACCESS_TOKEN>" 
-H "Content-Type: application/json"
-d "{
     "email": "stitch-api-test@stitchdata.com",
     "last_name": "Product Team",
     "partner_id": "<PARTNER_ID>",
     "first_name": "Stitch",
     "partner_secret": "<PARTNER_SECRET>",
     "company": "Stitch Product Team"
   }"

Expore the API docs

JS Client

This is how you would authorize an integration with OAuth using the JS Client:

Stitch.authorizeSource({
    "id": 45612,
    "ephemeral_token": "<EPHEMERAL_TOKEN>"
}).then((result) => {
    console.log(`Integration created, type=${result.type}, 
    id=${result.id}`);
}).catch((error) => {
    console.log("Integration not created.", error);
});

Explore the JS Client docs

Create a Stitch client
Create a HubSpot source
Update a destination

Explore the API docs

Authorize an integration with OAuth
Select data from an integration
Display a connection check

Explore the JS Client docs

curl -X POST https://api.stitchdata.com/v3/accounts
-H "Authorization: Bearer <ACCESS_TOKEN>" 
-H "Content-Type: application/json"
-d "{
     "email": "stitch-api-test@stitchdata.com",
     "last_name": "Product Team",
     "partner_id": "<PARTNER_ID>",
     "first_name": "Stitch",
     "partner_secret": "<PARTNER_SECRET>",
     "company": "Stitch Product Team"
   }"

HTTP/1.1 200 OK
Content-Type: application/json;charset=ISO-8859-1

{
  "access_token":"<ACCESS_TOKEN>"
}

curl -X POST https://api.stitchdata.com/v4/sources
-H "Authorization: Bearer <ACCESS_TOKEN>" 
-H "Content-Type: application/json"
-d "{
        "type":"platform.hubspot",
        "display_name":"HubSpot",
        "properties":{
           "start_date":"2017-01-01T00:00:00Z",
           "frequency_in_minutes":"30"
        }
     }"

HTTP/1.1 200 OK
Content-Type: application/json;charset=ISO-8859-1

{
   "properties":{
      "frequency_in_minutes":"30",
      "image_version":"1.latest",
      "start_date":"2017-01-01T00:00:00Z"
   },
   "updated_at":"2018-02-06T16:25:06Z",
   "check_job_name":null,
   "name":"hubspot",
   "type":"platform.hubspot",
   "deleted_at":null,
   "system_paused_at":null,
   "stitch_client_id":<ACCOUNT_ID>,
   "paused_at":null,
   "id":<SOURCE_ID>,
   "display_name":"HubSpot",
   "created_at":"2018-02-06T16:25:06Z"
  }

curl -X PUT https://api.stitchdata.com/v3/destinations/{id}
-H "Authorization: Bearer <ACCESS_TOKEN>" 
-H "Content-Type: application/json"
-d "{
     "type":"postgres",
     "connection": {
       "host": "<HOST>",
       "port": 5432,
       "username": "<USERNAME>",
       "database": "<DATABASE>",
       "password": "<PASSWORD>",
       "ssl": false
       }
   }"

HTTP/1.1 200 OK
Content-Type: application/json;charset=ISO-8859-1

{
  "id":"<DESTINATION_ID>",
  "type":"postgres",
  "created_at":"2018-02-06T15:36:36Z",
  "updated_at":"2018-02-06T18:55:43Z",
  "connection": {
      "host":"<HOST>",
      "port":5432,
      "username":"<USERNAME>",
      "database":"<DATABASE>",
      "password":"<PASSWORD>",
      "ssl":false
  },
  "last_check":{
      "error": false,
      "started_at":"2018-02-06T16:15:19Z",
      "completed_at":"2018-02-06T16:16:21Z"
  }
}

Stitch.authorizeSource({
    "id": 45612,
    "ephemeral_token": "<EPHEMERAL_TOKEN>"
}).then((result) => {
    console.log(`Integration created, type=${result.type}, 
    id=${result.id}`);
}).catch((error) => {
    console.log("Integration not created.", error);
});

Authorize an integration with OAuth - Result

Stitch.selectStreamsForSource({
    "id": 123,
    "default_streams": {
        "campaigns": true,
        "companies": true
    },
    "ephemeral_token": "<EPHEMERAL_TOKEN>"
}).then((result) => {
    console.log(`Integration created, type=${result.type}, 
    id=${result.id}`);
}).catch((error) => {
    console.log("Integration not created.", error);
});

Select data from an integration - Result

Stitch.displayDiscoveryOutputForSource({
    "id": 123,
    "discovery_job_name": "987-123-4567891234-checks"
}).then((result) => {
    console.log(`Integration created, type=${result.type}, 
    id=${result.id}`);
}).catch((error) => {
    console.log("Integration not created.", error);
});

Get started today

For technical details on the Stitch API, visit our docs. Interested in seeing how it could work with your application?

Get in touch

More platform features

Ready to learn more?

Contact our sales team today.

Set up in minutesUnlimited data volume during trial