---
title: "AdminEmailsByAction (Discourse)"
description: "itgen_dce_adminemailsbyaction_plural"
language: en
source_language: en
translation_state: complete
canonical: https://documentation.invantive.eu/en/datamodels/discourse/Discourse.Emails.AdminEmailsByAction
original: https://documentation.invantive.eu/en/datamodels/discourse/Discourse.Emails.AdminEmailsByAction
updated: 2026-11-01T16:08:49Z
license: https://documentation.invantive.eu/en/
---

# AdminEmailsByAction: Discourse itgen_dce_adminemailsbyaction_plural

`read only` `REST`

- Catalog: `Discourse`
- Schema: `Emails`
- Label: itgen_dce_adminemailsbyaction_plural

get a list of emails

Can only retrieve data.

## Summary

get a list of emails

## API Source

- Endpoint: `/admin/emails/{action}.json`
- Operation: `get /admin/emails/{action}.json`

## Performance Characteristics

| Characteristic | Value |
|---|---:|
| Average access latency (ms) | 243 |
| Write rows per minute | 219 |

The result can be cached on the client.

## Parameters

| Name | Data Type | Required | Default | Documentation |
|---|---|:---:|---|---|
| `action` | `` | [x] |  | Values: sent, skipped, bounced, received, rejected. |
| `offset` | `` | [ ] |  |  |

## Table Columns

The columns of the table `AdminEmailsByAction` are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update.

| Name | Data Type | Label | Required | Marks | Documentation |
|---|---|---|:---:|---|---|
| `bounced` | `char` | Bounced | [ ] | filters on the platform, writable, `bounced` |  |
| `created_at` | `varchar2` | Created at | [ ] | filters on the platform, writable, `created_at` |  |
| `email_type` | `varchar2` | Email Type | [ ] | filters on the platform, writable, `email_type` |  |
| `id` | `int64` | ID | [ ] | filters on the platform, writable, `id` |  |
| `reply_key` | `varchar2` | Reply Key | [ ] | filters on the platform, writable, `reply_key` |  |
| `skipped` | `char` | Skipped | [ ] | filters on the platform, writable, `skipped` |  |
| `to_address` | `varchar2` | To Address | [ ] | filters on the platform, writable, `to_address` |  |
| `user` | `varchar2` | itgen_dce_user | [ ] | writable | The JSON text of the nested object. |
| `user_id` | `int64` | User ID | [ ] | filters on the platform, writable, `user_id` |  |



## Release Notes

What changed per release in the tables, columns, attributes and capabilities of the driver:

- [Discourse](/en/release-notes/drivers?driver=discourse)

### Changes of This Table, 26.0 to 27.0

<div class="rn-item" id="DCE-27.0-D016">

##### Table function Discourse.Emails.AdminEmailsByAction is removed

A statement that reads Discourse.Emails.AdminEmailsByAction fails after the upgrade. It had 9 columns. The operation is not in the updated Discourse specification, or has another name.

<div class="rn-action">

**What to Do**

Check statements, views and scripts that use it before the upgrade.

</div>

<div class="rn-chips">

- **can break a statement**
- importance 5

</div>

</div>

[All changes of the driver, 26.0 to 27.0](/en/release-notes/drivers?driver=discourse&step=26.0-to-27.0#discourse-26.0-to-27.0)

