personfavourites - SuperOffice

“personfavourites”

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

Supported Entities

Name	Description
”person”

Supported Columns

Name	Restriction	Description	OrderBy
getAllRows	bool
getNoRows	bool
personId	int		x
firstName	string		x
lastName	string		x
middleName	string		x
fullName	string		x
fullNameWithContact	None		x
contactId	int		x
hasInfoText	bool		x
hasInterests	bool		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
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
phone/formattedNumber	string
entityIcon	None		x
icon	None		x
text	positiveString		x
favouritePersonAssociateId	associate		x
favouriteAssociateId	associate		x
emailAddress	associate		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
searchPhone/formattedNumber	string
searchPhone/description	string		x
personInfo/textId	int		x
personInfo/infoText	positiveString		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
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

Supported Columns (cont.)

Name	Restriction	Description	OrderBy
personAddress/wgs84longitude	decimal		x
personAddress/formattedAddress	None
personAddress/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
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
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

Supported Columns (cont.)

Name	Restriction	Description	OrderBy
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
name	stringorPK		x
department	string		x
nameDepartment	string		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
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
contactPhone/formattedNumber	string
contactPhone/description	string		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
contactAssociate/firstName	string		x
contactAssociate/lastName	string		x
contactAssociate/middleName	string		x
contactAssociate/fullName	string		x
contactAssociate/contactId	int
contactAssociate/personId	int
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

Supported Columns (cont.)

Name	Restriction	Description	OrderBy
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
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/personfavourites?$select=contactAssociate/associateDbId,restrictionAddress/county,personAssociate/contactDepartment
Authorization: Basic dGplMDpUamUw
Accept: application/json; charset=utf-8
Accept-Language: sv

See also: IArchiveAgent.