Hi,
I am trying to match a netsuite search export to rest api query in postman
The netsuite report export finds 29 Records
the REST API query funds 40 Records
I can't figure out why the rest api has more?
Company added a special text field to the transactionline table called 'custcol1'. This is the main field I search on.
postman query:
{ "q": "SELECT * FROM transactionline tl where tl.custcol1 IS NOT NULL"}
finds 40 results
more complex still finds 40 records
{ "q": "SELECT * FROM transaction t LEFT JOIN transactionline tl ON t.id = tl.transaction LEFT JOIN subsidiary s ON tl.subsidiary = s.id where tl.custcol1 IS NOT NULL and t.type IS NOT NULL and s.name = 'MyCo' and t.trandate >= '11/1/2021' and t.trandate < '12/31/2021'"
}
finds 40 results
netsuite search criteria is:
POSTING is true AND
ACCOUNT TYPE is not none AND
SYSTEM NOTES : TYPE is Create AND
Subsidiary is MyCo and
date is within 11/1/2021 and 12/31/2021 AND
custcol1 is not empty
finds ONLY 29 results !
Which is correct?
Q1 : So I want the rest api and the netsuite count to match. How can I do this?
maybe the netsuite results need mod? Like what is SYSTEM NOTES : TYPE is Create ??
Q 2: - how can I add that to REST API or should I just take that out of netsuite criteria?
Or what should I do to get same count on both?
THANKS DAVE