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