calling sp_invoke_external_rest_endpoint for a private endpoint
Not sure if this is available and not documented, or an unsupported configuration, but I'd like to be able to use sp_invoke_external_rest_endpoint against a private endpoint rather than the public endpoint for my Azure openai service.
With public endpoints disabled, and a private endpoint available, a sql server in the same vnet hits the services public endpoint and there doesn't seem to be any well documented mechanism to specify outbound routing - all network config options relate to inbound
Is there any way to achieve this?
Hey mate, I ended up asking the same question here.
https://learn.microsoft.com/en-gb/answers/questions/2242640/can-sp-invoke-external-rest-endpoint-be-used-to-ca?page=1&orderby=Helpful&comment=answer-2018455&translated=false#newest-answer-comment
The response is: It's not possible (at least as of 2nd April 2025).