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

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

From a Customer EDI Setup

Find the Customer Entity you are you trying to change
Select the EDI configuration tab -> EDI Enabled Transaction Type tab
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).