SSIS Components for Amazon Marketplace

Build 23.0.8839


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.


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

Some example queries:

SELECT * FROM VendorPackingSlips WHERE PurchaseOrderNumber = '12345'

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


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 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) 2024 CData Software, Inc. - All rights reserved.
Build 23.0.8839