SSIS Components for NetSuite

Build 24.0.9060

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.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060