Salesforce API limits can prevent you from using Salesforce data at scale in your other public web projects. As a Salesforce customer, you only get 1,000 api calls per user per 24h period when you use the Salesforce APIs directly.

This article will show you how to get around that by using the open-source Hasura GraphQL engine in front of Salesforce to maximize developer happiness and data throughput.

Overview

We will create a GraphQL API for Salesforce using Heroku and the open-source version of Hasura. You need access to Heroku and Salesforce to make this work.

The following steps will take you between 10-30 minutes depending on your skill level.

Step 1: Launch a new Hasura Heroku instance

Time Required: 2 minutes

This is the fastest way to getting everything configured because the people at Hasura already prepared a heroku deploy button based on their docker images!

Click this link to deploy the app to Heroku:
https://heroku.com/deploy?template=https://github.com/hasura/graphql-engine-heroku

Just pick name and click “Deploy”:

Launch a new Hasura Heroku instance

Step 2: Heroku Connect

Time Required: 5–10 minutes

The Heroku marketplace has an add-on called “Heroku Connect” (Salesforce acquired the company that offers this app, so it is officially supported and sold by Salesforce). The free level of Heroku Connect allows for 10,000 records which has enough space for many use cases. The paid levels don’t have prices listed, but they’re about $4k/mo from the recent deals I’ve seen done.

plans and pricing

“enterprise” means you need to talk to *humans* to get the prices 🙂

Add the free version:
In your app, click the “Resources” tab at the top, then search and add “Heroku Connect”:

heroku resources
heroku free edition

After the add-on is installed you will connect (OAuth) to your Salesforce instance and select a table to synchronize. It’s self-explanatory for many users, but the official trailhead has explicit steps if you need them: https://trailhead.salesforce.com/content/learn/projects/develop-heroku-applications/set-up-heroku-connect#create-heroku-mappings

In my example I mapped a custom object in Salesforce called “Content__c”:

Table mapping example in Heroku

Table mapping example in Heroku

Do NOT enable “Database -> Salesforce” unless you understand the consequences!

Step 3: Hasura Table Tracking

Time Required: 5 minutes

The last step is to tell Hasura to expose our newly mapped table!

Load the Heroku Hasura app in your browser, click “Data” at the top, switch the schema to “Salesforce” and then click “track” next to your object:

Large, vibrantly colored arrows on a screenshot, how condescending!

With the table “tracked” we can now query it from GraphQL, our setup is done!

Use the API

Switch back to the “GraphQL” tab, select your object in the left panel named “explorer” and execute live queries of your salesforce data:

This UI shown above is just a wrapper on top of the GraphQL APIs that are provided, which means that integrating into existing projects is a snap:

Integration into project

You now have a scalable API: Your limits on this setup are probably closer to 1k requests per second instead of 1k per day (the salesforce limit). And even better, your developers can use GraphQL!

This post is part of a series on how to leverage your existing Salesforce data in external tools: https://cloudanswers.com/build-fast-static-sites-with-salesforce-and-netlify/ 

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

%d bloggers like this: