"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. How can I find the proper table names to use for Rest API queries? 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? 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) I have the basics working, such as getting access and refresh tokens going and also basic queries from the Postman - netSuite rest API collection If you need some consulting help of how you can design your NetSuite scripts better, contact us by filling out this form or by commenting below.I am trying to work with Oracle, NetSuite using Postman App (Mac) to get started with basic set up and queries. Our team has worked with 400+ NetSuite scripts and workflows combined. We are experts in both SuiteScript 2.0 and SuiteScript 1.0. LEACC Consulting is a team of NetSuite Certified Developers with IT experience solely dedicated to NetSuite technologies for eight years. Hit Save so you won’t lose the request you configured.Enter the NetSuite Account ID under Advanced > Realm. Consumer Secret (from Section I, Step 3). For more information on deploying your first RESTlet, go to this article.
0 Comments
Leave a Reply. |