SOAP Web service – search operation

SOAP Action – search

Scenario: Perform transaction search using soap web service

Request

<soapenv:Envelope
    xmlns:xsd='http://www.w3.org/2001/XMLSchema'
    xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance'
    xmlns:soapenv='http://schemas.xmlsoap.org/soap/envelope/'
    xmlns:platformCore='urn:core_2021_2.platform.webservices.netsuite.com'
    xmlns:listRel='urn:relationships_2021_2.lists.webservices.netsuite.com'
    xmlns:listAcct='urn:accounting_2021_2.lists.webservices.netsuite.com'
    xmlns:platformMsgs='urn:messages_2021_2.platform.webservices.netsuite.com'>
    <soapenv:Header>
        <tokenPassport xsi:type='platformCore:TokenPassport'>
            <account xsi:type='xsd:string'>{{accountId}}</account>
            <consumerKey xsi:type='xsd:string'>{{consumerKey}}</consumerKey>
            <token xsi:type='xsd:string'>{{tokenId}}</token>
            <nonce xsi:type='xsd:string'>{{nonce}}</nonce>
            <timestamp xsi:type='xsd:long'>{{timestamp}}</timestamp>
            <signature algorithm='HMAC_SHA256' xsi:type='platformCore:TokenPassportSignature'>{{signature}}</signature>
        </tokenPassport>
    </soapenv:Header>
    <soapenv:Body>
         <search xsi:type='platformMsgs:SearchRequest'>
            <searchRecord xsi:type='tranSales:TransactionSearch'>
                <basic xsi:type='platformCommon:TransactionSearchBasic'>
                    <entity operator='anyOf' xsi:type='platformCore:SearchMultiSelectField'>
                        <searchValue xsi:type='platformCore:RecordRef' internalId='3' type='customer'></searchValue>
                    </entity>
                </basic>
            </searchRecord>
        </search>
    </soapenv:Body>
</soapenv:Envelope>
   

Response

<?xml version="1.0" encoding="UTF-8"?>
<soapenv:Envelope
    xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/"
    xmlns:xsd="http://www.w3.org/2001/XMLSchema"
    xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
    <soapenv:Header>
        <platformMsgs:documentInfo
            xmlns:platformMsgs="urn:messages_2021_2.platform.webservices.netsuite.com">
            <platformMsgs:nsId>WEBSERVICES_TSTDRV2779698_0730202314397669211388525464_bdb0b</platformMsgs:nsId>
        </platformMsgs:documentInfo>
    </soapenv:Header>
    <soapenv:Body>
        <searchResponse
            xmlns="">
            <platformCore:searchResult
                xmlns:platformCore="urn:core_2021_2.platform.webservices.netsuite.com">
                <platformCore:status isSuccess="true"/>
                <platformCore:totalRecords>1</platformCore:totalRecords>
                <platformCore:pageSize>1000</platformCore:pageSize>
                <platformCore:totalPages>1</platformCore:totalPages>
                <platformCore:pageIndex>1</platformCore:pageIndex>
                <platformCore:searchId>WEBSERVICES_TSTDRV2779698_0730202314397669211388525464_bdb0b</platformCore:searchId>
                <platformCore:recordList>
                    <platformCore:record internalId="2" xsi:type="tranSales:SalesOrder"
                        xmlns:tranSales="urn:sales_2021_2.transactions.webservices.netsuite.com">
                        <tranSales:createdDate>2023-07-27T23:51:27.000-07:00</tranSales:createdDate>
                        <tranSales:entity internalId="3">
                            <platformCore:name>1 Anonymous</platformCore:name>
                        </tranSales:entity>
                        <tranSales:tranDate>2023-07-27T00:00:00.000-07:00</tranSales:tranDate>
                        <tranSales:tranId>2</tranSales:tranId>
                        <tranSales:nextBill>2023-07-27T00:00:00.000-07:00</tranSales:nextBill>
                        <tranSales:salesEffectiveDate>2023-07-27T00:00:00.000-07:00</tranSales:salesEffectiveDate>
                        <tranSales:excludeCommission>false</tranSales:excludeCommission>
                        <tranSales:isTaxable>false</tranSales:isTaxable>
                        <tranSales:taxItem internalId="-7">
                            <platformCore:name>-Not Taxable-</platformCore:name>
                        </tranSales:taxItem>
                        <tranSales:taxRate>0.0</tranSales:taxRate>
                        <tranSales:toBePrinted>false</tranSales:toBePrinted>
                        <tranSales:toBeEmailed>false</tranSales:toBeEmailed>
                        <tranSales:toBeFaxed>false</tranSales:toBeFaxed>
                        <tranSales:billingAddress
                            xmlns:platformCommon="urn:common_2021_2.platform.webservices.netsuite.com">
                            <platformCommon:internalId>14</platformCommon:internalId>
                            <platformCommon:country>_unitedStates</platformCommon:country>
                            <platformCommon:addressee>Anonymous</platformCommon:addressee>
                            <platformCommon:addrText>Anonymous<br>United States</platformCommon:addrText>
                            <platformCommon:override>false</platformCommon:override>
                        </tranSales:billingAddress>
                        <tranSales:shippingAddress
                            xmlns:platformCommon="urn:common_2021_2.platform.webservices.netsuite.com">
                            <platformCommon:internalId>14</platformCommon:internalId>
                            <platformCommon:country>_unitedStates</platformCommon:country>
                            <platformCommon:addressee>Anonymous</platformCommon:addressee>
                            <platformCommon:addrText>Anonymous<br>United States</platformCommon:addrText>
                            <platformCommon:override>false</platformCommon:override>
                        </tranSales:shippingAddress>
                        <tranSales:shipIsResidential>false</tranSales:shipIsResidential>
                        <tranSales:shipDate>2023-07-27T00:00:00.000-07:00</tranSales:shipDate>
                        <tranSales:shipComplete>false</tranSales:shipComplete>
                        <tranSales:saveOnAuthDecline>true</tranSales:saveOnAuthDecline>
                        <tranSales:canHaveStackable>false</tranSales:canHaveStackable>
                        <tranSales:revenueStatus>_pending</tranSales:revenueStatus>
                        <tranSales:recognizedRevenue>0.0</tranSales:recognizedRevenue>
                        <tranSales:deferredRevenue>0.0</tranSales:deferredRevenue>
                        <tranSales:subTotal>25.0</tranSales:subTotal>
                        <tranSales:taxTotal>0.0</tranSales:taxTotal>
                        <tranSales:total>25.0</tranSales:total>
                        <tranSales:subsidiary internalId="1">
                            <platformCore:name>Parent Company</platformCore:name>
                        </tranSales:subsidiary>
                        <tranSales:lastModifiedDate>2023-07-27T23:51:27.000-07:00</tranSales:lastModifiedDate>
                        <tranSales:location internalId="1">
                            <platformCore:name>MidWest</platformCore:name>
                        </tranSales:location>
                        <tranSales:status>Pending Approval</tranSales:status>
                    </platformCore:record>
                </platformCore:recordList>
            </platformCore:searchResult>
        </searchResponse>
    </soapenv:Body>
</soapenv:Envelope>

Leave a comment

Your email address will not be published. Required fields are marked *