CREATE procedure [dbo].[GetCustomerDetails]
select Cust_AddressLine1,Cust_AddressLine2,City ,PhoneNo from dbo.CustomerDetailTable where Customerid=@CustomerId
Check the Status of On-premise Data Gate way windows service running on Biz Talk Environment . To check go to run command and type
services.msc and check the status of On-premise data gateway If you are working on corporate firewall then you need to open appropriate ports . Follow the instruction as been mentioned in link
Install the on-premises data gateway for Logic App . In my case, i have used VPN Gateway to connect to Azure resources.
Step by Step Process to Create Logic App in Azure to Call Biz
Through postman, we have submitted the valid customer Id and got a response from On-premise BizTalk which is in Sync with SQL Server within corporate firewall zone.