Reading Published Resource Data in Form and Scheduled Scripts in SuiteProjects Pro
The functionality described in this topic requires the following feature and role permission. For more information about the features enabled for your SuiteProjects Pro account or about your role permissions, contact your account administrator.
-
Feature: Business Intelligence Connector
-
Role permission: Publish reports, in addition to platform permissions required to access user scripting (see Platform Role Permissions).
You can access your published list and report data in your form and scheduled scripts using the following functions:
-
Read the list of published lists and reports available to the user running the script using
NSOA.listview.list()andNSOA.report.list(). -
Read the published list or report data available to the user running the script using
NSOA.listview.data(listviewId)andNSOA.report.data(reportId)
User scripting support for reading your published resource data has the following benefits:
-
The
NSOA.listviewandNSOA.reportfunctions give you access to the same information available when you use BI tools to access your published resource data. -
Reading OData resource data using the
NSOA.listviewandNSOA.reportfunctions does not use any of your BI Connector request entitlement — see BI Connector Request Limits -
You can read data from all published reports in your user scripts. You can also publish reports exclusively for use in your user scripts. When using the
NSOA.report.list()user scripting function to read the list of published reports, each item in the list has the propertyPublishType— The scope of use specified for the published report. -
You can use published lists like custom queries and read the latest list data in your form and scheduled scripts. The data read by your scripts is the same as the data you can see in your list at any given time.
For more information, see the User Scripting.
Both form and scheduled scripts support the NSOA.listview.data(listviewId) function. However, the number of items you can process in form scripts is restricted by their run time limit. The function is best suited for reading published list data in scheduled scripts, which allow up to 1 hour of JS runtime.
