JSONata FAQs

What does JSONata editing provide within Orderful NetSuite SuiteApp?

Per Customer and EDI document type within a NetSuite instance, it provides the ability to override property mappings by adding or modifying a piece of JSONata code directly inside our SuiteApp.


Supported document types

The following EDI transaction document types all support JSONata, with some exceptions for 850 and 875*:

  • 850 Purchase Order*
  • 855 Purchase Order Acknowledgment
  • 856 Advance Ship Notice
  • 810 Invoice
  • 875 Grocery Products Purchase Order*
  • 880 Grocery Products Invoice

Notes:

  • For 850 and 875: new properties cannot be added or modified at the moment. However, existing property types can still be updated via JSONa can be over
  • 846 Inventory Advice is not supported via JSONata editing yet

Steps to find and edit a JSONata expression?

Using the dynamic editor

  1. Navigate to an Orderful Transaction Record wish to modify
  2. Click the Edit Advanced Mapping button

From a Customer EDI Setup

  1. Find the Customer Entity you are you trying to change
  2. Select the EDI configuration tab -> EDI Enabled Transaction Type tab
  3. Click Edit on the EDI transaction type you want to modify


JSONata templates

At the moment, our JSONata editor is not pre-populated with a preset.
However, to get a jumpstart, you can easily copy/paste from our publicly shared examples or from existing NetSuite customer settings (if already configured).