Required role: | Administrator |
All Verbs | /service/QueryCustomerShippingLocationRDB |
---|
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 .jsv suffix or ?format=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 } ]