Jira Rest API - Basic authentication with passwords is deprecated

[Henrique Abreu]

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!

[Mikael Sandberg]

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. 

[Henrique Abreu]

---

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