Postscript
Postscript
Overview
The Postscript connector enables teams to bring SMS marketing subscriber data into their analytics stack, allowing them to understand how SMS subscribers are acquired, engaged, and converted across their customer lifecycle.
Postscript typically captures:
- Subscriber acquisition source and timestamps
- SMS subscription consent (promotional and transactional)
- Shopify customer linkage and identifiers
- Subscriber tags and custom properties
By replicating this data into your warehouse, the connector allows you to blend SMS subscriber insights with transactional, marketing, and behavioral datasets.
Authentication Credentials
To connect Postscript with Daton, you need to provide an API access token generated from your Postscript account.
Required Fields
| Field | Description |
|---|---|
| Access Token | Postscript Private API Key |
How to Obtain the Postscript Private API Key
Follow these steps in your Postscript account:
- Log in to your Postscript dashboard
- Click on Account Settings
- Select the API tab
- Click Create New Secret Key Pair
- Label the key pair as Saras
- Click Show to reveal the Private Key
- Copy the generated Private Key
- Paste this value into the Access Token field on the Daton connector setup screen during the integration setup
Supported Tables
| Table Name | Description | Load Type |
|---|---|---|
| Subscribers | SMS subscribers in your Postscript account, including consent status, contact information, and Shopify linkage | Incremental |
Table-Level Details
1. Subscribers
Description
Contains all SMS subscribers in your Postscript account, including their contact details, consent (promotional/transactional), linked Shopify customer information, tags, and custom properties.
Endpoint
GET https://api.postscript.io/api/v2/subscribers
Load Behavior
- Incremental load using
updated_at - All timestamps are processed in UTC
Primary Key - id
Schema
| Column Name | Data Type | Mode | Description |
|---|---|---|---|
| id | STRING | NULLABLE | Unique identifier for the subscriber |
| created_at | DATETIME | NULLABLE | Subscriber creation timestamp |
| updated_at | DATETIME | NULLABLE | Subscriber last updated timestamp |
| STRING | NULLABLE | Subscriber email address | |
| phone_number | STRING | NULLABLE | Subscriber phone number |
| resource | STRING | NULLABLE | Resource type identifier |
| shopify_customer_id | NUMERIC | NULLABLE | Linked Shopify customer ID |
| shopify_customer | RECORD | REPEATED | Linked Shopify customer details (nested: first_name, last_name, id) |
| subscriptions | RECORD | REPEATED | Subscription consent details (nested: promotional.can_send, transactional.can_send) |
| properties | RECORD | REPEATED | Custom subscriber properties (nested key-value pairs) |
| tags | STRING | NULLABLE | Tags applied to the subscriber |
Error Handling & Retries
The connector automatically handles:
- HTTP 429 (rate limiting) — retries after a 60-second sleep interval
- HTTP 5xx server errors
Retries use controlled sleep intervals with logging to ensure data completeness without overwhelming the Postscript API.