> For the complete documentation index, see [llms.txt](https://upsolver.gitbook.io/content/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://upsolver.gitbook.io/content/reference-1/functions-and-operators/functions/structural.md). # Structural This section describes the following structural functions:

Function	Description
FROM_KEY_VALUE	Maps a list of key values to a record with fields for each key
GET_RANGE	Returns a range of numbers between start and end (inclusive)
JOIN_ALL_BY_KEY	Combines multiple key-value arrays into one by the keys
JSON_PATH	Extracts data from JSON objects
JSON_TO_RECORD	Extracts data from JSON objects
MAP_WITH_INDEX	Outputs an index and a value field. The index contains a zero-based index, and the value contains the value in the input field
QUERY_STRING_TO_RECORD	Extracts data from a query string
RECORD_TO_JSON	Converts the record containing the field to a JSON string
SORT_BY	Sorts the values array by the sortKeys array
TO_ARRAY	Outputs all the values from all the inputs as an array
ZIP	Combines multiple arrays by index into records
ZIP_WITH_INDEX	Combines multiple arrays by index into records

--- # Agent Instructions This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com. ## Querying This Documentation If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question. Perform an HTTP GET request on the current page URL with the `ask` query parameter, and the optional `goal` query parameter: ``` GET https://upsolver.gitbook.io/content/reference-1/functions-and-operators/functions/structural.md?ask=&goal= ``` `ask` is the immediate question: it should be specific, self-contained, and written in natural language. `goal` is optional and describes the broader end goal you are ultimately trying to accomplish on behalf of the user. GitBook uses it to tailor the answer towards what is most useful for that goal. The response will contain a direct answer to the question and relevant excerpts and sources from the documentation. Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.