Error de Conexión REST: TrustFailure y Certificado Inválido en Azure Data Factory

Yamaha_motors 0

Description: Hello everyone,

I'm facing an issue while trying to connect a REST service in Azure Data Factory. The configuration is as follows:

Base URL: https://yam.3psi.com.pe/wsextdatsee/api/operacioncliente?datpet=20383929050_1_Lgo2023$1
Authentication Type: Anonymous
Server Certificate Validation: Enabled

The error I receive is:

The connection to the REST service failed. Endpoint='https://yam.3psi.com.pe/wsextdatsee/api/operacioncliente?datpet=20383929050_1_Lgo2023$1', Reason='TrustFailure'

The underlying connection was closed: Could not establish trust relationship for the SSL/TLS secure channel.

The remote certificate is invalid according to the validation procedure.

Has anyone faced a similar issue or have any suggestions on how to resolve this certificate validation problem?

Thank you in advance for your help!

Smaran Thoomu 16,475 Reputation points Microsoft Vendor

2024-06-13T06:56:23.7433333+00:00
Hi @Yamaha_motors

Thank you for reaching out to us regarding your issue with connecting to a REST service in Azure Data Factory.

The error message you received indicates that there is a problem with the SSL/TLS secure channel and the remote certificate is invalid.

To resolve this issue, you can try disabling the server certificate validation in the Azure Data Factory connection configuration. To do this, follow these steps:

Open the Azure Data Factory pipeline that contains the REST dataset.

Click on the REST dataset to open the dataset configuration.

Under the "Settings" tab, set the "Server Certificate Validation" option to "Disabled".

Save the changes and run the pipeline again.

If disabling the server certificate validation does not resolve the issue, you can try importing the SSL certificate of the REST service into the Azure Key Vault and then reference it in the Azure Data Factory connection configuration. I hope this helps! Let me know if you have any further questions.
Yamaha_motors 0 Reputation points

2024-06-13T11:14:25.5933333+00:00

Issue Persisting After Disabling Server Certificate Validation

Hi Smaran,

Thank you for your response. I have disabled the server certificate validation in the Azure Data Factory connection settings. Now the connection test is successful, but when running the pipeline, I receive the following error:

Operation on target Copiar XML hacia json file failed: The error occurred on the "Source" side.

ErrorCode=RestCallFailedWithClientError,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=Rest call failed with client error, status code 403 Forbidden, please check your activity settings.

Do you have any additional suggestions to resolve this new issue?

Thanks in advance for your help.
Smaran Thoomu 16,475 Reputation points Microsoft Vendor

2024-06-18T09:38:45.4966667+00:00

@Yamaha_motors We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.

1 answer

Smaran Thoomu 16,475 Reputation points Microsoft Vendor

2024-06-14T07:11:12.21+00:00

Hi @Yamaha_motors

Please try granting User.Read.All or Directory.Read.All application permissions to your app to get a list of users in the tenant as suggested in the following post: Rest call failed with client error, status code 403 Forbidden, please check your activity settings - Microsoft Q&A

Hope this helps. Do let us know if you any further queries.

If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.
Please sign in to rate this answer.

0 comments No comments
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Share via

Error de Conexión REST: TrustFailure y Certificado Inválido en Azure Data Factory

1 answer

Your answer