- Defining mappings with the customer on a call (usually in a spreadsheet)
- Tooling/Setup to input those customizations in the system
- Engineering support for non 1:1 field mappings (ex. “Full Name” —> “first_name” “last_name”)
Base Workflows
First, determine the conceptual architecture for the integration you want to offer, we’ll use an Order Sync as our example To enable a Full Order Sync, we’ll want to- Fetch historical Orders
- Listen for New and Updated Orders
- Write data back to the ERP (like a tracking number after shipment)
Retrieving/Receiving Data from 3rd parties (Netsuite)
In this example for Fetch Historical Orders, the initial flow has aStop Workflow
block. Since each Netsuite user has unique Purchase Order fields, we’ll want to do that mapping per-customer, so it doesn’t make sense to proceed til we’ve built that out.


Customizing Workflows
After the Netsuite user has connected their account. An integration specialist, business analyst, or an onboarding team member should agree on the mappings between Your Application and their Netsuite Purchase Orders. Here’s a simple example of how that can lookYourApp | Netsuite |
---|---|
external_order_id | OrderId |
vendor.name | Subsidiary.refName |
vendor.email | Email |
lineItems[*].sku | lines[*].ItemSku |
lineItems[*].product_name | lines[*].Name |
lineItems[*].quantity | lines[*].Quantity |
lineItems[*].unit_cost | lines[*].Rate |
custom_field_1 | cust_Assigned_Procurement_Rep |
custom_field_2 | cust_ShippingPriority |
OrderId
into the default template, then only add the user-specific customizations in the next step.
Here’s an example of how we might pre-map some fields into our destination data structure. This is the default workflow the user installs

external_id
and email
which are usually standard. lineItems
today are handled separately in a custom code block, and we’ve left additional fields blank to be filled in with the User Specific mappings you determine with the end user.
Now, let’s customize it according to the mappings in the table for the specific user. Find the installation and workflow for the specific user in Installation Manager.

Initial Sync Workflow
and Create New User-Specific Version
.

Stop Workflow Block
and fill in the mappings