JDBC Driver for Amazon Marketplace

Build 22.0.8538

VendorPackingSlips

This view is part of Vendor Direct Fulfillment Shipping API. Returns a list of packing slips for the purchase orders that match the criteria specified. Date range to search must not be more than 7 days.

Select

The following fields are filtered server-side:
  • PurchaseOrderNumber supports the '=' comparison
  • CreatedDate supports all the >, >=, =, <=, < comparisons

Some example queries:

SELECT * FROM VendorPackingSlips

SELECT * FROM VendorPackingSlips WHERE PurchaseOrderNumber = '12345'

SELECT * FROM VendorPackingSlips WHERE CreatedDate > '2022-09-10T12:00:00' AND CreatedDate < '2022-09-15T12:00:00'

Columns

Name Type References Description
PurchaseOrderNumber [KEY] String This field will contain the Purchase Order Number for this order.
Content String A Base64encoded string of the packing slip PDF.
ContentType String The format of the file such as PDF, JPEG etc

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
CreatedDate String Filters for created date. If left empty the default specified range is from 6 days earlier to today

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8538