How to authenticate with Jira REST API using VBA, but not basic authentication

[Nicholas Hall]

I have read this article: https://community.atlassian.com/t5/Jira-questions/How-to-authenticate-to-Jira-REST-API/qaq-p/814987

Also able complete basic authentication login on a standard Jira server that requires Email Address and API token. 

Our Jira server requires Okta verify to confirm login, so the same code (using a appropriate email address and a different API token generated, while logged on to our Jira site) does not work.

Any suggestions on the way to proceed?
 

[Sunny Ape]

@Nicholas Hall 

You will have to speak to your Jira Admins / Sys Admins and request that the URLs related the REST API are exempt from requiring 2FA via OKTA.

[Nicholas Hall]

@Sunny Ape Thank you, is this the only solution, then I don't see I will get it to work.

I did some more investigation, if I submit it directly as a curl request instead of VBA it logs me in and provides data, which adds further to my confusion.

[David Semmens]

@Nicholas Hall did you find a suitable answer? We are moving our Jira over to OKTA now and I need to move the finance  reporting over.