Sample CSV output

sample-csv.xqy

xquery version "1.0-ml";

declare namespace obj="http://marklogic.com/solutions/obi/object";

declare function local:header(){
text {"One,Two"}
};

declare function local:process($uri as xs:string) {
text {fn:string-join((cts:element-values(xs:QName("obj:id"), (), (), cts:document-query($uri)), cts:element-values(xs:QName("obj:type"), (), (), cts:document-query($uri))), ",")}
};

(
xdmp:add-response-header("Content-Type", 'text/plain; charset=utf-8'),
local:header(),
local:process(cts:uris((), ("limit=500"), cts:collection-query("object") ))
)