---
title: "Join multiple queries"
method: POST
path: "/tesseract/multiquery.{extension}"
tags: ["TesseractModule"]
---

# Join multiple queries

`POST /tesseract/multiquery.{extension}`

## Request

- Base URL: `https://api.datausa.io` (the document declares no server; this is the origin it was published from)
- URL: `https://api.datausa.io/tesseract/multiquery.{extension}`
- Auth: none declared

Execute a request for joining data from the server.

## Path parameters

- `extension` 'csv' | 'csvbom' | 'xlsx' | 'jsonarrays' | 'jsonrecords' | 'parquet' | 'tsv' | 'tsvbom', required: Define the extensions available to the user and how to response to them.

## Query parameters

- `token` string, nullable

## Headers

- `authorization` string, nullable
- `x-tesseract-jwt` string, nullable

## Request body

- DataMultiRequest
  - `requests` DataRequest[], required
    - `cube` string, required
    - `drilldowns` string[], required
    - `measures` string[], required
    - `aliases` object
    - `captions` string[]
    - `cuts` object
    - `filters` object
    - `locale` string, nullable
    - `options` object
    - `pagination` PaginationIntent: Pagination instructions.
      - `limit` integer
      - `offset` integer
    - `parents` union
      - boolean
      - string[]
    - `properties` string[]
    - `ranking` union
      - boolean
      - object
    - `roles` string[]
    - `sorting` SortingIntent: Sorting instructions for internal use.
      - `field` string, required
      - `order` union, required
        - 'asc' | 'desc'
        - 'asc' | 'desc': Defines a direction to use in a sorting operation.
    - `sparse` boolean
    - `time_restriction` TimeRestriction: Time-axis filtering instructions for internal use. Instances of this class are used to define a time restriction over the resulting data. It must always contain both fields.
      - `level` string, required
      - `constraint` union, required
        - unknown[]
          - unknown
        - unknown[]
          - unknown
        - unknown[]
          - unknown
        - unknown[]
          - unknown
    - `topk` TopkIntent: Limits the results to the K first/last elements. The subsets are determined by one or more levels and their associated value. The result dataset adds a new column that indicates the position of each element in that ranking.
      - `levels` string[], required
      - `measure` string, required
      - `order` union
        - 'asc' | 'desc'
        - 'asc' | 'desc': Defines a direction to use in a sorting operation.
      - `amount` integer
    - `growth` GrowthIntent: Calculation of growth with respect to a time parameter and a measure.
      - `time_level` string, required
      - `measure` string, required
      - `method` union
        - unknown[]
          - unknown
        - unknown[]
          - unknown
        - unknown[]
          - unknown
      - `filter` boolean
  - `joins` JoinIntent[]
    - `on` union
      - string
      - string[]
      - JoinOnColumns: Columns to use for a Join operation.
        - `left_on` union, required
          - string
          - string[]
        - `right_on` union, required
          - string
          - string[]
    - `how` 'inner' | 'left' | 'right' | 'full' | 'semi' | 'anti' | 'cross': Defines the different types of join operations available to the user.
    - `suffix` string, nullable
    - `validate_relation` 'm:m' | 'm:1' | '1:m' | '1:1'
    - `join_nulls` boolean
    - `coalesce` boolean, nullable
  - `pagination` PaginationIntent: Pagination instructions.
    - `limit` integer
    - `offset` integer

## Response `200`

Successful Response

- unknown

## Other responses

- `422`: Validation Error

## Changes

- **2026-10-27** `433b34956d9c`: 4 breaking, 5 info
  - removed `#/components/schemas/TimeScale, subschema #1` from the `requests/items/time_restriction/anyOf[subschema #1: TimeRestriction]/level` request property `anyOf` list
  - removed `subschema #1, subschema #2, subschema #3, subschema #4, subschema #5` from the `requests/items/filters/additionalProperties/condition` request property `anyOf` list
  - removed `subschema #3` from the `requests/items/time_restriction/anyOf[subschema #1: TimeRestriction]/constraint` request property `anyOf` list
  - the `requests/items/time_restriction/anyOf[subschema #1: TimeRestriction]/level` request property type changed from no type to `string`
  - …5 more

[Operation history](https://skmtc.dev/datausa/apis/datausa-api/changes/tesseract/multiquery.:extension/post.md)

---

[API](https://skmtc.dev/datausa/apis/datausa-api.md) - [All operations](https://skmtc.dev/datausa/apis/datausa-api/llms.txt) - [OpenAPI document](https://skmtc.dev/datausa/apis/datausa-api/revisions/433b34956d9c?raw)