JDBC Driver for ShipStation

Build 22.0.8462

Warehouses

Lists warehouses.

Select

The driver 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 driver.

  • Id supports the following operator: =.
For example, the following query is processed server side:
SELECT * FROM Warehouses WHERE Id = 8688
You can turn off client-side execution by setting SupportEnhancedSQL to false in which case any search criteria that refers to other columns will cause an error.

Columns

Name Type References Description
Id [KEY] Integer Id of the warehouses.
WarehouseName String Name of the warehouse.
CreateDate Datetime Create date of the record.
ExtInventoryIdentity String Inventory Identity.
IsDefault Boolean Whether it is default warehouse or not.
OriginAddressAddressVerified String Origin address is verified or not.
OriginAddressCity String Origin city of the warehouse.
OriginAddressCompany String Origin country of the warehouse.
OriginAddressCountry String Origin name of the warehouse.
OriginAddressName String Origin phone of the warehouse.
OriginAddressPhone String Origin phone of the warehouse.
OriginAddressPostalCode String Origin postal code of the warehouse.
OriginAddressResidential Boolean Origin residential of the warehouse.
OriginAddressState String Origin state of the warehouse.
OriginAddressStreet1 String Origin street of the warehouse.
OriginAddressStreet2 String Origin street of the warehouse.
OriginAddressStreet3 String Origin street of the warehouse.
RegisterFedexMeter String Register Fedex Meter.
ReturnAddressAddressVerified String Return address is verified or not.
ReturnAddressCity String Return city of the warehouse.
ReturnAddressCompany String Return company of the warehouse.
ReturnAddressCountry String Return country of the warehouse.
ReturnAddressName String Return Name of the warehouse.
ReturnAddressPhone String Return phone of the warehouse.
ReturnAddressPostalCode String Return postal code of the warehouse.
ReturnAddressResidential String Return residential of the warehouse.
ReturnAddressState String Return state of the warehouse.
ReturnAddressStreet1 String Return street of the warehouse.
ReturnAddressStreet2 String Return street of the warehouse.
ReturnAddressStreet3 String Return street of the warehouse.
SellerIntegrationId String Seller Integration Id.

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