Integration Specifications
Integration Overview
Overview here
Integration Availability
This integration is available for:
Enterprise
Growth
API Endpoints
This extractor is based on the Shipbob Developer API. The following endpoints are used by Daasity to replicate data into Daasity:
Entity Relationship Diagram (ERD)
Shipbob Schema
The Shipbob extractor creates these tables using the endpoints and replication methods listed. The data is mapped from source API endpoint to the table based on the mapping logic outlined in each table.
Orders
Endpoint: Get Orders
Update Method: UPSERT
Table Name: [
shipbob.orders]
| JSON Element | Column |
|---|---|
$.channel.id | channel__id |
$.channel.name | channel__name |
$.created_date | created_date |
$.financials.total_price | financials__total_price |
$.gift_message | gift_message |
$.id | id |
$.order_number | order_number |
$.products | products |
$.purchase_date | purchase_date |
$.recipient.address.address1 | recipient__address__address1 |
$.recipient.address.address2 | recipient__address__address2 |
$.recipient.address.city | recipient__address__city |
$.recipient.address.company_name | recipient__address__company_name |
$.recipient.address.country | recipient__address__country |
$.recipient.address.state | recipient__address__state |
$.recipient.address.zip_code | recipient__address__zip_code |
$.recipient.email | recipient__email |
$.recipient.name | recipient__name |
$.recipient.phone_number | recipient__phone_number |
$.reference_id | reference_id |
$.retailer_program_data.addresses | retailer_program_data__addresses |
$.retailer_program_data.customer_ticket_number | retailer_program_data__customer_ticket_number |
$.retailer_program_data.delivery_date | retailer_program_data__delivery_date |
$.retailer_program_data.department | retailer_program_data__department |
$.retailer_program_data.do_not_ship_before_date | retailer_program_data__do_not_ship_before_date |
$.retailer_program_data.mark_for_store | retailer_program_data__mark_for_store |
$.retailer_program_data.purchase_order_number | retailer_program_data__purchase_order_number |
$.retailer_program_data.retailer_program_type | retailer_program_data__retailer_program_type |
$.retailer_program_data.ship_by_date | retailer_program_data__ship_by_date |
$.shipping_method | shipping_method |
$.shipping_terms.carrier_type | shipping_terms__carrier_type |
$.shipping_terms.payment_term | shipping_terms__payment_term |
$.status | status |
$.tags | tags |
$.type | type |
MD5($.id) | __sync_key |
Shipment Products
Endpoint: Get Orders
Update Method: UPSERT
Table Name: [
shipbob.shipment_products]
| JSON Element | Column |
|---|---|
$.shipments[].products[].id | id |
$.shipments[].products[].inventory_items | inventory_items |
$.shipments[].products[].name | name |
$.shipments[].products[].reference_id | reference_id |
$.shipments[].products[].sku | sku |
$.shipments[].id | shipment_id |
MD5($.shipments[].products[].id + $.shipments[].id) | __sync_key |
Shipment Status Details
Endpoint: Get Orders
Update Method: UPSERT
Table Name: [
shipbob.shipment_status_details]
| JSON Element | Column |
|---|---|
$.shipments[].status_details[].description | description |
$.shipments[].status_details[].exception_fulfillment_center_id | exception_fulfillment_center_id |
$.shipments[].status_details[].extra_information | extra_information |
$.shipments[].status_details[].id | id |
$.shipments[].status_details[].inventory_id | inventory_id |
$.shipments[].status_details[].name | name |
$.shipments[].id | shipment_id |
MD5($.shipments[].status_details[].id) | __sync_key |
Shipments
Endpoint: Get Orders
Update Method: UPSERT
Table Name: [
shipbob.shipments]
| JSON Element | Column |
|---|---|
$.shipments[].actual_fulfillment_date | actual_fulfillment_date |
$.shipments[].created_date | created_date |
$.shipments[].delivery_date | delivery_date |
$.shipments[].estimated_fulfillment_date | estimated_fulfillment_date |
$.shipments[].estimated_fulfillment_date_status | estimated_fulfillment_date_status |
$.shipments[].gift_message | gift_message |
$.shipments[].id | id |
$.shipments[].insurance_value | insurance_value |
$.shipments[].invoice_amount | invoice_amount |
$.shipments[].invoice_currency_code | invoice_currency_code |
$.shipments[].is_tracking_uploaded | is_tracking_uploaded |
$.shipments[].last_tracking_update_at | last_tracking_update_at |
$.shipments[].last_update_at | last_update_at |
$.shipments[].location.id | location__id |
$.shipments[].location.name | location__name |
$.shipments[].measurements | measurements |
$.shipments[].order_id | order_id |
$.shipments[].package_material_type | package_material_type |
$.shipments[].parent_cartons | parent_cartons |
$.shipments[].recipient.address.address1 | recipient__address__address1 |
$.shipments[].recipient.address.address2 | recipient__address__address2 |
$.shipments[].recipient.address.city | recipient__address__city |
$.shipments[].recipient.address.company_name | recipient__address__company_name |
$.shipments[].recipient.address.country | recipient__address__country |
$.shipments[].recipient.address.state | recipient__address__state |
$.shipments[].recipient.address.zip_code | recipient__address__zip_code |
$.shipments[].recipient.email | recipient__email |
$.shipments[].recipient.full_name | recipient__full_name |
$.shipments[].recipient.name | recipient__name |
$.shipments[].recipient.phone_number | recipient__phone_number |
$.shipments[].reference_id | reference_id |
$.shipments[].require_signature | require_signature |
$.shipments[].ship_option | ship_option |
$.shipments[].status | status |
$.shipments[].tracking | tracking |
MD5($.shipments[].id) | __sync_key |
Last updated