Creating Integration Reports
You can monitor SOAP web services processing by creating the following types of integration reports:
The Integration permission is required to view these reports. To enable this permission, administrators must go to Setup > Users/Roles > Manage Roles. Click Customize next to the appropriate role. On the Permissions tab, click Reports. In the Permissions dropdown list, select Integration and click Add.
You might receive a timeout error when creating integration reports for accounts with large volumes of SOAP web services traffic. Also, although integration reports do offer some filtering capabilities, users must first take the added step of customizing the report. Be aware that you can apply filtering in the SOAP Web Services Usage Log without doing customization.
Both of these reports provide details on type of operations used (for example, add, addList, delete), who performed an operation, and the time an operation was performed.
Web Services Integration reports are also useful for administrators who need to diagnose and troubleshoot issues. Note that each report can be customized to display only the desired information. To customize a report, click Customize next to the desired report and then modify the report as desired. For details about how to customize a report, see the help topic Report Customization.
If an integration report is timing out, you should customize the report by adding filters so the report returns fewer results. See Filtering Integration Report Data.
These reports do not support reporting by period even when the Report by Period preference is set to All Reports. The Report by Period preference can be configured at Home > Set Preferences, the Analytics subtab.
Integration and Automation Usage Summary by Job
This report can be used for performance statistics. It shows the duration of each SOAP web services processing job, the number of records modified in each job, the number of successful versus failed record modifications for each job, and the number of records queried for each job. You can also drill down to job details by clicking the job number.
Any related SOAP files are stored in View links in the reports Request Doc and Response Doc columns. Be aware that NetSuite purges SOAP files every 30 days. In sandbox environments, these files are accessible for seven days.
In sandbox environments, you can view request and response information in log and search results after 7 days. However, links to the original SOAP request and responses are not available.
You can view this report at Reports > Integration > Integration and Automation Usage Summary by Job.
Integration and Automation Usage Summary by Record Type
This report lists the record types modified by SOAP web services processing, and the number of records added, updated, deleted, and queried for each record type.
You can view this report at Reports > Integration > Integration and Automation Usage Summary by Record Type.
Filtering Integration Report Data
You can customize integration reports to run faster, by adding filters that limit the returned results. For example, you could limit a report to return only jobs with start dates that fall into a specified date range.
To filter an integration report by start date:
-
Go to Reports > Integration > Integration and Automation Usage Summary by Job > Customize or Reports > Integration > Integration and Automation Usage Summary by Record Type > Customize.
-
Click Filters.
-
Under Search Fields box, enter Start Date and click the Search button.
The Actual Job Start Date and Start Date fields are listed.
-
Click Start Date.
This field is added to the Choose Filters pane.
-
In the Choose Filters pane:
-
Set Filter to between.
-
Set Date Range to custom.
-
In the From and To fields, enter dates in {mm/dd/yyyy} format.
-
Click Done.
-
-
Click Save.