최근 검색

최근 검색 없음

Connecting ZD API to Excel

image avatar

Katie Edwards

2023년 5월 24일에 게시됨

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개

날짜
    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

    댓글을 남기려면 로그인하세요.

    원하는 정보를 못 찾으셨나요?

    새 게시물