CVS to JSONL example

csv-to-jsonl.xqy

xquery version "3.1";
declare namespace xpf = "http://www.w3.org/2005/xpath-functions";

(: Converts a CSV into JSONL, i.e. one JSON object per line :)

let $csv := fetch:text("https://gist.githubusercontent.com/CliffordAnderson/588774dd0fa7d7bb616abd8da478fe76/raw/33395bdb6fce8d215464738f8681b66b130159e9/books.csv") => csv:parse(map { 'header': true() }) 
for $record in $csv/csv/record
let $key-values :=
  for $entry in $record/*
  return
    if ($entry castable as xs:integer) 
    then <xpf:number key="{fn:name($entry)}">{$entry/text()}</xpf:number>
    else <xpf:string key="{fn:name($entry)}">{$entry/text()}</xpf:string>
let $line := <xpf:map>{$key-values}</xpf:map>
return xml-to-json($line, map { 'indent': false() })