Hi @altotus! So I'm nowhere near a full time developer myself, yet I've been able to do a lot with the help of online documentation and, believe it or not, Chat GPT on Open AI which is excellent at helping to develop and debug code.
I'm given to understand that in working with APIs in general, there are a variety of options in terms of programming languages and environments you can use. I administer a lot of Windows-based systems, so I opted to use the same tool we use to automate Windows administration tasks—PowerShell—because it's what I'm most familiar with these days.
My first PowerShell script was about 80 lines and accomplished exactly what I wanted it to do. But it would only ever do that one thing and nothing else. It took maybe 6 hours altogether to get it working. My latest version of the script is closer to 800 lines and leverages the Canvas API in a variety of ways. I've spent way more hours developing it than I'm going to save through its automation this semester, but it will end up saving me at least 2+ hours per week over the next few years (along with the associated eye strain and wrist strain). Moreover, my gradebooks will always be consistently updated, providing better feedback for my students, which I'm betting will decrease attrition, which is good for everyone.
Ultimately, though, I would only tackle this project if learning how to code is something you want to do in and of itself. Working with the Canvas API to automate tasks in your gradebooks is a great project and goal-oriented way to learn this skill. Otherwise, just wait a few weeks (or perhaps until the beginning of next semester) and I'll likely be able to share a general-use script on Github 🙂