Excel Add-In for NetSuite

Build 25.0.9434

SubmitSoapRequest

Generates and stores table schema based on NetSuite Simple Object Access Protocol (SOAP) requests, aiding in data structure understanding.

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 simple object access protocol (SOAP) request. This must include the envelope, header, and body. Ensure it conforms to the NetSuite WSDL format.
SoapAction String The specific SOAP action to execute, such as search or getList. This must match the NetSuite operation name.
BaseXPath String The primary XPath for extracting key information like page size and total records. For instance, envelope, body, searchresponse, searchresult, recordlist, and record.
EntityXPath# String A list of XPaths for locating entities to extract. For instance, envelope, body, searchresponse, and searchresult. Separate multiple paths with commas, with 1 space after each comma.
ExceptionXPath# String A list of XPaths to check for error messages. For instance, envelope, body, searchresponse, searchresult, status, and statusdetail. Separate multiple paths with commas, with 1 space after each comma.

Result Set Columns

Name Type Description
ResponseSoap String The entire SOAP response. Only returned if both EntityXPath and ExceptionXPath are not provided. Includes headers and body.
* String Response values are dynamic and depend on the data found at the EntityXPath locations.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9434