Update AccountId on Salesforce User record
AccountId field on the User object is read only. It is derived from Contact's AccountId field. We cannot update AccountId on the User object. The Contact record's AccountId field should ....
Tag: Salesforce SOQL
How to query Salesforce Connected App?
ConnectedApplication entity can be to query Salesforce Connected App. Use SOQL on ConnectedApplication entity to query Connected App details. Sample SOQL: SELECT Id, Name, OptionsAllowAdminApprovedUsersOnly FROM ConnectedApplication For additional columns ....
Parent and Child records in Salesforce SOQL using REST API
Sub-Query can be used to Parent and Child records in Salesforce SOQL using REST API. Example: /services/data/v57.0/query/?q=SELECT+Name+,+(+SELECT+Name+FROM+Contacts+)+FROM+Account+WHERE+Id+=+'0013t00002XXRyDAAX' Workbench: Postman: https://youtu.be/367LYcU6vPs
How to create and query Salesforce Custom Address Field?
To create custom address fields in Salesforce, use the following steps. 1. Go to User Interface in Salesforce Setup. 2. Enable "Use custom address fields". Create a Custom Address Field. ....
How to get Apex Class Access for a profile using Apex in Salesforce?
Apex Classes assignment to a Profile are stored in SetupEntityAccess entity/object. So, by filtering ParentId with the Profile's Permission Set Id and SetupEntityType = 'ApexClass', we can fetch the Apex ....
Salesforce Legacy API Versions Retirement
To check the users and metadata components using the older legacy API versions check the following. Note: Update the versions as per the current versions that are getting retired. Using ....
Insufficient Privileges when viewing Salesforce EmailMessage Record
When viewing the EmailMessage records, the following Exception is thrown when the EmailMessage Status is 5 i.e draft. Insufficient PrivilegesYou do not have the level of access necessary to perform ....
Too many SOQL queries: 101 Salesforce Exception
System.LimitException: Too many SOQL queries: 101 Salesforce Exception is thrown when more than 100 SOQL queries are executed in a single synchronous transaction. For Asynchronous, the limit is 200. This ....
How to query Salesforce Custom Label Translations?
Custom Label Translations are stored in ExternalStringLocalization Entity. So, we can query using Tooling API. Custom Label Translations Sample SOQL: SELECT Id, ExternalStringId, ExternalString.MasterLabel, ExternalString.Value, Value, Language FROM ExternalStringLocalization WHERE ....
Check Salesforce Reports and Dashboards Subscriptions for an User
Option 1 - API: Report Subscription: https://{Your Domain URL}/services/data/v56.0/analytics/notifications?source=lightningReportSubscribe&ownerId=0053t00000AG695AAD Dashboard Subscription: https://{Your Domain URL}/services/data/v56.0/analytics/notifications?source=lightningDashboardSubscribe&ownerId=0053t00000AG695AAD Option 2 - SOQL: SELECT Id, CronJobDetailId, State FROM CronTrigger WHERE CronJobDetail.JobType = 'A' AND OwnerId ....