Question

Azure Data Factory Pipeline Failing on GET using Freshdesk REST API

  • 11 May 2022
  • 2 replies
  • 48 views

Badge

Hi,

we are using Azure Data Factory copy function to get data from Freshdesk and copy it to Azure Storage (Data Lake) using the REST API. This has recently stopped working with Bad Request error 400.

The connection is successful it’s the getting the data bit from the Freshdesk view that is failing.

Have there been any changes recently that could explain this? Interestingly the same thing in Microsoft Power Business Intelligence still works. 

Thank you in advance for any responses, much appreciated.

Ravi


2 replies

Userlevel 4
Badge +4

Hi @ravisingh,

Welcome to the Freshworks Community!

I understand you are facing issues with the data fetch from fresh desk, usually this error code is returned only when the request body/query string is not in the correct format.

It would be great if you could DM us the exact error code you see while this call fails, and any type of an error log that would help for us to raise this further with our developers.

Cheers!

Badge

Hi Pooja,

Many thanks for the welcome.

This is the error according to Azure Data Factory

Operation on target CopyTickets failed: ErrorCode=HttpFileFailedToRead,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=Failed to read data from http server. Check the error from http server:The remote server returned an error: (400) Bad Request.,Source=Microsoft.DataTransfer.ClientLibrary,''Type=System.Net.WebException,Message=The remote server returned an error: (400) Bad Request.,Source=System,'

I am using the HTTP linked service GET

Base URL : https://npl.freshservice.com/api/v2/

Relative URL : analytics/export?id=< long string maybe best not to share > 

 

This used to work and then just stopped one week.

Reply