Warehouses
Returns warehouse records, including origin and return address details.
View-Specific Information
Select
The add-in 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 add-in.
- Id supports the following operator: =.
SELECT * FROM Warehouses WHERE Id = 'se-3456'
Columns
| Name | Type | References | Description |
| Id [KEY] | String | A string that uniquely identifies the warehouse. | |
| Name | String | The name of the warehouse. | |
| IsDefault | Boolean | Indicates whether this is the default warehouse on the account. | |
| CreatedAt | Datetime | The date and time the warehouse was created. | |
| OriginAddressName | String | The name of the contact person at the origin address. | |
| OriginAddressPhone | String | The phone number of the contact person at the origin address. | |
| OriginAddressEmail | String | The email address of the contact at the origin address. | |
| OriginAddressCompanyName | String | The company name at the origin address. | |
| OriginAddressLine1 | String | The first line of the origin address. | |
| OriginAddressLine2 | String | The second line of the origin address. | |
| OriginAddressLine3 | String | The third line of the origin address. | |
| OriginAddressCityLocality | String | The city or locality of the origin address. | |
| OriginAddressStateProvince | String | The state or province of the origin address. | |
| OriginAddressPostalCode | String | The postal code of the origin address. | |
| OriginAddressCountryCode | String | A two-letter ISO 3166-1 country code for the origin address. | |
| OriginAddressResidentialIndicator | String | Indicates whether the origin address is residential. | |
| ReturnAddressName | String | The name of the contact person at the return address. | |
| ReturnAddressPhone | String | The phone number of the contact person at the return address. | |
| ReturnAddressEmail | String | The email address of the contact at the return address. | |
| ReturnAddressCompanyName | String | The company name at the return address. | |
| ReturnAddressLine1 | String | The first line of the return address. | |
| ReturnAddressLine2 | String | The second line of the return address. | |
| ReturnAddressLine3 | String | The third line of the return address. | |
| ReturnAddressCityLocality | String | The city or locality of the return address. | |
| ReturnAddressStateProvince | String | The state or province of the return address. | |
| ReturnAddressPostalCode | String | The postal code of the return address. | |
| ReturnAddressCountryCode | String | A two-letter ISO 3166-1 country code for the return address. | |
| ReturnAddressResidentialIndicator | String | Indicates whether the return address is residential. |