A brief introduction to JSONiq for NashFP

100%

A brief introduction to JSONiq for NashFP

✓ Published0🌍 Public

Last edited May 28, 2014

Created on May 19, 2014

This example demonstrates the JSONiq query language by showing code snippets for tasks like object navigation, FLWOR expressions, JSON-to-XML conversion, and the Luhn algorithm. The sample queries use JSONiq’s map operator, function libraries like `fn:upper-case` and `fn:fold-left`, and the `keys()` and `members()` functions. Each snippet includes a link to run it in the Zorba engine’s online sandbox, referencing the NashFP presentation context.

AI-generated description

Similar vizzes

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

58% match

Loading thumbnail…

Functional SQL: https://www.codewars.com/kata/545434090294935e7d0010ab

This example recreates a functional SQL query engine in JavaScript, translating a Codewars kata into a working API. The code defines a `query` object with chainable methods like `select`, `from`, `where`, `groupBy`, `having`, and `orderBy`, mirroring SQL clause semantics. It performs cross joins across multiple arrays, applies filtering via nested callback arrays, and builds nested group structures using plain objects and recursive traversal. The final `execute` method returns mapped rows, demonstrating how relational query concepts can be implemented without external libraries, relying solely on native array methods and object literals.

MMunishkin

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

56% match

Loading thumbnail…

Gist 66b1a9a31dce76682837c3fd4d9a468b

This example demonstrates how to query JSONB data directly in PostgreSQL and flatten it into a relational result set. The code creates a table with a JSONB column, inserts two sample rows, and then uses two different query approaches: the `->>` operator to extract scalar fields as text, and the `jsonb_to_record` function with a column definition list to cast JSON values into typed columns (text and integer). The example highlights both methods for accessing nested JSON data, showing the explicit extraction syntax versus the more structured record-expansion technique, all within a single SQL file.

JJonasHeylen

56% match

Loading thumbnail…

Simple examples of higher-order functions and partial function application in XQuery

This example demonstrates higher-order functions and partial application in XQuery 3.0, using code tested with Saxon and Zorba. It shows functions that accept or return other functions, such as `local:pow` returning a function, and the `math:pow#2` built-in being partially applied with `?`. The code also illustrates fold operations (`fold-left`, `fold-right`) and sequence functions (`for-each`, `for-each-pair`, `filter`), applied to string and integer sequences. These snippets highlight how XQuery 3.0 supports functional programming patterns.

CCliffordAnderson

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

54% match

Loading thumbnail…

Bash / JQ for Cloudant Bulk Upload & Download

This example demonstrates a command-line workflow for bulk uploading and downloading JSON documents to and from a Cloudant database, using bash scripts that combine HTTPie and JQ. It shows how to aggregate multiple local JSON files into a single `_bulk_docs` payload via `jq -s`, upload that payload with an HTTP POST request, and retrieve data from a Cloudant view—transforming the response into either a plain document array or a GeoJSON FeatureCollection. The scripts also convert view output back into a file, enabling round-trip data migration and export without a custom application.

CCliffordAnderson

53% match

Loading thumbnail…

JSON expansion in Power Query M

This example demonstrates how to flatten or expand nested JSON structures using Power Query’s M language, specifically through the `List.Generate` function. It shows the step-by-step traversal of a record hierarchy, where each iteration checks whether the current value is a record, tracks the nesting level, and builds an output record that appends the field names discovered at each depth. The code relies on core M functions like `Record.FieldNames`, `Record.FieldValues`, and `Record.AddField`, along with list concatenation, to construct the expanded output. The visualization highlights a programmatic approach to transforming hierarchical JSON into a flat, tabular-friendly format, without external libraries.

HHugoberry

52% match