Invoke Stored Procedure

POST {{base_url}}/Utilities/InvokeCustom/:SPName

NOTE: Contact a Deltek consultant for further assistance.

Use this endpoint to call the custom stored procedure you created. You must build the stored procedure to enforce the desired security. Valid parameters for the POST request JSON body will vary depending on what fields you specify.

Specify the name of your custom stored procedure according to the following naming convention and prerequisites.
* The stored procedure name must begin with the prefix “DeltekStoredProc” in the database. * The endpoint uses the variable SPName which only takes the portion of the stored procedure name after “DeltekStoredProc”.

More importantly, a call to this endpoint will always return a response in XML format.

Request Params

Request Body

{"status"=>"active"}

HEADERS

The type of content supported by the API endpoint. | | Authorization | string | | Required.

The type of authorization supported by the API endpoint. |

RESPONSES

status: OK

"XML = '\u003c?xml version=\"1.0\"?\u003e\r\n \u003cResults\u003e\r\n   \u003cSampleList\u003e\r\n     \u003cSampleid\u003e1\u003c/Sampleid\u003e\r\n     \u003cFirstname\u003eName\u003c/Firstname\u003e\r\n     \u003cLastname\u003eLastName\u003c/Lastname\u003e\r\n     \u003cEmail\u003eemail@company\u003c/Email\u003e\r\n   \u003c/SampleList\u003e\r\n   \u003cSampleList\u003e\r\n     \u003cSampleid\u003e2\u003c/Sampleid\u003e\r\n     \u003cFirstname\u003eName2\u003c/Firstname\u003e\r\n     \u003cLastname\u003eLastName2\u003c/Lastname\u003e\r\n     \u003cEmail\u003eemail@email.com\u003c/Email\u003e\r\n   \u003c/SampleList\u003e\r\n   \u003cSampleList\u003e\r\n     \u003cSampleid\u003e3\u003c/Sampleid\u003e\r\n     \u003cFirstname\u003eName3\u003c/Firstname\u003e\r\n     \u003cLastname\u003eLastName3\u003c/Lastname\u003e\r\n     \u003cEmail\u003ecompany@company.com\u003c/Email\u003e\r\n   \u003c/SampleList\u003e\r\n \u003c/Results\u003e"