Ready-made query examples for the checkpoint assessments 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 Checkpoint assessments feed reference.
Replace yourtenant with your tenant name and YOUR_API_KEY with your API key in every example.
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/CheckpointAssessments 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 completed checkpoints |
|
See checkpoints for a specific programme |
|
See checkpoints with a score of 80 or above |
|
See checkpoints expiring this month |
|
See the 20 most recently completed |
|
Count all completed checkpoints |
|
Return only key 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 completed checkpoints, most recent first
Returns checkpoints that learners have completed, sorted by completion date. Useful for tracking assessment throughput.
Browser URL:
https://yourtenant.aptem.co.uk/odata/2.0/CheckpointAssessments?$filter=Status eq 'Completed'&$orderby=CompletedDate desc&$select=CheckpointName,LearnerUniqueId,ProgrammeId,Score,QuestionsCount,CorrectAnswersCount,CompletedDate
Excel Power Query:
let Source = OData.Feed( "https://yourtenant.aptem.co.uk/odata/2.0/CheckpointAssessments?$filter=Status eq 'Completed'&$orderby=CompletedDate desc&$select=CheckpointName,LearnerUniqueId,ProgrammeId,Score,QuestionsCount,CorrectAnswersCount,CompletedDate", [#"X-API-Token"="YOUR_API_KEY"], [Implementation="2.0"] ) in Source
High-scoring checkpoints
Returns completed checkpoints with a score of 80 or above. Useful for identifying learners who are performing well.
Browser URL:
https://yourtenant.aptem.co.uk/odata/2.0/CheckpointAssessments?$filter=Status eq 'Completed' and Score ge 80&$select=CheckpointName,LearnerUniqueId,Score,CorrectAnswersCount,QuestionsCount,CompletedDate&$orderby=Score desc
Excel Power Query:
let Source = OData.Feed( "https://yourtenant.aptem.co.uk/odata/2.0/CheckpointAssessments?$filter=Status eq 'Completed' and Score ge 80&$select=CheckpointName,LearnerUniqueId,Score,CorrectAnswersCount,QuestionsCount,CompletedDate&$orderby=Score desc", [#"X-API-Token"="YOUR_API_KEY"], [Implementation="2.0"] ) in Source
Low-scoring checkpoints
Returns completed checkpoints with a score below 50. Useful for identifying learners who may need additional support.
Browser URL:
https://yourtenant.aptem.co.uk/odata/2.0/CheckpointAssessments?$filter=Status eq 'Completed' and Score lt 50&$select=CheckpointName,LearnerUniqueId,ProgrammeId,Score,CorrectAnswersCount,QuestionsCount,CompletedDate&$orderby=Score
Excel Power Query:
let Source = OData.Feed( "https://yourtenant.aptem.co.uk/odata/2.0/CheckpointAssessments?$filter=Status eq 'Completed' and Score lt 50&$select=CheckpointName,LearnerUniqueId,ProgrammeId,Score,CorrectAnswersCount,QuestionsCount,CompletedDate&$orderby=Score", [#"X-API-Token"="YOUR_API_KEY"], [Implementation="2.0"] ) in Source
Checkpoints for a specific programme
Returns all checkpoints for a single programme across all learners and statuses. Replace 4501 with the programme ID.
Browser URL:
https://yourtenant.aptem.co.uk/odata/2.0/CheckpointAssessments?$filter=ProgrammeId eq 4501&$orderby=CompletedDate desc
Excel Power Query:
let Source = OData.Feed( "https://yourtenant.aptem.co.uk/odata/2.0/CheckpointAssessments?$filter=ProgrammeId eq 4501&$orderby=CompletedDate desc", [#"X-API-Token"="YOUR_API_KEY"], [Implementation="2.0"] ) in Source
Checkpoints expiring soon
Returns checkpoints with an end date within the next 30 days. Useful for flagging learners who need to complete their checkpoint before it expires. Adjust the dates to match your reporting period.
Browser URL:
https://yourtenant.aptem.co.uk/odata/2.0/CheckpointAssessments?$filter=Status ne 'Completed' and CheckpointEndDate ge 2026-08-25T00:00:00Z and CheckpointEndDate lt 2026-09-25T00:00:00Z&$select=CheckpointName,LearnerUniqueId,ProgrammeId,Status,CheckpointEndDate&$orderby=CheckpointEndDate
Excel Power Query:
let Source = OData.Feed( "https://yourtenant.aptem.co.uk/odata/2.0/CheckpointAssessments?$filter=Status ne 'Completed' and CheckpointEndDate ge 2026-08-25T00:00:00Z and CheckpointEndDate lt 2026-09-25T00:00:00Z&$select=CheckpointName,LearnerUniqueId,ProgrammeId,Status,CheckpointEndDate&$orderby=CheckpointEndDate", [#"X-API-Token"="YOUR_API_KEY"], [Implementation="2.0"] ) in Source
Recently created checkpoints (last 30 days)
Returns checkpoints 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/CheckpointAssessments?$filter=CreatedDate ge 2026-07-25T00:00:00Z&$orderby=CreatedDate desc&$select=CheckpointName,LearnerUniqueId,ProgrammeId,CheckpointType,Status,CreatedDate
Excel Power Query:
let Source = OData.Feed( "https://yourtenant.aptem.co.uk/odata/2.0/CheckpointAssessments?$filter=CreatedDate ge 2026-07-25T00:00:00Z&$orderby=CreatedDate desc&$select=CheckpointName,LearnerUniqueId,ProgrammeId,CheckpointType,Status,CreatedDate", [#"X-API-Token"="YOUR_API_KEY"], [Implementation="2.0"] ) in Source
Periodic checkpoints only
Returns only checkpoints generated on a periodic schedule. Replace 'PeriodicGeneration' with the checkpoint type you want to filter by.
Browser URL:
https://yourtenant.aptem.co.uk/odata/2.0/CheckpointAssessments?$filter=CheckpointType eq 'PeriodicGeneration'&$orderby=CreatedDate desc&$select=CheckpointName,LearnerUniqueId,Status,Score,CreatedDate,CompletedDate
Excel Power Query:
let Source = OData.Feed( "https://yourtenant.aptem.co.uk/odata/2.0/CheckpointAssessments?$filter=CheckpointType eq 'PeriodicGeneration'&$orderby=CreatedDate desc&$select=CheckpointName,LearnerUniqueId,Status,Score,CreatedDate,CompletedDate", [#"X-API-Token"="YOUR_API_KEY"], [Implementation="2.0"] ) in Source
All checkpoints with a count of total results
Returns all checkpoints 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/CheckpointAssessments?$count=true&$orderby=CreatedDate desc
Excel Power Query:
let Source = OData.Feed( "https://yourtenant.aptem.co.uk/odata/2.0/CheckpointAssessments?$count=true&$orderby=CreatedDate desc", [#"X-API-Token"="YOUR_API_KEY"], [Implementation="2.0"] ) in Source
Next steps
For the full field reference and join information, see the Checkpoint assessments feed reference.
For report-building guides that combine v2 data with v1 feeds in Excel, see:
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