SFTP 'No Such Host is Known' error when sending csv file from Logic App Workflow to on-prem server
I currently have a Logic App Workflow configured to send a csv file to an on-prem server through the built-in SFTP connector. We allowed SFTP access through our private bastion through a specific private endpoint from a Vnet. The virtual network that is integrated into the logic app has a private DNS zone with the record of the hostname. The NSG that is associated with it also allows all TCP traffic. The error message that is returned is "The service provider action failed with error code 'InvalidServiceProviderConnection' and error message 'No such host is known.'." How do I make the logic app use that private endpoint going outbound? I have gotten suggestions to create a SFTP gateway server but keeping costs down to a minimum would be preferred.