Netsuite REST web services help to query transaction lines
I am trying to get started using Netsuite rest web services.
I have some basic functions working OK using postman. I am able to do certain basic queries using the postman demonstration files such as:
"q": "SELECT t.tranId , t.tranDate FROM transaction t WHERE createddate >= '6/1/2021'"
"q": "SELECT c.companyname, c.id FROM customer c WHERE dateCreated >= '1/1/2021'"
- however when I try to access transaction lines - my query fails:
"q": "SELECT * FROM transaction_lines tl WHERE date_created >= '6/1/2021'"
"detail": "Invalid search query. Detailed unprocessed description follows. Invalid search type: transaction_lines.",