Integration Specifications
This article will help you learn about how Daasity replicates data from Duoplane, limitations to the data we can extract and where the data is stored in the Duoplane schema
Integration Overview
Duoplane is focused on the development of technology solutions to automate and manage business and supply chains of e-commerce businesses. It is a provider of drop-ship and operations for advanced order routing and inventory syncing.
This document provides context on what kind of data is being gathered through this extractor, which endpoints that data is coming from, and how the extracted tables relate to each other.
Integration Availability
This integration is available for:
Enterprise
API Endpoints
The Daasity Duoplane extractor is built based on this Duoplane API Documentation. The following endpoint is used by Daasity to replicate data from Duoplane:
Entity Relationship Diagram (ERD)
Click here to view the ERD for the Daasity Duoplane integration illustrating the different tables and keys to join across tables.
Duoplane Schema
The Daasity Duoplane 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.
Purchase Orders
Endpoint: Purchase Order
Update Method: UPSERT
Table Name: [
duoplane.purchase_orders]
purchase_order::id
purchase_order_id
purchase_order::public_reference
purchase_order_number
purchase_order::ordered_at
ordered_at
purchase_order::order_public_reference
order_number
purchase_order::vendor_id
retailer_id
purchase_order::retailer_account
retailer_account_number
purchase_order::vendor
retailer_name
purchase_order::promise_date
promise_date
purchase_order::vendor_reference
vendor_reference
purchase_order::ship_method
ship_method
purchase_order::shipping_address::first_name
shipping_first_name
purchase_order::shipping_address::last_name
shipping_last_name
purchase_order::shipping_address::company_name
shipping_company
purchase_order::shipping_address::address_1
shipping_address1
purchase_order::shipping_address::address_2
shipping_address2
purchase_order::shipping_address::city
shipping_city
purchase_order::shipping_address::province
shipping_state
purchase_order::shipping_address::post_code
shipping_zipcode
purchase_order::shipping_address::country
shipping_country
purchase_order::shipping_address::phone
shipping_phone
created_at
updated_at
Daasity: timestamp when loaded into DB
__synced_at
Purchase Order Items
Endpoint: Purchase Order
Update Method: UPSERT
Table Name: [
duoplane.purchase_order_items]
MD5(purchase_order::id + purchase_order::order_items::id)
key
purchase_order::id
purchase_order_id
purchase_order::order_items::id
id
purchase_order::order_items::name
name
purchase_order::order_items::retailer_sku
retailer_sku
purchase_order::order_items::vendor_sku
vendor_sku
purchase_order::order_items::quantity
quantity
purchase_order::order_items::quantity_open
quantity_open
purchase_order::order_items::cost
cost
purchase_order::order_items::price
price
purchase_order::order_items::total_discount
total_discount
purchase_order::order_items::net_price
net_price
purchase_order::order_items::promise_date
promise_date
Daasity: timestamp when loaded into DB
__synced_at
Shipments
Endpoint: Shipment
Update Method: UPSERT
Table Name: [
duoplane.shipments]
shipment::id
shipment_id
shipment::purchase_order_id
purchase_order_id
shipment::purchase_order_public_reference
purchase_order_number
shipment::shipper_id
shipper_id
shipment::shipper_name
shipper_name
shipment::vendor_invoice_reference
vendor_invoice_reference
shipment::vendor_shipping_cost
vendor_shipping_cost
shipment::vendor_handling_cost
vendor_handling_cost
shipment::shipper_invoice_reference
shipper_invoice_reference
shipment::shipper_shipping_cost
shipper_shipping_cost
shipment::created_at
created_at
shipment::updated_at
updated_at
Daasity: timestamp when loaded into DB
__synced_at
Shipment Items
Endpoint: Shipment
Update Method: UPSERT
Table Name: [
duoplane.shipment_items]
MD5(shipment::id + shipment::shipment_items_attributes::id)
key
shipment::shipment_items_attributes::id
id
shipment::id
shipment_id
shipment::shipment_items_attributes::order_item_id
order_item_id
shipment::shipment_items_attributes::order_item_name
order_item_name
shipment::shipment_items_attributes::quantity
quantity
shipment::shipment_items_attributes::cost
cost
Daasity: timestamp when loaded into DB
__synced_at
Shipment Tracking Numbers
Endpoint: Shipment
Update Method: UPSERT
Table Name: [
duoplane.shipment_tracking_numbers]
MD5(shipment::id + shipment::shipment_trackings_attributes::tracking)
key
shipment::id
shipment_id
shipment::shipment_trackings_attributes::id
id
shipment::shipment_trackings_attributes::tracking
shipper_tracking_number
Daasity: timestamp when loaded into DB
__synced_at
Last updated