求助：从Azure Logic Apps事件输出提取值并构建新JSON对象

原始JSON数据 #

[{"data":{"order_in":{"st_details":[{"is_fin": "true","parent__id": "sometext","st_info":{"TID":"somevalie"},"name":"Completed","status":"Completed"}]}}}]]

目标JSON结构（修正语法错误后） #

注：原始目标JSON存在语法错误，已修正为合法结构

{
  "or_information": {
    "details": [
      {
        "final": "@extracted dynamic values",
        "id": "@extracted values",
        "specific_info": {
          "TicketID": "@extracted values"
        }
      }
    ],
    "name": "@extracted values",
    "status": "@extracted values"
  }
}

提取转换逻辑 #

• 从原始JSON的 data.order_in.st_details[0] 节点映射字段：
  • final ← is_fin
  • id ← parent__id
  • specific_info.TicketID ← st_info.TID
  • name ← name
  • status ← status

最终转换结果 #

{
  "or_information": {
    "details": [
      {
        "final": "true",
        "id": "sometext",
        "specific_info": {
          "TicketID": "somevalie"
        }
      }
    ],
    "name": "Completed",
    "status": "Completed"
  }
}

内容的提问来源于stack exchange，提问作者Aluri Balahari