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
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. ....
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 ....
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 ....
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 ....
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 ....
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 ....
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 ....
Time difference between Case Creation Date and Email Message MessageDate can be used to find time delay in Case creation from Salesforce Email-To-Case. Sample Code: for ( EmailMessage objEM : ....
When a Lead record was assigned via Assignment Rule, in the Lead History entity, we should see an entry with ownerAssignment as the value in the Field column. Make sure ....