Step 6: Connect with Postman to avoid SOQL timeout

*This step is Optional

Overview – 

If you have a large number of records, you’ll need to chunk these records for masking. Suppose you have 40 million records. Of these 40 million, you may process around 2-3 million of these records using the ‘where’ clause. 

The challenge with utilizing the ‘where’ clause in this situation, is that when you attempt to perform the SOQL operation on a chunk of records, it can time out. This makes it difficult for you to guess the right number of records to mask.

This is where Postman comes in. Postman is an API platform for building and using APIs. It simplifies each step of the API lifecycle and streamlines collaboration, helping you create better APIs faster.

Below are the steps on how to utilize Postman:

Step 1: Refer article to download Postman and connect to your Salesforce Org.

Step 2: Once the connection is made, you now have the ability to submit simple query batch jobs using Bulk API. This will make it easier for you to get the count as it would not time out. For this refer to the following article, linked here.

Step 3: Once a job is submitted, go to ‘Navigate’ -> ‘Salesforce Dashboard Setup’ -> ‘Bulk Data Load Jobs.’

Now, you can see the status of the job, and prevent your masking from being impacted by time outs.

Powered by BetterDocs