Integration: Duoplane

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.

Key Topics

Click on the links below to take you to the section where you can learn more about this Integration

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:

  • Pro (V1 and V2)

NOTE: You are considered V2 if...

  • Your account says Pro V2 in the Daasity App

Not sure? Reach out to Support@Daasity.com

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)

The embedded diagram houses the ERD for the Daasity Duoplane integration illustrating the different tables and keys to join across tables. Hover over the embedded diagram to reveal controls to zoom and scroll.

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
JSON Element Database Column
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
JSON Element Database Column
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
JSON Element Database Column
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
JSON Element Database Column
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
JSON Element Database Column
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

Related Resources