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

# Route Merge

`GET /calcs/merge.{extension}`

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/fastapi.md) · [All operations](https://skmtc.dev/datausa/apis/fastapi/llms.txt) · [OpenAPI document](https://skmtc-service-production.skmtc.workers.dev/v1/apis/datausa/fastapi/revisions/6d014a4f1cd1/schema)