Recent searches

No recent searches

Connecting ZD API to Excel

image avatar

Katie Edwards

Posted May 24, 2023

Hi all,

I'm looking to connect Zendesk with Excel Power Query using the API, however, all of the authentication methods that are provided when trying to connect the data source don't allow me to connect.

I have tried all methods, but I assume that the Web API is the way to go. However, when I add in my API key it comes up with the error: "A web API key can only be specified when a web API key name is provided".

I appreciate this may be more of an Excel question than a Zendesk question, but if anyone has any experience or knowledge about this I would be grateful for some assistance! 

Thanks ever so much! 

0

3

3 comments

Date
    image avatar

    Warwick Allen

    Try using Basic authentication with the username as “<your email address>/token” and the password as your API key.

    2

    image avatar

    Katie Edwards

    Thanks so much, Warwick Allen - that's done the trick! 

    1

    image avatar

    Mark Pinfold

    For those coming across this in the future:
    Above works a charm: But dont convert the API key to Base64 like you would for other API requests.
    It would appear Excel handles the encoding for you. Winner.

    0

    Please sign in to leave a comment.

    Didn't find what you're looking for?

    New post