Schema Information for PIPE17
Schema Information for PIPE17
In this article, we will look at the schema information of the supported APIs and tables for PIPE17.
Find the links to other articles related to PIPE17 below:
Tables/APIs Supported
The tables and APIs associated with the PIPE17 connector are as follows.
Fulfillments
Purpose: The Fulfillments table in Pipe17 serves as a critical component for tracking and managing the fulfillment process of orders. It provides a detailed record of how orders are fulfilled, their current status, and associated logistics data. This table is particularly useful for monitoring, analyzing, and troubleshooting the fulfillment lifecycle in e-commerce operations.
Source API Documentation: https://apidoc.pipe17.com/#tag/Fulfillments/operation/listFulfillments
Replication Type: Key Based
Field Name |
Data Type |
actualShipDate |
TIMESTAMP |
autoEngUpdateStatus |
STRING |
createdAt |
TIMESTAMP |
extOrderId |
STRING |
fulfillmentId |
STRING |
fulfillmentType |
STRING |
orgKey |
STRING |
shipmentId |
STRING |
updatedAt |
TIMESTAMP |
_daton_user_id |
NUMERIC |
_daton_batch_runtime |
NUMERIC |
Fulfillment_Lines
Purpose: The Fulfillment Lines table in Pipe17 tracks detailed information about the individual items included in a fulfillment. While the Fulfillments table focuses on the overall fulfillment process, the Fulfillment Lines table breaks it down into item-level details.
Source API Documentation:
Replication Type: Key Based
Name |
Data Type |
success |
BOOL |
code |
NUMERIC |
_daton_user_id |
NUMERIC |
_daton_batch_runtime |
NUMERIC |
_daton_batch_id |
NUMERIC |
fulfillment |
RECORD |
fulfillment.actualShipDate |
TIMESTAMP |
fulfillment.autoEngUpdateStatus |
STRING |
fulfillment.createdAt |
TIMESTAMP |
fulfillment.extFulfillmentId |
STRING |
fulfillment.extOrderId |
STRING |
fulfillment.fulfillmentId |
STRING |
fulfillment.fulfillmentType |
STRING |
fulfillment.integration |
STRING |
fulfillment.locationId |
STRING |
fulfillment.orderIntegration |
STRING |
fulfillment.orgKey |
STRING |
fulfillment.shipmentId |
STRING |
fulfillment.shipmentIntegration |
STRING |
fulfillment.shippingCarrier |
STRING |
fulfillment.shippingClass |
STRING |
fulfillment.trackingNumber |
STRING |
fulfillment.trackingURLs |
STRING |
fulfillment.updatedAt |
TIMESTAMP |
fulfillment.customFields |
RECORD |
fulfillment.customFields.name |
STRING |
fulfillment.customFields.value |
STRING |
Inventory
Purpose: The Inventory table in Pipe17 serves as the central repository for tracking and managing product stock levels across warehouses, sales channels, and fulfillment centers. It provides real-time insights into inventory availability, enabling businesses to prevent stockouts, overselling, and inefficiencies.
Source API Documentation:
Replication Type: Key Based
Fields
Name |
Data Type |
available |
NUMERIC |
committed |
NUMERIC |
createdAt |
TIMESTAMP |
future |
NUMERIC |
integration |
STRING |
locationId |
STRING |
onHand |
NUMERIC |
orgKey |
STRING |
sku |
STRING |
updatedAt |
TIMESTAMP |
incoming |
NUMERIC |
unavailable |
NUMERIC |
vendorSKU |
STRING |
committedFuture |
NUMERIC |
_daton_user_id |
NUMERIC |
_daton_batch_runtime |
NUMERIC |
_daton_batch_id |
NUMERIC |
Orders
Purpose: The Orders table in the Pipe17 connector serves as the core dataset for tracking and managing customer orders throughout their lifecycle. It consolidates order information from various sales channels and provides the data necessary for fulfillment, inventory management, and customer support.
Source API Documentation:
Replication Type: Key Based
Fields
Name |
Data Type |
createdAt |
TIMESTAMP |
extOrderId |
STRING |
orderId |
STRING |
orgKey |
STRING |
status |
STRING |
tags |
STRING |
updatedAt |
TIMESTAMP |
shipByDate |
TIMESTAMP |
_daton_user_id |
NUMERIC |
_daton_batch_runtime |
NUMERIC |
_daton_batch_id |
NUMERIC |
Order_Lines
Purpose: The Order Lines table in Pipe17 provides a detailed breakdown of the items included in each customer order. It complements the Orders table by focusing on item-level specifics, offering granular insights into quantities, SKUs, and pricing. This level of detail is critical for accurate fulfillment, inventory tracking, and financial reconciliation.
Source API Documentation:
Replication Type: Key Based
Fields
Name |
Data Type |
success |
BOOL |
code |
NUMERIC |
_daton_user_id |
NUMERIC |
_daton_batch_runtime |
NUMERIC |
_daton_batch_id |
NUMERIC |
c_order |
RECORD |
Products
Purpose: The Products table in Pipe17 serves as a centralized repository for managing product details across all connected sales channels and warehouses. It contains essential information about each product, such as its SKU, description, pricing, and attributes, ensuring consistency and accuracy throughout the order-to-fulfillment process.
Source API Documentation:
Replication Type: Key Based
Fields
Name |
Data Type |
createdAt |
TIMESTAMP |
extProductId |
STRING |
inventoryNotTracked |
BOOL |
name |
STRING |
orgKey |
STRING |
parentExtProductId |
STRING |
productId |
STRING |
sku |
STRING |
status |
STRING |
tags |
STRING |
types |
STRING |
updatedAt |
TIMESTAMP |
_daton_user_id |
NUMERIC |
_daton_batch_runtime |
NUMERIC |
_daton_batch_id |
NUMERIC |
Shipments
Purpose: The Shipments table in Pipe17 tracks and manages shipment-related details for orders, providing visibility into the delivery process. It acts as a crucial link between orders, fulfillments, and carriers, ensuring efficient and accurate shipment management.
Source API Documentation:
Replication Type: Key Based
Fields
Name |
Data Type |
createdAt |
TIMESTAMP |
extOrderId |
STRING |
extReferenceId |
STRING |
extShipmentId |
STRING |
orderCreateTime |
TIMESTAMP |
orderId |
STRING |
orderType |
STRING |
orgKey |
STRING |
overfulfillPolicy |
STRING |
sentToFulfillmentAt |
TIMESTAMP |
shipByDate |
TIMESTAMP |
shipmentId |
STRING |
status |
STRING |
updatedAt |
TIMESTAMP |
version |
NUMERIC |
tags |
STRING |
_daton_user_id |
NUMERIC |
_daton_batch_runtime |
NUMERIC |
_daton_batch_id |
NUMERIC |
