[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 Xplenty 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] Xplenty 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] Xplenty 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 Xplenty 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.