Simplifying DB2API Result

You can simplify results returned from DB2API using JOLT, clean unnecessary fields, and reorganize data structure. This page includes examples of changing the name of the data element and moving specific fields to upper level.

Result value returned from DB2API:

{
  "statusCode" : 200,
  "statusDescription" : "OK",
  "columnNames" : [ "customerNumber", "customerName", "contactLastName", "contactFirstName", "phone", "addressLine1", "addressLine2", "city", "state", "postalCode", "country", "salesRepEmployeeNumber", "creditLimit" ],
  "numRows" : 2,
  "data" : [ {
    "country" : "France",
    "city" : "Nantes",
    "contactFirstName" : "Carine ",
    "postalCode" : "44000",
    "salesRepEmployeeNumber" : 1370,
    "customerNumber" : 103,
    "customerName" : "Atelier graphique",
    "phone" : "40.32.2555",
    "addressLine1" : "54, rue Royale",
    "creditLimit" : 21000.0,
    "contactLastName" : "Schmitt",
    "addressLine2" : null,
    "state" : null
  }, {
    "country" : "France",
    "city" : "Nantes",
    "contactFirstName" : "Janine ",
    "postalCode" : "44000",
    "salesRepEmployeeNumber" : 1370,
    "customerNumber" : 119,
    "customerName" : "La Rochelle Gifts",
    "phone" : "40.67.8555",
    "addressLine1" : "67, rue des Cinquante Otages",
    "creditLimit" : 118200.0,
    "contactLastName" : "Labrune",
    "addressLine2" : null,
    "state" : null
  } ],
  "elapsedTime" : 11,
  "errors" : [ ]
}  
 

• JOLT example and output that changes the name of the “data” element and cleans it from other elements:

-------------------------------------------
JOLT: 
--------------------------------------------  

[
  {
    "operation": "shift",
    "spec": {
          "data":"sonuç"
     }
  }
]

--------------------------------------------
RESULT
--------------------------------------------  
{
  "sonuç" : [ {
    "country" : "France",
    "city" : "Nantes",
    "contactFirstName" : "Carine ",
    "postalCode" : "44000",
    "salesRepEmployeeNumber" : 1370,
    "customerNumber" : 103,
    "customerName" : "Atelier graphique",
    "phone" : "40.32.2555",
    "addressLine1" : "54, rue Royale",
    "creditLimit" : 21000.0,
    "contactLastName" : "Schmitt",
    "addressLine2" : null,
    "state" : null
  }, {
    "country" : "France",
    "city" : "Nantes",
    "contactFirstName" : "Janine ",
    "postalCode" : "44000",
    "salesRepEmployeeNumber" : 1370,
    "customerNumber" : 119,
    "customerName" : "La Rochelle Gifts",
    "phone" : "40.67.8555",
    "addressLine1" : "67, rue des Cinquante Otages",
    "creditLimit" : 118200.0,
    "contactLastName" : "Labrune",
    "addressLine2" : null,
    "state" : null
  } ]
}

 

• JOLT example and output that moves “country” elements within the “data” element to one level up and cleans it from other elements:

-------------------------------------------
JOLT:
-------------------------------------------

[
  {
    "operation": "shift",
    "spec": {
      "data": {
        "*": {
          "country": "&"
        }
      }
    }
  }
]

 
--------------------------------------------
RESULT
--------------------------------------------  

{
  "country": [
    "France",
    "France"
  ]
}

• JOLT example and output that moves the value of “country” elements within the “data” element to one level up and cleans it from other elements:

-------------------------------------------
JOLT:
-------------------------------------------

[
  {
    "operation": "shift",
    "spec": {
      "data": {
        "*": {
          "country": "[&1]."
        }
      }
    }
  }
]

 
--------------------------------------------
RESULT
--------------------------------------------  

[
  "France",
  "France"
]