I'm trying to fetch account balances from SOAP api...
# suitetalkapi
v
I'm trying to fetch account balances from SOAP api. Using
getPostingTransactionSummary
endpoint. But first I need to fetch the periods.. store it and then fetch the balances for that period. SOAP request that I'm using :
Copy code
<soapenv:Envelope xmlns:soapenv="<http://schemas.xmlsoap.org/soap/envelope/|http://schemas.xmlsoap.org/soap/envelope/>" xmlns:urn="urn:<http://messages_2019_2.platform.webservices.netsuite.com|messages_2019_2.platform.webservices.netsuite.com>" xmlns:urn1="urn:<http://core_2019_2.platform.webservices.netsuite.com|core_2019_2.platform.webservices.netsuite.com>">
    <soapenv:Header>
       <urn:applicationInfo>
          <urn:applicationId>xxxxxxxxxxxxxxxxxxxxxxx</urn:applicationId>
       </urn:applicationInfo>
       <urn:passport>
           <urn1:email><http://xxxxxxxxxx.com|xxxxxxxxxx.com></urn1:email>
          <urn1:password>xxxxxxxx</urn1:password>
          <urn1:account>TSTDRVxxxxxxx</urn1:account>
          <!--Optional:-->
          <urn1:role internalId="3" />
       </urn:passport>
          <urn:searchPreferences>
           <urn:bodyFieldsOnly>false</urn:bodyFieldsOnly>
           <urn:pageSize>15</urn:pageSize>
       </urn:searchPreferences>
    </soapenv:Header>
    <soapenv:Body>
       <urn:getPostingTransactionSummary>
           <urn:fields>
             <!--Optional:-->
             <urn1:period>true</urn1:period>
             <!--Optional:-->
             <urn1:account>true</urn1:account>
          </urn:fields>
          <urn:filters>
                 <urn1:period>
                     <urn1:recordRef internalId="399"/>
                     <urn1:recordRef internalId="400"/>
                     <urn1:recordRef internalId="401"/>
                     <urn1:recordRef internalId="402"/>
                 </urn1:period>
          </urn:filters>
          <urn:pageIndex>1</urn:pageIndex>
       </urn:getPostingTransactionSummary>
    </soapenv:Body>
 </soapenv:Envelope
Is there any other effecient way to fetch account balances from SOAP api?
m
Nope. It's a massive pain
v
@Marc Reicher... Thanks 👍😊