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:

https://apidoc.pipe17.com/#tag/Fulfillments/operation/fetchFulfillment

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:

https://apidoc.pipe17.com/#tag/Inventory/operation/listInventory

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:

https://apidoc.pipe17.com/#tag/Orders/operation/listOrders

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:

https://apidoc.pipe17.com/#tag/Orders/operation/fetchOrder

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:

https://apidoc.pipe17.com/#tag/Products/operation/listProducts

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:

https://apidoc.pipe17.com/#tag/Shipping-Requests/operation/listShipments

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

Table of Contents

Tables/APIs Supported Fulfillments Fulfillment_Lines

Schema Information for PIPE17

Saras Pulse

Saras Daton