Introduction

Enzo Server
  Installation
  Quick Start
  Core Features
    Async Calls
    ConnectionStrings
    Edge Cache
    HTTP Access
    Scheduling
    Views
  Advanced Capabilities
    Change Data Capture
  Administration
    Configuration Settings
    Logins & ACL
    Auditing
    Current Executions
    Linked Server
    SSL

  User Guides
     Sharding
     Sharding Overview

     SharePoint

   Adapters
    All Adapters
    ActiveCampaign
    Azure Bus
    Azure IoT Hub
    Azure Key Vault
    Azure Storage
    Bing Search
    ConstantContact
    Couchbase
    CSV
    DB (RDBMS)
    Dropbox
    Files
    Flight Aware
    FreshBooks
    FTP
    Geonames
    GoogleDrive
    GoogleSearch
    GoogleSheet
    GreenMile
    GpsInsight
    HttpEndpoint (REST)
    Intacct
    Insteon
    Loggly
    MailChimp
    Messaging (SMS/SMTP)
    MongoDB
    Motus
    MSAD
    MSMQ
    OneDrive
    OneDrive365 (Business)
    Pipeline
    Pressero
    RabbitMQ
    SalesForce
    Shard
    SharePoint
    Slack
    SQL Server
    SQLX
    Sudoku
    Teams
    Threading
    Twilio
    Twitter
    VellemanDMX
    Whiparound
    WMI
    Xls (Excel)
    ZIP


  SDK
    Overview
    Installation
    DevHost
    Create A Simple Adapter
    Handler Columns

    Advanced SDK Concepts
      Handler Decorators
      Dynamic Columns
      Table & Table Enumerators
      Virtual Tables

/adapters/salesforce




SalesForce


This adapter allows you to connect to SalesForce and access built-in and custom tables. Some of the methods allows you to obtain metadata from SalesForce objects.

One of the main capabilities of this adapter is to return recent changes from a specific timeframe. This allows you to build CDC solutions.


Configuration Settings



Name Description Default
Boolean _isDefault Make this the default configuration. Defaults to true if configName is already the default.
String userId The user Id for SalesForce
String password The password for the user id to use
String authenticationToken The SalesForce authentication token to use
Boolean useSandbox True/1 when logging against a SalesForce sandbox environment

Handlers



DeleteRaw Deletes one or more record in SalesForce based on an XML document using the record Id (must be provided) details 

Arguments

Name Description Default
table R The name of the SalesForce table to use
data R The raw data (XML) to use

SQL Call

exec bsc.SalesForce.DeleteRaw 'Account', '0051323039'
exec bsc.SalesForce.DeleteRaw 'Account', '00513230390051323040'


Http Call

/bsc/salesforce/deleteraw

Output Columns

String outcome
String message
GetAccounts Return a list of Accounts details 

Arguments


SQL Call

select top 10 * from SalesForce.Account


Http Call

/bsc/salesforce/getaccounts

Output Columns

String CreatedById
DateTime CreatedDate
String Description
String Id
String LastModifiedById
DateTime LastModifiedDate
DateTime LastReferencedDate
DateTime LastViewedDate
String OwnerId
DateTime SystemModstamp
String Type
GetCases Retrieve Case objects details 

Arguments


SQL Call

select * from SalesForce.Cases where Id = 'test'


Http Call

/bsc/salesforce/getcases

Output Columns

String CaseNumber
DateTime ClosedDate
String ContactId
String CreatedById
DateTime CreatedDate
String Description
String Id
String LastModifiedById
DateTime LastModifiedDate
String OwnerId
DateTime SystemModstamp
String Type
GetContacts Retrieve Contact objects details 

Arguments


SQL Call

select * from SalesForce.Contact where LastName = 'test'


Http Call

/bsc/salesforce/getcontacts

Output Columns

String FirstName
String Id
String LastName
DateTime SystemModstamp
GetSFDeletedObjects Retrieves the list of SalesForce object that were deleted within a specific timeframe details 

Arguments

Name Description Default
objectName R The name of the SalesForce object
startDate The range start date (max is 30 days ago)
endDate The range end date

SQL Call

SELECT * FROM SalesForce.SFDeletedObjects WHERE objectName = 'Account'


Http Call

/bsc/salesforce/getsfdeletedobjects

Output Columns

String Id
DateTime deletedDate
DateTime earliestDateAvailable
DateTime latestDateCovered
String objectName
DateTime startDate
DateTime endDate
GetSFMetadata Retrieves the list of SalesForce object fields details 

Arguments

Name Description Default
objectName R The name of the SalesForce object

SQL Call

SELECT * FROM SalesForce.SFMetadata WHERE objectName = 'Account'


Http Call

/bsc/salesforce/getsfmetadata

Output Columns

String name
String fieldType
String label
Boolean autonumber
Boolean custom
Boolean calculated
String calculatedFormula
Int32 length
String mask
String maskType
Boolean nameField
Int32 precision
Boolean unique
Int32 scale
String pickValues
String refFields
String objectName
GetSFObjects Retrieves the list of SalesForce objects details 

Arguments


SQL Call

SELECT * FROM SalesForce.SFObjects


Http Call

/bsc/salesforce/getsfobjects

Output Columns

String name
String label
String labelPlural
String keyPrefix
Boolean activateable
Boolean queryable
Boolean custom
Boolean deletable
Boolean createable
Boolean updateable
Boolean undeletable
Boolean triggerable
Boolean searchable
Boolean retrieveable
Boolean replicateable
Boolean mergeable
GetSFUpdatedObjects Retrieves the list of SalesForce object that were inserted or updated within a specific timeframe details 

Arguments

Name Description Default
objectName R The name of the SalesForce object
startDate The range start date (max is 30 days ago)
endDate The range end date

SQL Call

SELECT * FROM SalesForce.SFUpdatedObjects WHERE objectName = 'Account'


Http Call

/bsc/salesforce/getsfupdatedobjects

Output Columns

String Id
DateTime latestDateCovered
String objectName
DateTime startDate
DateTime endDate
GetTasks Retrive Task object details details 

Arguments


SQL Call

select * from SalesForce.Task where arg1 = 'test'


Http Call

/bsc/salesforce/gettasks

Output Columns

String CallType
String Description
String Id
String Status
String Subject
String WhatId
String WhoId
GetUsers Retrieve User object details details 

Arguments


SQL Call

select * from SalesForce.Users where arg1 = 'test'


Http Call

/bsc/salesforce/getusers

Output Columns

String Alias
String Email
String FirstName
String Id
String LastName
String Username
InsertRaw Inserts one or more record in SalesForce based on an XML document details 

Arguments

Name Description Default
table R The name of the SalesForce table to use
data R The raw data (XML) to use: or

SQL Call

exec bsc.SalesForce.InsertRaw 'Account', 'Customer A00001Yes'


Http Call

/bsc/salesforce/insertraw

Output Columns

String outcome
String message
Query Creates virtual tables based on a SOQL query details 

Arguments

Name Description Default
soql R SalesForce Object Query statement

SQL Call

exec bsc.SalesForce.Query 'select * from Account'


Http Call

/bsc/salesforce/query

Output Columns

This call does not return data.

UpdateRaw Updates one or more records in SalesForce based on an XML document using the record Id (must be provided) details 

Arguments

Name Description Default
table R The name of the SalesForce table to use
data R The raw data (XML) to use: or

SQL Call

exec bsc.SalesForce.UpdateRaw 'Account', '0051323039Customer A00001Yes'


Http Call

/bsc/salesforce/updateraw

Output Columns

String outcome
String message