[ARCHIVED] [ARCHIVED] Can we add the LTI user_id field to the data dump?

[phil_mcgachey]

We use a number of third-party and in-house LTI tools to provide specialized functionality within Canvas. Some of these tools collect analytic data that we'd like to correlate to our Canvas (and other) data sets. Unfortunately, not all tools record the lis_person_sourcedid or custom_canvas_login_id which contain values that we could map back to our own systems.

It'd be a big help to us if one of the Canvas Data tables included the hash value that gets passed to an LTI provider in the user_id field. From a quick pass over the Canvas code, it looks like this is the value in the Canvas user table, column lti_context_id.

Thanks,

Phil

[cward]

 @phil_mcgachey ​,

To make sure I understand this correctly, you'd be able to track LTI usage back to Canvas if we were to add lti_context_id to the user_dim table in Canvas Data?

[phil_mcgachey]

Hi, Chris

That's right - thanks.

Phil

[James]

 @phil_mcgachey ‌,

I know this isn't exactly what you wanted, but the https://community.canvaslms.com/docs/DOC-8833-canvas-beta-release-notes-2017-02-06  say that they've added this information to the regular Canvas API. I checked it on the beta instance and it does appear.

[phil_mcgachey]

Hi, James

Thanks for flagging the update - I'd missed it in the release notes. Pulling data into our pipeline from the API's quite a bit slower than using the data files, but having the field available anywhere's going to be a huge help to us.

Phil