---
title: "Cross file lookup"
method: POST
path: "/lookup/{handle}/{col}"
tags: ["data"]
---

# Cross file lookup

`POST /lookup/{handle}/{col}`

This endpoint returns a Json response acknowledging if the lookup was successful.

## Path parameters

- `handle` string, required
- `col` string, required

## Request body

- LookupRequest
  - `matchConditions` LookupMatchConditions
    - `caseInsensitive` boolean
    - `ignorePunctuation` boolean
    - `ignoreWhitespace` boolean
  - `referenceFile` LookupReferenceFile, required
    - `additionalColumns` string[]
    - `column` string
    - `handle` string
    - `useSort` boolean
  - `returnAllMatches` boolean

## Response `200`

OK

- unknown

## Other responses

- `400` — Bad Request
- `500` — Internal Server Error

---

[API](https://skmtc.net/freshdesk/apis/gigasheet-api.md) · [All operations](https://skmtc.net/freshdesk/apis/gigasheet-api/llms.txt) · [OpenAPI document](https://skmtc-service-staging.skmtc.workers.dev/v1/apis/freshdesk/gigasheet-api/versions/d1e5cbb24557/schema)