Vedachalam Mahadevan
02/16/2025, 2:04 PMCeligo AI
02/16/2025, 2:04 PMAI generated answer (using internal Slack threads):SuiteAnalytics Connect does allow you to use SQL queries. It provides an ODBC connector that you can use to write SQL queries against using another tool, such as Visual Studio. However, it's important to note that SuiteAnalytics Connect is a paid module and you would need to contact your account representative to get it added to your account. In addition to SuiteAnalytics Connect, you can also use the
N/query
module in SuiteScript to run SuiteQL, which is a SQL-like query language, with certain differences and limitations. This does not require additional services and can be used without additional charges.
Another option is to use REST web services to run SuiteQL. An example of this would be using the API endpoint {{REST_SERVICES}}/query/v1/suiteql?limit=5
.
Please note that while SuiteQL is similar to SQL, there are certain differences and limitations.
******
Disclaimer:
This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes.
******Celigo AI
02/16/2025, 2:05 PMSlack thread 1: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.826901793
Slack thread 2: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.81767714
Slack thread 3: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.814357758
Celigo AI
02/16/2025, 2:05 PM