We would like to obtain the IP address and timezone information related to the submission. However, this data is not available in the CD2 submissions table. How/where can we source this information?
I don't know that you are going to be easily able to get the timezone information related to the submission, as all the timestamps are stored in UTC. Timezones in Canvas are set on users, courses and the like, but I don't think there is anything that looks at the local timezone of wherever the web request is physically coming from (which would never be accurate anyway if a VPN is being used).
If you want the timezone of the user, then you can get that from the time_zone field in the user table.
For the IP address, you are going to have to join data from the web_logs, which will only give the last 30 days - so you will need to extract progressively and save if you really want it. That is going to be an awfully large amount of data to extract just to get an IP address - and I am not sure what you are really going to do with that, since VPNs make the IP address not really reliable for anything.
EDUCAUSE is full of inspiration, whether you’re onsite or following from afar. Join the evolution by sharing what sparks your curiosity, the questions you have, and the insights you discover. We'll learn from each other, expand our networks, and strengthen our Community. Your perspective matters, and the more we share,…
Prompted by the most recent Canvas release notes, we looked into the Page Views feature, and we were happy with the new documented changes. However, we notice that more user actions are done by GraphQL API, which does not provide details in the page view report, either in the GUI or in the CSV file download. We and most…
I am currently teaching five courses this semester with more than 70 students. To track their progress, I currently have to review each course and section individually, which is very time-consuming. Ideally, I would like to consolidate key information for all students into a single Excel file—showing class attendance…
Hello, We are currently using the Analytics API provided in the Instructure Developer Documentation Portal to retrieve certain metrics-related data. We would like to know if it’s possible to replicate these datasets using the Canvas Data Platform (CDP), instead of relying on API calls. For example, could you please advise…
Is there a way to tell via CD2 if a course is using Enhanced Rubrics? I didn't see it in the entity diagram for Rubrics table, but I might have missed something... Thanks Ian
