Amazon Selling Partner (SP-API) Connector
Documentation
Version: 1
Documentation

EndPoint Get Order (Single)


Name

get_order

Description

Returns the order information for a specified OrderId [API Help]

Parameters

Parameter Label Required Options Description
AmazonOrderId AmazonOrderId NO Filters purchase orders based on the specified orderid.

Output Columns

Label DataType Length Raw Description
AmazonOrderId DT_WSTR 500 False
PurchaseDate DT_DBTIMESTAMP 0 False
LastUpdateDate DT_DBTIMESTAMP 0 False
OrderStatus DT_WSTR 100 False
FulfillmentChannel DT_WSTR 50 False
SalesChannel DT_WSTR 100 False
ShipServiceLevel DT_WSTR 500 False
CurrencyCode DT_WSTR 50 False
Amount DT_WSTR 50 False
NumberOfItemsShipped DT_I4 0 False
NumberOfItemsUnshipped DT_I4 0 False
PaymentMethod DT_WSTR 50 False
PaymentMethodDetails DT_WSTR 500 False
IsReplacementOrder DT_BOOL 0 False
MarketplaceId DT_WSTR 500 False
ShipmentServiceLevelCategory DT_WSTR 100 False
OrderType DT_WSTR 500 False
EarliestShipDate DT_DBTIMESTAMP 0 False
LatestShipDate DT_DBTIMESTAMP 0 False
EarliestDeliveryDate DT_DBTIMESTAMP 0 False
LatestDeliveryDate DT_DBTIMESTAMP 0 False
IsBusinessOrder DT_BOOL 0 False
IsPrime DT_BOOL 0 False
IsGlobalExpressEnabled DT_BOOL 0 False
IsPremiumOrder DT_BOOL 0 False
IsSoldByAB DT_BOOL 0 False
IsIBA DT_BOOL 0 False
DefaultShipFromName DT_WSTR 500 False
DefaultShipAddressLine1 DT_WSTR 500 False
DefaultShipFromCity DT_WSTR 100 False
DefaultShipFromStateOrRegion DT_WSTR 50 False
DefaultShipFromPostalCode DT_WSTR 100 False
DefaultShipFromCountryCode DT_WSTR 50 False
DefaultShipFromPhone DT_WSTR 500 False
DefaultShipFromAddressType DT_WSTR 100 False
FulfillmentSupplySourceId DT_WSTR 500 False
IsISPU DT_BOOL 0 False
IsAccessPointOrder DT_BOOL 0 False
HasAutomatedShippingSettings DT_BOOL 0 False
EasyShipShipmentStatus DT_WSTR 500 False
ElectronicInvoiceStatus DT_WSTR 500 False

Input Columns

Label DataType Length Raw Description
There are no Static columns defined for this endpoint. This endpoint detects columns dynamically at runtime.