SOAP request for Address search

DM-7

The below sample shows how to retrieve an address using SOAP for a customer. The below code added a filter to fetch only default billing is true. Also, added result columns Default ship address.

<soapenv:Envelope
    xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/"
    xmlns:urn="urn:messages_2020_1.platform.webservices.netsuite.com"
    xmlns:urn1="urn:core_2020_1.platform.webservices.netsuite.com"
    xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    xmlns:listRel="urn:relationships_2020_1.lists.webservices.netsuite.com"  

>
<soapenv:Header> <urn:preferences> </urn:preferences> <urn:partnerInfo>  </urn:partnerInfo><urn:tokenPassport><urn1:account>TSTDRV2096915</urn1:account><urn1:consumerKey>dbb4d06168d2ab125dc8e4be00327afbc95d58ce32cdea6d20c730fffd7e6bce</urn1:consumerKey><urn1:token>73bc8665b66312a22b275d356a6830c73111d72cd8f4f263968231064784c5b8</urn1:token><urn1:nonce>gT9uzFQ4ZklfGWWsyW7gBweTZTYX3aeF</urn1:nonce><urn1:timestamp>1605510671</urn1:timestamp><urn1:signature algorithm="HMAC-SHA1">y3M0/jU9WP/Wra0mRQPcL+asWQ0=</urn1:signature></urn:tokenPassport></soapenv:Header>

    <soapenv:Body>
        <urn:search>
            <urn:searchRecord xsi:type="listRel:CustomerSearchAdvanced"
                xmlns:ns2="urn:relationships_2020_1.lists.webservices.netsuite.com"
                xmlns:ns3="urn:common_2020_1.platform.webservices.netsuite.com"         
            >
                <listRel:criteria  xsi:type="listRel:CustomerSearch">
                    <listRel:basic>
                        <ns3:isInactive>
                            <platformCore:searchValue
                                xmlns:platformCore="urn:core_2020_1.platform.webservices.netsuite.com">FALSE                
                    
                            </platformCore:searchValue>
                        </ns3:isInactive>
                        <ns3:isDefaultBilling>
                            <platformCore:searchValue
                                xmlns:platformCore="urn:core_2020_1.platform.webservices.netsuite.com">TRUE
                    
                            </platformCore:searchValue>
                        </ns3:isDefaultBilling>
                    </listRel:basic>
                </listRel:criteria>

                <listRel:columns xsi:type="listRel:CustomerSearchRow">
                    <listRel:basic xsi:type="advancedSearch:CustomerSearchRowBasic" xmlns:advancedSearch="urn:common_2020_1.platform.webservices.netsuite.com">
                        <internalId
                            xmlns="urn:common_2020_1.platform.webservices.netsuite.com">
                            <customLabel
                                xmlns="urn:core_2020_1.platform.webservices.netsuite.com">Internal ID
 
                            </customLabel>
                        </internalId>
                        <!-- Email -->
                        <email
                         xmlns="urn:common_2020_1.platform.webservices.netsuite.com">
                            <customLabel
                                xmlns="urn:core_2020_1.platform.webservices.netsuite.com">Email
 
                            </customLabel>
                        </email>
                        <!-- firstName -->
                        <firstName
                         xmlns="urn:common_2020_1.platform.webservices.netsuite.com">
                            <customLabel
                                xmlns="urn:core_2020_1.platform.webservices.netsuite.com">First Name
 
                            </customLabel>
                        </firstName>

                        <!-- lastName -->
                        <lastName
                         xmlns="urn:common_2020_1.platform.webservices.netsuite.com">
                            <customLabel
                                xmlns="urn:core_2020_1.platform.webservices.netsuite.com">Last Name
 
                            </customLabel>
                        </lastName>

                        <!-- Shiiping Address -->
                        <billAddress

                            xmlns="urn:common_2020_1.platform.webservices.netsuite.com">
                            <customLabel
                                xmlns="urn:core_2020_1.platform.webservices.netsuite.com">Default Bill Address
 
                            </customLabel>
                        </billAddress>
                        </listRel:basic>
                    </listRel:columns>
                </urn:searchRecord >
            </urn:search>
        </soapenv:Body>
    </soapenv:Envelope>

Leave a comment

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