Required role: | Administrator |
All Verbs | /service/DeleteCustomerShippingLocationRDB |
---|
Name | Parameter | Data Type | Required | Description |
---|---|---|---|---|
Skip | query | int? | No | |
Take | query | int? | No | |
OrderBy | query | string | No | |
OrderByDesc | query | string | No | |
Include | query | string | No | |
Fields | query | string | No | |
Meta | query | Dictionary<string, string> | No | |
CustomerId | query | string | No | |
CustomerIdStartsWith | query | string | No | |
CustomerIdEndsWith | query | string | No | |
CustomerIdContains | query | string | No | |
CustomerIdLike | query | string | No | |
CustomerIdBetween | query | string[] | No | |
CustomerIdIn | query | string[] | No | |
ShipId | query | string | No | |
ShipIdStartsWith | query | string | No | |
ShipIdEndsWith | query | string | No | |
ShipIdContains | query | string | No | |
ShipIdLike | query | string | No | |
ShipIdBetween | query | string[] | No | |
ShipIdIn | query | string[] | No | |
ShipName | query | string | No | |
ShipNameStartsWith | query | string | No | |
ShipNameEndsWith | query | string | No | |
ShipNameContains | query | string | No | |
ShipNameLike | query | string | No | |
ShipNameBetween | query | string[] | No | |
ShipNameIn | query | string[] | No | |
ShipAddress | query | string | No | |
ShipAddressStartsWith | query | string | No | |
ShipAddressEndsWith | query | string | No | |
ShipAddressContains | query | string | No | |
ShipAddressLike | query | string | No | |
ShipAddressBetween | query | string[] | No | |
ShipAddressIn | query | string[] | No | |
ShipAddress2 | query | string | No | |
ShipAddress2StartsWith | query | string | No | |
ShipAddress2EndsWith | query | string | No | |
ShipAddress2Contains | query | string | No | |
ShipAddress2Like | query | string | No | |
ShipAddress2Between | query | string[] | No | |
ShipAddress2In | query | string[] | No | |
ShipCity | query | string | No | |
ShipCityStartsWith | query | string | No | |
ShipCityEndsWith | query | string | No | |
ShipCityContains | query | string | No | |
ShipCityLike | query | string | No | |
ShipCityBetween | query | string[] | No | |
ShipCityIn | query | string[] | No | |
ShipState | query | string | No | |
ShipStateStartsWith | query | string | No | |
ShipStateEndsWith | query | string | No | |
ShipStateContains | query | string | No | |
ShipStateLike | query | string | No | |
ShipStateBetween | query | string[] | No | |
ShipStateIn | query | string[] | No | |
ShipZipcode | query | string | No | |
ShipZipcodeStartsWith | query | string | No | |
ShipZipcodeEndsWith | query | string | No | |
ShipZipcodeContains | query | string | No | |
ShipZipcodeLike | query | string | No | |
ShipZipcodeBetween | query | string[] | No | |
ShipZipcodeIn | query | string[] | No | |
ShipCountry | query | string | No | |
ShipCountryStartsWith | query | string | No | |
ShipCountryEndsWith | query | string | No | |
ShipCountryContains | query | string | No | |
ShipCountryLike | query | string | No | |
ShipCountryBetween | query | string[] | No | |
ShipCountryIn | query | string[] | No | |
ShipPhone | query | string | No | |
ShipPhoneStartsWith | query | string | No | |
ShipPhoneEndsWith | query | string | No | |
ShipPhoneContains | query | string | No | |
ShipPhoneLike | query | string | No | |
ShipPhoneBetween | query | string[] | No | |
ShipPhoneIn | query | string[] | No | |
SalesRep | query | string | No | |
SalesRepStartsWith | query | string | No | |
SalesRepEndsWith | query | string | No | |
SalesRepContains | query | string | No | |
SalesRepLike | query | string | No | |
SalesRepBetween | query | string[] | No | |
SalesRepIn | query | string[] | No | |
NewLocation | query | bool? | No | |
ContactName | query | string | No | |
ContactNameStartsWith | query | string | No | |
ContactNameEndsWith | query | string | No | |
ContactNameContains | query | string | No | |
ContactNameLike | query | string | No | |
ContactNameBetween | query | string[] | No | |
ContactNameIn | query | string[] | No | |
ConId | query | string | No | |
ConIdStartsWith | query | string | No | |
ConIdEndsWith | query | string | No | |
ConIdContains | query | string | No | |
ConIdLike | query | string | No | |
ConIdBetween | query | string[] | No | |
ConIdIn | query | string[] | No | |
BillAddress | query | string | No | |
BillAddressStartsWith | query | string | No | |
BillAddressEndsWith | query | string | No | |
BillAddressContains | query | string | No | |
BillAddressLike | query | string | No | |
BillAddressBetween | query | string[] | No | |
BillAddressIn | query | string[] | No | |
BillAddress2 | query | string | No | |
BillAddress2StartsWith | query | string | No | |
BillAddress2EndsWith | query | string | No | |
BillAddress2Contains | query | string | No | |
BillAddress2Like | query | string | No | |
BillAddress2Between | query | string[] | No | |
BillAddress2In | query | string[] | No | |
BillCity | query | string | No | |
BillCityStartsWith | query | string | No | |
BillCityEndsWith | query | string | No | |
BillCityContains | query | string | No | |
BillCityLike | query | string | No | |
BillCityBetween | query | string[] | No | |
BillCityIn | query | string[] | No | |
BillState | query | string | No | |
BillStateStartsWith | query | string | No | |
BillStateEndsWith | query | string | No | |
BillStateContains | query | string | No | |
BillStateLike | query | string | No | |
BillStateBetween | query | string[] | No | |
BillStateIn | query | string[] | No | |
BillZipcode | query | string | No | |
BillZipcodeStartsWith | query | string | No | |
BillZipcodeEndsWith | query | string | No | |
BillZipcodeContains | query | string | No | |
BillZipcodeLike | query | string | No | |
BillZipcodeBetween | query | string[] | No | |
BillZipcodeIn | query | string[] | No | |
BillCountry | query | string | No | |
BillCountryStartsWith | query | string | No | |
BillCountryEndsWith | query | string | No | |
BillCountryContains | query | string | No | |
BillCountryLike | query | string | No | |
BillCountryBetween | query | string[] | No | |
BillCountryIn | query | string[] | No | |
Modified | query | bool? | No | |
BillingSource | query | int? | No | |
BillingSourceGreaterThanOrEqualTo | query | int? | No | |
BillingSourceGreaterThan | query | int? | No | |
BillingSourceLessThan | query | int? | No | |
BillingSourceLessThanOrEqualTo | query | int? | No | |
BillingSourceNotEqualTo | query | int? | No | |
BillingSourceBetween | query | int[] | No | |
BillingSourceIn | query | int[] | No | |
BillName | query | string | No | |
BillNameStartsWith | query | string | No | |
BillNameEndsWith | query | string | No | |
BillNameContains | query | string | No | |
BillNameLike | query | string | No | |
BillNameBetween | query | string[] | No | |
BillNameIn | query | string[] | No | |
BillPhone | query | string | No | |
BillPhoneStartsWith | query | string | No | |
BillPhoneEndsWith | query | string | No | |
BillPhoneContains | query | string | No | |
BillPhoneLike | query | string | No | |
BillPhoneBetween | query | string[] | No | |
BillPhoneIn | query | string[] | No | |
BillFax | query | string | No | |
BillFaxStartsWith | query | string | No | |
BillFaxEndsWith | query | string | No | |
BillFaxContains | query | string | No | |
BillFaxLike | query | string | No | |
BillFaxBetween | query | string[] | No | |
BillFaxIn | query | string[] | No | |
ShipFax | query | string | No | |
ShipFaxStartsWith | query | string | No | |
ShipFaxEndsWith | query | string | No | |
ShipFaxContains | query | string | No | |
ShipFaxLike | query | string | No | |
ShipFaxBetween | query | string[] | No | |
ShipFaxIn | query | string[] | No | |
SoldToId | query | string | No | |
SoldToIdStartsWith | query | string | No | |
SoldToIdEndsWith | query | string | No | |
SoldToIdContains | query | string | No | |
SoldToIdLike | query | string | No | |
SoldToIdBetween | query | string[] | No | |
SoldToIdIn | query | string[] | No | |
StoreType | query | string | No | |
StoreTypeStartsWith | query | string | No | |
StoreTypeEndsWith | query | string | No | |
StoreTypeContains | query | string | No | |
StoreTypeLike | query | string | No | |
StoreTypeBetween | query | string[] | No | |
StoreTypeIn | query | string[] | No | |
StoreClass | query | string | No | |
StoreClassStartsWith | query | string | No | |
StoreClassEndsWith | query | string | No | |
StoreClassContains | query | string | No | |
StoreClassLike | query | string | No | |
StoreClassBetween | query | string[] | No | |
StoreClassIn | query | string[] | No | |
StoreCategory | query | string | No | |
StoreCategoryStartsWith | query | string | No | |
StoreCategoryEndsWith | query | string | No | |
StoreCategoryContains | query | string | No | |
StoreCategoryLike | query | string | No | |
StoreCategoryBetween | query | string[] | No | |
StoreCategoryIn | query | string[] | No | |
Custom1STR | query | string | No | |
Custom1STRStartsWith | query | string | No | |
Custom1STREndsWith | query | string | No | |
Custom1STRContains | query | string | No | |
Custom1STRLike | query | string | No | |
Custom1STRBetween | query | string[] | No | |
Custom1STRIn | query | string[] | No | |
Custom2STR | query | string | No | |
Custom2STRStartsWith | query | string | No | |
Custom2STREndsWith | query | string | No | |
Custom2STRContains | query | string | No | |
Custom2STRLike | query | string | No | |
Custom2STRBetween | query | string[] | No | |
Custom2STRIn | query | string[] | No | |
Custom3STR | query | string | No | |
Custom3STRStartsWith | query | string | No | |
Custom3STREndsWith | query | string | No | |
Custom3STRContains | query | string | No | |
Custom3STRLike | query | string | No | |
Custom3STRBetween | query | string[] | No | |
Custom3STRIn | query | string[] | No | |
Custom4STR | query | string | No | |
Custom4STRStartsWith | query | string | No | |
Custom4STREndsWith | query | string | No | |
Custom4STRContains | query | string | No | |
Custom4STRLike | query | string | No | |
Custom4STRBetween | query | string[] | No | |
Custom4STRIn | query | string[] | No | |
Custom5STR | query | string | No | |
Custom5STRStartsWith | query | string | No | |
Custom5STREndsWith | query | string | No | |
Custom5STRContains | query | string | No | |
Custom5STRLike | query | string | No | |
Custom5STRBetween | query | string[] | No | |
Custom5STRIn | query | string[] | No | |
Custom6STR | query | string | No | |
Custom6STRStartsWith | query | string | No | |
Custom6STREndsWith | query | string | No | |
Custom6STRContains | query | string | No | |
Custom6STRLike | query | string | No | |
Custom6STRBetween | query | string[] | No | |
Custom6STRIn | query | string[] | No | |
Custom7STR | query | string | No | |
Custom7STRStartsWith | query | string | No | |
Custom7STREndsWith | query | string | No | |
Custom7STRContains | query | string | No | |
Custom7STRLike | query | string | No | |
Custom7STRBetween | query | string[] | No | |
Custom7STRIn | query | string[] | No | |
Custom8STR | query | string | No | |
Custom8STRStartsWith | query | string | No | |
Custom8STREndsWith | query | string | No | |
Custom8STRContains | query | string | No | |
Custom8STRLike | query | string | No | |
Custom8STRBetween | query | string[] | No | |
Custom8STRIn | query | string[] | No | |
Custom9STR | query | string | No | |
Custom9STRStartsWith | query | string | No | |
Custom9STREndsWith | query | string | No | |
Custom9STRContains | query | string | No | |
Custom9STRLike | query | string | No | |
Custom9STRBetween | query | string[] | No | |
Custom9STRIn | query | string[] | No | |
Custom10STR | query | string | No | |
Custom10STRStartsWith | query | string | No | |
Custom10STREndsWith | query | string | No | |
Custom10STRContains | query | string | No | |
Custom10STRLike | query | string | No | |
Custom10STRBetween | query | string[] | No | |
Custom10STRIn | query | string[] | No | |
Custom11STR | query | string | No | |
Custom11STRStartsWith | query | string | No | |
Custom11STREndsWith | query | string | No | |
Custom11STRContains | query | string | No | |
Custom11STRLike | query | string | No | |
Custom11STRBetween | query | string[] | No | |
Custom11STRIn | query | string[] | No | |
Custom12STR | query | string | No | |
Custom12STRStartsWith | query | string | No | |
Custom12STREndsWith | query | string | No | |
Custom12STRContains | query | string | No | |
Custom12STRLike | query | string | No | |
Custom12STRBetween | query | string[] | No | |
Custom12STRIn | query | string[] | No | |
Custom13STR | query | string | No | |
Custom13STRStartsWith | query | string | No | |
Custom13STREndsWith | query | string | No | |
Custom13STRContains | query | string | No | |
Custom13STRLike | query | string | No | |
Custom13STRBetween | query | string[] | No | |
Custom13STRIn | query | string[] | No | |
Custom14STR | query | string | No | |
Custom14STRStartsWith | query | string | No | |
Custom14STREndsWith | query | string | No | |
Custom14STRContains | query | string | No | |
Custom14STRLike | query | string | No | |
Custom14STRBetween | query | string[] | No | |
Custom14STRIn | query | string[] | No | |
Custom15STR | query | string | No | |
Custom15STRStartsWith | query | string | No | |
Custom15STREndsWith | query | string | No | |
Custom15STRContains | query | string | No | |
Custom15STRLike | query | string | No | |
Custom15STRBetween | query | string[] | No | |
Custom15STRIn | query | string[] | No | |
TerritoryId | query | string | No | |
TerritoryIdStartsWith | query | string | No | |
TerritoryIdEndsWith | query | string | No | |
TerritoryIdContains | query | string | No | |
TerritoryIdLike | query | string | No | |
TerritoryIdBetween | query | string[] | No | |
TerritoryIdIn | query | string[] | No | |
RegionId | query | string | No | |
RegionIdStartsWith | query | string | No | |
RegionIdEndsWith | query | string | No | |
RegionIdContains | query | string | No | |
RegionIdLike | query | string | No | |
RegionIdBetween | query | string[] | No | |
RegionIdIn | query | string[] | No | |
ShipVia | query | string | No | |
ShipViaStartsWith | query | string | No | |
ShipViaEndsWith | query | string | No | |
ShipViaContains | query | string | No | |
ShipViaLike | query | string | No | |
ShipViaBetween | query | string[] | No | |
ShipViaIn | query | string[] | No | |
SalesRep2 | query | string | No | |
SalesRep2StartsWith | query | string | No | |
SalesRep2EndsWith | query | string | No | |
SalesRep2Contains | query | string | No | |
SalesRep2Like | query | string | No | |
SalesRep2Between | query | string[] | No | |
SalesRep2In | query | string[] | No | |
CYForecast | query | double? | No | |
CYForecastGreaterThanOrEqualTo | query | double? | No | |
CYForecastGreaterThan | query | double? | No | |
CYForecastLessThan | query | double? | No | |
CYForecastLessThanOrEqualTo | query | double? | No | |
CYForecastNotEqualTo | query | double? | No | |
CYForecastBetween | query | double[] | No | |
CYForecastIn | query | double[] | No | |
NYForecast | query | double? | No | |
NYForecastGreaterThanOrEqualTo | query | double? | No | |
NYForecastGreaterThan | query | double? | No | |
NYForecastLessThan | query | double? | No | |
NYForecastLessThanOrEqualTo | query | double? | No | |
NYForecastNotEqualTo | query | double? | No | |
NYForecastBetween | query | double[] | No | |
NYForecastIn | query | double[] | No | |
InfoReviewed | query | DateTime? | No | |
InfoReviewedGreaterThanOrEqualTo | query | DateTime? | No | |
InfoReviewedGreaterThan | query | DateTime? | No | |
InfoReviewedLessThan | query | DateTime? | No | |
InfoReviewedLessThanOrEqualTo | query | DateTime? | No | |
InfoReviewedNotEqualTo | query | DateTime? | No | |
InfoReviewedBetween | query | DateTime[] | No | |
InfoReviewedIn | query | DateTime[] | No | |
_InfoReviewed | query | bool? | No | |
Terms | query | string | No | |
TermsStartsWith | query | string | No | |
TermsEndsWith | query | string | No | |
TermsContains | query | string | No | |
TermsLike | query | string | No | |
TermsBetween | query | string[] | No | |
TermsIn | query | string[] | No | |
SalesRep3 | query | string | No | |
SalesRep3StartsWith | query | string | No | |
SalesRep3EndsWith | query | string | No | |
SalesRep3Contains | query | string | No | |
SalesRep3Like | query | string | No | |
SalesRep3Between | query | string[] | No | |
SalesRep3In | query | string[] | No | |
SalesRep4 | query | string | No | |
SalesRep4StartsWith | query | string | No | |
SalesRep4EndsWith | query | string | No | |
SalesRep4Contains | query | string | No | |
SalesRep4Like | query | string | No | |
SalesRep4Between | query | string[] | No | |
SalesRep4In | query | string[] | No | |
SalesRep5 | query | string | No | |
SalesRep5StartsWith | query | string | No | |
SalesRep5EndsWith | query | string | No | |
SalesRep5Contains | query | string | No | |
SalesRep5Like | query | string | No | |
SalesRep5Between | query | string[] | No | |
SalesRep5In | query | string[] | No | |
Residential | query | bool? | No | |
SalesRep1Sellable | query | bool? | No | |
SalesRep2Sellable | query | bool? | No | |
SalesRep3Sellable | query | bool? | No | |
SalesRep4Sellable | query | bool? | No | |
SalesRep5Sellable | query | bool? | No | |
BillAddress3 | query | string | No | |
BillAddress3StartsWith | query | string | No | |
BillAddress3EndsWith | query | string | No | |
BillAddress3Contains | query | string | No | |
BillAddress3Like | query | string | No | |
BillAddress3Between | query | string[] | No | |
BillAddress3In | query | string[] | No | |
ShipAddress3 | query | string | No | |
ShipAddress3StartsWith | query | string | No | |
ShipAddress3EndsWith | query | string | No | |
ShipAddress3Contains | query | string | No | |
ShipAddress3Like | query | string | No | |
ShipAddress3Between | query | string[] | No | |
ShipAddress3In | query | string[] | No | |
Exported | query | bool? | No | |
Created | query | DateTime? | No | |
CreatedGreaterThanOrEqualTo | query | DateTime? | No | |
CreatedGreaterThan | query | DateTime? | No | |
CreatedLessThan | query | DateTime? | No | |
CreatedLessThanOrEqualTo | query | DateTime? | No | |
CreatedNotEqualTo | query | DateTime? | No | |
CreatedBetween | query | DateTime[] | No | |
CreatedIn | query | DateTime[] | No | |
CreatedBy | query | string | No | |
CreatedByStartsWith | query | string | No | |
CreatedByEndsWith | query | string | No | |
CreatedByContains | query | string | No | |
CreatedByLike | query | string | No | |
CreatedByBetween | query | string[] | No | |
CreatedByIn | query | string[] | No | |
DNU | query | bool? | No | |
DefaultWarehouseId | query | string | No | |
DefaultWarehouseIdStartsWith | query | string | No | |
DefaultWarehouseIdEndsWith | query | string | No | |
DefaultWarehouseIdContains | query | string | No | |
DefaultWarehouseIdLike | query | string | No | |
DefaultWarehouseIdBetween | query | string[] | No | |
DefaultWarehouseIdIn | query | string[] | No | |
Status | query | string | No | |
StatusStartsWith | query | string | No | |
StatusEndsWith | query | string | No | |
StatusContains | query | string | No | |
StatusLike | query | string | No | |
StatusBetween | query | string[] | No | |
StatusIn | query | string[] | No | |
PriceList | query | string | No | |
PriceListStartsWith | query | string | No | |
PriceListEndsWith | query | string | No | |
PriceListContains | query | string | No | |
PriceListLike | query | string | No | |
PriceListBetween | query | string[] | No | |
PriceListIn | query | string[] | No | |
StoreLocator | query | bool? | No | |
StoreLocatorOrder | query | string | No | |
StoreLocatorOrderStartsWith | query | string | No | |
StoreLocatorOrderEndsWith | query | string | No | |
StoreLocatorOrderContains | query | string | No | |
StoreLocatorOrderLike | query | string | No | |
StoreLocatorOrderBetween | query | string[] | No | |
StoreLocatorOrderIn | query | string[] | No | |
WebSite | query | string | No | |
WebSiteStartsWith | query | string | No | |
WebSiteEndsWith | query | string | No | |
WebSiteContains | query | string | No | |
WebSiteLike | query | string | No | |
WebSiteBetween | query | string[] | No | |
WebSiteIn | query | string[] | No | |
query | string | No | ||
EmailStartsWith | query | string | No | |
EmailEndsWith | query | string | No | |
EmailContains | query | string | No | |
EmailLike | query | string | No | |
EmailBetween | query | string[] | No | |
EmailIn | query | string[] | No |
To override the Content-type in your clients, use the HTTP Accept Header, append the .other suffix or ?format=other
The following are sample HTTP requests and responses. The placeholders shown need to be replaced with actual values.
POST /service/DeleteCustomerShippingLocationRDB HTTP/1.1
Host: www.bernhardthospitality.com
Accept: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Content-Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
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-01T00:00:00.0000000Z","infoReviewedGreaterThanOrEqualTo":"0001-01-01T00:00:00.0000000Z","infoReviewedGreaterThan":"0001-01-01T00:00:00.0000000Z","infoReviewedLessThan":"0001-01-01T00:00:00.0000000Z","infoReviewedLessThanOrEqualTo":"0001-01-01T00:00:00.0000000Z","infoReviewedNotEqualTo":"0001-01-01T00:00:00.0000000Z","infoReviewedBetween":["0001-01-01T00:00:00.0000000Z"],"infoReviewedIn":["0001-01-01T00:00:00.0000000Z"],"_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-01T00:00:00.0000000Z","createdGreaterThanOrEqualTo":"0001-01-01T00:00:00.0000000Z","createdGreaterThan":"0001-01-01T00:00:00.0000000Z","createdLessThan":"0001-01-01T00:00:00.0000000Z","createdLessThanOrEqualTo":"0001-01-01T00:00:00.0000000Z","createdNotEqualTo":"0001-01-01T00:00:00.0000000Z","createdBetween":["0001-01-01T00:00:00.0000000Z"],"createdIn":["0001-01-01T00:00:00.0000000Z"],"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: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet Content-Length: length 0