I recently ran into issues when using an integration record with TBA to request for multiple pages of transaction summary records when using the getPostingTransactionSummary web services action.
I found the first request was consistently successful, but following requests for successive pages would fail giving the following error: [INDENT]For pages > 1, search parameters must match the original search exactly[/INDENT] I followed the suggestions in SuiteAnswer 33416 labeled "getPostingTransactionSummary returns an error: For pages > 1, search parameters must match the original search exactly". I then ensured we were requesting the first page first, ensured no field or filter parameters had changed, and was requesting the second page immediately.
The mechanism used to generate signature appears to be correct as all calls to any web service endpoint for the first page are always successful.
The following represents the sequence of requests used to reproduce (where real data is mocked):
Request for first page:
<x:Envelope xmlns:x="http://schemas.xmlsoap.org/soap/envelope/" xmlns:urn2="urn:messages_2015_2.platform.webservic es.netsuite.com" xmlns:urn="urn:core_2015_2.platform.webservices.ne tsuite.com"> <x:Header> <urn:tokenPassport> <urn1:account>1234567</urn1:account> <urn1:consumerKey>12345</urn1:consumerKey> <urn1:token>1234</urn1:token> <urn1:nonce>62005285</urn1:nonce> <urn1:timestamp>1478114023</urn1:timestamp> <urn1:signature algorithm="HMAC-SHA256">NIhrCvTi2SpGfhxbxO8N09WQ7mvXw7oJICiEewCtm1 M=</urn1:signature> </urn:tokenPassport> </x:Header> <x:Body> <urn2:getPostingTransactionSummary> <urn2:fields> <urneriod>true</urneriod> <urn:account>true</urn:account> <urn:location>true</urn:location> <urn:subsidiary>true</urn:subsidiary> </urn2:fields> <urn2:filters> <urneriod> <urn:recordRef internalId="1"/> <urn:recordRef internalId="2"/> <urn:recordRef internalId="3"/> </urneriod> <urn:account> <urn:recordRef internalId="985" type="account"></urn:recordRef> </urn:account> </urn2:filters> <urn2ageIndex>1</urn2ageIndex> </urn2:getPostingTransactionSummary> </x:Body> </x:Envelope>
Response for first page:<?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 xmlnslatformMsgs="urn:messages_2015_2.platform.webservi ces.netsuite.com"> <platformMsgs:nsId>WEBSERVICES_1234</platformMsgs:nsId> </platformMsgs:documentInfo> </soapenv:Header> <soapenv:Body> <getPostingTransactionSummaryResponse xmlns="urn:messages_2015_2.platform.webservices.ne tsuite.com"> <platformCore:getPostingTransactionSummaryResult xmlnslatformCore="urn:core_2015_2.platform.webservices. netsuite.com"> <platformCore:status isSuccess="true"/> <platformCore:totalRecords>2150</platformCore:totalRecords> <platformCoreageSize>1000</platformCoreageSize> <platformCore:totalPages>3</platformCore:totalPages> <platformCoreageIndex>1</platformCoreageIndex> <platformCoreostingTransactionSummaryList> <platformCoreostingTransactionSummary> <platformCoreeriod internalId="1"/> <platformCore:account internalId="985"/> <platformCore:subsidiary internalId="1"/> <platformCore:amount>100</platformCore:amount> </platformCoreostingTransactionSummary> <platformCoreostingTransactionSummary> <platformCoreeriod internalId="1"/> <platformCore:account internalId="985"/> <platformCore:location internalId="3"/> <platformCore:subsidiary internalId="2"/> <platformCore:amount>100</platformCore:amount> </platformCoreostingTransactionSummary> .... MORE RECORDS HERE </platformCoreostingTransactionSummaryList> </platformCore:getPostingTransactionSummaryResult> </getPostingTransactionSummaryResponse> </soapenv:Body> </soapenv:Envelope>
Request for second page:<x:Envelope xmlns:x="http://schemas.xmlsoap.org/soap/envelope/" xmlns:urn2="urn:messages_2015_2.platform.webservic es.netsuite.com" xmlns:urn="urn:core_2015_2.platform.webservices.ne tsuite.com"> <x:Header> <urn:tokenPassport> <urn1:account>1234567</urn1:account> <urn1:consumerKey>12345</urn1:consumerKey> <urn1:token>1234</urn1:token> <urn1:nonce>64687129</urn1:nonce> <urn1:timestamp>1478114087</urn1:timestamp> <urn1:signature algorithm="HMAC-SHA256">HWQ/O4MSz5L6/TRu0GhtxU37yXIHdhSqvznbG92Salg=</urn1:signature> </urn:tokenPassport> </x:Header> <x:Body> <urn2:getPostingTransactionSummary> <urn2:fields> <urneriod>true</urneriod> <urn:account>true</urn:account> <urn:location>true</urn:location> <urn:subsidiary>true</urn:subsidiary> </urn2:fields> <urn2:filters> <urneriod> <urn:recordRef internalId="1"/> <urn:recordRef internalId="2"/> <urn:recordRef internalId="3"/> </urneriod> <urn:account> <urn:recordRef internalId="985" type="account"></urn:recordRef> </urn:account> </urn2:filters> <urn2ageIndex>2</urn2ageIndex> </urn2:getPostingTransactionSummary> </x:Body> </x:Envelope>