Hi folks,
This is a doozy. Please bear with me as the issue is dense.
I have created a custom connector that connects to a public API. I have made use of the Route Request policy to enable multiple actions that go to the same endpoint, which is a common workaround. The endpoint's format is /deployments/api/resources/{resource_id}/requests.
This has been working successfully for over a year, with no problems. Our company is moving to an on-premises version of this API. The API reference is exactly the same. In order to enable this, all I have done is change the "Host URL" and modify the connector to require use of an on-premises data gateway. So far so good.
I am able to send requests to the on-premises API without issue. However, when I attempt to use the Route Request policy, this fails with a 404 and throws the error "The resource you are looking for has been removed, had its name changed, or is temporarily unavailable."
At first I thought something about my request was being malformed by Route Request, resulting in the error. I tried:
1. Sending a request without Route Request applied to the .../deployments/api/resources/{request_id}/requests endpoint. This is successful.
2. Checking in both Power Automate and the Custom Connector "Test" tab. Both return the same result.
3. Enabling Additional Logging on my on-premises data gateway and reviewing the QueryExecutionReport logs. Mysteriously, the requests that throw a 404 and give the "The resource you are looking for has been removed, had its name changed, or is temporarily unavailable." error are not ever sent to the gateway.
My thought is that the "The resource you are looking for has been removed, had its name changed, or is temporarily unavailable." error is being returned by Power Automate/Azure Service Bus due to some sort of incompatibility (perhaps with on-premise data gateway?).
My questions:
1. Is the Route Request feature supported for the on-premises data gateway?
2. If so, what could be causing this behavior? Why would Power Automate return this error when I am sending a valid request?
Any help would be greatly appreciated, thanks!
