ODBC Driver for Salesforce

Build 26.0.9770

Undelete

Restores records previously deleted and stored in Salesforce's Recycle Bin.

ストアドプロシージャ固有の情報

Salesforce のごみ箱からオブジェクトを復元するには、次の 3 つの方法があります。

  • 削除されたレコードの ID を指定する:
    EXEC Undelete Id = '1'
  • 削除されたレコードの ID リストを指定する:
    INSERT INTO Account#TEMP (ID) VALUES (1)
    INSERT INTO Account#TEMP (ID) VALUES (2)
    INSERT INTO Account#TEMP (ID) VALUES (3)
    EXEC Undelete Id = 'Account#TEMP'
  • XML 形式の ID リストを指定する:
    EXEC 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 unique identifier of the deleted object to restore. Required if XML is not provided.
XML String An XML-formatted list of object IDs to restore. Use this to undelete multiple records in a single request. Required if ID is not specified.

Result Set Columns

Name Type Description
Success String Indicates whether the undelete operation was successful (true) or not (false).
ID String The ID or IDs of the objects that were successfully restored.

Copyright (c) 2026 CData Software, Inc. - All rights reserved.
Build 26.0.9770