Stitch Documentation
has moved!

Please update your bookmarks to https://www.stitchdata.com/docs

If you're not automatically redirected after 5 seconds, click here.

Connecting Wootric

Wootric Info
This integration was created by Stitch for Singer, an open-source, composable ETL platform. Check out & contribute to the repo on GitHub.

Wootric is currently in Open Beta. The info in this article is subject to change.

Connecting Stitch to Wootric is a four-step process:

  1. Retrieve your Wootric API credentials
  2. Add Wootric as a Stitch data source
  3. Define the Historical Sync
  4. Define the Replication Frequency

Retrieving Your Wootric API Credentials

  1. Sign into your Wootric account.
  2. Click the user menu in the top right corner, then Settings.
  3. Click API in the left nav tab.
  4. Your Client ID and Client Secret will display:

    wootric-api-credentials.png

Leave this page open for now - you’ll need it to complete the setup in Stitch.

Adding Wootric as a Stitch Data Source

  1. On the Stitch Dashboard page, click the Add an Integration button.
  2. Click the Wootric icon.
  3. Enter a name for the integration. This is the name that will display on the for the integration; it’ll also be used to create the schema in your data warehouse.

    For example, the name “Stitch Wootric” would create a schema called stitch_wootric in the data warehouse. This schema is where all the tables for this integration will be stored.
  4. In the Client ID field, paste your Wootric Client ID.
  5. In the Client Secret field, paste your Wootric Client Secret.

Defining the Historical Sync

The Sync Historical Data setting will define the starting date for your Wootric integration. This means that data equal to or newer than this date will be replicated to your data warehouse.

Change this setting if you want to sync data beyond Wootric’s default setting of 1 year. For a detailed look at historical syncs, check out the Syncing Historical SaaS Data article.

Defining the Replication Frequency

The Replication Frequency controls how often Stitch will attempt to replicate data from your Wootric integration. By default the frequency is set to 30 minutes, but you can change it to better suit your needs.

Stitch & Replicating Wootric Data
When Stitch replicates data from Wootric, it does so using Full Table Replication. By design, Wootric’s API doesn’t allow results to be ordered or filtered based on an updated_at date. This means there is no way to incrementally upsert updated records.

Therefore, Full Table Replication is used to ensure the state of each record is accurately captured during replication. This will lead to a higher number of replicated rows.

To help prevent overages, we recommend setting the Replication Frequency to something less frequent - like 6 hours instead of 30 minutes.

For more tips on reducing your row count, check out the Reducing Your Row Count article.

After setting the Replication Frequency, click Save Integration to wrap things up.

Related

Was this article helpful?
0 out of 0 found this helpful

Comments

Questions or suggestions? If something in our documentation is unclear, let us know in the comments!