Integration: Order Desk

This article will help you learn about how Daasity replicates data from Order Desk, limitations to the data we can extract and where the data is stored in the Order Desk schema.

Key Topics

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

• Integration Overview
• Integration Availability
• API Endpoints
• Entity Relationship Diagram
• Order Desk Schema
• Related Resources

Integration Overview

Order Desk automates and streamlines order management workflow with integrations to hundreds of e-commerce services.

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 V2

API Endpoints

The Daasity Order Desk extractor is built based on this Order Desk API documentation.  The following endpoint is used by Daasity to replicate data from Order Desk:

• Orders

Entity Relationship Diagram (ERD)

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

Order Desk Schema

The Daasity Order Desk 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
• Order Checkout Data
• Order Metadata
• Order Discount List
• Order Notes
• Order Items
• Order Items Variation List
• Order Shipments

Orders

• Endpoint: Orders
• Update Method: UPSERT
• Table Name: order_desk.orders

Order Checkout Data

• Endpoint: Orders
• Update Method: UPSERT
• Table Name: order_desk.order_checkout_data

Order Metadata

• Endpoint: Orders
• Update Method: UPSERT
• Table Name: order_desk.order_metadata

Order Discount List

• Endpoint: Orders
• Update Method: UPSERT
• Table Name: order_desk.order_discount_list

Order Notes

• Endpoint: Orders
• Update Method: UPSERT
• Table Name: order_desk.order_notes

Order Items

• Endpoint: Orders
• Update Method: UPSERT
• Table Name: order_desk.order_items

Order Items Variation List

• Endpoint: Orders
• Update Method: UPSERT
• Table Name: order_desk.order_items_variation_list

Order Shipments

• Endpoint: Orders
• Update Method: UPSERT
• Table Name: order_desk.order_shipments

Related Resources