I would like to fetch company information via suiteql or soap ap

AI generated answer (using internal Slack threads):

To fetch company information via SuiteQL or SOAP API, you can use the following methods: 1. SuiteQL: SuiteQL is a powerful tool that allows you to perform complex queries on your NetSuite data. You can use a POST request to the SuiteTalk API endpoint with your SuiteQL query in the body. Here is a sample code:

code
POST <https://demo123.suitetalk.api.netsuite.com/services/rest/query/v1/suiteql?limit=10&offset=10>
Prefer: transient

{
  "q": "SELECT email, COUNT(*) as count FROM transaction GROUP BY email"
}

Please replace the URL and the query with your own. 2. SOAP API: SOAP API is another way to fetch data from NetSuite. You can use the

get

operation to retrieve a single record, or the

search

operation to retrieve multiple records. However, it seems that SOAP API does not return columns with formulas. Please note that you need to have the necessary permissions to access the data via SuiteQL or SOAP API. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******