Skip to main content
Question

Azure Data Factory Pipeline Failing on GET using Freshdesk REST API


Forum|alt.badge.img

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

Did this topic help you find an answer to your question?

7 replies

Pooja Bernice
Community Debut
Forum|alt.badge.img+5

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!


Forum|alt.badge.img
  • Author
  • Apprentice
  • 1 reply
  • July 1, 2022

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.


  • Community Debut
  • 1 reply
  • December 9, 2022

has  anyone found the solution for this issue .

 

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


Majorcanada
Community Debut
  • Community Debut
  • 1 reply
  • September 14, 2023

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


  • Community Debut
  • 1 reply
  • May 14, 2024

same issue here


  • Community Debut
  • 1 reply
  • August 14, 2024

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


jordan456
Community Debut
  • Community Debut
  • 4 replies
  • August 15, 2024

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