Maximum SOQL offset allowed is 2000 for Pagination

Salesforce Help Article There is a help article suggested by Salesforce: https://help.salesforce.com/articleView?id=000339353&type=1&mode=1. However, there are some good ways to use this. PK Chunking – the one we used to use Bulk API For example, let’s say you enable PK chunking for the following query on an Account table with 10,000,000 records. SELECT Name FROM Account …

Maximum SOQL offset allowed is 2000 for Pagination Read More »

“This session is not valid for use with the REST API” while making query

DESCRIPTION This error you must be getting while making query developer console OR query using api. It’s because of fact that you don’t have permission to access org using API. SOLUTION If Issue is taking place in developer console Quick way to fix it to give permission “Use any API client” using profile or permission …

“This session is not valid for use with the REST API” while making query Read More »

Salesforce Winter ’21 Release Notes (Developer Perspective)

Update Resources with the PATCH HTTP Method in Apex Callouts To make partial or full updates to a resource in an HTTP web service, specify the PATCH method in the HttpRequest class. Previously, only the PUT method was supported for full updates. https://releasenotes.docs.salesforce.com/en-us/winter21/release-notes/rn_apex_callouts_patch.htm?edition=&impact= Use the Safe Navigation Operator to Avoid Null Pointer Exceptions Use the safe navigation …

Salesforce Winter ’21 Release Notes (Developer Perspective) Read More »

How to get IP Address of Community User – Guest and Logged in Customer User

DESCRIPTION Tracing IP address of community is utmost requirement to achieve different goals like geo based technical support, spam protection and other security things. There are bunch of forum discussions related to this: https://developer.salesforce.com/forums/?id=9062I000000g56rQAA https://salesforce.stackexchange.com/questions/145145/how-to-get-ip-address-of-current-user-in-lightning-component https://salesforce.stackexchange.com/questions/246085/how-to-get-the-public-ip-address-of-current-user-in-lightning-component-hosted-o/246087 APPROACHES In order to solve this, simple approach is to get the IP address and store in any custom …

How to get IP Address of Community User – Guest and Logged in Customer User Read More »

Salesforce Platform Encryption and Classical Encryption – Depuzzling

To take your security measures further, Salesforce Shield provides a more robust suite of solutions. Shield includes three products: Platform Encryption, Event Monitoring, and Field Audit Trail. Here our focus on Shield Platform Encryption, which provides a higher-level encryption (256-bit instead of 128-bit) than the classic offering. Platform Encryption is very different than classical encryption …

Salesforce Platform Encryption and Classical Encryption – Depuzzling Read More »

Box Authentication – Getting Access token Using JWT OAuth2.0 in Salesforce

This articles explains how can we authenticate in Box.com using JWT OAuth 2.0. Here is the API details in Box API documentation: https://developer.box.com/guides/authentication/jwt/without-sdk/ Box – Prerequisites Salesforce – Prerequisites Apex Code A). In following implementation, we are not using standard JWT and JWS because it throws error “Signature verification error. The public key identified by …

Box Authentication – Getting Access token Using JWT OAuth2.0 in Salesforce Read More »