FindContactWithoutPhoneAddressEmail

“FindContactWithoutPhoneAddressEmail”

This provider name is implemented by the class SuperOffice.CRM.ArchiveLists.FindContactSubProvider inside NetServer’s SODatabase assembly.

Supported Entities

Name	Description
”contact”

Supported Columns

Name	Restriction	OrderBy
getAllRows	bool
getNoRows	bool
contactId	int	x
name	stringorPK	x
department	string	x
nameDepartment	string	x
hasInfoText	bool	x
hasInterests	bool	x
associateId	associate	x
category	listAny	x
categoryGroup	listAny	x
companyCategoryRank	int	x
business	listAny	x
country	listAny	x
countryId	int	x
number	string	x
code	string	x
orgnr	string	x
stop	bool	x
contactNoMail	bool	x
updatedBy	associate	x
updatedByFullName	associate	x
updatedDate	date	x
registeredBy	associate	x
registeredByFullName	associate	x
registeredDate	date	x
contactSource	listAny	x
contactDeleted	bool	x
phone/formattedNumber	string
activeErpLinks	bool	x
numEmployees	int	x
yearFounded	int	x
revenueYear	int	x
revenueBasecurrency	decimal	x
sharecapitalBasecurrency	decimal	x
sourcedFrom	string	x
linkedinUrl	string	x
deletedDate	datetime
mainContact	None	x
forceCompany	bool
who	None	x
contactPhone/formattedNumber	string
contactPhone/description	string	x
contactFax/formattedNumber	string
contactFax/description	string	x
searchPhone/formattedNumber	string
searchPhone/description	string	x
email/emailProtocol	string	x
email/emailAddress	string	x
email/emailDescription	string	x
email/emailId	int	x
email/emailLastSent	datetime	x
email/emailBounceCount	int	x
email/emailLastBounce	datetime	x
email/emailHasBounced	bool	x
postAddress/addressId	int	x
postAddress/line1	string	x
postAddress/line2	string	x
postAddress/line3	string	x
postAddress/county	string	x
postAddress/city	string	x
postAddress/zip	string	x
postAddress/state	string	x
postAddress/wgs84latitude	decimal	x
postAddress/wgs84longitude	decimal	x
postAddress/formattedAddress	None
postAddress/formattedMultiLineAddress	None
streetAddress/addressId	int	x
streetAddress/line1	string	x
streetAddress/line2	string	x
streetAddress/line3	string	x
streetAddress/county	string	x
streetAddress/city	string	x
streetAddress/zip	string	x
streetAddress/state	string	x
streetAddress/wgs84latitude	decimal	x
streetAddress/wgs84longitude	decimal	x
streetAddress/formattedAddress	None
streetAddress/formattedMultiLineAddress	None
restrictionAddress/addressId	int	x
restrictionAddress/line1	string	x
restrictionAddress/line2	string	x
restrictionAddress/line3	string	x
restrictionAddress/county	string	x
restrictionAddress/city	string	x
restrictionAddress/zip	string	x
restrictionAddress/state	string	x
restrictionAddress/wgs84latitude	decimal	x
restrictionAddress/wgs84longitude	decimal	x
restrictionAddress/formattedAddress	None
restrictionAddress/formattedMultiLineAddress	None
url/URLAddress	string	x
url/URLDescription	string	x
contactAssociate/firstName	string	x
contactAssociate/lastName	string	x
contactAssociate/middleName	string	x
contactAssociate/fullName	string	x
contactAssociate/contactId	int
contactAssociate/personId	int

Supported Columns (cont.)

Name	Restriction	OrderBy
contactAssociate/mrMrs	string	x
contactAssociate/title	string	x
contactAssociate/associateDbId	associate	x
contactAssociate/contactName	string	x
contactAssociate/contactDepartment	string	x
contactAssociate/usergroup	userGroup	x
contactAssociate/usergroupId	int	x
contactAssociate/contactFullName	string	x
contactAssociate/contactCategory	listAny	x
contactAssociate/role	listAny	x
contactAssociate/assocName	associate	x
contactAssociate/assocTooltip	string
contactAssociate/assocType	listAny	x
contactAssociate/ejUserId	int
contactAssociate/simultaneousEjUser	bool
contactAssociate/ejDisplayName	string	x
contactAssociate/ejStatus	int
contactAssociate/credentialType	None	x
contactAssociate/credentialDisplayValue	None	x
contactAssociate/isActive	bool	x
contactAssociate/isActiveText	bool	x
contactAssociate/portraitThumbnail	None
contactAssociate/otherGroups	userGroup
contactAssociate/userName	string	x
contactAssociate/personEmail	string	x
contactAssociate/locationAddress	string	x
contactAssociate/isLocation	bool	x
contactInterestIds	listInterest
contactInfo/textId	int	x
contactInfo/infoText	positiveString	x
contactUdef/SuperOffice:1	string	x
contactUdef/SuperOffice:2	string	x
contactUdef/SuperOffice:3	int	x
contactUdef/SuperOffice:4	date	x
contactUdef/SuperOffice:5	unlimitedDate	x
contactUdef/SuperOffice:6	bool	x
contactUdef/SuperOffice:7	listAny	x
contactUdef/SuperOffice:8	decimal	x
contactUdef/SuperOffice:9	string	x
contactUdef/SuperOffice:10	string	x
contactUdef/SuperOffice:11	string	x
contactUdef/SuperOffice:12	listAny	x
contactUdef/SuperOffice:13	listAny	x
contactExtra/x_contact_integer	int	x
contactExtra/x_contact_hidden_integer	int	x
contactExtra/x_contact_default_integer	int	x
contactExtra/x_contact_float	decimal	x
contactExtra/x_contact_longtext	string	x
contactExtra/x_contact_dropdown	listAny	x
contactExtra/x_contact_date	date	x
contactExtra/x_contact_datetime	datetime	x
contactExtra/x_contact_time	None	x
contactExtra/x_contact_boolean	bool	x
contactExtra/x_contact_timespan	timeSpan	x
contactExtra/x_contact_shorttext	string	x
contactExtra/x_contact_short_dropdown	listAny	x
contactExtra/x_contact_contact_relation	stringorPK	x
contactExtra/x_contact_request_relation	stringorPK	x
contactExtra/x_contact_contact	stringorPK	x
contactExtra/y_organization/x_name	string	x
NumberOfActivities	int
NumberOfActivitiesInPeriod	int
NumberOfNotCompletedActivities	int
NumberOfNotCompletedActivitiesInPeriod	int
LastActivity	date
LastCompletedActivity	date
LastDoByActivity	date
NumberOfSales	int
NumberOfSalesInPeriod	int
NumberOfNotCompletedSales	int
NumberOfNotCompletedSalesInPeriod	int
LastSale	date
LastCompletedSale	date
LastDoBySale	date
NumberOfTickets	int
NumberOfTicketsInPeriod	int
NumberOfNotCompletedTickets	int
NumberOfNotCompletedTicketsInPeriod	int
LastTicket	date
LastCompletedTicket	date
LastDoByTicket	date
SaintStatus1	saintStatus
SaintStatus2	saintStatus
saintSaleStatus	listAny
saintAmountClass	listAny
saintActivityType	listAny
saintDirection	listAny
saintIntention	listAny
saintTicketStatus	listAny
saintTicketCategory	listAny
sourceRelation/contactId	int	x
sourceRelation/name	stringorPK	x
sourceRelation/department	string	x
sourceRelation/nameDepartment	string	x
sourceRelation/hasInfoText	bool	x
sourceRelation/hasInterests	bool	x
sourceRelation/associateId	associate	x
sourceRelation/category	listAny	x
sourceRelation/categoryGroup	listAny	x
sourceRelation/companyCategoryRank	int	x

Supported Columns (cont.)

Name	Restriction	OrderBy
sourceRelation/business	listAny	x
sourceRelation/country	listAny	x
sourceRelation/countryId	int	x
sourceRelation/number	string	x
sourceRelation/code	string	x
sourceRelation/orgnr	string	x
sourceRelation/stop	bool	x
sourceRelation/contactNoMail	bool	x
sourceRelation/updatedBy	associate	x
sourceRelation/updatedByFullName	associate	x
sourceRelation/updatedDate	date	x
sourceRelation/registeredBy	associate	x
sourceRelation/registeredByFullName	associate	x
sourceRelation/registeredDate	date	x
sourceRelation/contactSource	listAny	x
sourceRelation/contactDeleted	bool	x
sourceRelation/activeErpLinks	bool	x
sourceRelation/numEmployees	int	x
sourceRelation/yearFounded	int	x
sourceRelation/revenueYear	int	x
sourceRelation/revenueBasecurrency	decimal	x
sourceRelation/sharecapitalBasecurrency	decimal	x
sourceRelation/sourcedFrom	string	x
sourceRelation/linkedinUrl	string	x
sourceRelation/deletedDate	datetime
sourceRelation/mainContact	None	x
sourceRelation/forceCompany	bool
sourceRelation/restrictionContactId	int
sourceRelation/who	None	x
sourceRelation/csRelation	listAny	x
targetRelation/contactId	int	x
targetRelation/name	stringorPK	x
targetRelation/department	string	x
targetRelation/nameDepartment	string	x
targetRelation/hasInfoText	bool	x
targetRelation/hasInterests	bool	x
targetRelation/associateId	associate	x
targetRelation/category	listAny	x
targetRelation/categoryGroup	listAny	x
targetRelation/companyCategoryRank	int	x
targetRelation/business	listAny	x
targetRelation/country	listAny	x
targetRelation/countryId	int	x
targetRelation/number	string	x
targetRelation/code	string	x
targetRelation/orgnr	string	x
targetRelation/stop	bool	x
targetRelation/contactNoMail	bool	x
targetRelation/updatedBy	associate	x
targetRelation/updatedByFullName	associate	x
targetRelation/updatedDate	date	x
targetRelation/registeredBy	associate	x
targetRelation/registeredByFullName	associate	x
targetRelation/registeredDate	date	x
targetRelation/contactSource	listAny	x
targetRelation/contactDeleted	bool	x
targetRelation/activeErpLinks	bool	x
targetRelation/numEmployees	int	x
targetRelation/yearFounded	int	x
targetRelation/revenueYear	int	x
targetRelation/revenueBasecurrency	decimal	x
targetRelation/sharecapitalBasecurrency	decimal	x
targetRelation/sourcedFrom	string	x
targetRelation/linkedinUrl	string	x
targetRelation/deletedDate	datetime
targetRelation/mainContact	None	x
targetRelation/forceCompany	bool
targetRelation/restrictionContactId	int
targetRelation/who	None	x
targetRelation/csRelation	listAny	x
sourceRelation/contactPersonRelation	listAny	x
targetRelation/personContactRelation	listAny	x
sale/completed	bool	x
sale/icon	listAny	x
sale/date	date	x
sale/time	None
sale/type	listAny	x
sale/recordType	string	x
sale/text	positiveString	x
sale/associateId	associate	x
sale/contactId	listAny	x
sale/personId	listAny	x
sale/projectId	listAny	x
sale/saleId	int	x
sale/userGroup	userGroup	x
sale/who	None
sale/updatedBy	associate	x
sale/updatedByFullName	associate	x
sale/updatedDate	date	x
sale/registeredBy	associate	x
sale/registeredByFullName	associate	x
sale/registeredDate	date	x
sale/currencyId	int	x
sale/currency	listAny	x
sale/credited	listAny	x
sale/lossReason	listAny	x
sale/source	listAny	x
sale/competitor	listAny	x
sale/heading	stringorPK	x
sale/amount	decimal	x

Supported Columns (cont.)

Name	Restriction	OrderBy
sale/amountWeighted	decimal	x
sale/earning	decimal	x
sale/earningPercent	decimal	x
sale/probPercent	int	x
sale/originalStage	listAny	x
sale/stage	listAny	x
sale/stageName	None	x
sale/saleStatus	listAny	x
sale/stageRank	None	x
sale/saleType	listAny	x
sale/saleTypeId	None	x
sale/stageId	None	x
sale/nextDueDate	date	x
sale/reopenDate	date	x
sale/stalledComment	listAny	x
sale/saleTypeCategory	listAny	x
sale/soldReason	listAny	x
sale/saleNumber	string	x
sale/hasStakeholders	bool	x
sale/stakeholdersEnabled	bool	x
sale/hasQuote	bool	x
sale/hasGuide	bool	x
sale/description	string
sale/activeErpLinks	bool	x
sale/createdByWorkflow	listAny	x
sale/amountInBaseCurrency	None	x
sale/amountWeightedInBaseCurrency	None	x
sale/daysInStage	int	x
sale/saleCycle	int	x
sale/visibleFor	listAny
sale/sale/textId	int	x
sale/sale/description	positiveString	x
sale/salePublish/isPublished	bool	x
sale/salePublish/publishedFrom	date	x
sale/salePublish/publishedTo	date	x
sale/salePublish/publishedBy	None
sale/associate/firstName	string	x
sale/associate/lastName	string	x
sale/associate/middleName	string	x
sale/associate/fullName	string	x
sale/associate/contactId	int
sale/associate/personId	int
sale/associate/mrMrs	string	x
sale/associate/title	string	x
sale/associate/associateDbId	associate	x
sale/associate/contactName	string	x
sale/associate/contactDepartment	string	x
sale/associate/usergroup	userGroup	x
sale/associate/usergroupId	int	x
sale/associate/contactFullName	string	x
sale/associate/contactCategory	listAny	x
sale/associate/role	listAny	x
sale/associate/assocName	associate	x
sale/associate/assocTooltip	string
sale/associate/assocType	listAny	x
sale/associate/ejUserId	int
sale/associate/simultaneousEjUser	bool
sale/associate/ejDisplayName	string	x
sale/associate/ejStatus	int
sale/associate/credentialType	None	x
sale/associate/credentialDisplayValue	None	x
sale/associate/isActive	bool	x
sale/associate/isActiveText	bool	x
sale/associate/portraitThumbnail	None
sale/associate/otherGroups	userGroup
sale/associate/userName	string	x
sale/associate/personEmail	string	x
sale/associate/locationAddress	string	x
sale/associate/isLocation	bool	x
sale/saleUdef/SuperOffice:1	string	x
sale/saleUdef/SuperOffice:2	string	x
sale/saleUdef/SuperOffice:3	int	x
sale/saleUdef/SuperOffice:4	date	x
sale/saleUdef/SuperOffice:5	unlimitedDate	x
sale/saleUdef/SuperOffice:6	bool	x
sale/saleUdef/SuperOffice:7	listAny	x
sale/saleUdef/SuperOffice:8	decimal	x
appointment/completed	bool	x
appointment/icon	listAny	x
appointment/date	date	x
appointment/time	None
appointment/type	listAny	x
appointment/recordType	string	x
appointment/text	positiveString	x
appointment/associateId	associate	x
appointment/contactId	listAny	x
appointment/personId	listAny	x
appointment/projectId	listAny	x
appointment/saleId	int	x
appointment/userGroup	userGroup	x
appointment/who	None
appointment/updatedBy	associate	x
appointment/updatedByFullName	associate	x
appointment/updatedDate	date	x
appointment/registeredBy	associate	x
appointment/registeredByFullName	associate	x
appointment/registeredDate	date	x
appointment/appointmentId	int	x
appointment/endDate	date	x
appointment/priority	listAny	x

Supported Columns (cont.)

Name	Restriction	OrderBy
appointment/alarm	bool	x
appointment/isFree	bool	x
appointment/recurring	bool	x
appointment/booking	bool	x
appointment/excludeParticipants	bool
appointment/intention	listAny	x
appointment/location	string	x
appointment/recurrenceRuleId	int	x
appointment/rawType	int	x
appointment/rawStatus	int	x
appointment/cautionWarning	listAny	x
appointment/visibleInDiary	bool	x
appointment/endTime	None
appointment/suggestedAppointmentId	int	x
appointment/completedDate	date	x
appointment/isMilestone	bool	x
appointment/invitedPersonId	int	x
appointment/recordTypeText	listAny	x
appointment/joinVideomeetUrl	None	x
appointment/duration	timeSpan
appointment/createdByWorkflow	listAny	x
appointment/colorIndex	listAny	x
appointment/visibleFor	listAny
appointment/appointmentPublish/isPublished	bool	x
appointment/appointmentPublish/publishedFrom	date	x
appointment/appointmentPublish/publishedTo	date	x
appointment/appointmentPublish/publishedBy	None
appointment/appointmentUdef/SuperOffice:1	string	x
appointment/appointmentUdef/SuperOffice:2	string	x
appointment/appointmentUdef/SuperOffice:3	int	x
appointment/appointmentUdef/SuperOffice:4	date	x
appointment/appointmentUdef/SuperOffice:5	unlimitedDate	x
appointment/appointmentUdef/SuperOffice:6	bool	x
appointment/appointmentUdef/SuperOffice:7	listAny	x
appointment/appointmentUdef/SuperOffice:8	decimal	x
appointment/associate/firstName	string	x
appointment/associate/lastName	string	x
appointment/associate/middleName	string	x
appointment/associate/fullName	string	x
appointment/associate/contactId	int
appointment/associate/personId	int
appointment/associate/mrMrs	string	x
appointment/associate/title	string	x
appointment/associate/associateDbId	associate	x
appointment/associate/contactName	string	x
appointment/associate/contactDepartment	string	x
appointment/associate/usergroup	userGroup	x
appointment/associate/usergroupId	int	x
appointment/associate/contactFullName	string	x
appointment/associate/contactCategory	listAny	x
appointment/associate/role	listAny	x
appointment/associate/assocName	associate	x
appointment/associate/assocTooltip	string
appointment/associate/assocType	listAny	x
appointment/associate/ejUserId	int
appointment/associate/simultaneousEjUser	bool
appointment/associate/ejDisplayName	string	x
appointment/associate/ejStatus	int
appointment/associate/credentialType	None	x
appointment/associate/credentialDisplayValue	None	x
appointment/associate/isActive	bool	x
appointment/associate/isActiveText	bool	x
appointment/associate/portraitThumbnail	None
appointment/associate/otherGroups	userGroup
appointment/associate/userName	string	x
appointment/associate/personEmail	string	x
appointment/associate/locationAddress	string	x
appointment/associate/isLocation	bool	x
appointment/appointment/text	positiveString	x
appointment/appointment/description	positiveString	x
appointment/appointment/title	positiveString	x
appointment/appointment/titleHtml	None	x
appointment/appointment/agenda	positiveString	x
appointment/appointment/agendaHtml	None	x
appointment/appointment/isConverted	None
appointment/appointment/textId	int	x
appointment/appointment/internalNotes	positiveString	x
appointment/appointment/internalNotesHtml	positiveString	x
document/completed	bool	x
document/icon	listAny	x
document/date	date	x
document/time	None
document/type	listAny	x
document/recordType	string	x
document/text	positiveString	x
document/associateId	associate	x
document/contactId	listAny	x
document/personId	listAny	x
document/projectId	listAny	x
document/saleId	int	x
document/userGroup	userGroup	x
document/who	None
document/updatedBy	associate	x
document/updatedByFullName	associate	x
document/updatedDate	date	x
document/registeredBy	associate	x
document/registeredByFullName	associate	x
document/registeredDate	date	x
document/documentId	int	x
document/keywords	string	x

Supported Columns (cont.)

Name	Restriction	OrderBy
document/ourref	string	x
document/yourref	string	x
document/attention	string	x
document/subject	string	x
document/name	string	x
document/mailMergeDraft	bool	x
document/snum	int	x
document/isReport	bool
document/suggestedDocumentId	int	x
document/isMail	bool
document/recordTypeText	None	x
document/visibleFor	listAny
document/documentPublish/isPublished	bool	x
document/documentPublish/publishedFrom	date	x
document/documentPublish/publishedTo	date	x
document/documentPublish/publishedBy	None
document/associate/firstName	string	x
document/associate/lastName	string	x
document/associate/middleName	string	x
document/associate/fullName	string	x
document/associate/contactId	int
document/associate/personId	int
document/associate/mrMrs	string	x
document/associate/title	string	x
document/associate/associateDbId	associate	x
document/associate/contactName	string	x
document/associate/contactDepartment	string	x
document/associate/usergroup	userGroup	x
document/associate/usergroupId	int	x
document/associate/contactFullName	string	x
document/associate/contactCategory	listAny	x
document/associate/role	listAny	x
document/associate/assocName	associate	x
document/associate/assocTooltip	string
document/associate/assocType	listAny	x
document/associate/ejUserId	int
document/associate/simultaneousEjUser	bool
document/associate/ejDisplayName	string	x
document/associate/ejStatus	int
document/associate/credentialType	None	x
document/associate/credentialDisplayValue	None	x
document/associate/isActive	bool	x
document/associate/isActiveText	bool	x
document/associate/portraitThumbnail	None
document/associate/otherGroups	userGroup
document/associate/userName	string	x
document/associate/personEmail	string	x
document/associate/locationAddress	string	x
document/associate/isLocation	bool	x
document/documentUdef/SuperOffice:1	string	x
document/documentUdef/SuperOffice:2	string	x
document/documentUdef/SuperOffice:3	int	x
document/documentUdef/SuperOffice:4	date	x
document/documentUdef/SuperOffice:5	unlimitedDate	x
document/documentUdef/SuperOffice:6	bool	x
document/documentUdef/SuperOffice:7	listAny	x
document/documentUdef/SuperOffice:8	decimal	x
document/document/textId	int	x
document/document/description	positiveString	x
personId	int	x
firstName	string	x
lastName	string	x
middleName	string	x
fullName	string	x
personHasInterests	bool	x
mrMrs	string	x
position	listAny	x
personNumber	string	x
title	string	x
personCountry	listAny	x
personCountryId	int	x
personNoMail	bool	x
rank	int	x
birthdate	None
associateType	None
useAsMailingAddress	bool	x
personSource	listAny	x
retired	bool	x
birthYear	int	x
birthMonth	int	x
birthDay	int	x
kanaFirstName	string	x
kanaLastName	string	x
personUpdatedBy	associate	x
personUpdatedByFullName	associate	x
personUpdatedDate	date	x
personRegisteredBy	associate	x
personRegisteredByFullName	associate	x
personRegisteredDate	date	x
portraitThumbnail	None
personActiveErpLinks	bool	x
personSourcedFrom	string	x
personLinkedinUrl	string	x
ticketPriority	listAny	x
supportLanguage	listAny	x
supportAssociate	associate	x
supportAssociateFullName	associate	x
personAssociateId	associate	x
personAssociateFullName	associate	x
personCategory	listAny	x

Supported Columns (cont.)

Name	Restriction	OrderBy
personCategoryGroup	listAny	x
personCategoryRank	int	x
personBusiness	listAny	x
leadStatus	listAny	x
leadstatusRank	int	x
personDeletedDate	datetime
hasCompany	bool	x
isProjectMember	bool	x
isStakeholder	bool	x
updatedByWorkflow	listAny	x
whenUpdatedByWorkflow	datetime	x
createdByForm	listAny	x
personDirectPhone/formattedNumber	string
personDirectPhone/description	string	x
personMobilePhone/formattedNumber	string
personMobilePhone/description	string	x
personPrivate/formattedNumber	string
personPrivate/description	string	x
personPager/formattedNumber	string
personPager/description	string	x
personDirectFax/formattedNumber	string
personDirectFax/description	string	x
personInfo/textId	int	x
personInfo/infoText	positiveString	x
personEmail/emailProtocol	string	x
personEmail/emailAddress	string	x
personEmail/emailDescription	string	x
personEmail/emailId	int	x
personEmail/emailLastSent	datetime	x
personEmail/emailBounceCount	int	x
personEmail/emailLastBounce	datetime	x
personEmail/emailHasBounced	bool	x
personUrl/URLAddress	string	x
personUrl/URLDescription	string	x
personAddress/addressId	int	x
personAddress/line1	string	x
personAddress/line2	string	x
personAddress/line3	string	x
personAddress/county	string	x
personAddress/city	string	x
personAddress/zip	string	x
personAddress/state	string	x
personAddress/wgs84latitude	decimal	x
personAddress/wgs84longitude	decimal	x
personAddress/formattedAddress	None
personAddress/formattedMultiLineAddress	None
personInterestIds	listInterest
personUdef/SuperOffice:1	string	x
personUdef/SuperOffice:2	string	x
personUdef/SuperOffice:3	int	x
personUdef/SuperOffice:4	date	x
personUdef/SuperOffice:5	unlimitedDate	x
personUdef/SuperOffice:6	bool	x
personUdef/SuperOffice:7	listAny	x
personUdef/SuperOffice:8	decimal	x
personUdef/SuperOffice:9	string	x
personUdef/SuperOffice:10	string	x
personUdef/SuperOffice:11	string	x
personExtra/x_person_integer	int	x
personExtra/x_person_hidden_integer	int	x
personExtra/x_person_float	decimal	x
personExtra/x_person_longtext	string	x
personExtra/x_person_date	date	x
personExtra/x_person_datetime	datetime	x
personExtra/x_person_time	None	x
personExtra/x_person_boolean	bool	x
personExtra/x_person_timespan	timeSpan	x
personExtra/x_person_shorttext	string	x
personExtra/x_person_shorttext_list	listAny	x
personExtra/x_person_user_relation	associate	x
personExtra/x_person_category_relation	listAny	x
personExtra/x_person_priority_relation	listAny	x
personExtra/x_person_request_relation	stringorPK	x
personExtra/x_person_appointment_relation	stringorPK	x
personExtra/x_person_contact_relation	stringorPK	x
personExtra/y_rental/id	int	x
personExtra/y_rental/x_start	date	x
personExtra/y_rental/x_end	date	x
personExtra/y_rental/x_amount	int	x
personExtra/y_rental/x_contact	stringorPK	x
personExtra/y_rental/y_equipment/x_name	string	x
personExtra/y_car/id	int	x
personAssociate/firstName	string	x
personAssociate/lastName	string	x
personAssociate/middleName	string	x
personAssociate/fullName	string	x
personAssociate/contactId	int
personAssociate/personId	int
personAssociate/mrMrs	string	x
personAssociate/title	string	x
personAssociate/associateDbId	associate	x
personAssociate/contactName	string	x
personAssociate/contactDepartment	string	x
personAssociate/usergroup	userGroup	x
personAssociate/usergroupId	int	x
personAssociate/contactFullName	string	x
personAssociate/contactCategory	listAny	x
personAssociate/role	listAny	x
personAssociate/assocName	associate	x
personAssociate/assocTooltip	string

Supported Columns (cont.)

Name	Restriction	OrderBy
personAssociate/assocType	listAny	x
personAssociate/ejUserId	int
personAssociate/simultaneousEjUser	bool
personAssociate/ejDisplayName	string	x
personAssociate/ejStatus	int
personAssociate/credentialType	None	x
personAssociate/credentialDisplayValue	None	x
personAssociate/isActive	bool	x
personAssociate/isActiveText	bool	x
personAssociate/portraitThumbnail	None
personAssociate/otherGroups	userGroup
personAssociate/userName	string	x
personAssociate/personEmail	string	x
personAssociate/locationAddress	string	x
personAssociate/isLocation	bool	x
correspondingAssociate/firstName	string	x
correspondingAssociate/lastName	string	x
correspondingAssociate/middleName	string	x
correspondingAssociate/fullName	string	x
correspondingAssociate/contactId	int
correspondingAssociate/personId	int
correspondingAssociate/mrMrs	string	x
correspondingAssociate/title	string	x
correspondingAssociate/associateDbId	associate	x
correspondingAssociate/contactName	string	x
correspondingAssociate/contactDepartment	string	x
correspondingAssociate/usergroup	userGroup	x
correspondingAssociate/usergroupId	int	x
correspondingAssociate/contactFullName	string	x
correspondingAssociate/contactCategory	listAny	x
correspondingAssociate/role	listAny	x
correspondingAssociate/assocName	associate	x
correspondingAssociate/assocTooltip	string
correspondingAssociate/assocType	listAny	x
correspondingAssociate/ejUserId	int
correspondingAssociate/simultaneousEjUser	bool
correspondingAssociate/ejDisplayName	string	x
correspondingAssociate/ejStatus	int
correspondingAssociate/credentialType	None	x
correspondingAssociate/credentialDisplayValue	None	x
correspondingAssociate/isActive	bool	x
correspondingAssociate/isActiveText	bool	x
correspondingAssociate/portraitThumbnail	None
correspondingAssociate/otherGroups	userGroup
correspondingAssociate/userName	string	x
correspondingAssociate/personEmail	string	x
correspondingAssociate/locationAddress	string	x
correspondingAssociate/isLocation	bool	x
isMailingRecipient	bool	x
hasStoreConsent	bool
withdrawnStoreConsent	bool
hasEmarketingConsent	bool
withdrawnEmarketingConsent	bool
subscription	listAny	x
legalBaseStore	listAny	x
legalBaseEmarketing	listAny	x
consentSourceStore	listAny	x
consentSourceEmarketing	listAny	x

Sample

GET /api/v1/archive/FindContactWithoutPhoneAddressEmail?$select=contactAssociate/role,sale/lossReason,sale/hasStakeholders,appointment/appointmentUdef/SuperOffice:8
Authorization: Basic dGplMDpUamUw
Accept: application/json; charset=utf-8
Accept-Language: sv

​“FindContactWithoutPhoneAddressEmail”

​Supported Entities

​Supported Columns

​Supported Columns (cont.)

​Supported Columns (cont.)

​Supported Columns (cont.)

​Supported Columns (cont.)

​Supported Columns (cont.)

​Supported Columns (cont.)

​Supported Columns (cont.)

​Sample

“FindContactWithoutPhoneAddressEmail”

Supported Entities

Supported Columns

Supported Columns (cont.)

Supported Columns (cont.)

Supported Columns (cont.)

Supported Columns (cont.)

Supported Columns (cont.)

Supported Columns (cont.)

Supported Columns (cont.)

Sample