Descriptions/codes for numbers in the web_logs.web_application_action column?

Hello -

I am trying to decipher the web_application_action column in the web_logs table. Per the schema, the integers returns should be referring to "The action in the Canvas web application used to service this request."

I can not find any reference for what these numbers actually mean, either in the DAP documentation or the schema details, and in the Entity Relationship diagram all it connects to is "canvas_logs.Action" which doesn't tell me anything either.

Does anyone know where I can find this information?

Find more posts tagged with

Accepted answers

KristineRoshau

Hi @mclark19,

Thank you! This set me in the right direction. I double checked the datatype in my DB and it was indeed set to INT; however, what I hadn't looked at before were the two other tables that were generated when I initialized the database: web_logs__web_application_controller and web_logs__web_application_action. It appears the codes mapping numbers (id, integer) to the text strings (value, character varying(64)) are in there.

I'm new to this so perhaps this is expected behavior, but when I initially changed the data type for those columns to text and tried to resync, it failed when attempting to recreate those two columns in the export. I ended up having to strip the collation then reconvert the columns back to data type INT before I could resync at all, but at least now I can reference the values in those other two tables.

Kristine

All comments

IanGoh

Yeah, I don't even see Action as a table I can get from the canvas_logs namespace.

mclark19

Hi @KristineRoshau -- Are you saying that the data in your "web_application_action" column in the "web_logs" table are integers and not strings? Could that be a data processing error? Our data for that field are all strings ("get_custom_colors", "unread_count", "grade_summary", "image_thumbnail", api_show", etc.). There are 420 distinct values of those strings for that column in our data, not any numbers.

Best,

Martyn

KristineRoshau

Hi @mclark19,

Kristine

Unanswered Questions

EDUCAUSE Insights: Data and Decision-Making
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,…
Problems with GraphQL in User Pageviews reports
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…
Metrics Easy Button
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…
Analytics API / Metrics calculation logic
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…
CD2: Enhanced Rubrics
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