Qlik Community

Knowledge

Search or browse our knowledge base to find answers to your questions ranging from account questions to troubleshooting error messages. The content is curated and updated by our global Support team

Announcements
Support Case Portal has moved to Qlik Community! Read the FAQs to start exploring Support resources.

Salesforce - How to get started with Salesforce in Automations

PradeepUrala
Support
Support

Salesforce - How to get started with Salesforce in Automations

This article helps the users of Qlik Application Automation to understand the different functionalities of the Salesforce connector.

The Salesforce connector supports the generic CRUD operations that can be performed on the Salesforce application, such as:

  • API LIST Recently Deleted Records Incrementally
  • API LIST Recently Created and Updated Records Incrementally
  • API LIST Records Incrementally
  • API GET Record By Id
  • API GET Record By External Id
  • API CREATE Record
  • API UPDATE Record
  • API UPSERT Record By External ID
  • API DELETE Record By Id
  • Custom Query
  • Custom Query (All)

Refer to this page for more information on the usage of the Generic Blocks.

Apart from the above blocks, Salesforce also has functionality for Bulk operations. With Bulk API 2.0 (Jobs), you can insert, update, upsert, or delete large data sets by preparing a comma-separated value (CSV) file. Below is a list of available blocks for these operations.

  • Create Bulk Upload Job
  • Upload Job Data
  • Get Upload Job Information
  • Close Or Abort Upload Job
  • Get Upload Job Successful Record Results
  • Get Upload Job Failed Record Results
  • Get Upload Job Unprocessed Records Results
  • List Upload Jobs

Refer to this page for more information on the usage of the Upload Jobs.

 

Authentication for this connector is based on the oAuth2 Protocol. For more details on Authenticating to Salesforce, check this article.

 

Now, let's go through a basic use case to retrieve all the Object Types from the Salesforce organization

  1. Create an automation
  2. From the left menu, search for the Salesforce connector
    BasicInfo_1.PNG

     



  3. After selecting the Salesforce connector, Use the 'Search for blocks' input to search for the 'List Object Types' block.
    BasicInfo_2.PNG

     

  4. Drag and drop the block into the automation and link it to the start block. Connect to Salesforce.
    BasicInfo_3.PNG

     

  5. Run the automation. This will output a paginated list of Object Types available.

     

     

     

Tags (1)
Labels (1)
Version history
Revision #:
3 of 3
Last update:
‎2021-09-06 11:08 AM
Updated by:
 
Contributors