Lob Lite
Lob is direct mail platform.
Features
| Feature Name | Supported | Notes |
|---|---|---|
| Capture deletes | check | ADDRESS. |
| History mode | ||
| Custom data | check | ADDRESS, BANK_ACCOUNT, CHECK, LETTER, POSTCARD, TEMPLATE, and TEMPLATE_VERSION tables. |
| Data blocking | check | |
| Column hashing | check | |
| Re-sync | check | |
| API configurable | check | API configuration |
| Priority-first sync | ||
| Fivetran data models | ||
| Private networking | ||
| Authorization via API |
Setup guide
Follow our step-by-step Lob setup guide to connect Lob with your destination using Fivetran connectors.
Sync overview
To capture new records, we incrementally sync the following tables:
ADDRESSBANK_ACCOUNTCHECKSLETTERPOSTCARDSELF_MAILERTEMPLATETEMPLATE_VERSION
We also re-import the following tables once a week to capture updates and deletes:
BANK_ACCOUNTCHECKSLETTERPOSTCARDSELF_MAILERTEMPLATE
Schema information
This schema applies to all Lob connectors.
Explore Lob schema ERD
Custom data
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.
Limitations
We do not support Webhook events.