This topic was automatically generated from Slack. You can find the original thread here.
Hey everyone. I have the new and awesome webinar participants’ report. I’m fairly good at reverse engineering other scripts but have little skill or knowledge in creating anything.
The workflow step returns only a pagesize of 30, which for me is not enough when we have webinars of 400+ attendees. I also have no idea on how to take the result and push it to rows in a google sheet.
Last I need the join and leave time for each participant so I can aggregate their attendance time.
I’d really appreciate any assistance I can get here.
Hi, I think your question is a great case for Pipedream bot to help. I’ll pass your question to the Pipedream bot now. Please feel free to ask it any question
Hey everyone. I have the new and awesome webinar participants’ report. I’m fairly good at reverse engineering other scripts but have little skill or knowledge in creating anything.
The workflow step returns only a pagesize of 30, which for me is not enough when we have webinars of 400+ attendees. I also have no idea on how to take the result and push it to rows in a google sheet.
Last I need the join and leave time for each participant so I can aggregate their attendance time.
I’d really appreciate any assistance I can get here.
To handle your use case, you can create a Pipedream workflow with the following steps: 1. Use an appropriate trigger for your workflow (e.g., HTTP, Scheduler, or an app-based event). 2. Add a code step to fetch the webinar participants’ data. You might need to paginate the API requests if the API returns data in pages. Make sure to collect the join and leave time for each participant. 3. Add another code step to process the data and calculate the attendance time for each participant. 4. Use the Google Sheets action to add the processed data as rows in your Google Sheet. Here’s an example of how you can structure your code step to fetch the webinar participants’ data and paginate the API requests: ```
import { axios } from “@pipedream/platform”; async function fetchParticipants(page) { // Replace this with the actual API request to fetch the webinar participants return await axios($, { method: “GET”, url: “https://your-webinar-api.com/participants”, params: { page: page, }, }); } let allParticipants = []; let currentPage = 1; let totalPages = 1; while (currentPage <= totalPages) { const response = await fetchParticipants(currentPage); allParticipants = allParticipants.concat(response.data); totalPages = response.totalPages; // Replace this with the actual value from the API response currentPage++; } return allParticipants;
may I confirm that you’re using the Zoom - Fetch Participants as the image below? As I don’t have zoom paid account so I couldn’t test it fully, though I think it might be something related to the action pagination. Would you mind submitting a ticket here with your action result and your actual participants number?
