将MarkLogic XML转换为JSON(MarkLogic XML to JSON conversion)

 我试图将此XML文件转换为JSON但无法取得任何成功。 我的XML中有两个子元素，但它只返回最后一个元素。 如何获取JSON格式的记录？ 
 
 XML 
 
 <Carousel>
  <Video>
    <Title>1</Title>
    <Abstract>3</Abstract>
    <FileName type="custom" mediatype="image">D</FileName>
    <HasAccess>4</HasAccess>
  </Video>
  <Video>
    <Title>1</Title>
    <Abstract>2</Abstract>
    <FileName type="custom" mediatype="image">D</FileName>
    <HasAccess>3</HasAccess>
  </Video>
</Carousel>
 
 XQUERY： 
 
import module namespace json = "http://marklogic.com/xdmp/json"  at "/MarkLogic/json/json.xqy";

let $custom := let $config := json:config("custom")
           return 
             (
              map:put( $config, "whitespace", "ignore" ),

              $config
             )
let $XML := $XMLFile (: XML content :)
return json:transform-to-json($XML,$custom)
 
 当前输出： 
 
{"Carousel":{"Video":{"Title":"1", "Abstract":"2", "FileName":{"type":"custom", "mediatype":"image", "_value":"D"}, "HasAccess":"3"}}}
 
 我也尝试使用默认的“基本”JSON设置json:transform-to-json($XML)但是得到了错误 
 
XML Element not in expected namespace [http://marklogic.com/xdmp/json/basic] (json:INVALIDELEM): Carousel
 
 它仅在“Full”模式下工作，但它会添加JSON格式的附加信息，如_attribute等，这在我的输出JSON中不是必需的。 
 
 请帮助我或者说明为什么它没有以JSON格式返回完整的输出。 

I am trying to convert this XML file into JSON but unable to get any success. I have two child element in my XML but it is returning only last one. How to get both the records in JSON format?
 
XML
 
 <Carousel>
  <Video>
    <Title>1</Title>
    <Abstract>3</Abstract>
    <FileName type="custom" mediatype="image">D</FileName>
    <HasAccess>4</HasAccess>
  </Video>
  <Video>
    <Title>1</Title>
    <Abstract>2</Abstract>
    <FileName type="custom" mediatype="image">D</FileName>
    <HasAccess>3</HasAccess>
  </Video>
</Carousel>
 
XQUERY:
 
import module namespace json = "http://marklogic.com/xdmp/json"  at "/MarkLogic/json/json.xqy";

let $custom := let $config := json:config("custom")
           return 
             (
              map:put( $config, "whitespace", "ignore" ),

              $config
             )
let $XML := $XMLFile (: XML content :)
return json:transform-to-json($XML,$custom)
 
Current OUTPUT:
 
{"Carousel":{"Video":{"Title":"1", "Abstract":"2", "FileName":{"type":"custom", "mediatype":"image", "_value":"D"}, "HasAccess":"3"}}}
 
I also tried it with default "Basic" JSON setting json:transform-to-json($XML) but got error like
 
XML Element not in expected namespace [http://marklogic.com/xdmp/json/basic] (json:INVALIDELEM): Carousel
 
It works in "Full" mode only, but it is adding some extra information in JSON format like _attribute etc. which is not required in my output JSON. 
 
Please help me or give any idea why it is not returning complete output in JSON format.

原文：https://stackoverflow.com/questions/26858466