【8】豪豪插件的 xml 转 json 出错

登录

向一个数据接口请求数据，返回的是一个xml格式的数据，期望通过插件中的“ xml 转 json” 转换为 json格式，再通过json反序列化得到json对象，然后将json对象写入本地数据库中。

执行的结果如下图：

返回的信息说：
Data at the root level is invalid. Line 1, position 1.

返回的数据如下（数据已经脱敏处理，但是格式没变）：

<DataTable xmlns="http://tempuri.org/">
<xs:schema xmlns="" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" id="NewDataSet">
<xs:element name="NewDataSet" msdata:IsDataSet="true" msdata:MainDataTable="data" msdata:UseCurrentLocale="true">
<xs:complexType>
<xs:choice minOccurs="0" maxOccurs="unbounded">
<xs:element name="data" msprop:BaseTable.0="DBA01">
<xs:complexType>
<xs:sequence>
<xs:element name="XH" msprop:BaseColumn="XH" msprop:OraDbType="126" type="xs:string" minOccurs="0"/>
<xs:element name="RQ" msprop:BaseColumn="RQ" msprop:OraDbType="106" type="xs:dateTime" minOccurs="0"/>
<xs:element name="JES" msprop:BaseColumn="JES" msprop:OraDbType="122" type="xs:float" minOccurs="0"/>
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:choice>
</xs:complexType>
</xs:element>
</xs:schema>
<diffgr:diffgram xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:diffgr="urn:schemas-microsoft-com:xml-diffgram-v1">
<DocumentElement xmlns="">
<data diffgr:id="data1" msdata:rowOrder="0">
<XH>87届38</XH>
<RQ>2012-03-22T00:00:00+08:00</RQ>
<JES>14.76</JES>
</data>
<data diffgr:id="data2" msdata:rowOrder="1">
<XH>87届38</XH>
<RQ>2012-03-23T00:00:00+08:00</RQ>
<JES>16.1</JES>
</data>
<data diffgr:id="data3" msdata:rowOrder="2">
<XH>87届38</XH>
<RQ>2012-03-24T00:00:00+08:00</RQ>
<JES>41.79</JES>
</data>
<data diffgr:id="data4" msdata:rowOrder="3">
<XH>87届38</XH>
<RQ>2012-03-25T00:00:00+08:00</RQ>
<JES>45.43</JES>
</data>
<data diffgr:id="data5" msdata:rowOrder="4">
<XH>87届38</XH>
<RQ>2012-03-26T00:00:00+08:00</RQ>
<JES>43.24</JES>
</data>
<data diffgr:id="data6" msdata:rowOrder="5">
<XH>87届38</XH>
<RQ>2012-03-27T00:00:00+08:00</RQ>
<JES>44.62</JES>
</data>
<data diffgr:id="data7" msdata:rowOrder="6">
<XH>87届38</XH>
<RQ>2012-03-28T00:00:00+08:00</RQ>
<JES>40.15</JES>
</data>
<data diffgr:id="data8" msdata:rowOrder="7">
<XH>87届38</XH>
<RQ>2012-03-29T00:00:00+08:00</RQ>
<JES>42.69</JES>
</data>
<data diffgr:id="data9" msdata:rowOrder="8">
<XH>87届38</XH>
<RQ>2012-03-30T00:00:00+08:00</RQ>
<JES>40.7</JES>
</data>
<data diffgr:id="data10" msdata:rowOrder="9">
<XH>87届38</XH>
<RQ>2012-03-31T00:00:00+08:00</RQ>
<JES>40.41</JES>
</data>
<data diffgr:id="data11" msdata:rowOrder="10">
<XH>87届38</XH>
<RQ>2012-04-01T00:00:00+08:00</RQ>
<JES>40.89</JES>
</data>
<data diffgr:id="data12" msdata:rowOrder="11">
<XH>87届38</XH>
<RQ>2012-04-02T00:00:00+08:00</RQ>
<JES>40.24</JES>
</data>
<data diffgr:id="data13" msdata:rowOrder="12">
<XH>87届38</XH>
<RQ>2012-04-03T00:00:00+08:00</RQ>
<JES>39.31</JES>
</data>
<data diffgr:id="data14" msdata:rowOrder="13">
<XH>87届38</XH>
<RQ>2012-04-04T00:00:00+08:00</RQ>
<JES>38.57</JES>
</data>
<data diffgr:id="data15" msdata:rowOrder="14">
<XH>87届38</XH>
<RQ>2012-04-05T00:00:00+08:00</RQ>
<JES>37.75</JES>
</data>
<data diffgr:id="data16" msdata:rowOrder="15">
<XH>87届38</XH>
<RQ>2012-04-06T00:00:00+08:00</RQ>
<JES>37</JES>
</data>
<data diffgr:id="data17" msdata:rowOrder="16">
<XH>87届38</XH>
<RQ>2012-04-07T00:00:00+08:00</RQ>
<JES>37</JES>
</data>
<data diffgr:id="data18" msdata:rowOrder="17">
<XH>87届38</XH>
<RQ>2012-04-08T00:00:00+08:00</RQ>
<JES>37.23</JES>
</data>
<data diffgr:id="data19" msdata:rowOrder="18">
<XH>87届38</XH>
<RQ>2012-04-09T00:00:00+08:00</RQ>
<JES>37.09</JES>
</data>
<data diffgr:id="data20" msdata:rowOrder="19">
<XH>87届38</XH>
<RQ>2012-04-10T00:00:00+08:00</RQ>
<JES>36.74</JES>
</data>
<data diffgr:id="data21" msdata:rowOrder="20">
<XH>87届38</XH>
<RQ>2012-04-11T00:00:00+08:00</RQ>
<JES>37</JES>
</data>
<data diffgr:id="data22" msdata:rowOrder="21">
<XH>87届38</XH>
<RQ>2012-04-12T00:00:00+08:00</RQ>
<JES>37.04</JES>
</data>
<data diffgr:id="data23" msdata:rowOrder="22">
<XH>87届38</XH>
<RQ>2012-04-13T00:00:00+08:00</RQ>
<JES>36.24</JES>
</data>
<data diffgr:id="data24" msdata:rowOrder="23">
<XH>87届38</XH>
<RQ>2012-04-14T00:00:00+08:00</RQ>
<JES>36.17</JES>
</data>
<data diffgr:id="data25" msdata:rowOrder="24">
<XH>87届38</XH>
<RQ>2012-04-15T00:00:00+08:00</RQ>
<JES>35.8</JES>
</data>
<data diffgr:id="data26" msdata:rowOrder="25">
<XH>87届38</XH>
<RQ>2012-04-16T00:00:00+08:00</RQ>
<JES>35.27</JES>
</data>
<data diffgr:id="data27" msdata:rowOrder="26">
<XH>87届38</XH>
<RQ>2012-04-17T00:00:00+08:00</RQ>
<JES>35.36</JES>
</data>
<data diffgr:id="data28" msdata:rowOrder="27">
<XH>87届38</XH>
<RQ>2012-04-18T00:00:00+08:00</RQ>
<JES>35.1</JES>
</data>
<data diffgr:id="data29" msdata:rowOrder="28">
<XH>87届38</XH>
<RQ>2012-04-19T00:00:00+08:00</RQ>
<JES>35.19</JES>
</data>
<data diffgr:id="data30" msdata:rowOrder="29">
<XH>87届38</XH>
<RQ>2012-04-20T00:00:00+08:00</RQ>
<JES>34.59</JES>
</data>
<data diffgr:id="data31" msdata:rowOrder="30">
<XH>87届38</XH>
<RQ>2012-04-21T00:00:00+08:00</RQ>
<JES>34.15</JES>
</data>
<data diffgr:id="data32" msdata:rowOrder="31">
<XH>87届38</XH>
<RQ>2012-04-22T00:00:00+08:00</RQ>
<JES>34.19</JES>
</data>
</DocumentElement>
</diffgr:diffgram>
</DataTable>