Using Third Party Plugin for MS SQL Integration Service to Connect to API EndPoints
Within the plugin there is a preview section that works great after configuring the URLs, Authorization header, etc.
Outside the preview section when executing the whole ETL process I get a HTTP Error Code 406.
Looking around I found out this
"The resource identified by the request cannot provide any of the acceptable content-types specified in the Accept header of the client request."
Any suggestion on what entries are needed on my header to make this work?
Submitted by
iCIMSUNIFIL on December 19, 2017
Permalink
Found the problem with the custom SSIS plugin (Pragmatics Rest Source).
This is why is failing. Captured that with Fiddler Web Debugger.
HTTP/1.0 406 Not Acceptable
Content-Type: text/json;charset=UTF-8
X-Error: 406:You are not connecting with TLSv1.2. Please connect with TLSv1.2.
Connection: Keep-Alive
Content-Length: 113
Content-Encoding: utf-8
{"errors":[{"errorMessage":"You are not connecting with TLSv1.2. Please connect with TLSv1.2.","errorCode":406}]}