I am trying to work with Oracle, NetSuite using Postman App (Mac) to get started with basic set up and queries.
I have the basics working, such as getting access and refresh tokens going and also basic queries from the Postman - netSuite rest API collection
https://netsuite.custhelp.com/app/answers/detail/a_id/87118
Q: in the post man netSuite examples, these queries do work, however I am confused as to the table names, as they do not seem to match what is showing in the NetSuite Docs (ODBC)
https://zzzzz.app.netsuite.com/help/helpcenter/en_US/srbrowser/Browser2021_1/odbc/record/customer.html
they say:
FROM customer c, transaction t ????
why not : customers and transactions as table names? What is the significance of customer 'c' and transaction 't' ? Am guessing correctly that the 'c' and the 't' are like alias for the table name to be used in the where area?
How can I find the proper table names to use for Rest API queries?
Any help would be appreciated– Dave
postman queries...
"q": "SELECT c.email AS email, c.companyName AS company, t.tranId AS document, t.tranDate AS date FROM customer c, transaction t WHERE t.entity = c.id AND t.type = 'SalesOrd'"
}
// or
{
"q": "SELECT id, companyName, email, dateCreated FROM customer WHERE dateCreated >= '{{thisYearStart}}' AND dateCreated < '{{thisYearEnd}}'"
}```
Copyright Notice:Content Author:「deal tek」,Reproduced under the CC 4.0 BY-SA copyright license with a link to the original source and this disclaimer.
Link to original article:https://stackoverflow.com/questions/68216835/netsuite-queries-and-proper-table-names