LogoLogo
About
  • Home
  • Guides
  • BDK
  • REST API
  • Release Notes
  • Airtable
    • Fetching Airtable Data
    • Creating and Modifying Airtable Records
    • Creating Airtable Reports
    • Exporting Airtable Reports
    • File Management
    • Submit Airtable Records for Approval
  • AWS S3
    • Listing Files
    • Retrieving Files
    • Uploading Files
    • Uploading CSV
    • Uploading Strings
    • Deleting Files
    • Deleting CSV
  • Azure Blob Storage
    • Uploading Files
    • Retrieving Files
  • Azure Service Bus
    • Sending Messages to Azure Service Bus Queue
    • Receiving Messages from Azure Service Bus Queue
  • Azure Translate
    • Translating A Document
  • Database
    • Retrieving Database Records
    • Updating Database Records
    • Creating Database Records
    • Deleting Database Records
  • Document Processing
    • Document Processing: Workflow Patterns and Best Practices
    • Document Processing with OCR
    • Extract Data from a Document
    • Extract Pages from a Document
    • Extract Tables from a Document
    • Extract a Subdocument
    • Extract Subdocuments
    • Getting Fields from a Document
    • Getting Tables from a Document
  • Google Cloud Storage
    • Dumping Files to Google Cloud Storage
    • Purging Files from Google Cloud Storage
    • Dumping CSVs to Google Cloud Storage
    • Purging CSVs from Google Cloud Storage
    • Enriching Questions
  • HTML
    • Extracting Tables from HTML
  • HTTP
    • GET Request
    • POST Request
    • DELETE Request
    • PATCH Request
    • PUT Request
    • HEAD Request
  • Hubspot
    • Fetching Data from Hubspot
  • Microsoft Excel
    • Opening Excel Files
    • Converting a File to Excel Format
    • Getting a Table from Excel
    • Converting Tables to Excel Workbooks
    • Renaming Excel Files
    • Creating a Merged Spreadsheet from Multiple Files
    • Getting an Excel Worksheet's Row
    • Getting an Excel Worksheet's Row's Cell
    • Getting an Excel Worksheet Cell's Column Label
    • Setting an Excel Worksheet Cell to a String
    • Getting an Excel Worksheet's Changelog
    • Apply Changelogs to an Excel Worksheet
    • Saving An Excel Worksheet
  • Microsoft Outlook
    • Email Operations
    • Getting Schedules
    • Moving Emails
  • Microsoft Power BI
    • Working with Power BI Objects
  • Microsoft SharePoint
    • Retrieving SharePoint Items
    • Uploading a File to SharePoint
    • Converting Data to SharePoint String
    • Moving a File to a Folder
    • Deleting a Folder
    • Getting a Folder
    • Uploading a String to a Folder
    • Creating and Retrieving a Folder
    • Deleting a File
  • Oracle Cloud Fusion
    • Fetching Data from Oracle Cloud Fusion
    • Adding New Records
    • Updating Records
    • Deleting Oracle Fusion Objects
    • Managing Attachments
    • Downloading Files from Oracle Fusion Objects
    • Detaching Files from Oracle Fusion Objects
  • Paycom
    • Working with Employee Details
    • Managing Punch Entries
  • Salesforce
    • Working with Salesforce Objects
    • Submitting Sales Objects for Approval
    • Creating Salesforce Reports
    • File Management
  • Servicenow
    • Retrieving Data
    • Manipulating Data
  • Slack
    • Sending Slack Messages
    • Reading Slack Messages
  • Stripe Pay
    • Fetch Data from Stripe
    • Add New Records
    • Working with Invoices
    • Deleting Objects from Stripe
  • Zendesk
    • Creating a Ticket
    • Updating a Ticket
    • Assigning a Ticket
    • Deleting a Ticket
    • Getting a Ticket
Powered by GitBook
On this page
  • Overview
  • Fetching Data using custom SQL queries
  • Fetching Data using Direct Queries
  • Creating and Modifying Salesforce Objects
  • Adding New Records
  • Updating Existing Records
  • Deleting Salesforce Objects
  • Creating a new lead in Salesforce

Was this helpful?

Export as PDF
  1. Salesforce

Working with Salesforce Objects

Overview

Interacting with Salesforce objects is a core functionality when integrating Salesforce with Kognitos. This section covers how to fetch data, create and modify Salesforce objects, and delete them when necessary.

Fetching Data using custom SQL queries

To fetch data from Salesforce using custom SQL queries:

 fetch the records from salesforce where
      the query is "SELECT Id, Email FROM Contact"

Fetching Data using Direct Queries

To fetch data from Salesforce using direct queries:

get salesforce's leads whose annual revenue is less than 1000000000

Creating and Modifying Salesforce Objects

Adding New Records

To add a new record to Salesforce, you need to specify the type of object you're creating and provide the necessary field values. Example:

the opportunity is
    the name is "New Deal"
    the close date is "2023-12-31"
    the stage is "Prospecting"
add the opportunity in salesforce

This creates a new opportunity named "New Deal" with a close date and stage specified.

Updating Existing Records

To update an existing Salesforce object, you must identify the object by its ID and specify the fields you want to update. Example:

the opportunity's ID is "006xx000001Sv6aAAC"
change the opportunity's stage to "Closed Won" in salesforce

This updates the stage of the specified opportunity to "Closed Won".

Deleting Salesforce Objects

Single Deletion

To delete a specific Salesforce object, you need to specify the object and its ID.

Example:

the salesobject's ID is "006xx000001Sv6aAAC"
delete the salesobject

This command deletes the sales object with the specified ID.

Creating a new lead in Salesforce

To create a new lead in Salesforce:

Create a lead in salesforce with
  the lead status is "New"
  the last name is "Hackmann Test"
  the company is the lead company
  the email is the lead email
  the lead source is "Other Campaigns"

Last updated 1 month ago

Was this helpful?