Hi everyone , I am a newbie to NetSuite and API c...
# suiteql
z
Hi everyone , I am a newbie to NetSuite and API calls . I am trying to fetch data from Netsuite into my GCP project . I had some questions regarding the same 1. what is the difference between Schema browser vs Record browser ? 2. Where can I get the exact table names that i can query from SuiteQl . For eg : On the record browser I see a table called RevRecSchedule , however when I try to query it using SuiteQl using postman (Attached screenshot) it says not valid .I am unable to fetch it through a simple REST API call as well .I have had trouble querying other tables like currency , division as well . So my basic question would be where can I find the list of tables and what joins we can use to fetch data from SuiteQl . Any leads would be greatly appreciated ! Thanks
m
The Record Browser is the reference to access data via scripting. The Schema Browser is the reference to access the data via SOAP Web Services. I believe the Record Catalog is the reference to access data via SuiteQL or Rest Web Services.
z
Thanks @Mike Robbins