EMUN1 ASP.NET

<back to all web services

QueryProspectRDB

Requires Authentication
Required role:Administrator
The following routes are available for this service:
All Verbs/service/QueryProspectRDB
QueryProspectRDB Parameters:
NameParameterData TypeRequiredDescription
Skipqueryint?No
Takequeryint?No
OrderByquerystringNo
OrderByDescquerystringNo
IncludequerystringNo
FieldsquerystringNo
MetaqueryDictionary<string, string>No
IdquerystringNo
IdStartsWithquerystringNo
IdEndsWithquerystringNo
IdContainsquerystringNo
IdLikequerystringNo
IdBetweenquerystring[]No
IdInquerystring[]No
SalesRepIdquerystringNo
SalesRepIdStartsWithquerystringNo
SalesRepIdEndsWithquerystringNo
SalesRepIdContainsquerystringNo
SalesRepIdLikequerystringNo
SalesRepIdBetweenquerystring[]No
SalesRepIdInquerystring[]No
NamequerystringNo
NameStartsWithquerystringNo
NameEndsWithquerystringNo
NameContainsquerystringNo
NameLikequerystringNo
NameBetweenquerystring[]No
NameInquerystring[]No
PhonequerystringNo
PhoneStartsWithquerystringNo
PhoneEndsWithquerystringNo
PhoneContainsquerystringNo
PhoneLikequerystringNo
PhoneBetweenquerystring[]No
PhoneInquerystring[]No
EmailquerystringNo
EmailStartsWithquerystringNo
EmailEndsWithquerystringNo
EmailContainsquerystringNo
EmailLikequerystringNo
EmailBetweenquerystring[]No
EmailInquerystring[]No
Address1querystringNo
Address1StartsWithquerystringNo
Address1EndsWithquerystringNo
Address1ContainsquerystringNo
Address1LikequerystringNo
Address1Betweenquerystring[]No
Address1Inquerystring[]No
Address2querystringNo
Address2StartsWithquerystringNo
Address2EndsWithquerystringNo
Address2ContainsquerystringNo
Address2LikequerystringNo
Address2Betweenquerystring[]No
Address2Inquerystring[]No
CityquerystringNo
CityStartsWithquerystringNo
CityEndsWithquerystringNo
CityContainsquerystringNo
CityLikequerystringNo
CityBetweenquerystring[]No
CityInquerystring[]No
StatequerystringNo
StateStartsWithquerystringNo
StateEndsWithquerystringNo
StateContainsquerystringNo
StateLikequerystringNo
StateBetweenquerystring[]No
StateInquerystring[]No
ZipquerystringNo
ZipStartsWithquerystringNo
ZipEndsWithquerystringNo
ZipContainsquerystringNo
ZipLikequerystringNo
ZipBetweenquerystring[]No
ZipInquerystring[]No
BestCallTimequerystringNo
BestCallTimeStartsWithquerystringNo
BestCallTimeEndsWithquerystringNo
BestCallTimeContainsquerystringNo
BestCallTimeLikequerystringNo
BestCallTimeBetweenquerystring[]No
BestCallTimeInquerystring[]No
ProspectStatusquerystringNo
ProspectStatusStartsWithquerystringNo
ProspectStatusEndsWithquerystringNo
ProspectStatusContainsquerystringNo
ProspectStatusLikequerystringNo
ProspectStatusBetweenquerystring[]No
ProspectStatusInquerystring[]No
ProspectSourcequerystringNo
ProspectSourceStartsWithquerystringNo
ProspectSourceEndsWithquerystringNo
ProspectSourceContainsquerystringNo
ProspectSourceLikequerystringNo
ProspectSourceBetweenquerystring[]No
ProspectSourceInquerystring[]No
ProspectRankingquerystringNo
ProspectRankingStartsWithquerystringNo
ProspectRankingEndsWithquerystringNo
ProspectRankingContainsquerystringNo
ProspectRankingLikequerystringNo
ProspectRankingBetweenquerystring[]No
ProspectRankingInquerystring[]No
Modifiedquerybool?No
Uploadedquerybool?No
CompanyNamequerystringNo
CompanyNameStartsWithquerystringNo
CompanyNameEndsWithquerystringNo
CompanyNameContainsquerystringNo
CompanyNameLikequerystringNo
CompanyNameBetweenquerystring[]No
CompanyNameInquerystring[]No
NotesquerystringNo
NotesStartsWithquerystringNo
NotesEndsWithquerystringNo
NotesContainsquerystringNo
NotesLikequerystringNo
NotesBetweenquerystring[]No
NotesInquerystring[]No
StoreTypeIdquerystringNo
StoreTypeIdStartsWithquerystringNo
StoreTypeIdEndsWithquerystringNo
StoreTypeIdContainsquerystringNo
StoreTypeIdLikequerystringNo
StoreTypeIdBetweenquerystring[]No
StoreTypeIdInquerystring[]No
DateCreatedqueryDateTime?No
DateCreatedGreaterThanOrEqualToqueryDateTime?No
DateCreatedGreaterThanqueryDateTime?No
DateCreatedLessThanqueryDateTime?No
DateCreatedLessThanOrEqualToqueryDateTime?No
DateCreatedNotEqualToqueryDateTime?No
DateCreatedBetweenqueryDateTime[]No
DateCreatedInqueryDateTime[]No
VendorIDsquerystringNo
VendorIDsStartsWithquerystringNo
VendorIDsEndsWithquerystringNo
VendorIDsContainsquerystringNo
VendorIDsLikequerystringNo
VendorIDsBetweenquerystring[]No
VendorIDsInquerystring[]No
ConvertedToCustomerIdquerystringNo
ConvertedToCustomerIdStartsWithquerystringNo
ConvertedToCustomerIdEndsWithquerystringNo
ConvertedToCustomerIdContainsquerystringNo
ConvertedToCustomerIdLikequerystringNo
ConvertedToCustomerIdBetweenquerystring[]No
ConvertedToCustomerIdInquerystring[]No
QualificationquerystringNo
QualificationStartsWithquerystringNo
QualificationEndsWithquerystringNo
QualificationContainsquerystringNo
QualificationLikequerystringNo
QualificationBetweenquerystring[]No
QualificationInquerystring[]No
QualificationReasonquerystringNo
QualificationReasonStartsWithquerystringNo
QualificationReasonEndsWithquerystringNo
QualificationReasonContainsquerystringNo
QualificationReasonLikequerystringNo
QualificationReasonBetweenquerystring[]No
QualificationReasonInquerystring[]No
DateContactedqueryDateTime?No
DateContactedGreaterThanOrEqualToqueryDateTime?No
DateContactedGreaterThanqueryDateTime?No
DateContactedLessThanqueryDateTime?No
DateContactedLessThanOrEqualToqueryDateTime?No
DateContactedNotEqualToqueryDateTime?No
DateContactedBetweenqueryDateTime[]No
DateContactedInqueryDateTime[]No
DateConvertedqueryDateTime?No
DateConvertedGreaterThanOrEqualToqueryDateTime?No
DateConvertedGreaterThanqueryDateTime?No
DateConvertedLessThanqueryDateTime?No
DateConvertedLessThanOrEqualToqueryDateTime?No
DateConvertedNotEqualToqueryDateTime?No
DateConvertedBetweenqueryDateTime[]No
DateConvertedInqueryDateTime[]No
TitlequerystringNo
TitleStartsWithquerystringNo
TitleEndsWithquerystringNo
TitleContainsquerystringNo
TitleLikequerystringNo
TitleBetweenquerystring[]No
TitleInquerystring[]No
WebsitequerystringNo
WebsiteStartsWithquerystringNo
WebsiteEndsWithquerystringNo
WebsiteContainsquerystringNo
WebsiteLikequerystringNo
WebsiteBetweenquerystring[]No
WebsiteInquerystring[]No
PotentialDollarqueryint?No
PotentialDollarGreaterThanOrEqualToqueryint?No
PotentialDollarGreaterThanqueryint?No
PotentialDollarLessThanqueryint?No
PotentialDollarLessThanOrEqualToqueryint?No
PotentialDollarNotEqualToqueryint?No
PotentialDollarBetweenqueryint[]No
PotentialDollarInqueryint[]No
CompetitionquerystringNo
CompetitionStartsWithquerystringNo
CompetitionEndsWithquerystringNo
CompetitionContainsquerystringNo
CompetitionLikequerystringNo
CompetitionBetweenquerystring[]No
CompetitionInquerystring[]No
Hotquerybool?No
AccountTypequerystringNo
AccountTypeStartsWithquerystringNo
AccountTypeEndsWithquerystringNo
AccountTypeContainsquerystringNo
AccountTypeLikequerystringNo
AccountTypeBetweenquerystring[]No
AccountTypeInquerystring[]No
CategoryquerystringNo
CategoryStartsWithquerystringNo
CategoryEndsWithquerystringNo
CategoryContainsquerystringNo
CategoryLikequerystringNo
CategoryBetweenquerystring[]No
CategoryInquerystring[]No
OrderSourcequerystringNo
OrderSourceStartsWithquerystringNo
OrderSourceEndsWithquerystringNo
OrderSourceContainsquerystringNo
OrderSourceLikequerystringNo
OrderSourceBetweenquerystring[]No
OrderSourceInquerystring[]No
CountryquerystringNo
CountryStartsWithquerystringNo
CountryEndsWithquerystringNo
CountryContainsquerystringNo
CountryLikequerystringNo
CountryBetweenquerystring[]No
CountryInquerystring[]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/QueryProspectRDB 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
	},
	id: String,
	idStartsWith: String,
	idEndsWith: String,
	idContains: String,
	idLike: String,
	idBetween: 
	[
		String
	],
	idIn: 
	[
		String
	],
	salesRepId: String,
	salesRepIdStartsWith: String,
	salesRepIdEndsWith: String,
	salesRepIdContains: String,
	salesRepIdLike: String,
	salesRepIdBetween: 
	[
		String
	],
	salesRepIdIn: 
	[
		String
	],
	name: String,
	nameStartsWith: String,
	nameEndsWith: String,
	nameContains: String,
	nameLike: String,
	nameBetween: 
	[
		String
	],
	nameIn: 
	[
		String
	],
	phone: String,
	phoneStartsWith: String,
	phoneEndsWith: String,
	phoneContains: String,
	phoneLike: String,
	phoneBetween: 
	[
		String
	],
	phoneIn: 
	[
		String
	],
	email: String,
	emailStartsWith: String,
	emailEndsWith: String,
	emailContains: String,
	emailLike: String,
	emailBetween: 
	[
		String
	],
	emailIn: 
	[
		String
	],
	address1: String,
	address1StartsWith: String,
	address1EndsWith: String,
	address1Contains: String,
	address1Like: String,
	address1Between: 
	[
		String
	],
	address1In: 
	[
		String
	],
	address2: String,
	address2StartsWith: String,
	address2EndsWith: String,
	address2Contains: String,
	address2Like: String,
	address2Between: 
	[
		String
	],
	address2In: 
	[
		String
	],
	city: String,
	cityStartsWith: String,
	cityEndsWith: String,
	cityContains: String,
	cityLike: String,
	cityBetween: 
	[
		String
	],
	cityIn: 
	[
		String
	],
	state: String,
	stateStartsWith: String,
	stateEndsWith: String,
	stateContains: String,
	stateLike: String,
	stateBetween: 
	[
		String
	],
	stateIn: 
	[
		String
	],
	zip: String,
	zipStartsWith: String,
	zipEndsWith: String,
	zipContains: String,
	zipLike: String,
	zipBetween: 
	[
		String
	],
	zipIn: 
	[
		String
	],
	bestCallTime: String,
	bestCallTimeStartsWith: String,
	bestCallTimeEndsWith: String,
	bestCallTimeContains: String,
	bestCallTimeLike: String,
	bestCallTimeBetween: 
	[
		String
	],
	bestCallTimeIn: 
	[
		String
	],
	prospectStatus: String,
	prospectStatusStartsWith: String,
	prospectStatusEndsWith: String,
	prospectStatusContains: String,
	prospectStatusLike: String,
	prospectStatusBetween: 
	[
		String
	],
	prospectStatusIn: 
	[
		String
	],
	prospectSource: String,
	prospectSourceStartsWith: String,
	prospectSourceEndsWith: String,
	prospectSourceContains: String,
	prospectSourceLike: String,
	prospectSourceBetween: 
	[
		String
	],
	prospectSourceIn: 
	[
		String
	],
	prospectRanking: String,
	prospectRankingStartsWith: String,
	prospectRankingEndsWith: String,
	prospectRankingContains: String,
	prospectRankingLike: String,
	prospectRankingBetween: 
	[
		String
	],
	prospectRankingIn: 
	[
		String
	],
	modified: False,
	uploaded: False,
	companyName: String,
	companyNameStartsWith: String,
	companyNameEndsWith: String,
	companyNameContains: String,
	companyNameLike: String,
	companyNameBetween: 
	[
		String
	],
	companyNameIn: 
	[
		String
	],
	notes: String,
	notesStartsWith: String,
	notesEndsWith: String,
	notesContains: String,
	notesLike: String,
	notesBetween: 
	[
		String
	],
	notesIn: 
	[
		String
	],
	storeTypeId: String,
	storeTypeIdStartsWith: String,
	storeTypeIdEndsWith: String,
	storeTypeIdContains: String,
	storeTypeIdLike: String,
	storeTypeIdBetween: 
	[
		String
	],
	storeTypeIdIn: 
	[
		String
	],
	dateCreated: 0001-01-01,
	dateCreatedGreaterThanOrEqualTo: 0001-01-01,
	dateCreatedGreaterThan: 0001-01-01,
	dateCreatedLessThan: 0001-01-01,
	dateCreatedLessThanOrEqualTo: 0001-01-01,
	dateCreatedNotEqualTo: 0001-01-01,
	dateCreatedBetween: 
	[
		0001-01-01
	],
	dateCreatedIn: 
	[
		0001-01-01
	],
	vendorIDs: String,
	vendorIDsStartsWith: String,
	vendorIDsEndsWith: String,
	vendorIDsContains: String,
	vendorIDsLike: String,
	vendorIDsBetween: 
	[
		String
	],
	vendorIDsIn: 
	[
		String
	],
	convertedToCustomerId: String,
	convertedToCustomerIdStartsWith: String,
	convertedToCustomerIdEndsWith: String,
	convertedToCustomerIdContains: String,
	convertedToCustomerIdLike: String,
	convertedToCustomerIdBetween: 
	[
		String
	],
	convertedToCustomerIdIn: 
	[
		String
	],
	qualification: String,
	qualificationStartsWith: String,
	qualificationEndsWith: String,
	qualificationContains: String,
	qualificationLike: String,
	qualificationBetween: 
	[
		String
	],
	qualificationIn: 
	[
		String
	],
	qualificationReason: String,
	qualificationReasonStartsWith: String,
	qualificationReasonEndsWith: String,
	qualificationReasonContains: String,
	qualificationReasonLike: String,
	qualificationReasonBetween: 
	[
		String
	],
	qualificationReasonIn: 
	[
		String
	],
	dateContacted: 0001-01-01,
	dateContactedGreaterThanOrEqualTo: 0001-01-01,
	dateContactedGreaterThan: 0001-01-01,
	dateContactedLessThan: 0001-01-01,
	dateContactedLessThanOrEqualTo: 0001-01-01,
	dateContactedNotEqualTo: 0001-01-01,
	dateContactedBetween: 
	[
		0001-01-01
	],
	dateContactedIn: 
	[
		0001-01-01
	],
	dateConverted: 0001-01-01,
	dateConvertedGreaterThanOrEqualTo: 0001-01-01,
	dateConvertedGreaterThan: 0001-01-01,
	dateConvertedLessThan: 0001-01-01,
	dateConvertedLessThanOrEqualTo: 0001-01-01,
	dateConvertedNotEqualTo: 0001-01-01,
	dateConvertedBetween: 
	[
		0001-01-01
	],
	dateConvertedIn: 
	[
		0001-01-01
	],
	title: String,
	titleStartsWith: String,
	titleEndsWith: String,
	titleContains: String,
	titleLike: String,
	titleBetween: 
	[
		String
	],
	titleIn: 
	[
		String
	],
	website: String,
	websiteStartsWith: String,
	websiteEndsWith: String,
	websiteContains: String,
	websiteLike: String,
	websiteBetween: 
	[
		String
	],
	websiteIn: 
	[
		String
	],
	potentialDollar: 0,
	potentialDollarGreaterThanOrEqualTo: 0,
	potentialDollarGreaterThan: 0,
	potentialDollarLessThan: 0,
	potentialDollarLessThanOrEqualTo: 0,
	potentialDollarNotEqualTo: 0,
	potentialDollarBetween: 
	[
		0
	],
	potentialDollarIn: 
	[
		0
	],
	competition: String,
	competitionStartsWith: String,
	competitionEndsWith: String,
	competitionContains: String,
	competitionLike: String,
	competitionBetween: 
	[
		String
	],
	competitionIn: 
	[
		String
	],
	hot: False,
	accountType: String,
	accountTypeStartsWith: String,
	accountTypeEndsWith: String,
	accountTypeContains: String,
	accountTypeLike: String,
	accountTypeBetween: 
	[
		String
	],
	accountTypeIn: 
	[
		String
	],
	category: String,
	categoryStartsWith: String,
	categoryEndsWith: String,
	categoryContains: String,
	categoryLike: String,
	categoryBetween: 
	[
		String
	],
	categoryIn: 
	[
		String
	],
	orderSource: String,
	orderSourceStartsWith: String,
	orderSourceEndsWith: String,
	orderSourceContains: String,
	orderSourceLike: String,
	orderSourceBetween: 
	[
		String
	],
	orderSourceIn: 
	[
		String
	],
	country: String,
	countryStartsWith: String,
	countryEndsWith: String,
	countryContains: String,
	countryLike: String,
	countryBetween: 
	[
		String
	],
	countryIn: 
	[
		String
	]
}
HTTP/1.1 200 OK
Content-Type: text/jsv
Content-Length: length

[
	{
		id: String,
		salesRepId: String,
		name: String,
		phone: String,
		email: String,
		address1: String,
		address2: String,
		city: String,
		state: String,
		zip: String,
		bestCallTime: String,
		prospectStatus: String,
		prospectSource: String,
		prospectRanking: String,
		modified: False,
		uploaded: False,
		companyName: String,
		notes: String,
		storeTypeId: String,
		dateCreated: 0001-01-01,
		vendorIDs: String,
		convertedToCustomerId: String,
		qualification: String,
		qualificationReason: String,
		dateContacted: 0001-01-01,
		dateConverted: 0001-01-01,
		title: String,
		website: String,
		potentialDollar: 0,
		competition: String,
		hot: False,
		accountType: String,
		category: String,
		orderSource: String,
		country: String
	}
]