Azure Logic App:获取API JSON输入并将值映射到另一个JSON对象中的键

Question

我正在进行一个API调用，它以下面的格式返回JSON：

{
    "query_status": "ok",
    "data": [
        {
            "id": "41",
            "ioc": "gaga.com",
            "threat_type": "botnet_cc",
            "threat_type_desc": "Indicator that identifies a botnet command&control server (C&C)",
            "ioc_type": "domain",
        },
        [...]
}

我正在寻找一种解决方案，通过它我可以获取这些值并将它们附加到Azure中的表中。我需要将这些值赋给下面的值：

{
  "emailSenderName": "String",
  "emailSourceDomain": "String",
  "emailSourceIpAddress": "String",
  "emailSubject": "String",
  "emailXMailer": "String",
  "expirationDateTime": "String (timestamp)",
  "externalId": "String",
  "fileCompileDateTime": "String (timestamp)",
  "fileCreatedDateTime": "String (timestamp)",
  "fileHashType": "string",
  "fileHashValue": "String",
  "fileMutexName": "String",
  "fileName": "String",
  "filePacker": "String",
  "filePath": "String",
  "fileSize": 1024,
  "fileType": "String",
  "id": "String (identifier)",
  "ingestedDateTime": "String (timestamp)",
  "isActive": true,
  "killChain": ["String"],
}

所需的输出是创建此链接上显示的对象

https://docs.microsoft.com/en-us/graph/api/tiindicator-submittiindicators?view=graph-rest-beta&tabs=http

做这件事最好的方法是什么？在浏览了MS文档之后，我没有找到任何有用的东西。本质上，我想要做的是改变密钥。

Answer 1

为什么不在逻辑应用程序中使用编写操作，如下例所示：

​