Wootric is currently in Open Beta. The info in this article is subject to change.
Connecting Stitch to Wootric is a four-step process:
Leave this page open for now - you’ll need it to complete the setup in Stitch.
stitch_wootricin the data warehouse. This schema is where all the tables for this integration will be stored.
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.
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.