主页 / coding / 问题 / 79332849
Accepted
user3691240
Asked: 2025-01-06 19:14:31 +0800 CST

使用 jolt 转换来转换 JSON

  • 772

我有输入 JSON

{
  "MainObj": {
    "SubObject": {
      "Invoices": [
        {
          "InvoiceItemsDetail": [
            {
              "InvoiceItemLineNumber": "1",
              "ItemCode": "122",
              "Description": "GoodsDescription1"
            },
            {
              "InvoiceItemLineNumber": "2",
              "ItemCode": "222",
              "Description": "GoodsDescription2"
            }
          ]
        },
        {
          "InvoiceItemsDetail": [
            {
              "InvoiceItemLineNumber": "3",
              "ItemCode": "322",
              "Description": "GoodsDescription3"
            },
            {
              "InvoiceItemLineNumber": "4",
              "ItemCode": "422",
              "Description": "GoodsDescription4"
            }
          ]
        }
      ]
    }
  }
}

我需要不包含“AnotherObject”和“SomeOtherObject”的结果。

生成的 JSON 将包含

  • InvoiceItemLineNumber转换为INVOICE_LINE_ITEM_NUMBER，

  • ItemCode至ITEM_CODE和

  • Description到DESCRIPTION

所有这些都包含在一个数组中"outputs"

{
  "outputs": [
    {
      "INVOICE_LINE_ITEM_NUMBER": "1",
      "ITEM_CODE": "122",
      "DESCRIPTION": "GoodsDescription1"
    },
    {
      "INVOICE_LINE_ITEM_NUMBER": "2",
      "ITEM_CODE": "222",
      "DESCRIPTION": "GoodsDescription2"
    },
    {
      "INVOICE_LINE_ITEM_NUMBER": "3",
      "ITEM_CODE": "322",
      "DESCRIPTION": "GoodsDescription3"
    },
    {
      "INVOICE_LINE_ITEM_NUMBER": "4",
      "ITEM_CODE": "422",
      "DESCRIPTION": "GoodsDescription4"
    }
  ]
}
json

1 个回答

  1. Best Answer

    您只需要 "*": "[]"键值对作为转换的最内层部分，例如

    [
  {
    "operation": "shift",
    "spec": {
      "MainObj": {
        "SubObject": {
          "Invoices": {
            "*": {
              "InvoiceItemsDetail": {
                "*": "[]"
              }
            }
          }
        }
      }
    }
  }
]

    网站上的演示Jolt Transform Demo Using v0.1.1是：

    在此处输入图片描述

    编辑：考虑到您需要重命名新编辑案例的属性，您可以使用以下规范：

    [
  { //determine the objects seperated by upper indexes separately
    "operation": "shift",
    "spec": {
      "MainObj": {
        "SubObject": {
          "Invoices": {
            "*": {
              "InvoiceItemsDetail": {
                "*": {
                  "Invoice*": "&3_&1.INVOICE_LINE_ITEM_NUMBER",
                  "Item*": "&3_&1.ITEM_CODE",
                  "Desc*": "&3_&1.DESCRIPTION"
                }
              }
            }
          }
        }
      }
    }
  },
  { //get rid of the object keys while adding an array wrapper, namely "outputs"
    "operation": "shift",
    "spec": {
      "*": "outputs[]"
    }
  }
]
    • 1

相关问题