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 Referral SaaSquatch Data

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

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

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

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

Replicating Referral SaaSquatch Data

Historical Sync

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

Frequency

Stitch will replicate Referral SaaSquatch 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 Referral SaaSquatch 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.

Referral SaaSquatch Tables in Your Data Warehouse

Below is a list of the Referral SaaSquatch tables that will be created in your data warehouse, along with their Replication Methods and Primary Keys. Click the table names to check out Referral SaaSquatch's API docs.

referrals
Replication Method: Incremental
Primary Key: id

The referrals table contains info about all of the referrals in your Referral SaaSquatch tenant.

Attributes include:

  • Referral ID (id)
  • referreduser
  • referredaccount
  • referredreward
  • referredmoderationstatus
  • referreruser
  • referreraccount
  • referrerreward
  • referrermoderationstatus
  • datereferralstarted
  • datereferralpaid
  • datereferralended
  • datemoderated

reward_balances
Replication Method: Incremental
Primary Key: userId : accountId

The reward_balance table contains info about the balances for all rewards.

Attributes include:

  • userid
  • accountid
  • type
  • amount
  • unit

users
Replication Method: Incremental
Primary Key: id

The users table contains info about the users in your Referral SaaSquatch tenant.

Attributes include:

  • User ID (id)
  • accountid
  • email
  • firstname
  • lastname
  • imageurl
  • firstseenip
  • lastseenip
  • datecreated
  • emailhash
  • referralsource
  • locale
  • sharelink
  • facebooksharelink
  • twittersharelink
  • emailsharelink
  • linkedinsharelink

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!