Dhiraj Bhalerao
10/18/2024, 9:55 AMMilcho Dimkov
10/18/2024, 9:56 AMCeligo AI
10/18/2024, 9:56 AMAI generated answer (using internal Slack threads):To use RESTlets to export the custom report data to a data warehouse, you can follow these steps: 1. Create a Saved Search or a Dataset: The first step is to create a saved search or a dataset for a workbook that gets the information you want with the filters you need. This can be done in the NetSuite UI. Saved searches have been around for a while and are a reliable way to gather the data you need. 2. Create a RESTlet: Once you have your saved search or dataset, you can create a RESTlet that will retrieve the data from this saved search or dataset. This RESTlet will serve as an endpoint that allows you to retrieve the data externally. 3. Use SuiteQL: If your report has complex filters and custom fields, you might find it helpful to use SuiteQL, which is a SQL-like language that allows you to query your NetSuite data. Here is a sample code snippet for using SuiteQL:
code
let SQL = ""
var mySuiteQLQuery = query.runSuiteQL(SQL);
let results = mySuiteQLQuery.results;
return JSON.stringify(results);
4. Extract Data: Now that you have your RESTlet set up, you can use it to extract the data from NetSuite and import it into your data warehouse. The exact method for doing this will depend on the capabilities of your data warehouse.
Remember, if you're dealing with a large amount of data, using the REST API endpoints might be slow. In such cases, you might want to consider using SuiteAnalytics Connect, which is designed for reading large amounts of data.
******
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
10/18/2024, 9:56 AMSlack thread 1: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.798472345
Slack thread 2: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.793594539
Slack thread 3: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.791986465
Celigo AI
10/18/2024, 9:56 AMDhiraj Bhalerao
10/18/2024, 9:57 AM