ExecuteSOAPOperation
Sends a request to directly invoke a SOAP operation.
Stored Procedure-Specific Information
To execute this procedure, set Service to the name of the Workday SOAP service (for example, Human_Resources) and Request to the full XML payload for the operation.Enter:
EXEC ExecuteSOAPOperation Service='Human_Resources', Request='<bsvc:Get_Workers_Request bsvc:version="v46.1" xmlns:bsvc="urn:com.workday/bsvc"><bsvc:Response_Filter><bsvc:As_Of_Effective_Date>2000-01-01</bsvc:As_Of_Effective_Date><bsvc:As_Of_Entry_DateTime>2000-01-01T00:00:00-05:00</bsvc:As_Of_Entry_DateTime></bsvc:Response_Filter></bsvc:Get_Workers_Request>'
Input
| Name | Type | Description |
| Service | String | Name of the Workday SOAP service being called. |
| Request | String | The XML request payload sent to the SOAP API. |
Result Set Columns
| Name | Type | Description |
| Response | String | The XML response body from the SOAP API, or NULL if an error occurred. |
| FaultCode | String | SOAP error code if an error occurred, otherwise NULL. |
| FaultString | String | SOAP error message if an error occurred, otherwise NULL. |