In this short and engaging video, Integrate.io Technical Success Engineer Ellie Mary Finley walks through the process of extracting data from Intercom into Salesforce. Finley guides Salesforce developers step-by-step through the Integrate.io interface, outlining everything users need to know to establish a connection quickly and easily. She goes on to describe how to validate a data package and set up a schedule for new data to upload from Intercom into Salesforce on a regular basis.
This tutorial is helpful viewing for Salesforce developers new to the Integrate.io interface, or those in need of a quick refresher. Any Salesforce user who wants to extract data using a rest API component into Salesforce will find Finley's talk useful and easy to follow. Keep it on hand whenever you need to create a new connection, establish a data package, validate a data package, or set up scheduling for the integration of new data.
[00:00:00] In this tutorial, I'm going to walk you through extracting data from Intercom using our rest API source component and loading it into your Salesforce instance. The first step is to create our connections to Intercom in Salesforce.
[00:00:32] They're both native connectors, so the only thing you have to do to get these connections set up is click authenticate and then allow Integrate.io access.
[00:00:53] Now we can create our package. We're going to use a blank data flow.
[00:01:02] The first component we'll create is the rest API source component. We're going to use this to load in the Intercom data using the Intercom connection we already created.
[00:01:22] Integrate.io will handle the authentication, so we just need to put in the method URL and any headers that are necessary.
[00:01:44] I'm going to edit the API call so that instead of grabbing all of the companies, I'll only grab ones that were created after a specific time.
[00:02:02] Integrate.io can parse JSON for us so we can edit the JSON path to get directly to the company data that we're interested in using.
[00:02:15] For creating accounts in Salesforce, I'm just going to need the Intercom ID and the name of the company.
[00:02:27] For this data flow, we don't need any transformation between Intercom and Salesforce, so we can connect to the Salesforce destination.
[00:02:42] Here I specify that I want to create new accounts using insert only. In the final step in the Salesforce destination component, I mapped the fields from Integrate.io to the field names in Salesforce.
[00:03:00] Next, we validate the package and then we run it.
[00:03:20] Now that the packages run successfully, we can take a look at how many records were updated as well as what the package variables evaluated to. The job submission timestamp captures the time that the job was submitted for execution. The next time that this package runs, that timestamp will be saved as a new variable called "package last successful job submission time".
[00:03:49] We can use this package variable to implement incremental loading in our package. In our package, we'll edit the user package variables to include that timestamp for the last time that the job successfully ran.
[00:04:09] Now we can use that variable in the Intercom API call to limit the results to companies that have been created since the last time we successfully ran this package.
[00:04:31] After we validate our package, we're ready to set up scheduling.
[00:04:38] We'll create a schedule that runs once a day and it will incrementally load any new companies from Intercom into Salesforce.
[00:05:07] Now that you've got your schedule up and running, you can count on your data to get incrementally loaded into your Salesforce instance every day.