ConvertXMLToJSON

1、概述

将xml格式的内容转换为json格式。

XML Attribute Mark (XML属性标记)

当提取包含属性的元素时，该字符指定元素属性转换到json属性时添加的前缀。

XML Content Key Name (XML内容键值)

当提取包含属性的元素时，该内容指定元素值转换到json时对应的key值。

Xpath Path Expression (XML路径表达式)

根据该表达式提取相应的内容，将其转换成json格式

示例

示例：XML属性标记、XML内容键值

样本数据

<Employee id="1"> 
    <device>computer</device>  
    <device>ipad</device>  
    <age>30</age>  
    <name>jiangbin</name>  
    <gender>Male</gender>  
    <role department="IT" extra="manager">Java Developer</role>  
    <additional> 
      <petname>Doggy</petname>  
      <petage>2</petage> 
    </additional> 
</Employee> 

假设我们对属性键值会添加前缀"@"，同时对于元素值对应的json key值为"content"，：

则可以看到转换结果如下：

{
  "Employees": {
    "Employee": {
      "role": {
        "@department": "IT",
        "@extra": "manager",
        "content": "Java Developer"
      },
      "gender": "Male",
      "additional": {
        "petname": "Doggy",
        "petage": 2
      },
      "name": "jiangbin",
      "@id": 1,
      "device": [
        "computer",
        "ipad"
      ],
      "age": 30
    }
  }
}

示例：XML Path Expression (XML路径表达式)

样本数据2

<Employees>
    <Employee id="1">
        <device>computer</device>
        <device>ipad</device>
        <age>30</age>
        <name>jiangbin</name>
        <gender>Male</gender>
        <role department="IT" extra="manager">Java Developer</role>
    </Employee>
    <Employee id="2">
        <age>35</age>
        <name>Lisa</name>
        <gender>Female</gender>
        <role  department="Decision" extra="CIO">CEO</role>
    </Employee>>
</Employees>

我们指定xml路径表达式为：/Employees/Employee[2]，提取第二个xml对象，配置如下：

则可以看到转换结果如下：

{
  "Employee": {
    "role": {
      "extra": "CIO",
      "department": "Decision",
      "content": "CEO"
    },
    "gender": "Female",
    "name": "Lisa",
    "id": "2",
    "age": "35"
  }
}