Visit Freshworks.com Visit Freshworks
Question

Azure Data Factory Pipeline Failing on GET using Freshdesk REST API

R
Rank
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

4 replies

Majorcanada
Rank

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

N
Rank

has  anyone found the solution for this issue .

 

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

R
Rank
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.

Pooja Bernice
Rank
Userlevel 5
Badge +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!

Reply


Terms of UseCookie settings