Simplified batch NetSuite export configuration
We’ve streamlined your process for configuring batch and dynamic exports from NetSuite. When you configure batch exports, you’ll no longer need to go to NetSuite’s and configure the saved search before you can map your fields in IO. Everything can be done from IO. If you’re running a dynamic export, you can now pull the data you need with dynamic filters and columns.
- Use arrays in ‘Define search criteria’: We now support arrays in ‘Define search criteria’ exports.
Example: If you’re trying to filter for a group of IDs, you can now use a list of IDs to define your filter.
Here are few examples on how we can use an array of internal ids. Any valid JSON representation works:
- "id" :["1","2","3"]
- "id" :[1,2,3]
- "id" :"["1","2","3"]"
- "id" :"1,2,3"
- Join items in filters: You can now join items in your NetSuite import mappings, creating a single custom field, so that you can now see item-join fields while defining a lookup for a sales order record. Previously, item join fields were not visible in the drop down while configuring the Qualification Criteria in a NS Export. Now, you can see them. eg: [items : Name] The custom fields created by your joins will not appear in the drop-downs for defining lookup filters.
- Update bundles without 1.7.4: You can now successfully update your NetSuite bundles without prefixing the IO version number with 1.7.4. Now you’ll be able to update bundles in IO and Integration Apps without the prefix.
- Error webhooks in exports: Previously, webhooks which contained only errors would not result in a job in IO. Now, the hook will create a job that you’ll see in the dashboard and it will show the error.
- Filters for Price Book and Subscription line records: Previously, when creating filters for Price Book or a dynamic lookup for Price Book, you would not find any or search criteria or search filter. We now use metadata for Price Book record types to allow you to use filters for Price Book filters and dynamic lookups.
- Line level custom fields: When you’re building an integration with any export with a NetSuite import and you add a dynamic lookup in your mapping fields, you’ll find body and custom line level fields in the dropdown menus as well.