is it possible to fetch custom reports using any E...
# ask-stanley-ai
d
is it possible to fetch custom reports using any ETL tool?
c
AI generated answer (using internal Slack threads):
Based on the conversations, it is possible to fetch custom reports using an ETL (Extract, Transform, Load) tool, but not directly. You can use RESTlets to export the data to a data warehouse like BigQuery and then generate the report using a tool like Looker. However, it's important to note that you cannot load and work with reports directly in a script in NetSuite. SuiteAnalytics datasets/workbooks can be exported to CSV with the Query/task module. Normal reports can also be exported to CSV and sent by email, and you might be able to use the attached CSV to ingest the data somehow with an email plugin. Also, it's possible to consider the report as an endpoint and call this report using the https module by enabling the web query option checkbox. However, you will have to parse the format yourself and deal with the security problems it brings, as the reports essentially become public. ****** 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.803106844
Slack thread 2: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.799746096
Slack thread 3: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.799124599
Please provide your feedback on this answer.
d
is it possible to schedule the report to be sent on email every hour?