Amazon Selling Partner (SP-API) Connector
Documentation
Version: 1
Documentation
Home » API Integration Hub » Amazon Selling Partner (SP-API) Connector » EndPoints » Get Vendor PurchaseOrder Items

EndPoint Get Vendor PurchaseOrder Items

Name

get_vendor_purchaseorder_items

Description

Returns a list of purchase order items created or changed during the time frame that you specify. You define the time frame using the createdAfter, createdBefore, changedAfter and changedBefore parameters. The date range to search must not be more than 7 days. You can choose to get only the purchase order numbers by setting includeDetails to false. You can then use the getPurchaseOrder operation to receive details for a specific purchase order. [API reference]

Parameters

Parameter Label Required Options Description
CreatedAfter CreatedAfter NO
Option Value
2023-12-31 2023-12-31
2023-12-31T00:00:00 2023-12-31T00:00:00
now now
now-24h now-24h
today today
yesterday yesterday
yearstart-10y yearstart-10y
monthstart monthstart
monthend monthend
yearstart yearstart
yearend yearend
weekstart weekstart
weekend weekend
yearstart-1y yearstart-1y
yearend-1y yearend-1y
monthstart-1d monthstart-1d
monthend+1d monthend+1d
monthend+1d-1y monthend+1d-1y
Purchase orders that became available after this time will be included in the result. Must be in ISO 8601 date/time format. Date format must be UTC - ISO 8601 format (e.g. short date 2017-02-10 -OR- date and time 2017-02-10T12:10:02). If LastUpdatedAfter is not specified. Specifying both CreatedAfter and LastUpdatedAfter returns an error. You can use static values or date functions. Supported functions are now|today|yesterday|weekstart|weekend|monthstart|monthend|yearstart|yearend and supported intervals for add/subtract are ms|s|sec|min|h|hour|y|year|d|day|m|month|y|year. Example monthstart-3d (subtract 3days from month start)
CreatedBefore CreatedBefore NO
Option Value
2023-12-31 2023-12-31
2023-12-31T00:00:00 2023-12-31T00:00:00
now now
now-24h now-24h
today today
yesterday yesterday
yearstart-10y yearstart-10y
monthstart monthstart
monthend monthend
yearstart yearstart
yearend yearend
weekstart weekstart
weekend weekend
yearstart-1y yearstart-1y
yearend-1y yearend-1y
monthstart-1d monthstart-1d
monthend+1d monthend+1d
monthend+1d-1y monthend+1d-1y
Purchase orders that became available before this time will be included in the result. Must be in ISO 8601 date/time format. Date format must be UTC - ISO 8601 format (e.g. short date 2017-02-10 -OR- date and time 2017-02-10T12:10:02) You can use static values or date functions. Supported functions are now|today|yesterday|weekstart|weekend|monthstart|monthend|yearstart|yearend and supported intervals for add/subtract are ms|s|sec|min|h|hour|y|year|d|day|m|month|y|year. Example monthstart-3d (subtract 3days from month start)
ChangedAfter ChangedAfter NO
Option Value
2023-12-31 2023-12-31
2023-12-31T00:00:00 2023-12-31T00:00:00
now now
now-24h now-24h
today today
yesterday yesterday
yearstart-10y yearstart-10y
monthstart monthstart
monthend monthend
yearstart yearstart
yearend yearend
weekstart weekstart
weekend weekend
yearstart-1y yearstart-1y
yearend-1y yearend-1y
monthstart-1d monthstart-1d
monthend+1d monthend+1d
monthend+1d-1y monthend+1d-1y
Purchase orders that changed after this timestamp will be included in the result. Must be in ISO 8601 date/time format. Date format must be UTC - ISO 8601 format (e.g. short date 2017-02-10 -OR- date and time 2017-02-10T12:10:02). If CreatedAfter is not specified.Specifying both CreatedAfter and LastUpdatedAfter returns an error.If LastUpdatedAfter is specified, then BuyerEmail and SellerOrderId cannot be specified. You can use static values or date functions. Supported functions are now|today|yesterday|weekstart|weekend|monthstart|monthend|yearstart|yearend and supported intervals for add/subtract are ms|s|sec|min|h|hour|y|year|d|day|m|month|y|year. Example monthstart-3d (subtract 3days from month start)
ChangedBefore ChangedBefore NO
Option Value
2023-12-31 2023-12-31
2023-12-31T00:00:00 2023-12-31T00:00:00
now now
now-24h now-24h
today today
yesterday yesterday
yearstart-10y yearstart-10y
monthstart monthstart
monthend monthend
yearstart yearstart
yearend yearend
weekstart weekstart
weekend weekend
yearstart-1y yearstart-1y
yearend-1y yearend-1y
monthstart-1d monthstart-1d
monthend+1d monthend+1d
monthend+1d-1y monthend+1d-1y
Purchase orders that changed before this timestamp will be included in the result. Must be in ISO 8601 date/time format. Date format must be UTC - ISO 8601 format (e.g. short date 2017-02-10 -OR- date and time 2017-02-10T12:10:02) You can use static values or date functions. Supported functions are now|today|yesterday|weekstart|weekend|monthstart|monthend|yearstart|yearend and supported intervals for add/subtract are ms|s|sec|min|h|hour|y|year|d|day|m|month|y|year. Example monthstart-3d (subtract 3days from month start)
IncludeDetails IncludeDetails NO
Option Value
true true
false false
When true, returns purchase orders with complete details. Otherwise, only purchase order numbers are returned. Default value is true.
SortOrder SortOrder NO
Option Value
ASC ASC
DESC DESC
Sort in ascending or descending order by purchase order creation date.
PoItemState PoItemState NO
Option Value
ACCEPTED ACCEPTED
PARTIALLY_ACCEPTED PARTIALLY_ACCEPTED
REJECTED REJECTED
UNCONFIRMED UNCONFIRMED
Current state of the purchase order item. If this value is Cancelled, this API will return purchase orders which have one or more items cancelled by Amazon with updated item quantity as zero.
IsPOChanged IsPOChanged NO
Option Value
true true
false false
When true, returns purchase orders which were modified after the order was placed. Vendors are required to pull the changed purchase order and fulfill the updated purchase order and not the original one. Default value is false.
PurchaseOrderState PurchaseOrderState NO
Option Value
New New
Acknowledged Acknowledged
Closed Closed
Filters purchase orders based on the purchase order state.
OrderingVendorCode OrderingVendorCode NO Filters purchase orders based on the specified ordering vendor code. This value should be same as 'sellingParty.partyId' in the purchase order. If not included in the filter, all purchase orders for all of the vendor codes that exist in the vendor group used to authorize the API client application are returned.
PageSize PageSize NO

Output Columns

Label Data Type (SSIS) Data Type (SQL) Length Raw Description
PurchaseOrderNumber DT_WSTR nvarchar(50) 50 False
PurchaseOrderState DT_WSTR nvarchar(50) 50 False
PurchaseOrderDate DT_DBTIMESTAMP datetime False
PurchaseOrderChangedDate DT_DBTIMESTAMP datetime False
PurchaseOrderStateChangedDate DT_DBTIMESTAMP datetime False
PurchaseOrderType DT_WSTR nvarchar(50) 50 False
ImportContainers DT_WSTR nvarchar(100) 100 False
InternationalCommercialTerms DT_WSTR nvarchar(100) 100 False
MethodOfPayment DT_WSTR nvarchar(50) 50 False
PortOfDelivery DT_WSTR nvarchar(50) 50 False
ShippingInstructions DT_WSTR nvarchar(2000) 2000 False
PaymentMethod DT_WSTR nvarchar(50) 50 False
BuyingPartyPartyId DT_WSTR nvarchar(50) 50 False
SellingPartyPartyId DT_WSTR nvarchar(50) 50 False
ShipToPartyPartyId DT_WSTR nvarchar(50) 50 False
BillToPartyPartyId DT_WSTR nvarchar(50) 50 False
ShipWindow DT_WSTR nvarchar(200) 200 False
ItemSequenceNumber DT_WSTR nvarchar(6) 6 False
AmazonProductIdentifier DT_WSTR nvarchar(50) 50 False
VendorProductIdentifier DT_WSTR nvarchar(50) 50 False
OrderedQuantityAmount DT_I8 bigint False
OrderedQuantityUnitOfMeasure DT_WSTR nvarchar(50) 50 False
OrderedQuantityUnitSize DT_I8 bigint False
IsBackOrderAllowed DT_BOOL bit False
NetCostAmount DT_WSTR nvarchar(40) 40 False
NetCostCurrencyCode DT_WSTR nvarchar(12) 12 False
ListPriceAmount DT_WSTR nvarchar(40) 40 False
ListPriceCurrencyCode DT_WSTR nvarchar(12) 12 False

Input Columns

Label Data Type (SSIS) Data Type (SQL) Length Raw Description
There are no Static columns defined for this endpoint. This endpoint detects columns dynamically at runtime.

Examples

SSIS

Use Amazon Selling Partner (SP-API) Connector in API Source component to read data or in API Destination component to read/write data:

Get Vendor PurchaseOrder Items using API Source

Amazon Selling Partner (SP-API)
Get Vendor PurchaseOrder Items
SSIS API Source - Read from table or endpoint

Get Vendor PurchaseOrder Items using API Destination

Amazon Selling Partner (SP-API)
Get Vendor PurchaseOrder Items
SSIS API Destination - Access table or endpoint