Comédie Française API

100%

Comédie Française API

✓ Published0🌍 Public

Last edited Dec 11, 2015

Created on Dec 11, 2015

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.

AI-generated description

Similar vizzes

Loading thumbnail…

Convert JSON to Dublin Core in XML

This example shows a live conversion of movie search results from JSON into Dublin Core XML metadata. It retrieves data from the OMDB API using `fetch:text` and `fn:parse-json` to parse the response, then extracts the `Search` array. For each movie, it creates a Dublin Core `title` and `relation` element, mapping the movie title and poster URL respectively. The code uses XQuery 3.1 with the `dc` namespace, and the final output is an XML `<movies>` wrapper. The example demonstrates a straightforward data transformation pipeline, not a visual chart, but it is included in the gallery for its metadata-handling technique.

CCliffordAnderson

67% match

Loading thumbnail…

fn:xml-to-json example

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.

CCliffordAnderson

64% 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

64% match

Loading thumbnail…

Sample code for extracting, transforming, and loading IA metadata into BaseX

This example demonstrates an XQuery 3.1 pipeline for harvesting Open Library search results and persisting them as structured XML in a BaseX database. It first fetches JSON via `fetch:text` and parses it with `json:parse`, then converts each record into a canonical `book` element with attributes for key and full-text availability, and child elements for title, authors, dates, publishers, and subjects. Subsequent scripts extend the process to paginate through large result sets, and a final query retrieves full book texts from the Internet Archive, storing them alongside the metadata.

CCliffordAnderson

62% match

Loading thumbnail…

CVS to JSONL example

This example shows a practical data-transformation workflow that converts a CSV file into JSONL format, producing one JSON object per line. It fetches a remote CSV file from a GitHub gist using the `fetch:text` function, parses it into records with `csv:parse`, and iterates through each record to build key-value pairs. The code distinguishes between integer and string values using `castable as xs:integer`, then constructs JSON maps with `xml-to-json` using XQuery 3.1. The output is unindented JSONL, suitable for streaming or line-oriented processing.

CCliffordAnderson

60% match

Loading thumbnail…

{$doc/RecordTitle/text()}

This example extracts bibliographic records from a collection of quarterly publications and serializes them into CSV format. It queries a local XML document store containing full-text articles, capturing fields such as title, publication, volume, issue, date, pagination, and a document link. The XQuery 3.1 script uses the `csv:serialize` function to convert the generated `element csv` tree into a delimited text file, demonstrating a straightforward data-wrangling pipeline for export and downstream analysis.

CCliffordAnderson

59% match

Loading thumbnail…

XQuery to clean up data from an Excel-generated webpage & generate an EAD document

This example shows how XQuery 3.1 can clean data scraped from an Excel-generated HTML table and use it to generate an EAD (Encoded Archival Description) finding aid. The `fetch:text()` and `html:parse` functions extract rows from a legacy webpage, normalize the text content, and repackage the fields into JSON maps. A second function transforms those entries into EAD `<c02>` components, inserting metadata like titles, abstracts, and thumbnail image links from the Lantern Slide collection at Vanderbilt. Finally, the script rebuilds a complete EAD document, injecting the new `<c02>` elements into the existing archival description hierarchy, preserving the original structure while enriching it with parsed data.

CCliffordAnderson

59% match

Loading thumbnail…

Parse Text Node as XML

This example demonstrates the transformation of CSV data containing organism records into structured XML, specifically parsing a text column of notes as embedded XML. It shows two versions of the process: the first uses a verbose `fn:parse-xml` call wrapped in a `<notes>` element, while the second simplifies the syntax with an `element notes` constructor. Both versions fetch remote CSV data via the `http:send-request` API, parse it with `csv:parse`, and iterate through records to repackage fields, replacing the raw notes text with parsed XML content. The data source is the Bioimages repository’s `organisms-small.csv` file.

CCliffordAnderson

58% match