How do I get the name of the NetSuite company using SuiteQL?

Question

Is it possible to get company info (name, address, timezone, etc) from NetSuite using SuiteQL? I can't find any references to it in the docs.

Answer 1

You could do this by making a post request to the suiteql endpoint and including the requested information in the raw body of the request.

Example:

POST request to: https://{yourNetsuiteCompanyID}.suitetalk.api.netsuite.com/services/rest/query/v1/suiteql

Body:
{
    "q": "select customer.CompanyName, customer.id, customer.name from 
          Customer"
}

This request would give me the company name and internal company id. I can also rename these fields as I would in SQL.