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

In a blog post about how I use the Record Browser, I briefly describe the various types. I use @tdietrich’s query tool to develop all my queries; it has a built-in schema reference tool. You can also access it from Setup > Records Catalog

Thanks @erictgrubaugh for the quick response . The one issue I have even though I have access to the Netsuite login ,its only read access as this is a vendor for us and we only can view data . As per Tim's tool , I would need to deploy a script to use that tool , an access that I wont have But thanks for the reference to your blog ,will check it out !

Without the tool installed, you can still access the Records Catalog page, so that's likely your best bet

Yes I was checking that which is why I am not sure this is not getting queried , even though i can see it under Records browser

confusingly, Records Browser

!==

Records Catalog. My account doesn't have any of the rev rec stuff so I unfortunately can't verify where you should look in the Catalog

ohhh , okay maybe that's something I can get from the vendor