Querying Jira from Excel: error "We couldn't authenticate with the credentials provided."

[Gauthier de Spa]

Hello,

I'm trying to import Jira tickets from https://<my company>.atlassian.net in Excel 2016 with a query, but with Basic authentication I have the following error:

We couldn't authenticate with the credentials provided. Please try again.

I've also tried to authenticate with a token in Web API authentication and have the following error:

A web API key can only be specified when a web API key name is provided.

Any idea on how to import my tickets in Excel 2016?

Note: I have no problem downloading the list of tickets from https://<my company>.atlassian.net/sr/jira.issueviews:searchrequest-csv-current-fields/10061/SearchRequest-10061.csv, but I need a dynamic solution.

Regards,
Gauthier

[Krister Broman _Advania_]

Not sure about excel import but Web API certainly sounds the same as the REST authentication. For REST you need an API token to access the API so i would bet on that being the case for the excel import as well. 

Follow this guide to create your api token: https://confluence.atlassian.com/cloud/api-tokens-938839638.html 

In Rest you only provide one string for authentication encoded as base64 in this format

FORMAT: ”Basic ”+Base64 encoded string of "login name:API-key"
Exampel BASE64 (https://www.base64encode.org/): krister.broman:ABCDE12345 gives a3Jpc3Rlci5icm9tYW46QUJDREUxMjM0NQ
Final result for authentication: Basic a3Jpc3Rlci5icm9tYW46QUJDREUxMjM0NQ