Webgains (Platform API)
v0.0.4
To find out more about the Webgains API check their docs out here.
Set up
To set up the Webgains (Platform API) connector in your app all you will need is an Access Token. You can follow the steps here to generate one.
Features
| Feature | Support | Notes |
|---|---|---|
| Backfill | ✅ | Custom for transaction reports and all time for Program Memberships |
| Incremental | ✅ | Only for the Transaction Report |
| API reliability | 🟢 | Reliable |
Reports detail
| ⬇️ Report | 🔑 Incremental key | 🔑 Primary key | 📄 Link to API endpoint |
|---|---|---|---|
| Transaction Report | DATE | ID | Get Transaction Report |
| Transaction Report Single Campaign | DATE | ID | Get Transaction Report |
| Transaction Report (custom periods) | N/A | ID | Get Transaction Report |
| Transaction Report Single Campaign (custom periods) | N/A | ID | Get Transaction Report |
| Program Memberships | N/A | ID | Get All Program Memberships |
Incremental logic for Transaction Report
The API currently does not allow to filter transactions via the
LAST_UPDATEDfield, so incremental logic relies on theDATEfield of transactions.This means some data might be missed on incremental (append) runs for transactions where the
LAST_UPDATEDis much later than theDATEfield value. To avoid missing data, you can periodically do backfill runs and do reconciliations in the data warehouse.
Duplicates
Transaction reports runs can generate duplicates, so you will need to de-duplicate in a Transform.
Updated 10 months ago