Power BI Connector for Act! CRM

Build 23.0.8839

OpportunityContacts

Query and delete the Contacts associated with an Opportunity.

Table Specific Information

Select

  • Id supports the '=' operator.
  • OpportunityId supports the '=' operator.
  • Created supports the '<=,<,=,!=,>,>=' operator.
  • FullName supports the '<=,<,=,!=,>,>=,CONTAINS' operator.
  • AltEmailAddress supports the '<=,<,=,!=,>,>=,CONTAINS' operator.
  • AlternateExtension supports the '<=,<,=,!=,>,>=,CONTAINS' operator.
  • AlternatePhone supports the '<=,<,=,!=,>,>=,CONTAINS' operator.
  • Birthday supports the '<=,<,=,!=,>,>=,CONTAINS' operator.
  • BusinessAddressCity supports the '<=,<,=,!=,>,>=,CONTAINS' operator.
  • BusinessAddressCountry supports the '<=,<,=,!=,>,>=,CONTAINS' operator.
  • BusinessAddressLine1 supports the '<=,<,=,!=,>,>=,CONTAINS' operator.
  • BusinessAddressLine2 supports the '<=,<,=,!=,>,>=,CONTAINS' operator.
  • BusinessAddressLine3 supports the '<=,<,=,!=,>,>=,CONTAINS' operator.
  • BusinessAddressPostalCode supports the '<=,<,=,!=,>,>=,CONTAINS' operator.
  • BusinessAddressState supports the '<=,<,=,!=,>,>=,CONTAINS' operator.
  • BusinessExtension supports the '<=,<,=,!=,>,>=,CONTAINS' operator.
  • BusinessPhone supports the '<=,<,=,!=,>,>=,CONTAINS' operator.
  • Company supports the '<=,<,=,!=,>,>=,CONTAINS' operator.
  • CompanyID supports the '<=,<,=,!=,>,>=,CONTAINS' operator.
  • ContactType supports the '<=,<,=,!=,>,>=,CONTAINS' operator.
  • Department supports the '<=,<,=,!=,>,>=,CONTAINS' operator.
  • Edited supports the '<=,<,=,!=,>,>=' operator.
  • EditedBy supports the '<=,<,=,!=,>,>=,CONTAINS' operator.
  • EmailAddress supports the '<=,<,=,!=,>,>=,CONTAINS' operator.
  • FaxExtension supports the '<=,<,=,!=,>,>=,CONTAINS' operator.
  • FaxPhone supports the '<=,<,=,!=,>,>=,CONTAINS' operator.
  • FirstName supports the '<=,<,=,!=,>,>=,CONTAINS' operator.
  • HomeAddressCity supports the '<=,<,=,!=,>,>=,CONTAINS' operator.
  • HomeAddressCountry supports the '<=,<,=,!=,>,>=,CONTAINS' operator.
  • HomeAddressLine1 supports the '<=,<,=,!=,>,>=,CONTAINS' operator.
  • HomeAddressLine2 supports the '<=,<,=,!=,>,>=,CONTAINS' operator.
  • HomeAddressLine3 supports the '<=,<,=,!=,>,>=,CONTAINS' operator.
  • HomeAddressPostalCode supports the '<=,<,=,!=,>,>=,CONTAINS' operator.
  • HomeAddressState supports the '<=,<,=,!=,>,>=,CONTAINS' operator.
  • HomeExtension supports the '<=,<,=,!=,>,>=,CONTAINS' operator.
  • HomePhone supports the '<=,<,=,!=,>,>=,CONTAINS' operator.
  • IdStatus supports the '<=,<,=,!=,>,>=,CONTAINS' operator.
  • IsUser supports the '=' operator.
  • JobTitle supports the '<=,<,=,!=,>,>=,CONTAINS' operator.
  • LastName supports the '<=,<,=,!=,>,>=,CONTAINS' operator.
  • LastResults supports the '<=,<,=,!=,>,>=,CONTAINS' operator.
  • Latitude supports the '<=,<,=,!=,>,>=' operator.
  • Longitude supports the '<=,<,=,!=,>,>=' operator.
  • MessengerID supports the '<=,<,=,!=,>,>=,CONTAINS' operator.
  • MiddleName supports the '<=,<,=,!=,>,>=,CONTAINS' operator.
  • MobileExtension supports the '<=,<,=,!=,>,>=,CONTAINS' operator.
  • MobilePhone supports the '<=,<,=,!=,>,>=,CONTAINS' operator.
  • NamePrefix supports the '<=,<,=,!=,>,>=,CONTAINS' operator.
  • NameSuffix supports the '<=,<,=,!=,>,>=,CONTAINS' operator.
  • PagerExtension supports the '<=,<,=,!=,>,>=,CONTAINS' operator.
  • PagerPhone supports the '<=,<,=,!=,>,>=,CONTAINS' operator.
  • PersonalEmailAddress supports the '<=,<,=,!=,>,>=,CONTAINS' operator.
  • RecordOwner supports the '<=,<,=,!=,>,>=,CONTAINS' operator.
  • ReferredBy supports the '<=,<,=,!=,>,>=,CONTAINS' operator.
  • Salutation supports the '<=,<,=,!=,>,>=,CONTAINS' operator.
  • Website supports the '<=,<,=,!=,>,>=,CONTAINS' operator.
The connector uses the Act! CRM API to process search criteria that refer to the supported fields. The connector processes other filters client-side within the connector. For example, the following queries are processed server side:
SELECT * FROM OpportunityContacts WHERE OpportunityId = '12345'

SELECT * FROM OpportunityContacts WHERE FullName = 'Contact name' 

Delete

OpportunityContacts can be deleted by providing an OpportunityId and Id (Contact Id) and issuing a DELETE statement.

DELETE FROM OpportunityContacts WHERE OpportunityId = '12345' AND Id = '34567'

Columns

Name Type ReadOnly Description
Id [KEY] String False

The unique identifier (id) for this contact.

OpportunityId [KEY] String False

The unique identifier (id) for the opportunity to query contacts from.

Created Datetime False

Created date of the contact.

FullName String False

The first name, any middle names, and surname of a contact. This may also include name prefixes and sufixes that are defined within Act!

AltEmailAddress String False

A unique electronic address that an individual can be contacted.

AlternateExtension String False

The contact's alternate phone number extension.

AlternatePhone String False

The contact's alternate phone number.

Birthday String False

The anniversary of the day on which a person was born.

BusinessAddressCity String False

An inhabited place of greater size, population, or importance than a town or village.

BusinessAddressCountry String False

A nation with its own government, occupying a particular territory.

BusinessAddressLine1 String False

Primary street address

BusinessAddressLine2 String False

Secondary street address

BusinessAddressLine3 String False

Miscellaneous street address

BusinessAddressPostalCode String False

A code of letters and digits added to a postal address to aid in the sorting of mail.

BusinessAddressState String False

A nation or territory considered as an organized political community under one government.

BusinessExtension String False

The contact's business phone number extension.

BusinessPhone String False

The contact's business phone number.

Company String False

The organization that this contact is associated with.

CompanyID String False

The unique identifier (companyID) for a given companies.

ContactType String False

The type of contact: Contact, Secondary, or User.

Department String False

An area of special expertise or responsibility.

Edited Datetime False

Edited date of the contact.

EditedBy String False

User who edited the contact.

EmailAddress String False

A unique electronic address that an individual can be contacted.

FaxExtension String False

The contact's fax phone number extension.

FaxPhone String False

The contact's fax phone number.

FirstName String False

A personal given name.

HomeAddressCity String False

An inhabited place of greater size, population, or importance than a town or village.

HomeAddressCountry String False

A nation with its own government, occupying a particular territory.

HomeAddressLine1 String False

Primary street address

HomeAddressLine2 String False

Secondary street address

HomeAddressLine3 String False

Miscellaneous street address

HomeAddressPostalCode String False

A code of letters and digits added to a postal address to aid in the sorting of mail.

HomeAddressState String False

A nation or territory considered as an organized political community under one government.

HomeExtension String False

The contact's home phone extension.

HomePhone String False

The contact's home phone number.

IdStatus String False

The relative social or professional position of an individual within a group or organization.

IsUser Bool False

An indicator if this contact is also a user within the system.

JobTitle String False

The title or position this contact holds.

LastName String False

The family name or surname.

LastResults String False

Identifies last communication or action with a contact.

Latitude Decimal False

The angular distance of a place north or south of the earth's equator, or of a celestial object north or south of the celestial equator, usually expressed in degrees and minutes.

Longitude Decimal False

The angular distance of a place east or west of the meridian at Greenwich, England, or west of the standard meridian of a celestial object, usually expressed in degrees and minutes.

MessengerID String False

An online identifier alias.

MiddleName String False

A name between one's first name and surname.

MobileExtension String False

The contact's mobile phone extension.

MobilePhone String False

The contact's mobile phone number.

NamePrefix String False

A patronymic prefix.

NameSuffix String False

Provides additional information about the person that identifies an individual position, educational degree, accreditation, orffice, or honors.

PagerExtension String False

The contact's pager phone number extension

PagerPhone String False

The contact's pager phone number.

PersonalEmailAddress String False

A unique electronic address that an individual can be contacted.

RecordOwner String False

Owner user of the record.

ReferredBy String False

Indiciates how this contact came about.

Salutation String False

A gesture or utterance made as a greeting or acknowledgment.

Website String False

The contact's web site.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 23.0.8839