Node-RED for Salesforce

I happened across Node-RED last week while prepping for a topcoder challenge and became obsessed with it. If you are not familiar with it, Node-RED is an open source IBM technology for “wiring together hardware devices, APIs and online services in new and interesting ways”. Since Node-RED is built on Node.js, this makes it ideal to run at the edge of the network on low-cost hardware such as an Arduino or Raspberry Pi as well as in the cloud. There are even a couple of Heroku Buttons to get you started however local installation is a snap.

See yesterday's post on Node-RED for Topcoder Challenges with IBM Bluemix & Watson for a complete walkthrough.

Naturally I wanted to see how I could connect Node-RED to Salesforce so I poked around the internetwebs for awhile. I found some work done by my buddy Reid Carlberg with Push Topics but that was about it. Flabbergast, I decided to write some Salesforce nodes over the weekend.

The code is available on github at node-red-contrib-salesforce and installs as an npm package.

The nodes are easy to install and once you've set up your Connected App it's a breeze to get going. The following nodes are available:

  • SOQL - Executes a SOQL query.
  • SOSL - Executes a SOSL query.
  • DML - Executes an insert, update, upsert or delete DML statement.