Integrate a FileMaker File with Zoom API and Panopto API

My institution uses Zoom to host online gatherings of students in the form of lectures that run, led by one or more staff members, and participated in by multiple students. Staff members sign in using institution provided email addresses. Students sign in using institution provided email addresses. After a Zoom meeting has taken place, it is automatically made available in our Panopto video repository. I have a FileMaker Database File, created for the purpose of this task. The file is available, attached to the project, and will be provided to you. The FileMaker Database file represents a solution for tracking attetables of: Students Staff Members Lectures Students in Lectures I have set up Zoom API account. See [login to view URL] for documentation. I have set up Panopto Public API access. See [login to view URL] for documentation Task 1. I would like you to create a script that loops through the records of the Lectures table and for each lecture, does the following: Uses the Zoom API GET /users/{userId}/meetings call to list all the meetings (lectures) scheduled for a user (staff member). Parses the date and start time information that is returned and loop through the results to find the one that relates to the Class. Stores the relevant Zoom Meeting ID against in the relevant field in the Lectures table in FileMaker. Task 2. I would like you to create a script that loops through the records of the Lectures table and for each Student in that lecture, does the following: Uses the Zoom API GET /past_meetings/{meetingUUID}/participants to retrieve information on participants from a past meeting. Parses the participation list and loop through each participant in the Zoom meeting. Stores the Attendance mark in the Lecture as ‘Present’ for each matching Student. Task 3 I would like you to create a script that loops through the records of the Lectures table and for each lecture, does the following: Uses the Panopto API GET /api/v1/sessions/search call to list all the Panopto sessions (classes) that are relevant to the Lecture record being viewed. Parses the description and start time information that is returned to find the one that relates to the Lecture. Stores the relevant Panopto Session ID against in the relevant field in the Lectures table in FileMaker. Task 4 I would like you to create a script that loops through the records of the Lectures table and for each lecture, does the following: Uses the Panopto API GET /api/v1/sessions/{id}/viewers call to get a list of viewers for each session. Parses the viewer list and loop through each viewer in the Panopo session. Stores the Attendance mark in the Lecture as ‘After The Event’ for each matching Student.