The most recent content from our members.
Hi everyone, I'm exploring some changes to how the DAP Query API handles schemas, and I want to hear from you before we go too far down any path. Here's the situation. The DAP schema today is fairly sophisticated. It defines specific enum values, type constraints, and so on. That gives you a strong data contract, but it…
Hello, We can't get the assessment_questions or quiz_questions table to finish initializing. The other 6 tables initialized fine and sync daily. We've tried many times to get these two to initialize but on the insert data part they just sit at 0% or sometimes 50%. I've dropped and re-initialized, no luck. Our DAP version…
Hi, We've been having some sync issues in the past 8 hours or so. We're using DAP client, both the CLI and the Python library, and we're getting errors back from the Instructure servers. With the CLI, we're getting errors back for all commands, along with {'message': None} as the Reason: And in the Python library a similar…
I have everything working as I would like. Postgres has all the schema and tables and I can successfully run the syncdb on all the tables in Terminal (I am on a mac). I would like to schedule the syncdb with cron but I have hit a wall. Right now the error is that dap is not available or found. Anyone sucessfully using cron…
I have recently joined as a Senior Product Manager for the Instructure Data & Insights team. I’m overseeing the DAP Query API and the DAP CLI client and library. I look forward to meeting many of you to discuss your data and analytics priorities. As I started to work on shaping the roadmap for these products, I'm eager to…
Hi, Does anyone know a way to find student IDs or user emails from CD2? I have checked users and accounts tables in the canvas namespace - but they don't have "email" column. I only have the primary key of userID and accountID and only their full name. Is there some other place that I should be looking? Thanks Z
We wanted a way to import selected data from selected Canvas tables into a Microsoft SQL Server instance in a way that can be scheduled for automation and required the smallest number of dependencies and tools. Using canvas-data-cli, we were able to accomplish this on a windows server with only node, Powershell, and the…
Overview: Introducing the GA release of the Data Access Platform CLI & Client Library! In this post, we'll walk you through everything you need to know to effectively utilize the Data Access Platform (DAP) CLI. From prerequisites to installation instructions, environment variable setup, and essential commands for seamless…
Good morning folks! After updating to the new stable release of the DAP CLI tool, I was able to smooth out some existing issues which some of you have already experienced: TCI_KEEPIDLE issue was an OS/Python issue "Please use initdb" when trying to use syncdb was corrected by updating to the new stable release of 1.1.0…
Hi - I'm using DAPClient 1,1 and postgres 16 With an incremental query I've discovered we seem to have started losing pseudonym "id"'s. e.g. users.id 2720 has pseudonym.id 2689, but in the pseudonymn table 2689 has been skipped, so has 2693. Confirmed that this relationship does exist in live API. No errors in DAP output…
Sign in to enhance your access to articles, forums, and events—and to participate by sharing insights, engaging in discussions, and connecting with your network of edtech peers.