fn:xml-to-json example

100%

fn:xml-to-json example

✓ Published0🌍 Public

Last edited Aug 2, 2017

Created on Aug 2, 2017

This example demonstrates the transformation of a nested XML document into JSON using the XQuery 3.1 function `fn:xml-to-json`. The XML input encodes workshop information, including leaders and institutions, within a structured `<map>` and `<array>` hierarchy using the XPath Functions namespace. The function converts this XML representation directly into its JSON equivalent, preserving the nested array and map structure. The code relies on the standard XQuery 3.1 function library, with the source document defined inline and the transformed JSON output returned as the query result.

AI-generated description

Similar vizzes

Loading thumbnail…

Comédie Française API

This example converts Comédie Française play data from JSON to XML, preserving metadata like author, title, and creation date. It shows how to transform API responses into structured XML documents for database storage. The code uses the XQuery `json-to-xml` function and `fetch:text` to retrieve and parse the JSON, then constructs custom `<play>` elements with attributes and child nodes. It optionally persists the results to a BaseX database via `db:add`, as seen in the commented-out line. The script demonstrates a direct data-cleaning workflow, with fields conditionally included based on presence in the source JSON.

CCliffordAnderson

64% match

Loading thumbnail…

XQuery Working Group Challenge

This example transforms the PROIEL treebank’s Latin New Testament XML into a sequence of verse elements, each tagged with its citation and concatenated token forms. It fetches the remote XML via `fn:doc`, extracts distinct citation parts, and filters tokens by matching `@citation-part` to build structured verses. The code uses XQuery 3.1’s element constructors and `fn:data` to output text, demonstrating a direct pipeline from hierarchical treebank data to flat verse-like text.

CCliffordAnderson

62% match

Loading thumbnail…

Get Zotero JSON from API

This example demonstrates how to retrieve and parse Zotero library items as structured XML from the Zotero API. It uses the XQuery `fetch:text` function to download JSON data from the API endpoint, then parses that JSON with `json:parse`. The code extracts all `note` elements from the parsed data and converts each into an XML fragment using `fn:parse-xml-fragment`. This approach shows a direct pipeline from API response to manipulable XML nodes, useful for further processing or transformation in an XQuery environment.

CCliffordAnderson

61% match

Loading thumbnail…

Converts from XML to GEOJson

This example shows the conversion of a single XML item containing place-name, latitude, and longitude data into a GeoJSON FeatureCollection with a Point geometry. It demonstrates a direct data-shape transformation. The code constructs the output JSON structure explicitly, mapping the XML text value to a `properties` field and the numeric coordinates into a `coordinates` array. The conversion relies on the MarkLogic `json:serialize` function to produce the final GeoJSON output from the hand-built `json` element. The snippet does not include any rendering or mapping library.

CCliffordAnderson

61% match

Loading thumbnail…

From Wikipedia: https://en.wikipedia.org/wiki/JSON

This example demonstrates the structural differences between JSON, XML, and an XML attribute-based format for the same person record. It shows how nested objects, arrays, and scalar values map across representations: the JSON file uses brace-delimited objects and bracketed arrays, while the XML versions use element and attribute conventions, including a namespace from the XPath functions spec. The code relies on standard parsing libraries—such as `JSON.parse` for the JSON input and an XML parser like `DOMParser` for the XML strings—to illustrate round-trip conversion. The focus is on format equivalence, not on visual encoding, making it a static comparison without interactive or rendered graphics.

CCliffordAnderson

60% match

Loading thumbnail…

RESTXQ example using map:find with BaseX 6.0 beta

This example demonstrates a RESTXQ service that queries the Open Library API for book titles and returns matching results as XML. The code defines an XQuery function annotated with `%rest:path` and `%rest:GET`, which receives a book title and a key parameter. It constructs a URL to the Open Library search endpoint, retrieves the JSON response using `fn:json-doc`, then flattens and searches the resulting structure with `array:flatten` and `map:find` from BaseX 6.0. The matched items are wrapped in a custom `results` element.

CCliffordAnderson

60% match

Loading thumbnail…

fn:analyze-string results

This example demonstrates the results of an XQuery transformation that uses the XPath 3.1 `fn:analyze-string` function to parse bibliographic text. Given a TEI XML source, the query extracts page ranges from bibliographic entries by matching patterns like "p. 35-42" and wraps them in a `tei:citedRange` element, while preserving the remaining text. The output shows a series of TEI `<bibl>` records where the cited page ranges are cleanly separated from the bibliographic citation text, enabling structured access to page references for downstream processing or display.

CCliffordAnderson

59% match

Loading thumbnail…

Playing with Higher Order Functions in XQuery

This example demonstrates how higher-order functions in XQuery 3.1 enable function composition for transforming numeric sequences. It shows a square function (`$map-sqr`) that uses the simple map operator (`!`) with `math:pow`, which is then fed into a reversal function (`$pow-rev`) via the `=>` arrow operator. The code applies `fn:reverse` to the input sequence before passing it to the squared map, returning the squares of the reversed order. The rendered output is computed in-memory with no external data source, purely exercising the language’s functional capabilities.

CCliffordAnderson

59% match