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.

Expected Wootric Data

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.

Now that Wootric is successfully connected to your Stitch account, what comes next? In this article, we'll cover:

  1. How Stitch replicates Wootric data
  2. The tables that will be created in your data warehouse

Replicating Wootric Data

Historical Sync

By default, a historical sync of Wootric data goes back one year from the Stitch connection date.

Frequency

Stitch will replicate Wootric data based on the frequency you define. The default setting is every 30 minutes, but you can change it better suit your needs.

Replication Method

When Stitch replicates Wootric data, it does so using Incremental Replication. This means that every time Braintree data is queued for replication, only new and updated data will be replicated.

Wootric Tables in Your Data Warehouse

Below is a list of the Wootric tables that will be created in your data warehouse. Because Wootric uses nested arrays to structure data in some of its API's endpoints, Stitch will de-nest these arrays and create subtables if your data warehouse doesn't natively support nested structures. Refer to the Handling of Nested Data Structures doc for more info.

Nested arrays are marked with a *.

Click the table names to check out Wootric's API docs.

declines
Replication Method: Incremental
Primary Key: id

The declines table contains info about declines, or the instances where a user is presented with a survey opportunity and opts out.

Attributes include:

  • Decline ID (id)
  • created_at
  • updated_at
  • end_user_id
  • survey_id

end_users
Replication Method: Incremental
Primary Key: id

The end_users table contains info about end users.

Attributes include:

  • End User ID (id)
  • created_at
  • updated_at
  • email
  • last_surveyed
  • external_created_at
  • page_views_count

responses
Replication Method: Incremental
Primary Key: id

The responses table contains info about end user responses to surveys.

Attributes include:

  • Response ID (id)
  • created_at
  • updated_at
  • score
  • text
  • ip_address
  • origin_url
  • end_user_id
  • survey_id
  • completed
  • excluded_from_calculations
  • tags *

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!