Easypost

Easypost ETL connector for data replication

Snapshot

Features	Details
Release Status	Released
Source API Version	V1
Table Selection	Yes
Column Selection	Yes
Edit Integration	Yes
Replication Type Selection	No
Authentication Parameters	Easypost Username
Replication Type	Key Based Incremental
Replication Key	Date
Suggested Replication Frequency	1 hour

Tables/APIs supported

Shipments

Integrate Easypost with Daton

1. Sign in to Daton

2. Select Easypost from the list of Integrations

3. Provide Integration Name, Replication Frequency, and History. Integration name would be used in creating tables for the integration and cannot be changed later

4. Provide Easypost Username. Follow the link learn more about Easypost Authentication.

5. Post successful authentication, you will be prompted to choose from the list of available tables

6. Then select all required fields for each table

7. Submit the integration

Workflow

1. Integrations would be in Pending state initially and will be moved to Active state as soon as the first job loads data successfully on to the configured warehouse

2. Users would be able to edit/pause/re-activate/delete integration anytime

3. Users can view job status and process logs from the integration details page by clicking on the integration name from the active list

Easypost Data

Shipments

Purpose: This API is used to fetch a list of all shipments

Source API Documentation: https://www.easypost.com/docs/api#shipments

Replication: Key-Based Incremental

Replication Key: start_datetime, end_datetime

Fields

NAME	DATA TYPE
created_at	TIMESTAMP
is_return	BOOLEAN
mode	STRING
options	RECORD
status	STRING
tracking_code	STRING
updated_at	TIMESTAMP
batch_id	STRING
batch_status	STRING
customs_info	RECORD
from_address	RECORD
parcel	RECORD
postage_label	RECORD
rates	RECORD
scan_form	RECORD
selected_rate	RECORD
tracker	RECORD
to_address	RECORD
usps_zone	NUMERIC
return_address	RECORD
buyer_address	RECORD
fees	RECORD
id	STRING
object	STRING
messages	RECORD
reference	STRING
refund_status	STRING
forms	RECORD