---
title: "DEPRECATED Check the extraction tables a recipe reads"
method: GET
path: "/api/v3/automated-recipes/{recipe_id}/extractions/"
tags: ["Recipes"]
deprecated: true
---

# DEPRECATED Check the extraction tables a recipe reads

`GET /api/v3/automated-recipes/{recipe_id}/extractions/`

## Request

- Base URL: `https://embedded.improvado.io`
- URL: `https://embedded.improvado.io/api/v3/automated-recipes/{recipe_id}/extractions/`
- Auth: one of:
  - HTTP bearer
  - API key in cookie `dts_session_id`
- TypeScript: <https://skmtc.dev/improvado/apis/improvado-embedded-api-v3/docs/api/v3/automated-recipes/:recipe_id/extractions/get.ts> (a function with typed inputs; its response is checked against the schema)

> **Deprecated.**

Deprecated: use [`GET /api/v3.1/automated-recipes/{recipe_id}/extractions/`](/api/automated-recipes#check-recipe-extraction-tables). This version stays available until it is switched off; see [Moving recipes to v3.1](/recipes-migration).

When the recipes service fails, this version answers `500` with an HTML page, and an error in the `4xx` range can arrive with a body that is not JSON. It also repeats the request to the recipes service up to three times, create included, so a create can run twice. v3.1 does neither: every error is `{code, message, details}`, and a request is repeated only when it provably never reached the service.

Reports the extraction tables the recipe reads and whether each one already exists in the workspace destination. Use it to decide when a build that failed for missing data is worth repeating: once every `table_exists` is true, the build can be started again.

The tables come from the cells of the recipe and of the intermediate recipes it is built on, narrowed to the selected data sources. The extraction ids are the ones the last build used - created or reused - so they are empty before the first build. Nothing here is cached - every call queries the destination once.

`ready` is true when every listed table exists. A recipe whose cells reference no extraction tables answers with `ready: false` and an empty `sources` list. A table exists once the first account's rows land in it, so `ready` does not mean that every account has delivered, and it can be true while the recipe is still `Extracting Data`; the recipe `state` is the readiness signal.

## Path parameters

- `recipe_id` string, required

## Response `200`

The extraction tables the recipe reads

- AutomatedRecipeExtractions: The extraction tables an automated recipe reads, and whether they exist yet
  - `ready` boolean: True when every table in `sources` exists in the destination. Not a sign that every account has delivered - see the recipe `state`.
  - `sources` AutomatedRecipeSourceExtractions[]: One entry per extraction table the recipe reads, sorted by table name. A data source with more than one table appears once per table, so `data_source` is not unique - key this list by `table`. Empty when the recipe's cells reference no extraction tables.
    - `data_source` string: Data source name, e.g. `facebook`
    - `table` string: Name of the extraction table in the workspace destination
    - `table_exists` boolean: Whether that table exists in the destination right now
    - `extraction_ids` integer[]: Extractions the last build used for this data source - the ones it created and the existing ones it reused, including any it did not wait for. Repeated on every table of the same data source, and empty before the first build.

## Other responses

- `401`: Forbidden
- `403`: The embedded API is not enabled for this agency, or the recipe belongs to another workspace, or to another agency. The three answer with different `detail` strings.
- `404`: Not Found
- `501`: The workspace destination does not support checking whether a table exists.
- `503`: The destination could not be queried, or the workspace has no active destination. A failure is never reported as `table_exists: false`.

---

[API](https://skmtc.dev/improvado/apis/improvado-embedded-api-v3.md) - [All operations](https://skmtc.dev/improvado/apis/improvado-embedded-api-v3/llms.txt) - [OpenAPI document](https://skmtc.dev/improvado/apis/improvado-embedded-api-v3/revisions/a881099bd6c4?raw)