ODBC Driver for Salesforce

Build 24.0.9029

Undelete

Restores from Salesforce's RecycleBin a deleted record.

Procedure-Specific Information

To restore an object from Salesforce's recycle bin you need to use one of the following examples:

1. By specifying the Id of the deleted record.


EXECUTE Undelete Id = '1'

2. By specifying a list of deleted record Ids.


INSERT INTO Account#TEMP (ID) VALUES (1)
INSERT INTO Account#TEMP (ID) VALUES (2)
INSERT INTO Account#TEMP (ID) VALUES (3)

EXECUTE Undelete Id = 'Account#TEMP'

3. By specifying a list of Ids that are XML formatted.


EXECUTE Undelete XML = '<undelete xmlns="urn:enterprise.soap.sforce.com"> <ids>1</ids> <ids>2</ids> <ids>3</ids> </undelete>'

Input

Name Type Description
ID String The Id of the object that has been deleted. This or XML input are required.
XML String List of ids formatted in XML. This or ID input are required.

Result Set Columns

Name Type Description
Success String Returns true if the object is restored successfully.
ID String The Id of the restored object/s, if the operation is successful.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9029