---
title: "Route Merge"
method: GET
path: "/calcs/merge.{extension}"
tags: ["CalculationsModule"]
---

# Route Merge

`GET /calcs/merge.{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/calcs/merge.{extension}`
- Auth: none declared

Merge endpoint.

## 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

- `params` MergeParameters, required: Parameters needed to perform a PUMS calculation.
  - `cube_left` string, required: Cube to retrieve part of the data
  - `drilldowns_left` string[], required: A list of the level names to slice the bulk of the aggregated data.
  - `measures_left` string[], required: Quantitative variable
  - `include_left` object: Limits the results returned by the output. Only members of the declared Level will be considered in the data.
  - `exclude_left` object: Limits the results returned by the output. Members of the declared Level won't be considered in the data.
  - `cube_right` string, required: The cube to retrieve the main data
  - `drilldowns_right` string[], required: Cube to retrieve part of the data
  - `measures_right` string[], required: Quantitative variable
  - `include_right` object: Limits the results returned by the output. Only members of the declared Level will be considered in the data.
  - `exclude_right` object: Limits the results returned by the output. Members of the declared Level won't be considered in the data.
  - `time` string, nullable: Specifies the time period to filter the data by
  - `locale` string, nullable: Defines the locale variation for the labels in the data
- `token` string, nullable
- `filters` string
- `top` string

## Headers

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

## Response `200`

Successful Response

- unknown

## Other responses

- `422`: Validation Error

---

[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)