The following samples will help you to get started with using Salesforce and Linx for data migration, integration and process automation. Please note that the Linx samples are built using Linx version 5.20.2.0 and Salesforce version v50.0.
- Create a new job that specifies the object and action.
- Send data to the server.
- Once all data has been submitted, close the job. Once closed, no more batches can be sent as part of the job.
- Check status.
- Save the result sets with the original data set in a file, to determine which records failed and succeeded.
-
Authenticating Salesforce using OAuth 2.0
- Parameters - Consumer Key, Consumer Secret, Base URI
- Result - Access Token
-
SoQL Query
- Parameters - query, access_url, token
- Result – RESTEndpoint.ResponseBody as String
-
Data - Create, Delete, Update, Query All, Query by ID
- Parameter - sObject Name
- Result - RESTEndpoint.ResponseBody as string
-
Bulk data process
Covers step for creating a job, adding data to job, get status, verifying its status and closing the job
- AddDataToJob
- Parameters – action, body, instance_url, token, object
- Result – Linx type - batchJobInfo
- CloseJob
- Parameters – instance_url, token, query, JobId
- Result – RESTEndpoint.Status.code
- CreateJob
- Parameters – action, body, instance_url, token, object
- Result – RESTEndpoint.ResponseBody
- GetJobStatus
- Parameters - instance_url, token, JobId
- Result – RESTEndpoint.ResponseBody
- VerifyJobStatus
- Parameters - instance_url, token, JobId
- Result – RESTEndpoint.ResponseBody
- AddDataToJob
-
Authenticating GoogleSheets using OAuth 2.0
- Parameters - Consumer Key, Consumer Secret, Base URI
- Result - Authentication Code
- GoogleSheets
- GetToken - Reads token saved in file generated in Authenticating GoogleSheets using OAuth 2.0
- Salesforce
- GetAccessTokenAndInstanceURL - Reads Access Token and Instance url from file generated in Authenticating Salesforce using OAuth 2.0
This template integrates Excel data with Salesforce to ensure that while users continue capturing leads using their preferred tool. This template serves as a foundation for creating Leads in Salesforce as Leads are updated and created in Excel Sheet.
Business today demands up-to-the-minute data. Latency requirements are shrinking at the same time. Sales use different tools to capture various information easily and quickly. This template integrates GoogleSheet data with Salesforce to ensure that users continue capturing leads using their preferred tool. This template serves as a foundation for creating Leads in Salesforce as Leads are updated and created in GoogleSheet. This integration saves time by copying and pasting data from Googlesheet into Salesforce.
Migrating data to and from Salesforce can be challenging due to data inconsistencies, invalid mapping, or improper formatting. This template synchronizes products data between Salesforce and a database system like SQL Server. Download CreateProductTable.sql and run the script. This template makes it fast to configure the fields to be synchronized, how they map, and criteria on when to trigger the synchronization. This template imports products from the existing database into Salesforce and updates the product table in SQL Server with the salesforce ID.
The movement of large quantities of data is necessary during daily data sync. This template upload account records that are stored in CSV format to Salesforce. Download Bulk API Sample Contact Data.csv. It uses the Bulk Api from Salesforce. It also verifies the job status and writes the result to a log file.
- Click on RUN in AuthorizationOAuthTemplate and start
- In Browser - Navigate to base_uri/oauth/authorize
- instance url saved in c:\temp\instance_url
- access token saved in c:\temp\access_token
- The above paths can be changed inside the function.
- Click on RUN in GoogleSheetOAuthTemplate and start
- In Browser - Navigate to base_uri/oauth/authorize
- instance url saved in c:\temp\google\instance_url
- access token saved in c:\temp\google\access_token
- The above paths can be changed inside the function.
- CreateBulkJobTemplate - State : open
- CloseJob - State : UploadComplete
- VerifyJobStatus - Get the state of the job in batch at a particular time after UploadComplete
- GetJobStatus - Once a job has been completed and is in the JobComplete state (or Failed state), you can get details of which job data records were successfully processed
- Parameter - Google SpreadSheet ID
- Result - Google Spreadsheet
Serves to delete all Leads in Salesforce. This is useful to avoid duplicating data when running sample tests.
To generate sample file and data, or simply download Lead.xlsx for use in Automate lead management with Excel.
A sample to retrieve metadata for an object
- Salesforce-Linx integration guide
- Salesforce API authentication documentation
- GoogleSheet-Linx integration guide
- https://github.com/linx-software/salesforce#setting-up-the-sample
- https://github.com/linx-software/google-drive-file-management#setting-up-the-sample
For questions please ask the Linx community or use the Slack channel.