SalesForce Adapter

This adapter allows you to access SalesForce data and changes from SQL Server directly, and through REST commands.

This adapter requires a SalesForce account to be configured

Want to try it in Azure? Click here to learn more or click here to create a new Enzo Server RTM 3.1 Azure VM now.

Want to try it in AWS? Click here to learn more or click here to create a new Enzo Server RTM 3.1 AWS VM now.

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

BLOGS AND VIDEOS

IN THE NEWS

OTHER

SalesForce Adapter

Configuration Settings

Handlers

Arguments

SQL Call

Http Call

Output Columns

Arguments

SQL Call

Http Call

Output Columns

Arguments

SQL Call

Http Call

Output Columns

Arguments

SQL Call

Http Call

Output Columns

Arguments

SQL Call

Http Call

Output Columns

Arguments

SQL Call

Http Call

Output Columns

Arguments

SQL Call

Http Call

Output Columns

Arguments

SQL Call

Http Call

Output Columns

Arguments

SQL Call

Http Call

Output Columns

Arguments

SQL Call

Http Call

Output Columns

Arguments

SQL Call

Http Call

Output Columns

Arguments

SQL Call

Http Call

Output Columns

Arguments

SQL Call

Http Call

Output Columns

PLATFORM

SOLUTIONS

RESOURCES

COMPANY