I've been trying for a while now to access data about who attended our Zoom webinars via the Zoom API.
Amongst other things I've been using Joe Glines' Zoom API v2 video (https://www.the-automator.com/zoom-api/) on this, but our IT team isn't really happy about using SCiTE and that, combined with my general unfamiliarity with APIs, means I'm unsure of what I'm doing wrong.
Ideally I'd be able to run something that just downloaded a raw JSON file - as my intention is then to bring it/them into Power BI which can handle the JSON formatting.
I've got the start of the thing OK I think, but I'm just not sure what to do at the end to save the info that's coming back to me as a file (or even just paste into notepad).
Here's my code
Code: Select all
#SingleInstance,Force
JWT_Token:="MY JWT TOKEN - EXCLUDED HERE FOR OBVIOUS REASONS"
EndPoint:="https://api.zoom.us/v2/metrics/webinars/{webinarId}/participants"
Reg:=API_Call("GET",Endpoint,QS,JWT_Token)
return
;********API call**********************
API_Call(Type,Endpoint,QS,JWT_Token){
HTTP := ComObjCreate("WinHttp.WinHttpRequest.5.1") ;Creates COM Object
HTTP.Open(TYPE,EndPoint QS) ;Starts the request
HTTP.SetRequestHeader("Authorization","Bearer " JWT_Token) ;Authorisation from a JWT token
HTTP.SetRequestHeader("Content-Type","application/json") ;JSON
}
Please could someone give me a few pointers?
Many thanks,
Matt