Warehouses
Lists warehouses.
Select
The connector 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 connector.
- Id supports the following operator: =.
SELECT * FROM Warehouses WHERE Id = 8688
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. | |
| 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. | |
| 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. |