如何将解析器转换用于IIC中的JSON数据？

Question

我是iics的新手，并且我的json数据如下，我将在CSV文件中解析。我正在使用 link 参考以实现这种转变。我在iics中创建了有效的映射。该映射运行良好。但是，当我看到我的工作时，我将收到以下错误。

不知道怎么了？我需要将JSON数据文件保存为TXT文件吗？

任何帮助将不胜感激！提前致谢！

运行映射后的错误

[error]无法处理数据：文件c：/iicslabfiles/test.json不存在或不可读取 - 有关更多信息，请参见文件：// C：/Progra〜1/Informatica Cloud Secure Agent/apps/data_integration_server/data/cmreports/tmp/2022-06-01/hierarchyparser_h2r_udt_8gns3_only_only_h2r_h2r_xmap_/event.cme

<B#80010%#>
    !~109146~165266~~10.2.2.65()
    <B#80032%#>
    </B#8032%#>
    <m -- XMap%m>
        !~103149~1654220266~~Pages\/page_m_1.cmv%Pages\/page_m_1.json
        <B#80037%XML#>
            !~1031~1654220266~~Pages\/Input_of_m_1.cmv%Pages\/Input_of_m_1.json
            <LocalFile>
                !~309025~16542266~~C:\/IICSLabFiles\/test.json
            </LocalFile>
            !~103205~16540266~~C:\/IICSLabFiles\/test.json
            !~3033~1654220266~~
        </B#8007%XML#>
    </m -- XMap>
</B#80010%#>

json数据保存在test.json中（用文件类型为JSON文件）：

{
  "current_page": 1,
  "first_page_url": "https://covid-api.com/api/regions?per_page=20&page=1",
  "last_page_url": "https://covid-api.com/api/regions?per_page=20&page=50",
  "next_page_url": "https://covid-api.com/api/regions?per_page=20&page=2",
  "prev_page_url": null,
  "per_page": "20",
  "last_page": 50,
  "from": 1,
  "path": "https://covid-api.com/api/regions",
  "to": 20,
  "total": 997,
  "data": [
    {
      "iso": "CHN",
      "name": "China"
    },
    {
      "iso": "TWN",
      "name": "Taipei and environs"
    },
    {
      "iso": "USA",
      "name": "US"
    },
    {
      "iso": "JPN",
      "name": "Japan"
    },
    {
      "iso": "THA",
      "name": "Thailand"
    },
    {
      "iso": "KOR",
      "name": "Korea, South"
    },
    {
      "iso": "SGP",
      "name": "Singapore"
    },
    {
      "iso": "PHL",
      "name": "Philippines"
    },
    {
      "iso": "MYS",
      "name": "Malaysia"
    },
    {
      "iso": "VNM",
      "name": "Vietnam"
    },
    {
      "iso": "AUS",
      "name": "Australia"
    },
    {
      "iso": "MEX",
      "name": "Mexico"
    },
    {
      "iso": "BRA",
      "name": "Brazil"
    },
    {
      "iso": "COL",
      "name": "Colombia"
    },
    {
      "iso": "FRA",
      "name": "France"
    },
    {
      "iso": "NPL",
      "name": "Nepal"
    },
    {
      "iso": "CAN",
      "name": "Canada"
    },
    {
      "iso": "KHM",
      "name": "Cambodia"
    },
    {
      "iso": "LKA",
      "name": "Sri Lanka"
    },
    {
      "iso": "CIV",
      "name": "Cote d'Ivoire"
    }
  ]
}

** JSON模式，保存在层次结构架构中（用文件类型为JSON文件）**

{
  "$schema": "http://json-schema.org/draft-04/schema#",
  "type": "object",
  "properties": {
    "current_page": {
      "type": "integer"
    },
    "first_page_url": {
      "type": "string"
    },
    "last_page_url": {
      "type": "string"
    },
    "next_page_url": {
      "type": "string"
    },
    "prev_page_url": {
      "type": "null"
    },
    "per_page": {
      "type": "string"
    },
    "last_page": {
      "type": "integer"
    },
    "from": {
      "type": "integer"
    },
    "path": {
      "type": "string"
    },
    "to": {
      "type": "integer"
    },
    "total": {
      "type": "integer"
    },
    "data": {
      "type": "array",
      "items": [
        {
          "type": "object",
          "properties": {
            "iso": {
              "type": "string"
            },
            "name": {
              "type": "string"
            }
          },
          "required": [
            "iso",
            "name"
          ]
        },
        {
          "type": "object",
          "properties": {
            "iso": {
              "type": "string"
            },
            "name": {
              "type": "string"
            }
          },
          "required": [
            "iso",
            "name"
          ]
        },
        {
          "type": "object",
          "properties": {
            "iso": {
              "type": "string"
            },
            "name": {
              "type": "string"
            }
          },
          "required": [
            "iso",
            "name"
          ]
        },
        {
          "type": "object",
          "properties": {
            "iso": {
              "type": "string"
            },
            "name": {
              "type": "string"
            }
          },
          "required": [
            "iso",
            "name"
          ]
        },
        {
          "type": "object",
          "properties": {
            "iso": {
              "type": "string"
            },
            "name": {
              "type": "string"
            }
          },
          "required": [
            "iso",
            "name"
          ]
        },
        {
          "type": "object",
          "properties": {
            "iso": {
              "type": "string"
            },
            "name": {
              "type": "string"
            }
          },
          "required": [
            "iso",
            "name"
          ]
        },
        {
          "type": "object",
          "properties": {
            "iso": {
              "type": "string"
            },
            "name": {
              "type": "string"
            }
          },
          "required": [
            "iso",
            "name"
          ]
        },
        {
          "type": "object",
          "properties": {
            "iso": {
              "type": "string"
            },
            "name": {
              "type": "string"
            }
          },
          "required": [
            "iso",
            "name"
          ]
        },
        {
          "type": "object",
          "properties": {
            "iso": {
              "type": "string"
            },
            "name": {
              "type": "string"
            }
          },
          "required": [
            "iso",
            "name"
          ]
        },
        {
          "type": "object",
          "properties": {
            "iso": {
              "type": "string"
            },
            "name": {
              "type": "string"
            }
          },
          "required": [
            "iso",
            "name"
          ]
        },
        {
          "type": "object",
          "properties": {
            "iso": {
              "type": "string"
            },
            "name": {
              "type": "string"
            }
          },
          "required": [
            "iso",
            "name"
          ]
        },
        {
          "type": "object",
          "properties": {
            "iso": {
              "type": "string"
            },
            "name": {
              "type": "string"
            }
          },
          "required": [
            "iso",
            "name"
          ]
        },
        {
          "type": "object",
          "properties": {
            "iso": {
              "type": "string"
            },
            "name": {
              "type": "string"
            }
          },
          "required": [
            "iso",
            "name"
          ]
        },
        {
          "type": "object",
          "properties": {
            "iso": {
              "type": "string"
            },
            "name": {
              "type": "string"
            }
          },
          "required": [
            "iso",
            "name"
          ]
        },
        {
          "type": "object",
          "properties": {
            "iso": {
              "type": "string"
            },
            "name": {
              "type": "string"
            }
          },
          "required": [
            "iso",
            "name"
          ]
        },
        {
          "type": "object",
          "properties": {
            "iso": {
              "type": "string"
            },
            "name": {
              "type": "string"
            }
          },
          "required": [
            "iso",
            "name"
          ]
        },
        {
          "type": "object",
          "properties": {
            "iso": {
              "type": "string"
            },
            "name": {
              "type": "string"
            }
          },
          "required": [
            "iso",
            "name"
          ]
        },
        {
          "type": "object",
          "properties": {
            "iso": {
              "type": "string"
            },
            "name": {
              "type": "string"
            }
          },
          "required": [
            "iso",
            "name"
          ]
        },
        {
          "type": "object",
          "properties": {
            "iso": {
              "type": "string"
            },
            "name": {
              "type": "string"
            }
          },
          "required": [
            "iso",
            "name"
          ]
        },
        {
          "type": "object",
          "properties": {
            "iso": {
              "type": "string"
            },
            "name": {
              "type": "string"
            }
          },
          "required": [
            "iso",
            "name"
          ]
        }
      ]
    }
  },
  "required": [
    "current_page",
    "first_page_url",
    "last_page_url",
    "next_page_url",
    "prev_page_url",
    "per_page",
    "last_page",
    "from",
    "path",
    "to",
    "total",
    "data"
  ]
}

源连接设置

​

Path
C:/IICSLabFiles/test.json

Answer 1

错误消息“ c：/iicslabfiles/test.json不存在或不可读取”，建议您尝试阅读本地文件。这是运行映射的安全代理上的文件的路径，还是存储在笔记本电脑上的文件的路径？您的来源定义是什么？

请记住，您可以在笔记本电脑上设计映射，在那里您可以访问存储在笔记本电脑上的文件 - 但是一旦执行，它将被安全的代理处理（可以是不同的机器，云托管等）。在这种情况下，似乎安全代理无法在给定位置访问文件。

也可以将安全代理安装在计算机上，并在您实际上一直在设计映射的笔记本电脑上运行该过程。在这种情况下，请确保路径中没有错别字，没有前导或落后空的空间。而且，如果它是基于Windows的安全代理，请验证这些路径，因为您使用的路径具有Froward Slashes，而Windows通常使用后斜线：

C:/IICSLabFiles/test.json
vs
C:\IICSLabFiles\test.json