Shippo
Shippo ETL connector for data replication
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 |
- 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
- 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
Adressess
Purpose: Returns the list of all 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.
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.
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.
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.
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.
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.
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.
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.
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.
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 |
Last modified 3yr ago