> ## Documentation Index
> Fetch the complete documentation index at: https://www.marqeta.com/docs/llms.txt
> Use this file to discover all available pages before exploring further.

# Core API Transaction Token

> Use this view endpoint to associate the Core API Transaction Token with the DiVA Reports Transaction Token.

export const EndpointCard = ({method = "API", title, children, href, arrow = true}) => {
  const METHOD_STYLES = {
    GET: {
      bg: "mint-bg-green-400/20 dark:mint-bg-green-400/20",
      text: "mint-text-green-700 dark:mint-text-green-400",
      border: "mint-border-green-300 dark:mint-border-green-700"
    },
    POST: {
      bg: "mint-bg-blue-400/20 dark:mint-bg-blue-400/20",
      text: "mint-text-blue-700 dark:mint-text-blue-400"
    },
    PUT: {
      bg: "mint-bg-yellow-400/20 dark:mint-bg-yellow-400/20",
      text: "mint-text-yellow-700 dark:mint-text-yellow-400"
    },
    PATCH: {
      bg: "mint-bg-orange-400/20 dark:mint-bg-orange-400/20",
      text: "mint-text-orange-700 dark:mint-text-orange-400"
    },
    DELETE: {
      bg: "mint-bg-red-400/20 dark:mint-bg-red-400/20",
      text: "mint-text-red-700 dark:mint-text-red-400"
    },
    API: {
      bg: "mint-bg-black",
      text: "mint-text-white"
    }
  };
  const MethodBadge = ({method}) => {
    const style = METHOD_STYLES[method?.toUpperCase()] ?? METHOD_STYLES.GET;
    return <span className={`
          method-pill rounded-lg font-semibold px-1.5 py-0.5 text-xs leading-5 ${style.bg} ${style.text}`}>
        {method?.toUpperCase()}
      </span>;
  };
  const content = <div className="group flex items-center gap-4 border border-gray-200 dark:border-gray-700 rounded-xl p-5 hover:border-gray-400 dark:hover:border-gray-500 hover:shadow-md transition-all cursor-pointer">
      {}
      <div className="shrink-0">
        <MethodBadge method={method} />
      </div>
      {}
      <div className="flex-1 min-w-0">
        <p className="font-semibold text-gray-900 dark:text-white text-sm leading-snug">{title}</p>
        {children && <p className="mt-1 text-sm text-gray-500 dark:text-gray-400 line-clamp-2">{children}</p>}
      </div>
    </div>;
  if (!href) return content;
  return <a href={href} className="block no-underline border-b-0 mb-2">
      {content}
    </a>;
};

Use this view endpoint to associate the Core API Transaction Token with the DiVA Reports Transaction Token. This endpoint provides a lookup between the two types of tokens, with the Core API Transaction Token derived from webhooks associated with the Core API (see [Transactions](/core-api/transactions/) in the Core API Reference). The `/transactiontoken` endpoint is useful for assisting reconciliation efforts.

This endpoint supports multiple response formats, query filtering, field filtering, sorting, and pagination. For more information about response options, see [Response Customization](/diva-api/response-customization/).

<h2 id="_retrieve_the_core_api_transaction_token_json">
  Retrieve the Core API transaction token (JSON)
</h2>

**Action:** `GET`\
**Endpoint:** `/views/transactiontoken`

Retrieve the Core API transaction token. This endpoint returns a JSON object that contains an array of records matching your filter query.

<h3 id="_sample_response_body">
  Sample response body
</h3>

The following sample shows a representative response for a `GET` request to the `/views/transactiontoken?program=my_program` endpoint.

```json JSON expandable lines wrap theme={null}
{
    "total": 21,
    "is_more": false,
    "count": 21,
    "info": {},
    "start_date": null,
    "end_date": null,
    "last_run_time": "2020-10-12T11:12:13Z",
    "schema": [
        {
            "field": "program",
            "type": "character varying(128)",
            "description": "The name of the card program.",
            "display": "Program",
            "units": null,
            "has_total": false,
            "is_filter_only": false
        },
        {
            "field": "bank",
            "type": "character varying(128)",
            "description": "The bank under which the program operates.",
            "display": "Bank",
            "units": null,
            "has_total": false,
            "is_filter_only": false
        },
        {
            "field": "core_api_transaction_token",
            "type": "character varying(36)",
            "description": null,
            "display": "Core Api Transaction Token",
            "units": null,
            "has_total": false,
            "is_filter_only": false
        },
        {
            "field": "transaction_token",
            "type": "character varying(128)",
            "description": "The token of the transaction; unique within a program.",
            "display": "Transaction Token",
            "units": null,
            "has_total": false,
            "is_filter_only": false
        },
        {
            "field": "transaction_timestamp",
            "type": "timestamp without time zone",
            "description": "The date and time when a transaction occurred. Displayed in UTC.",
            "display": "Transaction Timestamp",
            "units": null,
            "has_total": false,
            "date_format": "YYYY-MM-DD",
            "is_filter_only": false
        }
    ],
    "records": [
        {
            "program": "my_program",
            "bank": "bank_name",
            "core_api_transaction_token": "665z2647-683f-44ba-aa0a-e93ebe457990",
            "transaction_token": "e50b74c3-92c2-99e4-9e1h-30eadaz1a999",
            "transaction_timestamp": "2020-09-12",
        },
        {
            "program": "my_program",
            "bank": "bank_name",
            "core_api_transaction_token": "665z2647-683f-44ba-aa0a-e93ebe457990",
            "transaction_token": "e50b74c3-92c2-99e4-9e1h-30eadaz1a999",
            "transaction_timestamp": "2020-09-12",
        },

        ...

        {
            "program": "my_program",
            "bank": "bank_name",
            "core_api_transaction_token": "665z2647-683f-44ba-aa0a-e93ebe457990",
            "transaction_token": "e50b74c3-92c2-99e4-9e1h-30eadaz1a999",
            "transaction_timestamp": "2020-09-12",
        }
    ]
}
```

<h2 id="_retrieve_the_core_api_transaction_token_file_export">
  Retrieve the Core API transaction token (file export)
</h2>

**Action:** `GET`\
**Endpoint:** `/views/transactiontoken/{export_type}`

Retrieve transactiontoken information. This endpoint asynchronously generates a file in the specified format and returns a job token for retrieving the file when it is completed. The file contains a list of records matching your filter query.

<h3 id="_url_path_parameters">
  URL path parameters
</h3>

| Fields                                       | Description                                                                              |
| -------------------------------------------- | ---------------------------------------------------------------------------------------- |
| export\_type<br /><br />string<br />Required | File format in which to export the data.<br /><br />**Allowable Values:**<br /><br />csv |

<h3 id="_query_parameters">
  Query parameters
</h3>

| Fields                                   | Description                                                                                                                               |
| ---------------------------------------- | ----------------------------------------------------------------------------------------------------------------------------------------- |
| compress<br /><br />string<br />optional | Type of file compression for the exported file.<br /><br />**Allowable Values:**<br /><br />gz, zip<br /><br />**Default value:**<br />gz |

<h3 id="_sample_response_body_2">
  Sample response body
</h3>

```json JSON lines wrap theme={null}
{
    "token": "111122225b444d8888888a9999ae11111db63da4.csv.gz"
}
```

<h2 id="_retrieve_core_api_transaction_token_schema">
  Retrieve Core API transaction token schema
</h2>

**Action:** `GET`\
**Endpoint:** `/views/transactiontoken/schema`

Retrieve a JSON representation of the transactiontoken schema. The schema object contains an array of objects that describe the available columns and the data type of each column.

<h3 id="_sample_response_body_3">
  Sample response body
</h3>

The following sample shows a representative response for a `GET` request to the `/views/transactiontoken/schema?program=my_program` endpoint. The schema can vary based on the data you are authorized to access (based on the credentials you provide in your request).

```json JSON expandable lines wrap theme={null}
[
    {
        "field": "program",
        "type": "character varying(128)",
        "description": "The name of the card program.",
        "display": "Program",
        "units": null,
        "has_total": false,
        "is_filter_only": false
    },
    {
        "field": "bank",
        "type": "character varying(128)",
        "description": "The bank under which the program operates.",
        "display": "Bank",
        "units": null,
        "has_total": false,
        "is_filter_only": false
    },
    {
        "field": "core_api_transaction_token",
        "type": "character varying(36)",
        "description": null,
        "display": "Core Api Transaction Token",
        "units": null,
        "has_total": false,
        "is_filter_only": false
    },
    {
        "field": "transaction_token",
        "type": "character varying(128)",
        "description": "The token of the transaction; unique within a program.",
        "display": "Transaction Token",
        "units": null,
        "has_total": false,
        "is_filter_only": false
    },
    {
        "field": "transaction_timestamp",
        "type": "timestamp without time zone",
        "description": "The date and time when a transaction occurred. Displayed in UTC.",
        "display": "Transaction Timestamp",
        "units": null,
        "has_total": false,
        "date_format": "YYYY-MM-DD",
        "is_filter_only": false
    }
]
```