Hello! The Power Query application received data for the “Upcoming Event” through the ZOOM API JWT Token. But the data is incorrect by date range (getting the event of old past dates in scattered order). Those. ZOOM didn’t respond to my “from” and “to” request parameters.
For example, in the Power Query language (json format) I specify:
Request =
[
from=“2022-07-15”,
to=“2022-07-31”,
page_size=“300”
]
I receive at the beginning of the event in 2021 (10/20/2021, 04/16/2021, etc.) then the beginning of 2022 (May 2022, June 2022 and 07/14/2022, 07/15/2022).
Why is that? Help me please. Thanks in advance!
Hey @askerbek4205
Thanks for reaching out to us, I am happy to help here!
Could you please share with me what endpoint are you calling?
As well as the entire request URL that you are sending so I can debug this issue further?
Thanks,
Elisa
Hi @elisa.zoom
Thanks for the answer. Help me please)
I’m calling the endpoint on “Get upcoming events report”.
My use URL request - https://api.zoom.us/v2/report/upcoming_events
I write this code:
Query =
[
from=“2022-07-18”,
to=“2022-07-31”,
page_size=“300”
]
I receive the data indicated on the screen.
The string “to” is not getting correctly? Automatic takes the day “from”?
Thanks @askerbek4205
I will go ahead and debug this issue further. I will come back to you with an update shortly
Best,
Elisa