image post

How to connect to a Redshift database from Node.js

See how to use pg-promise to connect to a AWS Redshift database
Aug 11, 2020
A util piece of code to connect to a Redshift database

image post

Get all tables in Redshift

Aug 23, 2020
Get all tables from a given schema

image post

Salesforce client for an Apex RESTful web service

Expose a Rest service from an Apex class using RestResource annotation
Aug 29, 2020
An example about how to consume a Salesforce api rest

image post

How to add a pie chart in Campaign’s record page in Salesforce

Add a cool chart in a record page easily. No code.
Aug 30, 2020
What about if we add a component with a pie chart on the Campaign object’s record page?

image post

How to send a message to AWS SQS queue from Salesforce Apex class

Surprisingly, making a callout to put a message in AWS SQS queue is tricky in Apex
Jan 31, 2021
How to post a message in an AWS SQS queue from an Apex class in Salesforce

image post

Salesforce - Mock callouts in Apex

How to use mockups to tests callouts in Apex
Feb 19, 2021
Tests callouts in Apex

image post

Download Salesforce metadata using SFDX

How to download Salesforce metadata to your local machine using SFDX CLI
Feb 23, 2021
Download Salesforce metadata using SFDX

image post

How to download a file from Salesforce using Java Rest API

A Java snippet to download a Salesforce file through the Rest API
Apr 20, 2021
Let say we want to download a file stored in Salesforce. We'll have to deal with ContentVersion

image post

How to download a Salesforce file from Node.js

A JavaScript snippet to download a Salesforce file using the Rest API
Apr 20, 2021
Download a file from Salesforce using Node.js

image post

How to create files in Salesforce for testing purposes

ContentVersion and ContentDocumentLink creation from Apex
May 21, 2021
Fortunately, dealing with files in Salesforce in a unit text context, is pretty easy.


image post

Salesforce integration with AWS AppFlow, S3, Lambda and SQS

Send data out of Salesforce with AWS AppFlow service in realtime
Aug 24, 2021
There are many ways to sync up our Salesforce data with third parties. One option is a mix of Salesforce and AWS services, specifically Change Data Capture from Salesforce and AppFlow from AWS.

image post

Salesforce rest api download ContentVersion

Download a Salesforce file (ContentVersion) through the API using Node.js with jsforce package
Sep 09, 2021

image post

This is most likely not an error with the salesforce cli

Please ensure all information is accurate and try again. (Salesforce)
Oct 07, 2021
Error authenticating with auth code due to: grant type not supported

image post

AppFlow Salesforce: how to sync up relationships

An elegant solution to sync up relationships from Salesforce to AppFlow
Nov 10, 2021
Only basic types such as strings or numbers can be passed through AppFlow which means that look-up fields will be ignored. There's a way you can do it with some work from using the Salesforce out-of-the-box Process Builder tool, a custom object and some lines of Apex code.

image post

Get Record Type id by name in Apex - Salesforce

SOQL query to get a record type by name to use it in Apex code
Nov 10, 2021
Based on this query we are going to build a method that gets the record type id by its name

image post

Invalid request provided: AWS::AppFlow::FlowCreate - Salesforce integration

This is a common error when a field is mapped in App Flow but it doesn't exist in Salesforce
Nov 19, 2021
Resource handler returned message: "Invalid request provided: AWS::AppFlow::FlowCreate Flow

image post

Salesforce inspector: a Salesforce data explorer and exporter

Chrome and Firefox extension to inspect and export data from Salesforce
Jan 18, 2022
A productivity tool for Salesforce administrators and developers to inspect data and metadata directly from the browser without compromising security and privacy

image post

How to delay an execution in Salesforce Apex

Using Schedulable interface to delay an execution in Apex
Jun 10, 2022
In Java, we can use Thread.sleep(1000) to delay the execution by one second. In Apex is not that easy since Salesforce is a multi-tenant environment.

image post

Salesforce CLI - SFDX - Cannot read properties of undefined (reading 'id')

The error doesn't give us so much information but it is related to the URL we are using
Jul 06, 2022
Cannot read properties of undefined (reading 'id'). This is most likely not an error with the Salesforce CLI. Please ensure all information is accurate and try again.

image post

Get Salesforce ContentVersion file info using node-fetch

How to get a Salesforce file info without downloading the file itself
Jul 07, 2022
Let's say you want to get the file info without downloading it. For example, you want to know the file name and extension.

image post

Download a Salesforce ContentVersion file using node-fetch

Download locally a file stored in Salesforce using node-fetch package for Node.js
Jul 07, 2022
Let's download a file (ContentVersion) from Salesforce using node-fetch

image post

Salesforce Apex method to get the country name by ISO Code

Convert ISO code into country name in Salesforce Apex
Jul 24, 2022
This method in Apex receives the country ISO code as string and returns the out of the box country name.

image post

Get Accounts with at least one closed-won opportunity in Salesforce

Salesforce SOQL query to get accounts with at least one closed won opportunity
Jul 24, 2022


image post

Invoke Apex method from Salesforce Flow Builder

Sometimes the out of the box functionality is not enough to automate all our processes
Aug 04, 2022
Flow Builder is the replacement of Process Builder in Salesforce. Both of them are useful to automate several kinds of process but sometimes the out of the box functionality is not enough