> ## Documentation Index
> Fetch the complete documentation index at: https://help.impactu.colav.co/llms.txt
> Use this file to discover all available pages before exploring further.

# APC by affiliation

> Exports a CSV with APC data of the bibliographic products of an institution or research group.

## Path parameters

**affiliation\_id** `string` *required*

Identifier of the institution or group. Examples: `03bp5hc83` (Universidad
de Antioquia), `COL0000000` (research group).

> [!NOTE]
>
> This endpoint returns a CSV file (`Content-Type: text/csv`), not JSON. The name of the downloaded
> file is `affiliation.csv`.

## Response

The response body is a CSV file with the following columns. If the entity doesn't exist or has no products, the file only has the header row.

| Column | Description |
| - | - |
| `work_doi` | DOI of the product. |
| `work_title` | Title of the product. |
| `source_name` | Name of the journal or source. |
| `source_apc_value` | APC cost published by the journal. |
| `source_apc_currency` | Currency of the journal's cost. |
| `work_apc_value` | APC cost actually paid for this product. |
| `work_apc_currency` | Currency of the actual payment. |

> [!NOTE]
>
> The cost and currency fields can be empty when the information is not
> available in the database.

```csv 200 theme={null}
work_doi,work_title,source_name,source_apc_value,source_apc_currency,work_apc_value,work_apc_currency
,Suite de los ensamblajes,,,,,
,Un Si mayor por la paz,,,,,
```


This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.