How do I embed id dynamically in Canvas API while fetching assignments

Anonymous_user
Community Member

I am trying to pull all assignments via Jitterbit tool using API call. What is want is to pull all users first then see the courses a user is involved in, then fetch all the assignments submitted by that user for each individual course. 

 

The url to call assignments is 

GET   /api/v1/users/:user_id/courses/:course_id/assignments

 

I want to dynamically populate userid, and course id. So first it should traverse all the users in canvas then find out courses for those users and ultimately assignments for those courses. I want to ultimately load all this data to Salesforce. 

Is there a way to achieve this functionality by calling dynamic canvas api in jitterbit and then send it to salesforce? 

If its not possible via API, is there a way I can run query on the canvas app, and nested queries and fetch data? Need some guidance.

0 Likes