Converting Leads
Converting Leads
Using SF_ConvertLeads to Extract Information on Leads
You can use SF_ConvertLeads
to convert lead records to accounts, contacts, or opportunities.
First, create a table to hold the information needed for the conversion. At a minimum the table must have the following columns:
CREATE TABLE [dbo].[LeadConvert](
[LeadID] [nchar](18) NULL,
[convertedStatus] [nvarchar](255) NULL,
[Error] [nvarchar](512) NULL,
[AccountID] [nchar](18) NULL,
[OpportunityID] [nchar](18) NULL,
[ContactID] [nchar](18) NULL
) ON [PRIMARY]
Basic Examples
EXEC SF_ConvertLeads 'SALESFORCE', 'LeadConvert'
EXEC SF_ConvertLeads 'SALESFORCE', 'LeadConvert', 'ignorefailures(50)'
Be sure to examine the Errorcolumn in the Result table after running the command to look for possible errors.
See SF_ConvertLeads for more information.