SubmitSoapRequest
Creates the schema for the tables specified. Saves the schema at the location set by the Location connection property.
Note: This procedure makes use of indexed parameters. Indexed parameters facilitate providing multiple instances a single parameter as inputs for the procedure.
Suppose there is an input parameter named Param#. To input multiple instances of an indexed parameter like this, execute:
EXEC ProcedureName Param#1 = "value1", Param#2 = "value2", Param#3 = "value3"
In the table below, indexed parameters are denoted with a '#' character at the end of their names.
Input
Name | Type | Description |
SoapRequest | String | The complete SOAP request. This must include the envelope, header, and body. |
SoapAction | String | The SOAP action to take. For instance, search. |
BaseXPath | String | An XPath for pushing globally useful information such as page size and total records. For instance, /envelope/body/searchresponse/searchresult/recordlist/record. |
EntityXPath# | String | A list of XPaths to entities that should be pushed on. For instance, /envelope/body/searchresponse/searchresult/. |
ExceptionXPath# | String | A list of XPaths to exception messages to throw if found. For instance, /envelope/body/searchresponse/searchresult/status/statusdetail. |
Result Set Columns
Name | Type | Description |
ResponseSoap | String | The full SOAP response. This will only return if both EntityXPath and ExceptionXPath are not input. |
* | String | Response values may vary depending on what is contained at the EntityXPath. |