GET API Node.js Microsoft Graph Integration - Teams
Budget: $30 – $250 USD
Create a 1 REST GET API in Node.js that connects to MySQL and uses the Microsoft Graph API to download Microsoft Teams meetings, the Rest API will be executed automatically 2 times a day for meeting download and upload to vimeo.com and registration of the meetings in the database, here I explain step by step what the GET API has to do. (You need to retrieve all meeting scheduled and all meeting recording without duplicated)
1) Read from a mysql table the meetings that have to be retrieved from teams for each execution SELECT meetingID, name, date from calendar (events)
***(Each meeting can have one or more recordings, take care about recurring meetings with the same meeting ID) Meeting ID is different of Recording ID , Meeting ID can have one or more Recordings.
Meeting ID = repository row (repositorio table row) mysql
Recording row = temasubtema row (topicsubtopic row) mysql
2) If the meeting does not exist registered in the repository table (repository) insert it INSERT INTO if it already exists omit the INSERT and go to the next step.
3) If the meeting has already been downloaded (you can check the name of the file of id of the recording), skip the download if it has not been downloaded, download it and store it in a folder to later upload it to Vimeo (through its API and specific title structure for each video) and register it in the topicsubtopic mysql table (topicsubtopic) here the final URL is registered from VIMEO example: https://player.vimeo.com/video/442158363?autoplay=true&byline=false&portrait=true&title=true&speed=true&transparent=0&gesture=media
I will provide you the API keys for Microsoft Graph and Vimeo.
1) Read from a mysql table the meetings that have to be retrieved from teams for each execution SELECT meetingID, name, date from calendar (events)
***(Each meeting can have one or more recordings, take care about recurring meetings with the same meeting ID) Meeting ID is different of Recording ID , Meeting ID can have one or more Recordings.
Meeting ID = repository row (repositorio table row) mysql
Recording row = temasubtema row (topicsubtopic row) mysql
2) If the meeting does not exist registered in the repository table (repository) insert it INSERT INTO if it already exists omit the INSERT and go to the next step.
3) If the meeting has already been downloaded (you can check the name of the file of id of the recording), skip the download if it has not been downloaded, download it and store it in a folder to later upload it to Vimeo (through its API and specific title structure for each video) and register it in the topicsubtopic mysql table (topicsubtopic) here the final URL is registered from VIMEO example: https://player.vimeo.com/video/442158363?autoplay=true&byline=false&portrait=true&title=true&speed=true&transparent=0&gesture=media
I will provide you the API keys for Microsoft Graph and Vimeo.