Welcome to the Capstorm Developer Blog
Tips and tricks to make your Capstorm and Salesforce implementations ready for anything that comes your way.
How to Refresh a Sandbox Six Times a Day
A few years ago we faced an interesting problem. A client was doing a Salesforce migration project and had a 5GB Salesforce sandbox which they wanted to refresh multiple times per day. Testing the [...]
Migrating PostgreSQL JDBC Code to RedShift
Once every few months I am asked to support Amazon's RedShift as a backup database for CopyStorm. I doubted that RedShift would be a very good choice given the limitations of a database like [...]
Secrets on “How to Migrate Salesforce Rich Text Fields”
Migrating Salesforce rich text fields is a simple task UNTIL you have to migrate a rich text fields which contains images. This article explores the secrets of migrating any rich text field -- with [...]
How to Anonymize an Entire Salesforce Sandbox
Twice this week I was asked what seems to be simple question. We just refreshed our full Salesforce sandbox. How can we do a bulk anonymization of the sandbox's data so it is safe [...]
Why Are Salesforce Attachments so Darn Tricky to Read?
Salesforce Attachments are wonderful things. Not only are there multiple ways to store them (Classic and File), there are also multiple APIs to read them and.... Neither the SOAP or REST Salesforce APIs can [...]
Help! Salesforce Returned an UNKNOWN_EXCEPTION
If you use the Salesforce APIs to solve non-trivial problems, you will eventually get an error which looks like: [UnexpectedErrorFault [ApiFault exceptionCode='UNKNOWN_EXCEPTION' exceptionMessage='An unexpected error occurred. Please include this ErrorId if you contact support: [...]
Analytics with ROI Starting Today
Generate ROI From Salesforce and Amazon/AWS... Today! Sales came to me with an interesting analytics problem early this week. The solution required a combination and analysis of data from two different places: [...]
Salesforce’s SOQL Statement Is Stranger than You Think
Salesforce’s SOQL Statement Is Stranger than You Think Salesforce’s SOQL language is deceptively like other database query languages — at least on the surface. However, if you are not aware of its quirks you [...]
How to Populate a Scratch Org Using Automation
Salesforce scratch orgs have two glaring deficiencies for any use case which requires data. Scratch orgs do not contain any customizations used by the associated production org. They are plain vanilla. Scratch orgs do [...]
How to Create and Refresh Scratch Orgs using Automation
The first step to weaponizing a Saleforce scratch org is to automate its creation and maintenance. Since scratch orgs expire every few days, automation needs to do a few key operations: Detect when a [...]