Hi Easy,
I want serialize my xml to json , the xml is :
could you please provide us with a minimized example?
Thanks, Christian
<BasicDataset xmlns="urn:sc-wst:v1"> <DataSet code="HSDA00.01" codeSystem="WS365-2011" codeSystemName="城乡居民健康档案基本数据集" displayName="个人基本信息数据集"> <HDSN00.01.013 dataelementName="文档编号" value="8DF51E49-CEEA-4B3A-A20FB862C802DFC7"/> <HDSN00.01.014 dataelementName="文档生成日期" value="20131223"/> <HDSN00.01.015 dataelementName="参与人电话" value="18281039963"/> <HDSN00.01.016 dataelementName="参与人姓名" value="寇欢欢"/> <HDSN00.01.001 dataelementName="记录日期" value="20131019"/> <HDSN00.01.002 dataelementName="记录者姓名" value="范书琼"/> <HDSN00.01.003 dataelementName="记录人编号" value="510622197409046024"/> <HDSN00.01.004 dataelementName="记录人联系电话" value=""/> <HDSN00.01.018 dataelementName="社保号" value="无"/> <HDSD00.01.001 dataelementName="城乡居民健康档案编号" value="51068311920600239"/> <HDSD00.01.003 code="2" codeSystem="2.16.156.10011.2.3.3.4" codeSystemName="生理性别代码表(GB/T 2261.1)" dataelementName="性别代码" displayName="女"/> <HDSD00.01.004 dataelementName="出生日期" value="20121030"/> <HDSD00.01.005 code="01" codeSystem="2.16.156.10011.2.3.1.1" codeSystemName="身份证件类别代码表" dataelementName="身份证件类别代码" displayName="居民身份证"/> <HDSD00.01.006 dataelementName="身份证件号码" value="无"/> <HDSD00.01.376 dataelementName="户籍地址-省(自治区、直辖市)" value="四川省"/> <HDSD00.01.377 dataelementName="户籍地址-市(地区、州)" value="德阳市"/> <HDSD00.01.378 dataelementName="户籍地址-县(区)" value="绵竹市"/> <HDSD00.01.379 dataelementName="户籍地址-乡（镇、街道办事处）" value="富新镇"/> <HDSD00.01.380 dataelementName="户籍地址-村（街、路、弄等）" value="九胜村"/> <HDSD00.01.381 dataelementName="户籍地址-门牌号码" value="02组"/> <HDSD00.01.424 dataelementName="邮政编码" value="510683119"/> <HDSD00.01.007 dataelementName="工作单位名称" value=""/> <HDSD00.01.008 dataelementName="本人电话号码" value="无"/> <HDSD00.01.009 dataelementName="联系人姓名" value="寇欢欢"/> <HDSD00.01.010 dataelementName="联系人电话号码" value="18281039963"/> <HDSD00.01.011 dataelementName="常住地址户籍标志" value="true"/> <HDSD00.01.012 code="01" codeSystem="2.16.156.10011.2.3.3.3" codeSystemName="民族代码表(GB 3304)" dataelementName="民族" displayName="汉族"/> <HDSD00.01.013 code="5" codeSystem="2.16.156.10011.2.3.1.85" codeSystemName="ABO血型代码表" dataelementName="ABO血型代码" displayName="不详"/> <HDSD00.01.014 code="3" dataelementName="Rh血型代码" displayName="不详"/> <HDSD00.01.015 code="90" codeSystem="2.16.156.10011.2.3.3.6" codeSystemName="学历代码表（GB/T 4568）" dataelementName="学历代码" displayName="其他"/> <HDSD00.01.016 code="Y" codeSystem="2.16.156.10011.2.3.3.7" codeSystemName="职业类别代码表" dataelementName="职业类别代码" displayName=""/> <HDSD00.01.017 code="10" codeSystem="2.16.156.10011.2.3.3.5" codeSystemName="婚姻状况代码表" dataelementName="婚姻状况代码" displayName="未婚"/> <HDSD00.01.018 code="04" codeSystem="2.16.156.10011.2.3.1.197" codeSystemName="医疗费用来源类别代码表" dataelementName="医疗费用支付方式代码" displayName="公务员医疗补助"/> <HDSD00.01.019 dataelementName="药物过敏史标志" value="true"/> <HDSD00.01.01> <row> <HDSD00.01.020 code="" codeSystem="2.16.156.10011.2.3.1.137" codeSystemName="过敏源代码表" dataelementName="药物过敏源" displayName=""/> </row> </HDSD00.01.01> <HDSD00.01.02> <row> <HDSD00.01.021 code="1" codeSystem="2.16.156.10011.2.3.1.33" codeSystemName="环境危险因素暴露类别代码表" dataelementName="环境危险因素暴露类别代码" displayName=""/> </row> </HDSD00.01.02> </DataSet> </BasicDataset>
want the result as :
{ "BasicDataset": { "-xmlns": "urn:sc-wst:v1", "DataSet": { "-code": "HSDA00.01", "-codeSystem": "WS365-2011", "-codeSystemName": "城乡居民健康档案基本数据集", "-displayName": "个人基本信息数据集", "HDSN00.01.013": { "-dataelementName": "文档编号", "-value": "8DF51E49-CEEA-4B3A-A20FB862C802DFC7" }, "HDSN00.01.014": { "-dataelementName": "文档生成日期", "-value": "20131223" }, "HDSN00.01.015": { "-dataelementName": "参与人电话", "-value": "18281039963" }, "HDSN00.01.016": { "-dataelementName": "参与人姓名", "-value": "寇欢欢" }, "HDSN00.01.001": { "-dataelementName": "记录日期", "-value": "20131019" }, "HDSN00.01.002": { "-dataelementName": "记录者姓名", "-value": "范书琼" }, "HDSN00.01.003": { "-dataelementName": "记录人编号", "-value": "510622197409046024" }, "HDSN00.01.004": { "-dataelementName": "记录人联系电话" }, "HDSN00.01.018": { "-dataelementName": "社保号", "-value": "无" }, "HDSD00.01.001": { "-dataelementName": "城乡居民健康档案编号", "-value": "51068311920600239" }, "HDSD00.01.003": { "-code": "2", "-codeSystem": "2.16.156.10011.2.3.3.4", "-codeSystemName": "生理性别代码表(GB/T 2261.1)", "-dataelementName": "性别代码", "-displayName": "女" }, "HDSD00.01.004": { "-dataelementName": "出生日期", "-value": "20121030" }, "HDSD00.01.005": { "-code": "01", "-codeSystem": "2.16.156.10011.2.3.1.1", "-codeSystemName": "身份证件类别代码表", "-dataelementName": "身份证件类别代码", "-displayName": "居民身份证" }, "HDSD00.01.006": { "-dataelementName": "身份证件号码", "-value": "无" }, "HDSD00.01.376": { "-dataelementName": "户籍地址-省(自治区、直辖市)", "-value": "四川省" }, "HDSD00.01.377": { "-dataelementName": "户籍地址-市(地区、州)", "-value": "德阳市" }, "HDSD00.01.378": { "-dataelementName": "户籍地址-县(区)", "-value": "绵竹市" }, "HDSD00.01.379": { "-dataelementName": "户籍地址-乡（镇、街道办事处）", "-value": "富新镇" }, "HDSD00.01.380": { "-dataelementName": "户籍地址-村（街、路、弄等）", "-value": "九胜村" }, "HDSD00.01.381": { "-dataelementName": "户籍地址-门牌号码", "-value": "02组" }, "HDSD00.01.424": { "-dataelementName": "邮政编码", "-value": "510683119" }, "HDSD00.01.007": { "-dataelementName": "工作单位名称" }, "HDSD00.01.008": { "-dataelementName": "本人电话号码", "-value": "无" }, "HDSD00.01.009": { "-dataelementName": "联系人姓名", "-value": "寇欢欢" }, "HDSD00.01.010": { "-dataelementName": "联系人电话号码", "-value": "18281039963" }, "HDSD00.01.011": { "-dataelementName": "常住地址户籍标志", "-value": "true" }, "HDSD00.01.012": { "-code": "01", "-codeSystem": "2.16.156.10011.2.3.3.3", "-codeSystemName": "民族代码表(GB 3304)", "-dataelementName": "民族", "-displayName": "汉族" }, "HDSD00.01.013": { "-code": "5", "-codeSystem": "2.16.156.10011.2.3.1.85", "-codeSystemName": "ABO血型代码表", "-dataelementName": "ABO血型代码", "-displayName": "不详" }, "HDSD00.01.014": { "-code": "3", "-dataelementName": "Rh血型代码", "-displayName": "不详" }, "HDSD00.01.015": { "-code": "90", "-codeSystem": "2.16.156.10011.2.3.3.6", "-codeSystemName": "学历代码表（GB/T 4568）", "-dataelementName": "学历代码", "-displayName": "其他" }, "HDSD00.01.016": { "-code": "Y", "-codeSystem": "2.16.156.10011.2.3.3.7", "-codeSystemName": "职业类别代码表", "-dataelementName": "职业类别代码" }, "HDSD00.01.017": { "-code": "10", "-codeSystem": "2.16.156.10011.2.3.3.5", "-codeSystemName": "婚姻状况代码表", "-dataelementName": "婚姻状况代码", "-displayName": "未婚" }, "HDSD00.01.018": { "-code": "04", "-codeSystem": "2.16.156.10011.2.3.1.197", "-codeSystemName": "医疗费用来源类别代码表", "-dataelementName": "医疗费用支付方式代码", "-displayName": "公务员医疗补助" }, "HDSD00.01.019": { "-dataelementName": "药物过敏史标志", "-value": "true" }, "HDSD00.01.01": { "row": { "HDSD00.01.020": { "-codeSystem": "2.16.156.10011.2.3.1.137", "-codeSystemName": "过敏源代码表", "-dataelementName": "药物过敏源" } } }, "HDSD00.01.02": { "row": { "HDSD00.01.021": { "-code": "1", "-codeSystem": "2.16.156.10011.2.3.1.33", "-codeSystemName": "环境危险因素暴露类别代码表", "-dataelementName": "环境危险因素暴露类别代码" } } } } } }
but basex fn:json:serialize($x,{'format':'jsonml'}) got:
["json", {"type":"object"}, ["BasicDataset", ["DataSet", {"code":"HSDA00.01", "codeSystem":"WS365-2011", "codeSystemName":"城乡居民健康档案基本数据集", "displayName":"个人基本信息数据集"}, ["HDSN00.01.013", {"dataelementName":"文档编号", "value":"8DF51E49-CEEA-4B3A-A20FB862C802DFC7"}], ["HDSN00.01.014", {"dataelementName":"文档生成日期", "value":"20131223"}], ["HDSN00.01.015", {"dataelementName":"参与人电话", "value":"18281039963"}], ["HDSN00.01.016", {"dataelementName":"参与人姓名", "value":"寇欢欢"}], ["HDSN00.01.001", {"dataelementName":"记录日期", "value":"20131019"}], ["HDSN00.01.002", {"dataelementName":"记录者姓名", "value":"范书琼"}], ["HDSN00.01.003", {"dataelementName":"记录人编号", "value":"510622197409046024"}], ["HDSN00.01.004", {"dataelementName":"记录人联系电话", "value":""}], ["HDSN00.01.018", {"dataelementName":"社保号", "value":"无"}], ["HDSD00.01.001", {"dataelementName":"城乡居民健康档案编号", "value":"51068311920600239"}], ["HDSD00.01.003", {"code":"2", "codeSystem":"2.16.156.10011.2.3.3.4", "codeSystemName":"生理性别代码表(GB/T 2261.1)", "dataelementName":"性别代码", "displayName":"女"}], ["HDSD00.01.004", {"dataelementName":"出生日期", "value":"20121030"}], ["HDSD00.01.005", {"code":"01", "codeSystem":"2.16.156.10011.2.3.1.1", "codeSystemName":"身份证件类别代码表", "dataelementName":"身份证件类别代码", "displayName":"居民身份证"}], ["HDSD00.01.006", {"dataelementName":"身份证件号码", "value":"无"}], ["HDSD00.01.376", {"dataelementName":"户籍地址-省(自治区、直辖市)", "value":"四川省"}], ["HDSD00.01.377", {"dataelementName":"户籍地址-市(地区、州)", "value":"德阳市"}], ["HDSD00.01.378", {"dataelementName":"户籍地址-县(区)", "value":"绵竹市"}], ["HDSD00.01.379", {"dataelementName":"户籍地址-乡（镇、街道办事处）", "value":"富新镇"}], ["HDSD00.01.380", {"dataelementName":"户籍地址-村（街、路、弄等）", "value":"九胜村"}], ["HDSD00.01.381", {"dataelementName":"户籍地址-门牌号码", "value":"02组"}], ["HDSD00.01.424", {"dataelementName":"邮政编码", "value":"510683119"}], ["HDSD00.01.007", {"dataelementName":"工作单位名称", "value":""}], ["HDSD00.01.008", {"dataelementName":"本人电话号码", "value":"无"}], ["HDSD00.01.009", {"dataelementName":"联系人姓名", "value":"寇欢欢"}], ["HDSD00.01.010", {"dataelementName":"联系人电话号码", "value":"18281039963"}], ["HDSD00.01.011", {"dataelementName":"常住地址户籍标志", "value":"true"}], ["HDSD00.01.012", {"code":"01", "codeSystem":"2.16.156.10011.2.3.3.3", "codeSystemName":"民族代码表(GB 3304)", "dataelementName":"民族", "displayName":"汉族"}], ["HDSD00.01.013", {"code":"5", "codeSystem":"2.16.156.10011.2.3.1.85", "codeSystemName":"ABO血型代码表", "dataelementName":"ABO血型代码", "displayName":"不详"}], ["HDSD00.01.014", {"code":"3", "dataelementName":"Rh血型代码", "displayName":"不详"}], ["HDSD00.01.015", {"code":"90", "codeSystem":"2.16.156.10011.2.3.3.6", "codeSystemName":"学历代码表（GB/T 4568）", "dataelementName":"学历代码", "displayName":"其他"}], ["HDSD00.01.016", {"code":"Y", "codeSystem":"2.16.156.10011.2.3.3.7", "codeSystemName":"职业类别代码表", "dataelementName":"职业类别代码", "displayName":""}], ["HDSD00.01.017", {"code":"10", "codeSystem":"2.16.156.10011.2.3.3.5", "codeSystemName":"婚姻状况代码表", "dataelementName":"婚姻状况代码", "displayName":"未婚"}], ["HDSD00.01.018", {"code":"04", "codeSystem":"2.16.156.10011.2.3.1.197", "codeSystemName":"医疗费用来源类别代码表", "dataelementName":"医疗费用支付方式代码", "displayName":"公务员医疗补助"}], ["HDSD00.01.019", {"dataelementName":"药物过敏史标志", "value":"true"}], ["HDSD00.01.01", ["row", ["HDSD00.01.020", {"code":"", "codeSystem":"2.16.156.10011.2.3.1.137", "codeSystemName":"过敏源代码表", "dataelementName":"药物过敏源", "displayName":""}]]], ["HDSD00.01.02", ["row", ["HDSD00.01.021", {"code":"1", "codeSystem":"2.16.156.10011.2.3.1.33", "codeSystemName":"环境危险因素暴露类别代码表", "dataelementName":"环境危险因素暴露类别代码", "displayName":""}]]]]]]
how to got this ?
-- 此致
easy
莫愁前路无知己，天下谁人不识君。
BaseX-Talk mailing list BaseX-Talk@mailman.uni-konstanz.de https://mailman.uni-konstanz.de/mailman/listinfo/basex-talk