From Ivory Ibis, 3 Months ago, written in Text.
Embed
  1. source table:
  2. +-------+
  3. |oldCol1| with types: String
  4. +-------+
  5. |    123|
  6. |    456|
  7. +-------+
  8.  
  9. json:
  10. {  
  11.    "action":"Mapping",
  12.    "table":"tbla6b52401n151bn44fcn9b22n7705381d35bf",
  13.    "addNewColumns":[  
  14.       {  
  15.          "colName":"oldCol2",
  16.          "value":"42" // we can add here: "true"/"false" and convert to Boolean in Mappin; or "2018/12/31" and convert to Date; and so on
  17.       }
  18.    ],
  19.    "fieldsMapping":[  
  20.       {  
  21.          "oldFieldName":"oldCol1",
  22.          "newFieldName":"newCol1",
  23.          "fieldType":"String"
  24.       },
  25.       {  
  26.          "oldFieldName":"oldCol2",
  27.          "newFieldName":"newCol2",
  28.          "fieldType":"Long"
  29.       }
  30.    ],
  31.    "destinationTable":"tbl3c65c030n0d6en437an9609n0d89b78f6319",
  32.    "returnData":true
  33. }
  34.  
  35. destination table:
  36. +-------+-------+
  37. |newCol1|newCol2| with types: String, Long
  38. +-------+-------+
  39. |    123|     42|
  40. |    456|     42|
  41. +-------+-------+