Hi,
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:
- transactions
{
"q": "SELECT t.tranId , t.tranDate FROM transaction t WHERE createddate >= '6/1/2021'"
}
- customer
{
"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'"
}
error:
"status": 400,
"o:errorDetails": [
{
"detail": "Invalid search query. Detailed unprocessed description follows. Invalid search type: transaction_lines.",
"o:errorQueryParam": "q",
"o:errorCode": "INVALID_PARAMETER"
}
]
Q: how can I query the transaction lines table using rest web services API? Is there a better way?
Q: is there a link that shows us all the possible tables we can query using the Rest api?
BTW: I see this link for odbc - what about for rest api?
ODBC Table list:
https://ACCOUNTID.app.netsuite.com/help/helpcenter/en_US/srbrowser/Browser2021_1/odbc/record/transaction_lines.html
For Rest I see:
https://system.netsuite.com/help/helpcenter/en_US/APIs/REST_API_Browser/record/v1/2020.1/index.html
but where are transaction lines table access?
Thanks much,
Dave