Ready-made query examples for the actions feed, showing the browser URL and the equivalent Excel Power Query code for each. For an explanation of how query options work, see How to query OData v2 feeds. For field names and types, see the Actions feed reference.
Quick reference
To use URL (browser) queries you will need to log into your Aptem tenant first as this acts as your authenticator to access your Odata v2 feed.
Each query is appended to your feed URL: https://yourtenant.aptem.co.uk/odata/2.0/actions followed by the query string.
For Excel Power Queries replace yourtenant with your tenant name and YOUR_API_KEY with your API key in every example.
I want to... |
Query to append to your feed URL |
|---|---|
See all open actions |
|
See actions due this month |
|
See actions for a specific learner |
|
See overdue open actions |
|
Count completed actions |
|
See the 20 most recently created actions |
|
Return only three fields |
|
Full worked examples
Each example below shows the complete browser URL and the equivalent Excel Power Query code, so you can copy whichever you need.
All overdue open actions with key fields only
Returns open actions where the due date has passed, sorted by due date, showing only the fields you need for a chase list.
Browser URL:
https://yourtenant.aptem.co.uk/odata/2.0/actions?$filter=Status eq 'Open' and DueDate lt 2026-07-27&$select=Id,Action,DueDate,LearnerId,ProgrammeId&$orderby=DueDate
Excel Power Query:
let Source = OData.Feed( "https://yourtenant.aptem.co.uk/odata/2.0/actions?$filter=Status eq 'Open' and DueDate lt 2026-07-27&$select=Id,Action,DueDate,LearnerId,ProgrammeId&$orderby=DueDate", [#"X-API-Token"="YOUR_API_KEY"], [Implementation="2.0"] ) in Source
Actions due this month, sorted by due date
Returns all actions (any status) due within a specific month. Adjust the dates to match the month you need.
Browser URL:
https://yourtenant.aptem.co.uk/odata/2.0/actions?$filter=DueDate ge 2026-07-01 and DueDate lt 2026-08-01&$orderby=DueDate&$select=Id,Action,Status,DueDate,LearnerId
Excel Power Query:
let Source = OData.Feed( "https://yourtenant.aptem.co.uk/odata/2.0/actions?$filter=DueDate ge 2026-07-01 and DueDate lt 2026-08-01&$orderby=DueDate&$select=Id,Action,Status,DueDate,LearnerId", [#"X-API-Token"="YOUR_API_KEY"], [Implementation="2.0"] ) in Source
All actions for a specific learner
Returns all actions for a single learner across all programmes and statuses. Replace 48213 with the learner's ID.
Browser URL:
https://yourtenant.aptem.co.uk/odata/2.0/actions?$filter=LearnerId eq 48213&$orderby=CreatedDate desc
Excel Power Query:
let Source = OData.Feed( "https://yourtenant.aptem.co.uk/odata/2.0/actions?$filter=LearnerId eq 48213&$orderby=CreatedDate desc", [#"X-API-Token"="YOUR_API_KEY"], [Implementation="2.0"] ) in Source
Recently created actions (last 30 days)
Returns actions created in the last 30 days, sorted newest first. Adjust the date to match your reporting period.
Browser URL:
https://yourtenant.aptem.co.uk/odata/2.0/actions?$filter=CreatedDate ge 2026-06-27T00:00:00Z&$orderby=CreatedDate desc&$select=Id,Action,Status,DueDate,LearnerId,CreatedDate
Excel Power Query:
let Source = OData.Feed( "https://yourtenant.aptem.co.uk/odata/2.0/actions?$filter=CreatedDate ge 2026-06-27T00:00:00Z&$orderby=CreatedDate desc&$select=Id,Action,Status,DueDate,LearnerId,CreatedDate", [#"X-API-Token"="YOUR_API_KEY"], [Implementation="2.0"] ) in Source
Completed actions with closure details
Returns completed actions including who closed them and when. Useful for audit or compliance reporting.
Browser URL:
https://yourtenant.aptem.co.uk/odata/2.0/actions?$filter=Status eq 'Completed'&$select=Id,Action,LearnerId,ProgrammeId,DueDate,ClosedDate,ClosedBy&$orderby=ClosedDate desc
Excel Power Query:
let Source = OData.Feed( "https://yourtenant.aptem.co.uk/odata/2.0/actions?$filter=Status eq 'Completed'&$select=Id,Action,LearnerId,ProgrammeId,DueDate,ClosedDate,ClosedBy&$orderby=ClosedDate desc", [#"X-API-Token"="YOUR_API_KEY"], [Implementation="2.0"] ) in Source
Actions not yet required, for a specific programme
Returns actions marked as not required on a specific programme. Replace 312 with the programme ID.
Browser URL:
https://yourtenant.aptem.co.uk/odata/2.0/actions?$filter=Status eq 'NotRequired' and ProgrammeId eq 312&$select=Id,Action,LearnerId,DueDate,UpdatedDate
Excel Power Query:
let Source = OData.Feed( "https://yourtenant.aptem.co.uk/odata/2.0/actions?$filter=Status eq 'NotRequired' and ProgrammeId eq 312&$select=Id,Action,LearnerId,DueDate,UpdatedDate", [#"X-API-Token"="YOUR_API_KEY"], [Implementation="2.0"] ) in Source
All actions with a count of total results
Returns all actions with the total count included in the response. Useful when you need to know the size of the full dataset.
Browser URL:
https://yourtenant.aptem.co.uk/odata/2.0/actions?$count=true&$orderby=CreatedDate desc
Excel Power Query:
let Source = OData.Feed( "https://yourtenant.aptem.co.uk/odata/2.0/actions?$count=true&$orderby=CreatedDate desc", [#"X-API-Token"="YOUR_API_KEY"], [Implementation="2.0"] ) in Source
Next steps
Once you are comfortable querying the actions feed, you can build multi-table reports that combine v2 actions with v1 data:
Getting help
If you have questions about building queries:
Contact your Implementation Consultant if you are still in implementation
Contact your Customer Success Manager if you are a live customer
Raise a support ticket