To delete a record, use HTTP DELETE or the POST request with the custom X-HTTP-Method header value of DELETE. Supply the primary key of the record to delete. The following screen shows using an HTTP DELETE request in Postman to delete a record from a Salesforce data store.

To formulate the request:

  • The Content-Type header value is application/json.
  • The resource URL includes:
    • The service root, <myserver>:<port>/api/odata4.
    • The Data Source definition name, sfds.
    • The plural entity name, ACCOUNTS followed by the primary key.
  • The body of the request is empty.
The following screen shows the result of executing the request. The Status of 204 No Content indicates that the record was successfully deleted.
Hybrid Data Pipeline OData - Example account deletion