Edit on GitHub
Lob Lite link
Lob is direct mail platform.
Featureslink
Feature Name | Supported | Notes |
---|---|---|
Capture deletes | check | All tables |
Custom data | check | ADDRESS , BANK_ACCOUNT , CHECK , LETTER , POSTCARD , TEMPLATE , and TEMPLATE_VERSION tables. |
Data blocking | check | Column level |
Column hashing | check | |
Re-sync | check | Connector level |
History | ||
API configurable | check | API configuration |
Priority-first sync | ||
Fivetran data models | ||
Private networking |
Setup guidelink
Follow our step-by-step Lob setup guide to connect Lob with your destination using Fivetran connectors.
Schema informationlink
This schema applies to all Lob connectors.
To zoom, open the ERD in a new window.Custom datalink
The Lob connector extracts custom data from source tables into separate destination tables.
Source Table | Destination Table |
---|---|
ADDRESS | ADDRESS_METADATA |
BANK_ACCOUNT | BANK_ACCOUNT_METADATA |
CHECK | CHECK_METADATA , CHECK_MERGE_VARIABLE |
LETTER | LETTER_METADATA , LETTER_MERGE_VARIABLE |
POSTCARD | POSTCARD_METADATA , POSTCARD_MERGE_VARIABLE |
TEMPLATE | TEMPLATE_METADATA |
TEMPLATE_VERSION | TEMPLATE_VERSION_MERGE_VARIABLE |
We store the custom field name and value (JSON string) in the name
and value
columns of the destination table. The table also contains a foreign key column to the original table from which we extracted the custom data.
Limitationslink
We do not support Webhook events.