integrator.io executes NetSuite imports and exports via RESTlets, which are subject to NetSuite governance on the number of API operations allowed for every invocation. Each API call, typically executed as part of the integrator.io NetSuite bundle, costs a number of points as determined by NetSuite.
The SuiteScript points are directly proportional to...
- The number of records processed
- The number of dynamic lookups configured per record in a page
These operations typically occur during a NetSuite import. If you send too much data simultaneously in a single page, then NetSuite will return errors stating that you have exceeded your point limit:
How to minimize the cost of multiple dynamic lookups
Fist of all, try using static lookups whenever possible.
Example: If the number of locations you are searching for is manageably small, then you can have a static lookup mapped for only those locations processed within the flow.
You can also decrease the number of records imported at once by reducing the page size in the export. To specify a page size other than the default 20, navigate to the export configuration and expand the Advanced tab.
Finally, consider reducing the line-level lookups in the import mapping wherever you think you can skip them or replace them with the static lookups.
Example: Use Items : Item (Name) if your name field matches the NetSuite name field.
How to reduce the number of records in a single page
Try to decrease page size in the export, which lowers the number of records that will be processed at once in an import.
Implications of one-to-many downstream mapping
When you set up a one-to-many lookup, all the records within the path are sent at once. Then, there is no way to control the amount of records sent to an import.
Modify the import “batch size”
NetSuite imports allow you to control the Batch Size limit. This property limits the number of records sent to NetSuite to a maximum number.
To adjust this value, navigate to the import configuration and expand the Advanced settings.
Note: This setting is unrelated to the NetSuite export Batch size limit setting, which determines how many records can be retrieved at a time, before they are organized into pages within your flow.
Upgrade the NetSuite API version
If the other recommendations aren’t reducing your point usage, try switching the NetSuite API version in the import (shown above) to SuiteScript 2.0.