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

1. Signin to Daton

2. Select shippo from Integrations page

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 your shippo email and password to authorize Daton to periodically extract data from constantcontact.

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

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