Hello,
I am trying to pull Jira data into Excel via Power Query through the REST API. I want to use the REST API because the other methods don't allow me to specify the columns to be retrieved (e.g. printable filters, CSV, etc). So I really want to use the REST API because I can reliably define the data coming back.
My problem is that I cannot get Windows Authentication to work with the REST API. It works with other URLs (e.g. when accessing a Jira Filter's Printable page). But for some reason that doesn't work with the REST API.
I cannot use basic authentication and I don't seem to be able to use API tokens at the moment. We have our own Jira Server so I can't use the Cloud solution that has been suggested for API tokens.
Does anyone know now to get Windows Authentication to work with the REST API?
Very Respectfully,
Joel