Actions97
- Campaign Actions
- Campaign Contact Actions
- Category Actions
- Company Actions
- Company Contact Actions
- Contact Actions
- Contact Segment Actions
- Email Actions
- Field Actions
- Note Actions
- Notification Actions
- Role Actions
- Segment Actions
- Segment Email Actions
- Stats Actions
- Tag Actions
- Theme Actions
- User Actions
Stats → Get Stats
AI-generatedSummary
Retrieve rows from a selected Mautic statistics table, optionally filtering, sorting, and paginating the results.
Inputs
- authentication (required) — Choose Credentials or OAuth2 authentication.
- table (required) — Statistics table to query, such as Email Stats (
email_stats), Page Hits (page_hits), or Form Submissions (form_submissions). - returnAll — When enabled, retrieve all available matching rows; otherwise, cap the result using Limit.
- limit — Maximum number of rows to return when Return All is disabled; defaults to 50.
- orderBy — Column used to sort results; defaults to
id. - orderByDir — Sort direction, ascending or descending; defaults to ascending.
- start — Row offset to begin at; defaults to 0.
- where — JSON array of conditions to filter rows. Supports
eq,neq,gt,gte,lt,lte,like,notLike,in,notIn,isNull, andisNotNullexpressions.
Output shape
A list of row items from the selected table.
The result is limited by Limit unless Return All is enabled. Start sets the row offset; ordering and where conditions are passed as query options.