Integration Specifications

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:

• Get Orders

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

• Shipment Products

• Shipment Status Details

• Shipments

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