NetSuite sub records to JSON

Sub records hold information about a parent record and are meaningful only within that context. The sub record must be created, edited, removed, or viewed from its standard NetSuite record. These  sub records must be configured and mapped  in integrator.io. You can map sub records imported into NetSuite natively through integrator.io.

When transformed, the JSON structure can look like this:

[
  {
    "customer_name": "Test Customer",
    "email": "celigo@test.com",
    "line_items": [
      {
        "item_name": "Inventory Serial Item1",
        "item_amount": 245,
        "item_qty": 2,
        "item_location": 1,
        "inv_detail": [
          {
            "serialnumber": "inv01",
            "qty": 1
          },
          {
            "serialnumber": "inv02",
            "qty": 1
          }
        ]
      },
      {
        "item_name": "Inventory Serial Item2",
        "item_amount": 542,
        "item_qty": 1,
        "item_location": 1,
        "inv_detail": [
          {
            "serialnumber": "inv03",
            "qty": 1
          }
        ]
      }
    ]
  }
]