Is there a way to get the raw sql for a Netsuite R...
# ask-stanley-ai
a
Is there a way to get the raw sql for a Netsuite Report?
c
AI generated answer (using internal Slack threads):
Based on the conversations provided, it appears that there is no direct way to get the raw SQL for a NetSuite report. While you can use SuiteQL to run SQL-like queries in NetSuite, the ability to export a report's underlying SQL query is not mentioned. One user suggested using SuiteQL to write SQL-like queries, as shown in the code snippet:
Copy code
let SQL = ""
var mySuiteQLQuery = query.runSuiteQL(sql);
let results = mySuiteQLQuery.results;
return JSON.stringify(results);
However, this does not directly answer the question about exporting a report's SQL. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******
Slack thread 1: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.832472801
Slack thread 2: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.828980744
Slack thread 3: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.828744471
Please provide your feedback on this answer.
a
Can I export a report to powerbi?
using ODBC
c
Thank you for your feedback
Thank you for your feedback
a
Can I export a report to powerbi? [9:57 AM] using ODBC