Skip to main content

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

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!


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.


has  anyone found the solution for this issue .

 

I’m having same issue u#13244016] ADF - Fresh Service Connectivity Error : Freshservice


Anybody find a solution to this problem?  I’m having the same issue!


same issue here


any updates on this ? Is FreshService somehow blocking requests from Azure Data Factory ? Using the Api call via Power Bi or Postman works fine


Are there any updates on this? It seems that FreshService might be blocking requests from Azure Data Factory. Interestingly, the API call works perfectly through Power BI or Postman.


Reply