EMUN1 ASP.NET

<back to all web services

QueryCustomerShippingLocationRDB

Requires Authentication
Required role:Administrator
The following routes are available for this service:
All Verbs/service/QueryCustomerShippingLocationRDB
QueryCustomerShippingLocationRDB Parameters:
NameParameterData TypeRequiredDescription
Skipqueryint?No
Takequeryint?No
OrderByquerystringNo
OrderByDescquerystringNo
IncludequerystringNo
FieldsquerystringNo
MetaqueryDictionary<string, string>No
CustomerIdquerystringNo
CustomerIdStartsWithquerystringNo
CustomerIdEndsWithquerystringNo
CustomerIdContainsquerystringNo
CustomerIdLikequerystringNo
CustomerIdBetweenquerystring[]No
CustomerIdInquerystring[]No
ShipIdquerystringNo
ShipIdStartsWithquerystringNo
ShipIdEndsWithquerystringNo
ShipIdContainsquerystringNo
ShipIdLikequerystringNo
ShipIdBetweenquerystring[]No
ShipIdInquerystring[]No
ShipNamequerystringNo
ShipNameStartsWithquerystringNo
ShipNameEndsWithquerystringNo
ShipNameContainsquerystringNo
ShipNameLikequerystringNo
ShipNameBetweenquerystring[]No
ShipNameInquerystring[]No
ShipAddressquerystringNo
ShipAddressStartsWithquerystringNo
ShipAddressEndsWithquerystringNo
ShipAddressContainsquerystringNo
ShipAddressLikequerystringNo
ShipAddressBetweenquerystring[]No
ShipAddressInquerystring[]No
ShipAddress2querystringNo
ShipAddress2StartsWithquerystringNo
ShipAddress2EndsWithquerystringNo
ShipAddress2ContainsquerystringNo
ShipAddress2LikequerystringNo
ShipAddress2Betweenquerystring[]No
ShipAddress2Inquerystring[]No
ShipCityquerystringNo
ShipCityStartsWithquerystringNo
ShipCityEndsWithquerystringNo
ShipCityContainsquerystringNo
ShipCityLikequerystringNo
ShipCityBetweenquerystring[]No
ShipCityInquerystring[]No
ShipStatequerystringNo
ShipStateStartsWithquerystringNo
ShipStateEndsWithquerystringNo
ShipStateContainsquerystringNo
ShipStateLikequerystringNo
ShipStateBetweenquerystring[]No
ShipStateInquerystring[]No
ShipZipcodequerystringNo
ShipZipcodeStartsWithquerystringNo
ShipZipcodeEndsWithquerystringNo
ShipZipcodeContainsquerystringNo
ShipZipcodeLikequerystringNo
ShipZipcodeBetweenquerystring[]No
ShipZipcodeInquerystring[]No
ShipCountryquerystringNo
ShipCountryStartsWithquerystringNo
ShipCountryEndsWithquerystringNo
ShipCountryContainsquerystringNo
ShipCountryLikequerystringNo
ShipCountryBetweenquerystring[]No
ShipCountryInquerystring[]No
ShipPhonequerystringNo
ShipPhoneStartsWithquerystringNo
ShipPhoneEndsWithquerystringNo
ShipPhoneContainsquerystringNo
ShipPhoneLikequerystringNo
ShipPhoneBetweenquerystring[]No
ShipPhoneInquerystring[]No
SalesRepquerystringNo
SalesRepStartsWithquerystringNo
SalesRepEndsWithquerystringNo
SalesRepContainsquerystringNo
SalesRepLikequerystringNo
SalesRepBetweenquerystring[]No
SalesRepInquerystring[]No
NewLocationquerybool?No
ContactNamequerystringNo
ContactNameStartsWithquerystringNo
ContactNameEndsWithquerystringNo
ContactNameContainsquerystringNo
ContactNameLikequerystringNo
ContactNameBetweenquerystring[]No
ContactNameInquerystring[]No
ConIdquerystringNo
ConIdStartsWithquerystringNo
ConIdEndsWithquerystringNo
ConIdContainsquerystringNo
ConIdLikequerystringNo
ConIdBetweenquerystring[]No
ConIdInquerystring[]No
BillAddressquerystringNo
BillAddressStartsWithquerystringNo
BillAddressEndsWithquerystringNo
BillAddressContainsquerystringNo
BillAddressLikequerystringNo
BillAddressBetweenquerystring[]No
BillAddressInquerystring[]No
BillAddress2querystringNo
BillAddress2StartsWithquerystringNo
BillAddress2EndsWithquerystringNo
BillAddress2ContainsquerystringNo
BillAddress2LikequerystringNo
BillAddress2Betweenquerystring[]No
BillAddress2Inquerystring[]No
BillCityquerystringNo
BillCityStartsWithquerystringNo
BillCityEndsWithquerystringNo
BillCityContainsquerystringNo
BillCityLikequerystringNo
BillCityBetweenquerystring[]No
BillCityInquerystring[]No
BillStatequerystringNo
BillStateStartsWithquerystringNo
BillStateEndsWithquerystringNo
BillStateContainsquerystringNo
BillStateLikequerystringNo
BillStateBetweenquerystring[]No
BillStateInquerystring[]No
BillZipcodequerystringNo
BillZipcodeStartsWithquerystringNo
BillZipcodeEndsWithquerystringNo
BillZipcodeContainsquerystringNo
BillZipcodeLikequerystringNo
BillZipcodeBetweenquerystring[]No
BillZipcodeInquerystring[]No
BillCountryquerystringNo
BillCountryStartsWithquerystringNo
BillCountryEndsWithquerystringNo
BillCountryContainsquerystringNo
BillCountryLikequerystringNo
BillCountryBetweenquerystring[]No
BillCountryInquerystring[]No
Modifiedquerybool?No
BillingSourcequeryint?No
BillingSourceGreaterThanOrEqualToqueryint?No
BillingSourceGreaterThanqueryint?No
BillingSourceLessThanqueryint?No
BillingSourceLessThanOrEqualToqueryint?No
BillingSourceNotEqualToqueryint?No
BillingSourceBetweenqueryint[]No
BillingSourceInqueryint[]No
BillNamequerystringNo
BillNameStartsWithquerystringNo
BillNameEndsWithquerystringNo
BillNameContainsquerystringNo
BillNameLikequerystringNo
BillNameBetweenquerystring[]No
BillNameInquerystring[]No
BillPhonequerystringNo
BillPhoneStartsWithquerystringNo
BillPhoneEndsWithquerystringNo
BillPhoneContainsquerystringNo
BillPhoneLikequerystringNo
BillPhoneBetweenquerystring[]No
BillPhoneInquerystring[]No
BillFaxquerystringNo
BillFaxStartsWithquerystringNo
BillFaxEndsWithquerystringNo
BillFaxContainsquerystringNo
BillFaxLikequerystringNo
BillFaxBetweenquerystring[]No
BillFaxInquerystring[]No
ShipFaxquerystringNo
ShipFaxStartsWithquerystringNo
ShipFaxEndsWithquerystringNo
ShipFaxContainsquerystringNo
ShipFaxLikequerystringNo
ShipFaxBetweenquerystring[]No
ShipFaxInquerystring[]No
SoldToIdquerystringNo
SoldToIdStartsWithquerystringNo
SoldToIdEndsWithquerystringNo
SoldToIdContainsquerystringNo
SoldToIdLikequerystringNo
SoldToIdBetweenquerystring[]No
SoldToIdInquerystring[]No
StoreTypequerystringNo
StoreTypeStartsWithquerystringNo
StoreTypeEndsWithquerystringNo
StoreTypeContainsquerystringNo
StoreTypeLikequerystringNo
StoreTypeBetweenquerystring[]No
StoreTypeInquerystring[]No
StoreClassquerystringNo
StoreClassStartsWithquerystringNo
StoreClassEndsWithquerystringNo
StoreClassContainsquerystringNo
StoreClassLikequerystringNo
StoreClassBetweenquerystring[]No
StoreClassInquerystring[]No
StoreCategoryquerystringNo
StoreCategoryStartsWithquerystringNo
StoreCategoryEndsWithquerystringNo
StoreCategoryContainsquerystringNo
StoreCategoryLikequerystringNo
StoreCategoryBetweenquerystring[]No
StoreCategoryInquerystring[]No
Custom1STRquerystringNo
Custom1STRStartsWithquerystringNo
Custom1STREndsWithquerystringNo
Custom1STRContainsquerystringNo
Custom1STRLikequerystringNo
Custom1STRBetweenquerystring[]No
Custom1STRInquerystring[]No
Custom2STRquerystringNo
Custom2STRStartsWithquerystringNo
Custom2STREndsWithquerystringNo
Custom2STRContainsquerystringNo
Custom2STRLikequerystringNo
Custom2STRBetweenquerystring[]No
Custom2STRInquerystring[]No
Custom3STRquerystringNo
Custom3STRStartsWithquerystringNo
Custom3STREndsWithquerystringNo
Custom3STRContainsquerystringNo
Custom3STRLikequerystringNo
Custom3STRBetweenquerystring[]No
Custom3STRInquerystring[]No
Custom4STRquerystringNo
Custom4STRStartsWithquerystringNo
Custom4STREndsWithquerystringNo
Custom4STRContainsquerystringNo
Custom4STRLikequerystringNo
Custom4STRBetweenquerystring[]No
Custom4STRInquerystring[]No
Custom5STRquerystringNo
Custom5STRStartsWithquerystringNo
Custom5STREndsWithquerystringNo
Custom5STRContainsquerystringNo
Custom5STRLikequerystringNo
Custom5STRBetweenquerystring[]No
Custom5STRInquerystring[]No
Custom6STRquerystringNo
Custom6STRStartsWithquerystringNo
Custom6STREndsWithquerystringNo
Custom6STRContainsquerystringNo
Custom6STRLikequerystringNo
Custom6STRBetweenquerystring[]No
Custom6STRInquerystring[]No
Custom7STRquerystringNo
Custom7STRStartsWithquerystringNo
Custom7STREndsWithquerystringNo
Custom7STRContainsquerystringNo
Custom7STRLikequerystringNo
Custom7STRBetweenquerystring[]No
Custom7STRInquerystring[]No
Custom8STRquerystringNo
Custom8STRStartsWithquerystringNo
Custom8STREndsWithquerystringNo
Custom8STRContainsquerystringNo
Custom8STRLikequerystringNo
Custom8STRBetweenquerystring[]No
Custom8STRInquerystring[]No
Custom9STRquerystringNo
Custom9STRStartsWithquerystringNo
Custom9STREndsWithquerystringNo
Custom9STRContainsquerystringNo
Custom9STRLikequerystringNo
Custom9STRBetweenquerystring[]No
Custom9STRInquerystring[]No
Custom10STRquerystringNo
Custom10STRStartsWithquerystringNo
Custom10STREndsWithquerystringNo
Custom10STRContainsquerystringNo
Custom10STRLikequerystringNo
Custom10STRBetweenquerystring[]No
Custom10STRInquerystring[]No
Custom11STRquerystringNo
Custom11STRStartsWithquerystringNo
Custom11STREndsWithquerystringNo
Custom11STRContainsquerystringNo
Custom11STRLikequerystringNo
Custom11STRBetweenquerystring[]No
Custom11STRInquerystring[]No
Custom12STRquerystringNo
Custom12STRStartsWithquerystringNo
Custom12STREndsWithquerystringNo
Custom12STRContainsquerystringNo
Custom12STRLikequerystringNo
Custom12STRBetweenquerystring[]No
Custom12STRInquerystring[]No
Custom13STRquerystringNo
Custom13STRStartsWithquerystringNo
Custom13STREndsWithquerystringNo
Custom13STRContainsquerystringNo
Custom13STRLikequerystringNo
Custom13STRBetweenquerystring[]No
Custom13STRInquerystring[]No
Custom14STRquerystringNo
Custom14STRStartsWithquerystringNo
Custom14STREndsWithquerystringNo
Custom14STRContainsquerystringNo
Custom14STRLikequerystringNo
Custom14STRBetweenquerystring[]No
Custom14STRInquerystring[]No
Custom15STRquerystringNo
Custom15STRStartsWithquerystringNo
Custom15STREndsWithquerystringNo
Custom15STRContainsquerystringNo
Custom15STRLikequerystringNo
Custom15STRBetweenquerystring[]No
Custom15STRInquerystring[]No
TerritoryIdquerystringNo
TerritoryIdStartsWithquerystringNo
TerritoryIdEndsWithquerystringNo
TerritoryIdContainsquerystringNo
TerritoryIdLikequerystringNo
TerritoryIdBetweenquerystring[]No
TerritoryIdInquerystring[]No
RegionIdquerystringNo
RegionIdStartsWithquerystringNo
RegionIdEndsWithquerystringNo
RegionIdContainsquerystringNo
RegionIdLikequerystringNo
RegionIdBetweenquerystring[]No
RegionIdInquerystring[]No
ShipViaquerystringNo
ShipViaStartsWithquerystringNo
ShipViaEndsWithquerystringNo
ShipViaContainsquerystringNo
ShipViaLikequerystringNo
ShipViaBetweenquerystring[]No
ShipViaInquerystring[]No
SalesRep2querystringNo
SalesRep2StartsWithquerystringNo
SalesRep2EndsWithquerystringNo
SalesRep2ContainsquerystringNo
SalesRep2LikequerystringNo
SalesRep2Betweenquerystring[]No
SalesRep2Inquerystring[]No
CYForecastquerydouble?No
CYForecastGreaterThanOrEqualToquerydouble?No
CYForecastGreaterThanquerydouble?No
CYForecastLessThanquerydouble?No
CYForecastLessThanOrEqualToquerydouble?No
CYForecastNotEqualToquerydouble?No
CYForecastBetweenquerydouble[]No
CYForecastInquerydouble[]No
NYForecastquerydouble?No
NYForecastGreaterThanOrEqualToquerydouble?No
NYForecastGreaterThanquerydouble?No
NYForecastLessThanquerydouble?No
NYForecastLessThanOrEqualToquerydouble?No
NYForecastNotEqualToquerydouble?No
NYForecastBetweenquerydouble[]No
NYForecastInquerydouble[]No
InfoReviewedqueryDateTime?No
InfoReviewedGreaterThanOrEqualToqueryDateTime?No
InfoReviewedGreaterThanqueryDateTime?No
InfoReviewedLessThanqueryDateTime?No
InfoReviewedLessThanOrEqualToqueryDateTime?No
InfoReviewedNotEqualToqueryDateTime?No
InfoReviewedBetweenqueryDateTime[]No
InfoReviewedInqueryDateTime[]No
_InfoReviewedquerybool?No
TermsquerystringNo
TermsStartsWithquerystringNo
TermsEndsWithquerystringNo
TermsContainsquerystringNo
TermsLikequerystringNo
TermsBetweenquerystring[]No
TermsInquerystring[]No
SalesRep3querystringNo
SalesRep3StartsWithquerystringNo
SalesRep3EndsWithquerystringNo
SalesRep3ContainsquerystringNo
SalesRep3LikequerystringNo
SalesRep3Betweenquerystring[]No
SalesRep3Inquerystring[]No
SalesRep4querystringNo
SalesRep4StartsWithquerystringNo
SalesRep4EndsWithquerystringNo
SalesRep4ContainsquerystringNo
SalesRep4LikequerystringNo
SalesRep4Betweenquerystring[]No
SalesRep4Inquerystring[]No
SalesRep5querystringNo
SalesRep5StartsWithquerystringNo
SalesRep5EndsWithquerystringNo
SalesRep5ContainsquerystringNo
SalesRep5LikequerystringNo
SalesRep5Betweenquerystring[]No
SalesRep5Inquerystring[]No
Residentialquerybool?No
SalesRep1Sellablequerybool?No
SalesRep2Sellablequerybool?No
SalesRep3Sellablequerybool?No
SalesRep4Sellablequerybool?No
SalesRep5Sellablequerybool?No
BillAddress3querystringNo
BillAddress3StartsWithquerystringNo
BillAddress3EndsWithquerystringNo
BillAddress3ContainsquerystringNo
BillAddress3LikequerystringNo
BillAddress3Betweenquerystring[]No
BillAddress3Inquerystring[]No
ShipAddress3querystringNo
ShipAddress3StartsWithquerystringNo
ShipAddress3EndsWithquerystringNo
ShipAddress3ContainsquerystringNo
ShipAddress3LikequerystringNo
ShipAddress3Betweenquerystring[]No
ShipAddress3Inquerystring[]No
Exportedquerybool?No
CreatedqueryDateTime?No
CreatedGreaterThanOrEqualToqueryDateTime?No
CreatedGreaterThanqueryDateTime?No
CreatedLessThanqueryDateTime?No
CreatedLessThanOrEqualToqueryDateTime?No
CreatedNotEqualToqueryDateTime?No
CreatedBetweenqueryDateTime[]No
CreatedInqueryDateTime[]No
CreatedByquerystringNo
CreatedByStartsWithquerystringNo
CreatedByEndsWithquerystringNo
CreatedByContainsquerystringNo
CreatedByLikequerystringNo
CreatedByBetweenquerystring[]No
CreatedByInquerystring[]No
DNUquerybool?No
DefaultWarehouseIdquerystringNo
DefaultWarehouseIdStartsWithquerystringNo
DefaultWarehouseIdEndsWithquerystringNo
DefaultWarehouseIdContainsquerystringNo
DefaultWarehouseIdLikequerystringNo
DefaultWarehouseIdBetweenquerystring[]No
DefaultWarehouseIdInquerystring[]No
StatusquerystringNo
StatusStartsWithquerystringNo
StatusEndsWithquerystringNo
StatusContainsquerystringNo
StatusLikequerystringNo
StatusBetweenquerystring[]No
StatusInquerystring[]No
PriceListquerystringNo
PriceListStartsWithquerystringNo
PriceListEndsWithquerystringNo
PriceListContainsquerystringNo
PriceListLikequerystringNo
PriceListBetweenquerystring[]No
PriceListInquerystring[]No
StoreLocatorquerybool?No
StoreLocatorOrderquerystringNo
StoreLocatorOrderStartsWithquerystringNo
StoreLocatorOrderEndsWithquerystringNo
StoreLocatorOrderContainsquerystringNo
StoreLocatorOrderLikequerystringNo
StoreLocatorOrderBetweenquerystring[]No
StoreLocatorOrderInquerystring[]No
WebSitequerystringNo
WebSiteStartsWithquerystringNo
WebSiteEndsWithquerystringNo
WebSiteContainsquerystringNo
WebSiteLikequerystringNo
WebSiteBetweenquerystring[]No
WebSiteInquerystring[]No
EmailquerystringNo
EmailStartsWithquerystringNo
EmailEndsWithquerystringNo
EmailContainsquerystringNo
EmailLikequerystringNo
EmailBetweenquerystring[]No
EmailInquerystring[]No

To override the Content-type in your clients, use the HTTP Accept Header, append the .jsv suffix or ?format=jsv

HTTP + JSV

The following are sample HTTP requests and responses. The placeholders shown need to be replaced with actual values.

POST /service/QueryCustomerShippingLocationRDB HTTP/1.1 
Host: www.bernhardthospitality.com 
Accept: text/jsv
Content-Type: text/jsv
Content-Length: length

{
	skip: 0,
	take: 0,
	orderBy: String,
	orderByDesc: String,
	include: String,
	fields: String,
	meta: 
	{
		String: String
	},
	customerId: String,
	customerIdStartsWith: String,
	customerIdEndsWith: String,
	customerIdContains: String,
	customerIdLike: String,
	customerIdBetween: 
	[
		String
	],
	customerIdIn: 
	[
		String
	],
	shipId: String,
	shipIdStartsWith: String,
	shipIdEndsWith: String,
	shipIdContains: String,
	shipIdLike: String,
	shipIdBetween: 
	[
		String
	],
	shipIdIn: 
	[
		String
	],
	shipName: String,
	shipNameStartsWith: String,
	shipNameEndsWith: String,
	shipNameContains: String,
	shipNameLike: String,
	shipNameBetween: 
	[
		String
	],
	shipNameIn: 
	[
		String
	],
	shipAddress: String,
	shipAddressStartsWith: String,
	shipAddressEndsWith: String,
	shipAddressContains: String,
	shipAddressLike: String,
	shipAddressBetween: 
	[
		String
	],
	shipAddressIn: 
	[
		String
	],
	shipAddress2: String,
	shipAddress2StartsWith: String,
	shipAddress2EndsWith: String,
	shipAddress2Contains: String,
	shipAddress2Like: String,
	shipAddress2Between: 
	[
		String
	],
	shipAddress2In: 
	[
		String
	],
	shipCity: String,
	shipCityStartsWith: String,
	shipCityEndsWith: String,
	shipCityContains: String,
	shipCityLike: String,
	shipCityBetween: 
	[
		String
	],
	shipCityIn: 
	[
		String
	],
	shipState: String,
	shipStateStartsWith: String,
	shipStateEndsWith: String,
	shipStateContains: String,
	shipStateLike: String,
	shipStateBetween: 
	[
		String
	],
	shipStateIn: 
	[
		String
	],
	shipZipcode: String,
	shipZipcodeStartsWith: String,
	shipZipcodeEndsWith: String,
	shipZipcodeContains: String,
	shipZipcodeLike: String,
	shipZipcodeBetween: 
	[
		String
	],
	shipZipcodeIn: 
	[
		String
	],
	shipCountry: String,
	shipCountryStartsWith: String,
	shipCountryEndsWith: String,
	shipCountryContains: String,
	shipCountryLike: String,
	shipCountryBetween: 
	[
		String
	],
	shipCountryIn: 
	[
		String
	],
	shipPhone: String,
	shipPhoneStartsWith: String,
	shipPhoneEndsWith: String,
	shipPhoneContains: String,
	shipPhoneLike: String,
	shipPhoneBetween: 
	[
		String
	],
	shipPhoneIn: 
	[
		String
	],
	salesRep: String,
	salesRepStartsWith: String,
	salesRepEndsWith: String,
	salesRepContains: String,
	salesRepLike: String,
	salesRepBetween: 
	[
		String
	],
	salesRepIn: 
	[
		String
	],
	newLocation: False,
	contactName: String,
	contactNameStartsWith: String,
	contactNameEndsWith: String,
	contactNameContains: String,
	contactNameLike: String,
	contactNameBetween: 
	[
		String
	],
	contactNameIn: 
	[
		String
	],
	conId: String,
	conIdStartsWith: String,
	conIdEndsWith: String,
	conIdContains: String,
	conIdLike: String,
	conIdBetween: 
	[
		String
	],
	conIdIn: 
	[
		String
	],
	billAddress: String,
	billAddressStartsWith: String,
	billAddressEndsWith: String,
	billAddressContains: String,
	billAddressLike: String,
	billAddressBetween: 
	[
		String
	],
	billAddressIn: 
	[
		String
	],
	billAddress2: String,
	billAddress2StartsWith: String,
	billAddress2EndsWith: String,
	billAddress2Contains: String,
	billAddress2Like: String,
	billAddress2Between: 
	[
		String
	],
	billAddress2In: 
	[
		String
	],
	billCity: String,
	billCityStartsWith: String,
	billCityEndsWith: String,
	billCityContains: String,
	billCityLike: String,
	billCityBetween: 
	[
		String
	],
	billCityIn: 
	[
		String
	],
	billState: String,
	billStateStartsWith: String,
	billStateEndsWith: String,
	billStateContains: String,
	billStateLike: String,
	billStateBetween: 
	[
		String
	],
	billStateIn: 
	[
		String
	],
	billZipcode: String,
	billZipcodeStartsWith: String,
	billZipcodeEndsWith: String,
	billZipcodeContains: String,
	billZipcodeLike: String,
	billZipcodeBetween: 
	[
		String
	],
	billZipcodeIn: 
	[
		String
	],
	billCountry: String,
	billCountryStartsWith: String,
	billCountryEndsWith: String,
	billCountryContains: String,
	billCountryLike: String,
	billCountryBetween: 
	[
		String
	],
	billCountryIn: 
	[
		String
	],
	modified: False,
	billingSource: 0,
	billingSourceGreaterThanOrEqualTo: 0,
	billingSourceGreaterThan: 0,
	billingSourceLessThan: 0,
	billingSourceLessThanOrEqualTo: 0,
	billingSourceNotEqualTo: 0,
	billingSourceBetween: 
	[
		0
	],
	billingSourceIn: 
	[
		0
	],
	billName: String,
	billNameStartsWith: String,
	billNameEndsWith: String,
	billNameContains: String,
	billNameLike: String,
	billNameBetween: 
	[
		String
	],
	billNameIn: 
	[
		String
	],
	billPhone: String,
	billPhoneStartsWith: String,
	billPhoneEndsWith: String,
	billPhoneContains: String,
	billPhoneLike: String,
	billPhoneBetween: 
	[
		String
	],
	billPhoneIn: 
	[
		String
	],
	billFax: String,
	billFaxStartsWith: String,
	billFaxEndsWith: String,
	billFaxContains: String,
	billFaxLike: String,
	billFaxBetween: 
	[
		String
	],
	billFaxIn: 
	[
		String
	],
	shipFax: String,
	shipFaxStartsWith: String,
	shipFaxEndsWith: String,
	shipFaxContains: String,
	shipFaxLike: String,
	shipFaxBetween: 
	[
		String
	],
	shipFaxIn: 
	[
		String
	],
	soldToId: String,
	soldToIdStartsWith: String,
	soldToIdEndsWith: String,
	soldToIdContains: String,
	soldToIdLike: String,
	soldToIdBetween: 
	[
		String
	],
	soldToIdIn: 
	[
		String
	],
	storeType: String,
	storeTypeStartsWith: String,
	storeTypeEndsWith: String,
	storeTypeContains: String,
	storeTypeLike: String,
	storeTypeBetween: 
	[
		String
	],
	storeTypeIn: 
	[
		String
	],
	storeClass: String,
	storeClassStartsWith: String,
	storeClassEndsWith: String,
	storeClassContains: String,
	storeClassLike: String,
	storeClassBetween: 
	[
		String
	],
	storeClassIn: 
	[
		String
	],
	storeCategory: String,
	storeCategoryStartsWith: String,
	storeCategoryEndsWith: String,
	storeCategoryContains: String,
	storeCategoryLike: String,
	storeCategoryBetween: 
	[
		String
	],
	storeCategoryIn: 
	[
		String
	],
	custom1STR: String,
	custom1STRStartsWith: String,
	custom1STREndsWith: String,
	custom1STRContains: String,
	custom1STRLike: String,
	custom1STRBetween: 
	[
		String
	],
	custom1STRIn: 
	[
		String
	],
	custom2STR: String,
	custom2STRStartsWith: String,
	custom2STREndsWith: String,
	custom2STRContains: String,
	custom2STRLike: String,
	custom2STRBetween: 
	[
		String
	],
	custom2STRIn: 
	[
		String
	],
	custom3STR: String,
	custom3STRStartsWith: String,
	custom3STREndsWith: String,
	custom3STRContains: String,
	custom3STRLike: String,
	custom3STRBetween: 
	[
		String
	],
	custom3STRIn: 
	[
		String
	],
	custom4STR: String,
	custom4STRStartsWith: String,
	custom4STREndsWith: String,
	custom4STRContains: String,
	custom4STRLike: String,
	custom4STRBetween: 
	[
		String
	],
	custom4STRIn: 
	[
		String
	],
	custom5STR: String,
	custom5STRStartsWith: String,
	custom5STREndsWith: String,
	custom5STRContains: String,
	custom5STRLike: String,
	custom5STRBetween: 
	[
		String
	],
	custom5STRIn: 
	[
		String
	],
	custom6STR: String,
	custom6STRStartsWith: String,
	custom6STREndsWith: String,
	custom6STRContains: String,
	custom6STRLike: String,
	custom6STRBetween: 
	[
		String
	],
	custom6STRIn: 
	[
		String
	],
	custom7STR: String,
	custom7STRStartsWith: String,
	custom7STREndsWith: String,
	custom7STRContains: String,
	custom7STRLike: String,
	custom7STRBetween: 
	[
		String
	],
	custom7STRIn: 
	[
		String
	],
	custom8STR: String,
	custom8STRStartsWith: String,
	custom8STREndsWith: String,
	custom8STRContains: String,
	custom8STRLike: String,
	custom8STRBetween: 
	[
		String
	],
	custom8STRIn: 
	[
		String
	],
	custom9STR: String,
	custom9STRStartsWith: String,
	custom9STREndsWith: String,
	custom9STRContains: String,
	custom9STRLike: String,
	custom9STRBetween: 
	[
		String
	],
	custom9STRIn: 
	[
		String
	],
	custom10STR: String,
	custom10STRStartsWith: String,
	custom10STREndsWith: String,
	custom10STRContains: String,
	custom10STRLike: String,
	custom10STRBetween: 
	[
		String
	],
	custom10STRIn: 
	[
		String
	],
	custom11STR: String,
	custom11STRStartsWith: String,
	custom11STREndsWith: String,
	custom11STRContains: String,
	custom11STRLike: String,
	custom11STRBetween: 
	[
		String
	],
	custom11STRIn: 
	[
		String
	],
	custom12STR: String,
	custom12STRStartsWith: String,
	custom12STREndsWith: String,
	custom12STRContains: String,
	custom12STRLike: String,
	custom12STRBetween: 
	[
		String
	],
	custom12STRIn: 
	[
		String
	],
	custom13STR: String,
	custom13STRStartsWith: String,
	custom13STREndsWith: String,
	custom13STRContains: String,
	custom13STRLike: String,
	custom13STRBetween: 
	[
		String
	],
	custom13STRIn: 
	[
		String
	],
	custom14STR: String,
	custom14STRStartsWith: String,
	custom14STREndsWith: String,
	custom14STRContains: String,
	custom14STRLike: String,
	custom14STRBetween: 
	[
		String
	],
	custom14STRIn: 
	[
		String
	],
	custom15STR: String,
	custom15STRStartsWith: String,
	custom15STREndsWith: String,
	custom15STRContains: String,
	custom15STRLike: String,
	custom15STRBetween: 
	[
		String
	],
	custom15STRIn: 
	[
		String
	],
	territoryId: String,
	territoryIdStartsWith: String,
	territoryIdEndsWith: String,
	territoryIdContains: String,
	territoryIdLike: String,
	territoryIdBetween: 
	[
		String
	],
	territoryIdIn: 
	[
		String
	],
	regionId: String,
	regionIdStartsWith: String,
	regionIdEndsWith: String,
	regionIdContains: String,
	regionIdLike: String,
	regionIdBetween: 
	[
		String
	],
	regionIdIn: 
	[
		String
	],
	shipVia: String,
	shipViaStartsWith: String,
	shipViaEndsWith: String,
	shipViaContains: String,
	shipViaLike: String,
	shipViaBetween: 
	[
		String
	],
	shipViaIn: 
	[
		String
	],
	salesRep2: String,
	salesRep2StartsWith: String,
	salesRep2EndsWith: String,
	salesRep2Contains: String,
	salesRep2Like: String,
	salesRep2Between: 
	[
		String
	],
	salesRep2In: 
	[
		String
	],
	cyForecast: 0,
	cyForecastGreaterThanOrEqualTo: 0,
	cyForecastGreaterThan: 0,
	cyForecastLessThan: 0,
	cyForecastLessThanOrEqualTo: 0,
	cyForecastNotEqualTo: 0,
	cyForecastBetween: 
	[
		0
	],
	cyForecastIn: 
	[
		0
	],
	nyForecast: 0,
	nyForecastGreaterThanOrEqualTo: 0,
	nyForecastGreaterThan: 0,
	nyForecastLessThan: 0,
	nyForecastLessThanOrEqualTo: 0,
	nyForecastNotEqualTo: 0,
	nyForecastBetween: 
	[
		0
	],
	nyForecastIn: 
	[
		0
	],
	infoReviewed: 0001-01-01,
	infoReviewedGreaterThanOrEqualTo: 0001-01-01,
	infoReviewedGreaterThan: 0001-01-01,
	infoReviewedLessThan: 0001-01-01,
	infoReviewedLessThanOrEqualTo: 0001-01-01,
	infoReviewedNotEqualTo: 0001-01-01,
	infoReviewedBetween: 
	[
		0001-01-01
	],
	infoReviewedIn: 
	[
		0001-01-01
	],
	_InfoReviewed: False,
	terms: String,
	termsStartsWith: String,
	termsEndsWith: String,
	termsContains: String,
	termsLike: String,
	termsBetween: 
	[
		String
	],
	termsIn: 
	[
		String
	],
	salesRep3: String,
	salesRep3StartsWith: String,
	salesRep3EndsWith: String,
	salesRep3Contains: String,
	salesRep3Like: String,
	salesRep3Between: 
	[
		String
	],
	salesRep3In: 
	[
		String
	],
	salesRep4: String,
	salesRep4StartsWith: String,
	salesRep4EndsWith: String,
	salesRep4Contains: String,
	salesRep4Like: String,
	salesRep4Between: 
	[
		String
	],
	salesRep4In: 
	[
		String
	],
	salesRep5: String,
	salesRep5StartsWith: String,
	salesRep5EndsWith: String,
	salesRep5Contains: String,
	salesRep5Like: String,
	salesRep5Between: 
	[
		String
	],
	salesRep5In: 
	[
		String
	],
	residential: False,
	salesRep1Sellable: False,
	salesRep2Sellable: False,
	salesRep3Sellable: False,
	salesRep4Sellable: False,
	salesRep5Sellable: False,
	billAddress3: String,
	billAddress3StartsWith: String,
	billAddress3EndsWith: String,
	billAddress3Contains: String,
	billAddress3Like: String,
	billAddress3Between: 
	[
		String
	],
	billAddress3In: 
	[
		String
	],
	shipAddress3: String,
	shipAddress3StartsWith: String,
	shipAddress3EndsWith: String,
	shipAddress3Contains: String,
	shipAddress3Like: String,
	shipAddress3Between: 
	[
		String
	],
	shipAddress3In: 
	[
		String
	],
	exported: False,
	created: 0001-01-01,
	createdGreaterThanOrEqualTo: 0001-01-01,
	createdGreaterThan: 0001-01-01,
	createdLessThan: 0001-01-01,
	createdLessThanOrEqualTo: 0001-01-01,
	createdNotEqualTo: 0001-01-01,
	createdBetween: 
	[
		0001-01-01
	],
	createdIn: 
	[
		0001-01-01
	],
	createdBy: String,
	createdByStartsWith: String,
	createdByEndsWith: String,
	createdByContains: String,
	createdByLike: String,
	createdByBetween: 
	[
		String
	],
	createdByIn: 
	[
		String
	],
	dnu: False,
	defaultWarehouseId: String,
	defaultWarehouseIdStartsWith: String,
	defaultWarehouseIdEndsWith: String,
	defaultWarehouseIdContains: String,
	defaultWarehouseIdLike: String,
	defaultWarehouseIdBetween: 
	[
		String
	],
	defaultWarehouseIdIn: 
	[
		String
	],
	status: String,
	statusStartsWith: String,
	statusEndsWith: String,
	statusContains: String,
	statusLike: String,
	statusBetween: 
	[
		String
	],
	statusIn: 
	[
		String
	],
	priceList: String,
	priceListStartsWith: String,
	priceListEndsWith: String,
	priceListContains: String,
	priceListLike: String,
	priceListBetween: 
	[
		String
	],
	priceListIn: 
	[
		String
	],
	storeLocator: False,
	storeLocatorOrder: String,
	storeLocatorOrderStartsWith: String,
	storeLocatorOrderEndsWith: String,
	storeLocatorOrderContains: String,
	storeLocatorOrderLike: String,
	storeLocatorOrderBetween: 
	[
		String
	],
	storeLocatorOrderIn: 
	[
		String
	],
	webSite: String,
	webSiteStartsWith: String,
	webSiteEndsWith: String,
	webSiteContains: String,
	webSiteLike: String,
	webSiteBetween: 
	[
		String
	],
	webSiteIn: 
	[
		String
	],
	email: String,
	emailStartsWith: String,
	emailEndsWith: String,
	emailContains: String,
	emailLike: String,
	emailBetween: 
	[
		String
	],
	emailIn: 
	[
		String
	]
}
HTTP/1.1 200 OK
Content-Type: text/jsv
Content-Length: length

[
	{
		customerId: String,
		shipId: String,
		shipName: String,
		shipAddress: String,
		shipAddress2: String,
		shipCity: String,
		shipState: String,
		shipZipcode: String,
		shipCountry: String,
		shipPhone: String,
		salesRep: String,
		newLocation: False,
		contactName: String,
		conId: String,
		billAddress: String,
		billAddress2: String,
		billCity: String,
		billState: String,
		billZipcode: String,
		billCountry: String,
		modified: False,
		billingSource: 0,
		billName: String,
		billPhone: String,
		billFax: String,
		shipFax: String,
		soldToId: String,
		storeType: String,
		storeClass: String,
		storeCategory: String,
		custom1STR: String,
		custom2STR: String,
		custom3STR: String,
		custom4STR: String,
		custom5STR: String,
		custom6STR: String,
		custom7STR: String,
		custom8STR: String,
		custom9STR: String,
		custom10STR: String,
		custom11STR: String,
		custom12STR: String,
		custom13STR: String,
		custom14STR: String,
		custom15STR: String,
		territoryId: String,
		regionId: String,
		shipVia: String,
		salesRep2: String,
		cyForecast: 0,
		nyForecast: 0,
		infoReviewed: 0001-01-01,
		_InfoReviewed: False,
		terms: String,
		salesRep3: String,
		salesRep4: String,
		salesRep5: String,
		residential: False,
		salesRep1Sellable: False,
		salesRep2Sellable: False,
		salesRep3Sellable: False,
		salesRep4Sellable: False,
		salesRep5Sellable: False,
		billAddress3: String,
		shipAddress3: String,
		exported: False,
		created: 0001-01-01,
		createdBy: String,
		dnu: False,
		defaultWarehouseId: String,
		status: String,
		priceList: String,
		storeLocator: False,
		storeLocatorOrder: String,
		webSite: String,
		email: String
	}
]