Jira Rest API - Basic authentication with passwords is deprecated

Question

Hello.

I'm using the rest api from Kingswaysoft on a SSIS package. The package works fine on SSIS/Visual Studio, but when i deploy the package to SQL Server Integrations Services Catalogs, the package throws the error "Basic authentication with passwords is deprecated".

I have tried changing the connection string multiples times (Adding the API key, encoding it to Base64), but so far with no success.

Any suggestions?

Thanks in advance!

Henrique Silvério Ferreira Abreu · Answer

I have tried that and still no luck unfortunately. My connection string looks like this:

ServiceName=Jira;PathToTokenFile=;AuthenticationMode=Basic;ConsumerKey=;ServerUrl=linkurl;ApiThrottleRate=0;CertificatePath=;Username=username:apitoken;ProxyMode=Manual;ProxyUsername=proxyusername;ProxyServer=proxyserver;ProxyServerPort=proxyport;ServiceTimeout=120;RetryOnIntermittentErrors=True;IgnoreCertificateErrors=False

Mikael Sandberg · Answer

Have a look at Basic auth for REST APIs. Instead of username:password you should now use username:token when using basic authentication. You can Base64 this if you like.