Concordia Data Extraction with API

[r-saba]

Look into extracting data using the Concordia API

[JeremiahTee]

Steps taken:

1. Create an e-mail account for the project

   coursebin341@outlook.com

2. Sign up to opendata.concordia.ca using the above e-mail
3. Sign in to opendata.concordia.ca
   • difficulty encountered:

This is a known problem to the opendata website. I have tried registering with 2 different e-mails and signing in right away, gives the same error. The "fix" to the above problem is to change the password. Signing-in will be allowed then. Once signed in, you can create an "Application"

According to the API documentation:

Applications are what will provide you with the user id and key needed to query data through the API.

Note: there is a limit of 10,000 calls per application per day.

Testing the API using Postman:

Note: the asterisk * means 'any' According to documentation:

The API use basic authentication over https in the screenshot above, the Username and Password are the user and key in the application of the Open Data user.

The call https://opendata.concordia.ca/API/v1/course/schedule/filter/*/COMP/* returns the JSON object below:

[JeremiahTee]

What's next: BACK-END

• Dig into the API deeper. Find which API calls will be used in the project, and which information exactly needs to be extracted (variables such as courseID, termCode, and so on)

DATABASE

• Look into building a .json file with the information chosen from above. This .json will be used to fill up the database.