Home

SuiteQL tables list

Hi ,

 

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 .

SuiteQL tables listQuerying RevRecSchedule

 

 

Any leads would be greatly appreciated !

Thanks

Rookie Asked on April 22, 2024 in SuiteScript.
Add Comment
Cancel
1 Answer(s)

Hi,

The best place to start with this is probably Setup > Records Catalog.

It show all records, fields and joins. Plus custom fields.

I hope that helps.

Thanks,

Chris

Cancel
Advanced Answered on April 23, 2024.

zahra09

Thanks Chris !

Its actually a vendor source so I don’t have access to it , but I’ll try it to get it from them

on April 23, 2024.
Cancel
Add Comment
Cancel

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.
  • This site made possible by our sponsors:   Tipalti   Celigo   SuiteMigration   Become a Sponsor