Applying API Key in JWT Authentication

[mike.hutchinson (Mike)]

Still very green with Web Services, Authentication and getting data…

I am running Excel Power Query M language…

= Web.Contents(“https://mycompany.zoom.us/device”, [ApiKeyName=“API_Key”])

see this url… Web.Contents - PowerQuery M | Microsoft Docs
From M language reference… ApiKeyName : If the target site has a notion of an API key, this parameter can be used to specify the name (not the value) of the key parameter that must be used in the URL. The actual key value is provided in the credential.

I want to get a list of devices on our account…
I have registered my app in marketplace.zoom.us and have App credentials.
any idea if I am on the right track on applying APIKey …or am I even close?

Any help would be appreciated.

[gianni.zoom (Gianni)]

Hi @mike.hutchinson ,

I responded to you in your Marketplace Apps thread

Renew App JWT Token Expiration Time doesn't stick?

Hi @mike.hutchinson , I see. So from the docs you shared, I do not know if this will work as intended because in the example 3 you’re referring to it says “Connect to a secure URL that accepts an authentication key as part of its query string”: [image] Our JWT process uses bearer authentication: [image] [Screen Shot 2022-02-09 at 12.25.22 PM] The token itself is what allows you access to make requests to the Zoom API. Without the token, I do not think you’ll receive the connection you’re…

[dan.brill (Dan)]

Hi Mike,
I’ve been working on the same thing. We can’t be the only ones, right? Here’s what’s working for me:

let
    jwtToken = "yourTokenHere",
    endPoint = "https://api.zoom.us/v2/users/your.email@here.com/meetings",
    Source = Json.Document(Web.Contents(endPoint, [Headers=[Authorization="Bearer " & jwtToken, Accept="application/json"]])),
    meetings = Source[meetings],
    convertToTable = Table.FromList(meetings, Splitter.SplitByNothing(), null, null, ExtraValues.Error)
in
    convertToTable

Get your jwtToken at the bottom of your JWT App admin page. It’s sort of hidden at the bottom under the IM Chat History Token field.

Hope that helps,
Dan

[mike.hutchinson (Mike)]

Oh… thank you! I will give this a try!!!

[mike.hutchinson (Mike)]

This looks to have worked to get one of our user’s meetings!!! I am excited! Now trying to understand the syntax and refashion to get info on devices.

Thanks!

[gianni.zoom (Gianni)]

Thank you @dan.brill for your inputs here!

[cassey.gibson (Cassey)]

Glad that worked. Happy to help when I can.

Edit: Whoops. Looks like I logged on with the wrong account. It’s me, Dan.

[mike.hutchinson (Mike)]

Well shoot. I spoke too soon. In Power Query editor it looks to work. But when I go to load the data into Excel sheet… I get “We couldn’t authenticate with the credentials provided. Please try again”

Wondering what I am missing?

[dan.brill (Dan)]

Hmm. Anonymous is the right type. I have Privacy Level set to None/Ignore as the API key is enough for me. What are you using as the Privacy Level?

If that’s not the issue, could you post the raw code from the advanced editor? I doubt there’s anything to see there since the preview worked in the editor. I’ve never had the preview load but not the output.