Shippo
Shippo ETL connector for data replication
Shippo
Shippo ETL connector for data replication
Snapshot
Features |
Details |
Release Status |
Released |
Source API Version |
v1.2 |
Table Selection |
Yes |
Column Selection |
Yes |
Edit Integration |
Yes |
Replication Type Selection |
No |
Authentication Parameters |
Shippo email Shippo password |
Replication Type |
Full Based Replication Key-Based Replication |
Replication Key |
NA lastRunDate |
Suggested Replication Frequency |
24 hrs |
| Tables/APIs Supported | |
Adressess |
Parcels |
Shipments |
ShippingLables |
CustomItems |
CustomItemDeclarations |
Refunds |
Manifests |
CarrierAccounts |
Orders |
Integrate Shippo with Daton
- Signin to Daton
- Select shippo from Integrations page
- Provide Integration Name Replication Frequency and History. Integration name would be used in creating tables for the integration and cannot be changed later
- Provide your shippo email and password to authorize Daton to periodically extract data from constantcontact.
- Post successful authentication you will be prompted to choose from the list of available tables
- Then select all required fields for each table
- Submit the integration
Workflow
- 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
- Users would be able to edit/pause/re-activate/delete integration anytime
- Users can view job status and process logs from the integration details page by clicking on the integration name from the active list
SHIPPO Data
Adressess
Purpose: Returns the list of all addresses
Source API Documentation https://api.goshippo.com/addresses/
Replication: Full Replication
Replication Key: NA
Fields
Name |
Target Datatype |
is_complete |
BOOLEAN |
object_created |
TIMESTAMP |
object_updated |
TIMESTAMP |
object_id |
STRING |
object_owner |
STRING |
name |
STRING |
street1 |
STRING |
street2 |
STRING |
city |
STRING |
state |
STRING |
zip |
INTEGER |
country |
STRING |
phone |
INTEGER |
email |
STRING |
is_residential |
BOOLEAN |
metadata |
STRING |
test |
BOOLEAN |
Parcels
Purpose: Returns the list of all parcels.
Source API Documentation: https://api.goshippo.com/parcels/
Replication: Full Replication
Replication Key: NA
Fields
Name |
Target Datatype |
object_state |
STRING |
object_created |
TIMESTAMP |
object_updated |
TIMESTAMP |
object_id |
STRING |
object_owner |
STRING |
template |
STRING |
length |
STRING |
width |
STRING |
height |
STRING |
distance_unit |
STRING |
weight |
STRING |
mass_unit |
STRING |
metadata |
STRING |
test |
BOOLEAN |
Shipments
Purpose:Returns the list of all shipments.
Source API Documentation: https://api.goshippo.com/shipments/
Replication: Full Replication
Replication Key: NA
Fields
Name |
Target Datatype |
object_created |
TIMESTAMP |
object_updated |
TIMESTAMP |
object_id |
STRING |
object_owner |
STRING |
status |
STRING |
adress_from |
RECORD |
adrees_to |
RECORD |
parcels |
RECORD |
shipment_date |
TIMESTAMP |
adress_return |
RECORD |
extra |
RECORD |
custom_declaration |
STRING |
rates |
RECORD |
carrier_accounts |
STRING |
messages |
RECORD |
metdata |
STRING |
test |
BOOLEAN |
ShippingLables
Purpose:Returns the list of all shippinglables.
Source API Documentation: https://api.goshippo.com/shippinglables/
Replication: Full Replication
Replication Key: NA
Fields
Name |
Target Datatype |
object_state |
STRING |
status |
STRING |
object_created |
STRING |
object_updated |
STRING |
object_id |
STRING |
object_owner |
STRING |
test |
BOOLEAN |
rate |
STRING |
tracking_number |
STRING |
tracking_status |
STRING |
tracking_url_provider |
STRING |
eta |
STRING |
lable_url |
STRING |
commercial_invoice_url |
STRING |
messages |
STRING |
metdata |
STRING |
CustomItems
Purpose:Returns the list of all customitems.
Source API Documentation: https://api.goshippo.com/customitems/
Replication: Full Replication
Replication Key: NA
Fields
Name |
Target Datatype |
object_created |
TIMESTAMP |
object_updated |
TIMESTAMP |
object_id |
STRING |
object_owner |
STRING |
object_state |
STRING |
description |
STRING |
quantity |
NUMERIC |
net_weight |
STRING |
mass_unit |
STRING |
value_amount |
STRING |
value_currency |
STRING |
origin_country |
STRING |
tariff_number |
STRING |
metdata |
STRING |
test |
BOOLEAN |
CustomItemDeclarations
Purpose:Returns the list of all customitemdeclarations.
Source API Documentation: https://api.goshippo.com/customitemdeclarations/
Replication: Full Replication
Replication Key: NA
Fields
Name |
Target Datatype |
object_created |
TIMESTAMP |
object_updated |
TIMESTAMP |
object_id |
STRING |
object_owner |
STRING |
object_state |
STRING |
certify_signer |
STRING |
certify |
BOOLEAN |
items |
STRING |
non_delivery_option |
STRING |
contents_type |
STRING |
contents_explanation |
STRING |
exporter_reference |
STRING |
importer_reference |
STRING |
invoice |
STRING |
commercial_invoice |
BOOLEAN |
license |
STRING |
certificate |
STRING |
notes |
STRING |
eel_pfc |
STRING |
aes_itn |
STRING |
disclaimer |
STRING |
incoterm |
STRING |
metdata |
STRING |
test |
BOOLEAN |
Refunds
Purpose:Returns the list of all refunds.
Source API Documentation: https://api.goshippo.com/refunds/
Replication: Full Replication
Replication Key: NA
Fields
Name |
Target Datatype |
object_created |
TIMESTAMP |
object_updated |
TIMESTAMP |
object_id |
STRING |
object_owner |
STRING |
status |
STRING |
transactions |
STRING |
test |
BOOLEAN |
Manifests
Purpose:Returns the list of all mainfest.
Source API Documentation https://api.goshippo.com/manifests/
Replication: Full Replication
Replication Key: NA
Fields
Name |
Target Datatype |
object_created |
TIMESTAMP |
object_updated |
TIMESTAMP |
object_id |
STRING |
object_owner |
STRING |
status |
STRING |
carrier_account |
STRING |
shipment_date |
STRING |
adress_from |
STRING |
transactions |
STRING |
documents |
STRING |
CarrierAccounts
Purpose:Returns the list of list all carrier accounts.
Source API Documentation https://api.goshippo.com/carrieraccounts/
Replication: Full Replication
Replication Key: NA
Fields
Name |
Target Datatype |
object_id |
STRING |
object_owner |
STRING |
carrier |
STRING |
account_id |
STRING |
test |
BOOLEAN |
active |
BOOLEAN |
Orders
Purpose:Returns the list of all orders.
Source API Documentation https://api.goshippo.com/orders/
Replication: Full Replication
Replication Key: NA
Fields
Name |
Target Datatype |
object_id |
STRING |
object_owner |
STRING |
order_number |
STRING |
order_status |
STRING |
placed_at |
STRING |
to_address |
RECORD |
from_address |
STRING |
line_items |
RECORD |
shipping_cost |
STRING |
shipping_cost_currency |
STRING |
shipping_method |
STRING |
shop_app |
STRING |
subtotal_price |
STRING |
total_price |
STRING |
total_tax |
STRING |
currency |
STRING |
transactions |
STRING |
weight |
STRING |
weight_unit |
STRING |
notes |
STRING |
