• Usage
• Syntax
• Basic Examples 
• Adding Additional Columns to the Table 

Usage

You can use SF_ConvertLeads to convert lead records to accounts/contacts/opportunities.  SF_ConvertLeads takes as input a local SQL Server table you create called the Input table. At a minimum, the Input table must have the following columns: 

 CREATE TABLE [dbo].[LeadConvert](  

 [LeadID] [nvarchar](18) NULL,  

 [convertedStatus] [nvarchar](255) NULL,  

 [Error] [nvarchar](512) NULL,  

 [AccountID] [nvarchar](18) NULL,  

 [OpportunityID] [nvarchar](18) NULL,  

 [ContactID] [nvarchar](18) NULL  

  ) ON [PRIMARY]  

Make sure to examine the Error column in the Result table after running the command to look for possible errors. 

Syntax

 EXEC SF_ConvertLeads 𝘭𝘪𝘯𝘬𝘦𝘥_𝘴𝘦𝘳𝘷𝘦𝘳, load_SQL_Table, options  

where 

• linked_server—the linked server name. 

• load_SQL_Table—input table

• options—options for SF_ConvertLeads

Basic Examples 

 Exec SF_ConvertLeads 'SALESFORCE', 'LeadConvert' 

 Exec SF_ConvertLeads 'SALESFORCE', 'LeadConvert', 'ignorefailures(50)' 

Adding Additional Columns to the Table 

You can add additional columns to the table. The table below lists these additional columns, their data types, and gives a brief description of each.