sql server - MS SSIS: Import Data from REST API into SQL Table. ERROR (401) "Unauthorized" by Using ZappySys

Question

I need to Import Json Data from REST Api (BMC Discovery) into SQL Server Table.

A local connection with a token and execution from Visual Studio works perfectly. But once deployed on the SQL server, my package returns the error 401 "Unauthorized". It looks like the credentials of the REST API user or token are not being passed on and SQL Server failed to authenticate the request.

Given is SQL Server Version/Build: 13.0.4604.0. SQL Server executionaccount is a default technical local account.

Help me please to resolve this

Many thanks in advance

Irina

question from:https://stackoverflow.com/questions/65888913/ms-ssis-import-data-from-rest-api-into-sql-table-error-401-unauthorized-by

Answer 1

Waitting for answers