Data Factory OData Source - Resource Not Found

Kevin 1

I'm using Data Factory to copy data from OData source to Azure SQL. I have about 12 endpoints where 10 endpoints (GET) work fine but 2 endpoints return an error

Operation on target Copy Query To SQL failed: ErrorCode=ODataFailToParseUrl,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=The odata path in url RequestUrl is not recognized.,Source=Microsoft.DataTransfer.Runtime.ODataConnector,''Type=Microsoft.OData.Core.UriParser.ODataUnrecognizedPathException,Message=Resource not found for the segment 'GLAccount'.,Source=Microsoft.OData.Core,'

I have verified that this endpoint and the other endpoint work fine with Postman. Need some guidance on fixing this or how to dig into details of this error.

KranthiPakala-MSFT 46,442 Reputation points Microsoft Employee

2021-12-13T04:23:32.86+00:00

HI @Kevin ,

Thanks for reaching out. This is strange. Could you please tell us what is the exact difference between the endpoints that work successfully and the other 2 endpoints that fails?

As per the error message it seems like something is wrong in the endpoint URL. But you have mentioned that those endpoints work in postman.

The OData connector copies data from the combined URL: [URL specified in linked service]/[path specified in dataset]?[query specified in copy activity source]

If possible could you please share the endpoint used (Note: pls mask sensitive info) in postman that is working and the endpoint request formed in the ADF request. Just wanted to double check if they are exactly same or is there any difference. The reason I would want to recheck on this is in postman you will be using direct endpoint URL, whereas in ADF you will form URL in combination of [URL specified in linked service]/[path specified in dataset]?[query specified in copy activity source], so there is a possibility in forming incorrect URL while configuring in copy activity settings.

Do let us know your observations.
Kevin 1 Reputation point

2021-12-13T20:53:15.397+00:00

There's nothing different between the endpoints that work vs these 2. It would also help if I can see the entire url used to query the OData endpoint but I couldn't find that anywhere.
KranthiPakala-MSFT 46,442 Reputation points Microsoft Employee

2021-12-21T07:52:07.727+00:00

HI @Kevin ,

I agree that this issue looks strange and I wasn't able to reproduce this issue. If you have a support plan could you please file a support ticket for deeper investigation and do share the SR# with us? In case if you don't have a support plan please let us know here.

Thank you
KranthiPakala-MSFT 46,442 Reputation points Microsoft Employee

2021-12-22T01:05:47.467+00:00

HI @Kevin ,

Just checking to see if you have got a chance to file a support ticket for the above issue. If so could you please share the SR# with us here. Incase if you don't have a support plan, please let us know here.

Thank you
Kevin 1 Reputation point

2022-01-03T17:46:34.747+00:00

I do not have a support plan.
KranthiPakala-MSFT 46,442 Reputation points Microsoft Employee

2022-01-04T23:52:28.66+00:00

Hello @Kevin ,

Thanks for getting back. We have noticed that someone had already filed a support ticket (SR#2112210010002648) for this issue and a support engineer is looking into it.

Share via

Data Factory OData Source - Resource Not Found