Returns warehouse records, including origin and return address details.

View-Specific Information

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: =.

For example, the following query is processed server side:

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.