can i use query.runSuiteQL in a map reduce script

AI generated answer (using internal Slack threads):

Yes, you can use

query.runSuiteQL

in a Map/Reduce script in NetSuite. However, it's important to note that

query.runSuiteQL

has a limit of 5000 results. If you need to handle larger data loads, you can use

query.runSuiteQLPaged(options)

. In the

getInputData

stage of a Map/Reduce script, you can return a SuiteQL query. Here is an example of how you can structure it:

javascript
return {
    type: 'suiteql',
    query: "SELECT ... FROM ... "
};

This will allow NetSuite to execute the SuiteQL query. Please note that if the NetSuite instance does not have

SuiteAnalytics Connect

enabled, you will be limited to 100k results. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******