Returns the list of purchase orders.

View-Specific Information

Select

The connector will use the ShipStation API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client side within the connector.

• Id, OrderNumber, Status, ReferenceNumber and WarehouseId support the following operator: =.
• CreateDate supports the following operators: >,>=.

For example, the following queries are processed server side:

SELECT * FROM PurchaseOrders WHERE Id = 'se-4567'

SELECT * FROM PurchaseOrders WHERE OrderNumber = 'se-2345'

SELECT * FROM PurchaseOrders WHERE Status = 'open'

SELECT * FROM PurchaseOrders WHERE ReferenceNumber = '1234'

SELECT * FROM PurchaseOrders WHERE WarehouseId = 'se-5678'

SELECT * FROM PurchaseOrders WHERE CreateDate > '2024-11-13T23:47:25.293-05:00'

SELECT * FROM PurchaseOrders WHERE CreateDate >= '2024-11-13T23:47:25.293-05:00'

Columns

Name	Type	References	Description
Id [KEY]	String		A string that uniquely identifies the purchase order.
OrderNumber	String		The purchase order number.
SupplierId	String	Suppliers.Id	A string that uniquely identifies the supplier.
SupplierName	String		The name of the supplier.
Status	String		The status of the purchase order. The allowed values are draft, open, receiving, received, cancelled, closed.
OrderDate	Datetime		The date the purchase order was placed.
ExpectedDeliveryDate	Datetime		The expected delivery date of the purchase order.
CreateDate	Datetime		The date and time the purchase order was created.
ModifyDate	Datetime		The date and time the purchase order was last modified.
ReferenceNumber	String		An optional reference number for the purchase order.
WarehouseId	String	Warehouses.Id	A string that uniquely identifies the destination warehouse.