The most recent content from our members.
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…
Hello Community, I'm currently working with the DAP CLI tool to import Canvas Data 2 into a database, but I'm running into an issue where the tables and column headers are created successfully but the table rows remain empty. This is after running the “initdb” command (dap initdb --namespace canvas --table TABLENAME). I am…
Has anyone run into any issues running Data 1 and Data 2 APIs on the same server? We use the CLI tool to pull tables from Data 1 nightly. We want to begin testing the process using Data 2 but want to make sure we won't be causing any issues by having both running on the same server.
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.