SOAP Web services can be used for extracting account details from the NetSuite account. We need to define the SOAP request with the body to fetch the data. With the SOAP request, we can directly fetch the data from the NetSuite. SOAP is a standard NetSuite API.
Following are the process for the Account Details Bulk extraction:
- ACCOUNT_SEARCH – extract all account internal ids using the ACCOUNT_SEARCH SOAP Request. The response result page size is 1000. The soap operation is search.
- SEARCH_MORE_PAGE – Send the SEARCH_MORE_PAGE request if the ACCOUNT_SEARCH response has multiple pages. Search id for the request will be fetched from the initial request(ACCOUNT_SEARCH ) response. Multiple calls needed for the request which depend on pagesize.
The postman collection screenshot is below:
The sample Body for the request is below:
<soapenv:Envelope
xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/"
xmlns:urn="urn:messages_2021_2.platform.webservices.netsuite.com"
xmlns:urn1="urn:core_2021_2.platform.webservices.netsuite.com"
xmlns:listRel="urn:relationships_2021_2.lists.webservices.netsuite.com"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<soapenv:Header>
<urn:preferences></urn:preferences>
<urn:partnerInfo></urn:partnerInfo>
<urn:tokenPassport>
<urn1:account>{{ACCOUNT_ID}}</urn1:account>
<urn1:consumerKey>{{CONSUMER_KEY}}</urn1:consumerKey>
<urn1:token>{{TOKEN_ID}}</urn1:token>
<urn1:nonce>{{nonce}}</urn1:nonce>
<urn1:timestamp>{{timestamp}}</urn1:timestamp>
<urn1:signature algorithm="HMAC-SHA256">{{signature}}</urn1:signature>
</urn:tokenPassport>
</soapenv:Header>
<soapenv:Body>
<search
xmlns="urn:messages_2021_2.platform.webservices.netsu ite.com">
<searchRecord xsi:type="ns9:AccountSearchBasic"
xmlns:ns9="urn:common_2021_2.platform.webservices.netsuite.com">
<ns9:isInactive xsi:type="ns12:SearchBooleanField"
xmlns:ns12="urn:core_2021_2.platform.webservices.netsuite.com">
<ns12:searchValue xsi:type="xsd:boolean">false</ns12:searchValue>
</ns9:isInactive>
</searchRecord>
</search>
</soapenv:Body>
</soapenv:Envelope>