| Required role: | Administrator |
| All Verbs | /service/QueryProspectRDB |
|---|
| 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 | |
| Id | query | string | No | |
| IdStartsWith | query | string | No | |
| IdEndsWith | query | string | No | |
| IdContains | query | string | No | |
| IdLike | query | string | No | |
| IdBetween | query | string[] | No | |
| IdIn | query | string[] | No | |
| SalesRepId | query | string | No | |
| SalesRepIdStartsWith | query | string | No | |
| SalesRepIdEndsWith | query | string | No | |
| SalesRepIdContains | query | string | No | |
| SalesRepIdLike | query | string | No | |
| SalesRepIdBetween | query | string[] | No | |
| SalesRepIdIn | query | string[] | No | |
| Name | query | string | No | |
| NameStartsWith | query | string | No | |
| NameEndsWith | query | string | No | |
| NameContains | query | string | No | |
| NameLike | query | string | No | |
| NameBetween | query | string[] | No | |
| NameIn | query | string[] | No | |
| Phone | query | string | No | |
| PhoneStartsWith | query | string | No | |
| PhoneEndsWith | query | string | No | |
| PhoneContains | query | string | No | |
| PhoneLike | query | string | No | |
| PhoneBetween | query | string[] | No | |
| PhoneIn | 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 | |
| Address1 | query | string | No | |
| Address1StartsWith | query | string | No | |
| Address1EndsWith | query | string | No | |
| Address1Contains | query | string | No | |
| Address1Like | query | string | No | |
| Address1Between | query | string[] | No | |
| Address1In | query | string[] | No | |
| Address2 | query | string | No | |
| Address2StartsWith | query | string | No | |
| Address2EndsWith | query | string | No | |
| Address2Contains | query | string | No | |
| Address2Like | query | string | No | |
| Address2Between | query | string[] | No | |
| Address2In | query | string[] | No | |
| City | query | string | No | |
| CityStartsWith | query | string | No | |
| CityEndsWith | query | string | No | |
| CityContains | query | string | No | |
| CityLike | query | string | No | |
| CityBetween | query | string[] | No | |
| CityIn | query | string[] | No | |
| State | query | string | No | |
| StateStartsWith | query | string | No | |
| StateEndsWith | query | string | No | |
| StateContains | query | string | No | |
| StateLike | query | string | No | |
| StateBetween | query | string[] | No | |
| StateIn | query | string[] | No | |
| Zip | query | string | No | |
| ZipStartsWith | query | string | No | |
| ZipEndsWith | query | string | No | |
| ZipContains | query | string | No | |
| ZipLike | query | string | No | |
| ZipBetween | query | string[] | No | |
| ZipIn | query | string[] | No | |
| BestCallTime | query | string | No | |
| BestCallTimeStartsWith | query | string | No | |
| BestCallTimeEndsWith | query | string | No | |
| BestCallTimeContains | query | string | No | |
| BestCallTimeLike | query | string | No | |
| BestCallTimeBetween | query | string[] | No | |
| BestCallTimeIn | query | string[] | No | |
| ProspectStatus | query | string | No | |
| ProspectStatusStartsWith | query | string | No | |
| ProspectStatusEndsWith | query | string | No | |
| ProspectStatusContains | query | string | No | |
| ProspectStatusLike | query | string | No | |
| ProspectStatusBetween | query | string[] | No | |
| ProspectStatusIn | query | string[] | No | |
| ProspectSource | query | string | No | |
| ProspectSourceStartsWith | query | string | No | |
| ProspectSourceEndsWith | query | string | No | |
| ProspectSourceContains | query | string | No | |
| ProspectSourceLike | query | string | No | |
| ProspectSourceBetween | query | string[] | No | |
| ProspectSourceIn | query | string[] | No | |
| ProspectRanking | query | string | No | |
| ProspectRankingStartsWith | query | string | No | |
| ProspectRankingEndsWith | query | string | No | |
| ProspectRankingContains | query | string | No | |
| ProspectRankingLike | query | string | No | |
| ProspectRankingBetween | query | string[] | No | |
| ProspectRankingIn | query | string[] | No | |
| Modified | query | bool? | No | |
| Uploaded | query | bool? | No | |
| CompanyName | query | string | No | |
| CompanyNameStartsWith | query | string | No | |
| CompanyNameEndsWith | query | string | No | |
| CompanyNameContains | query | string | No | |
| CompanyNameLike | query | string | No | |
| CompanyNameBetween | query | string[] | No | |
| CompanyNameIn | query | string[] | No | |
| Notes | query | string | No | |
| NotesStartsWith | query | string | No | |
| NotesEndsWith | query | string | No | |
| NotesContains | query | string | No | |
| NotesLike | query | string | No | |
| NotesBetween | query | string[] | No | |
| NotesIn | query | string[] | No | |
| StoreTypeId | query | string | No | |
| StoreTypeIdStartsWith | query | string | No | |
| StoreTypeIdEndsWith | query | string | No | |
| StoreTypeIdContains | query | string | No | |
| StoreTypeIdLike | query | string | No | |
| StoreTypeIdBetween | query | string[] | No | |
| StoreTypeIdIn | query | string[] | No | |
| DateCreated | query | DateTime? | No | |
| DateCreatedGreaterThanOrEqualTo | query | DateTime? | No | |
| DateCreatedGreaterThan | query | DateTime? | No | |
| DateCreatedLessThan | query | DateTime? | No | |
| DateCreatedLessThanOrEqualTo | query | DateTime? | No | |
| DateCreatedNotEqualTo | query | DateTime? | No | |
| DateCreatedBetween | query | DateTime[] | No | |
| DateCreatedIn | query | DateTime[] | No | |
| VendorIDs | query | string | No | |
| VendorIDsStartsWith | query | string | No | |
| VendorIDsEndsWith | query | string | No | |
| VendorIDsContains | query | string | No | |
| VendorIDsLike | query | string | No | |
| VendorIDsBetween | query | string[] | No | |
| VendorIDsIn | query | string[] | No | |
| ConvertedToCustomerId | query | string | No | |
| ConvertedToCustomerIdStartsWith | query | string | No | |
| ConvertedToCustomerIdEndsWith | query | string | No | |
| ConvertedToCustomerIdContains | query | string | No | |
| ConvertedToCustomerIdLike | query | string | No | |
| ConvertedToCustomerIdBetween | query | string[] | No | |
| ConvertedToCustomerIdIn | query | string[] | No | |
| Qualification | query | string | No | |
| QualificationStartsWith | query | string | No | |
| QualificationEndsWith | query | string | No | |
| QualificationContains | query | string | No | |
| QualificationLike | query | string | No | |
| QualificationBetween | query | string[] | No | |
| QualificationIn | query | string[] | No | |
| QualificationReason | query | string | No | |
| QualificationReasonStartsWith | query | string | No | |
| QualificationReasonEndsWith | query | string | No | |
| QualificationReasonContains | query | string | No | |
| QualificationReasonLike | query | string | No | |
| QualificationReasonBetween | query | string[] | No | |
| QualificationReasonIn | query | string[] | No | |
| DateContacted | query | DateTime? | No | |
| DateContactedGreaterThanOrEqualTo | query | DateTime? | No | |
| DateContactedGreaterThan | query | DateTime? | No | |
| DateContactedLessThan | query | DateTime? | No | |
| DateContactedLessThanOrEqualTo | query | DateTime? | No | |
| DateContactedNotEqualTo | query | DateTime? | No | |
| DateContactedBetween | query | DateTime[] | No | |
| DateContactedIn | query | DateTime[] | No | |
| DateConverted | query | DateTime? | No | |
| DateConvertedGreaterThanOrEqualTo | query | DateTime? | No | |
| DateConvertedGreaterThan | query | DateTime? | No | |
| DateConvertedLessThan | query | DateTime? | No | |
| DateConvertedLessThanOrEqualTo | query | DateTime? | No | |
| DateConvertedNotEqualTo | query | DateTime? | No | |
| DateConvertedBetween | query | DateTime[] | No | |
| DateConvertedIn | query | DateTime[] | No | |
| Title | query | string | No | |
| TitleStartsWith | query | string | No | |
| TitleEndsWith | query | string | No | |
| TitleContains | query | string | No | |
| TitleLike | query | string | No | |
| TitleBetween | query | string[] | No | |
| TitleIn | 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 | |
| PotentialDollar | query | int? | No | |
| PotentialDollarGreaterThanOrEqualTo | query | int? | No | |
| PotentialDollarGreaterThan | query | int? | No | |
| PotentialDollarLessThan | query | int? | No | |
| PotentialDollarLessThanOrEqualTo | query | int? | No | |
| PotentialDollarNotEqualTo | query | int? | No | |
| PotentialDollarBetween | query | int[] | No | |
| PotentialDollarIn | query | int[] | No | |
| Competition | query | string | No | |
| CompetitionStartsWith | query | string | No | |
| CompetitionEndsWith | query | string | No | |
| CompetitionContains | query | string | No | |
| CompetitionLike | query | string | No | |
| CompetitionBetween | query | string[] | No | |
| CompetitionIn | query | string[] | No | |
| Hot | query | bool? | No | |
| AccountType | query | string | No | |
| AccountTypeStartsWith | query | string | No | |
| AccountTypeEndsWith | query | string | No | |
| AccountTypeContains | query | string | No | |
| AccountTypeLike | query | string | No | |
| AccountTypeBetween | query | string[] | No | |
| AccountTypeIn | query | string[] | No | |
| Category | query | string | No | |
| CategoryStartsWith | query | string | No | |
| CategoryEndsWith | query | string | No | |
| CategoryContains | query | string | No | |
| CategoryLike | query | string | No | |
| CategoryBetween | query | string[] | No | |
| CategoryIn | query | string[] | No | |
| OrderSource | query | string | No | |
| OrderSourceStartsWith | query | string | No | |
| OrderSourceEndsWith | query | string | No | |
| OrderSourceContains | query | string | No | |
| OrderSourceLike | query | string | No | |
| OrderSourceBetween | query | string[] | No | |
| OrderSourceIn | query | string[] | No | |
| Country | query | string | No | |
| CountryStartsWith | query | string | No | |
| CountryEndsWith | query | string | No | |
| CountryContains | query | string | No | |
| CountryLike | query | string | No | |
| CountryBetween | query | string[] | No | |
| CountryIn | query | string[] | No |
To override the Content-type in your clients, use the HTTP Accept Header, append the .csv suffix or ?format=csv
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/csv
Content-Type: text/csv
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-01T00:00:00.0000000Z","dateCreatedGreaterThanOrEqualTo":"0001-01-01T00:00:00.0000000Z","dateCreatedGreaterThan":"0001-01-01T00:00:00.0000000Z","dateCreatedLessThan":"0001-01-01T00:00:00.0000000Z","dateCreatedLessThanOrEqualTo":"0001-01-01T00:00:00.0000000Z","dateCreatedNotEqualTo":"0001-01-01T00:00:00.0000000Z","dateCreatedBetween":["0001-01-01T00:00:00.0000000Z"],"dateCreatedIn":["0001-01-01T00:00:00.0000000Z"],"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-01T00:00:00.0000000Z","dateContactedGreaterThanOrEqualTo":"0001-01-01T00:00:00.0000000Z","dateContactedGreaterThan":"0001-01-01T00:00:00.0000000Z","dateContactedLessThan":"0001-01-01T00:00:00.0000000Z","dateContactedLessThanOrEqualTo":"0001-01-01T00:00:00.0000000Z","dateContactedNotEqualTo":"0001-01-01T00:00:00.0000000Z","dateContactedBetween":["0001-01-01T00:00:00.0000000Z"],"dateContactedIn":["0001-01-01T00:00:00.0000000Z"],"dateConverted":"0001-01-01T00:00:00.0000000Z","dateConvertedGreaterThanOrEqualTo":"0001-01-01T00:00:00.0000000Z","dateConvertedGreaterThan":"0001-01-01T00:00:00.0000000Z","dateConvertedLessThan":"0001-01-01T00:00:00.0000000Z","dateConvertedLessThanOrEqualTo":"0001-01-01T00:00:00.0000000Z","dateConvertedNotEqualTo":"0001-01-01T00:00:00.0000000Z","dateConvertedBetween":["0001-01-01T00:00:00.0000000Z"],"dateConvertedIn":["0001-01-01T00:00:00.0000000Z"],"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/csv
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-01T00:00:00.0000000Z","vendorIDs":"String","convertedToCustomerId":"String","qualification":"String","qualificationReason":"String","dateContacted":"0001-01-01T00:00:00.0000000Z","dateConverted":"0001-01-01T00:00:00.0000000Z","title":"String","website":"String","potentialDollar":0,"competition":"String","hot":false,"accountType":"String","category":"String","orderSource":"String","country":"String"}]