Get Same "Current Term" as API Using SQL To Canvas Data

[brett_sheeran]

I'm currently attempting to port some in-house code from using the the API to Canvas Data SQL queries.

My problem if finding the the same "current term" as determined in API an using SQL query.

If I use this query,
select * from enrollment_term_dim;

I can see that for today, (2014-04-30) the current term ID is 32760000000000050.

However, when I run the following query to find a user's courses, I get 0 results.

select c.id, c.canvas_id, c.name, c.code, c.start_at, c.conclude_at, c.workflow_state from enrollment_dim e join course_dim c where e.user_id = 174440267134376236 and e.workflow_state = 'active' and e.course_id = c.id and c.enrollment_term_id = 32760000000000050;

Whereas, if I run the same query for the previous term of 32760000000000049 (which finished 2018-04-13) I see the same courses as returned thru the API request like this:

.../users/id_type:id/courses?access_token=XXX

All I want to do is be consistent with the API

Any suggestions?

Thanks.

Regards

Brett S

[James]

 @brett_sheeran , 

Is your user a student or someone else? I ask because I ran into an issue that I contacted Canvas support about as a bug report. They came back that it was the expected behavior.

I was getting current courses through the API for terms that had already ended. It turned out that as an instructor, I had access to the courses that had ended for students. In our Terms page in the Account Settings page, faculty were given extra access.

Here's what it looks like for us this term.

That means that my Spring 2018 classes are going to show up as current until July 31.

[brett_sheeran]

Hi James,

Thanks for the quick reply.:-)

The user I'm querying is a student although, the system I'm refactoring is used by staff too.

Cheers

Brett

[sam_mcknight]

When was the user added to the course? I ask because Canvas Data is 24-36 hours older than the production system via the API. If you are querying a current semester, it's possible the user was recently added and hasn't made it to the Canvas Data export yet.