Connecting ZD API to Excel
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!
-
Try using Basic authentication with the username as “<your email address>/token” and the password as your API key.
-
Thanks so much, Warwick Allen - that's done the trick!
Iniciar sesión para dejar un comentario.
2 Comentarios