[SalesForce] Contact information from AccountContactRelation

Given a contact ID, I'm looking to get all the contact's information as well as their associated account name (if they have one associated account) or the name of the direct account if they have multiple associated accounts.

The following works if the contact has an associated Account, but isn't handling the case where the contact has no account, and I'm not sure if there's a case of a contact having a single account which isn't direct.

SELECT contactID, contact.FirstName, contact.LastName, Account.Name, contact.Phone, contact.Title, contact.Email, contact.Contact_Type__c, contact.Inactive__c, acr.isdirect FROM AccountContactRelation acr where (contactid = '{markId}' and isdirect = true)

Best Answer

The AccountContactRelation (ACR) sObject is a junction object that resolves the many to many relationship of many Contacts being connected to many Accounts. In order for the junction object to exist, it needs to be connecting a Contact to an Account. If a Contact has no Account, the junction object would not have been created in the first place. So, in answer to your question, you don't have to worry about a Contact having no Account -- the ACR would not exist in that case.

Related Solutions

[SalesForce] Create case with no accountId although contact has related account

Create an additional lookup relationship with Contact on the Case object
Use the newly created Contact field in your Pagelayout and hide the Original one.
Use a Workflowrule or process to update the original Contact lookup field with the Value in your newly created Contact field.

[SalesForce] How to query Account object with minimum number of children

That can be a difficult query since Accounts and Contacts typically have a lot of records. There's a risk of running into the "Too many query rows" exception, but if you don't have too much data at this point, this query might work for you:

Apex:

list<AggregateResult> arlist = [
    SELECT COUNT(Id), AccountId
    FROM Contact 
    WHERE AccountId != NULL 
    GROUP BY AccountId
    HAVING COUNT(Id) >= 4
];

Rest api:

$ curl -H 'Authorization: Bearer <session-id>' \
  -H 'X-PrettyPrint: 1' \
  https://ap4.salesforce.com/services/data/v38.0/query?q=SELECT+COUNT%28Id%29,+AccountId+FROM+Contact+WHERE+AccountId+!=+NULL+GROUP+BY+AccountId+HAVING+COUNT%28Id%29+%3E=+4

Best Answer

Related Solutions

[SalesForce] Create case with no accountId although contact has related account

[SalesForce] How to query Account object with minimum number of children

Related Topic