REST endpoints from Azure SQL

Best practice for production apps is to use REST as the data layer to access data and not directly integrate to SQL using the SQL data provider. The SQL data provider will be squiggled in blue to indicate it is not recommended, together with a message to use REST instead.

1. Configure your Azure SQL database to call external REST endpoints. To learn how to call external REST endpoints from Azure SQL databases, read:

   • Microsoft Learn: sp_invoke_external_rest_endpoint (Transact-SQL)

   • GitHub sample: azure-sql-db-invoke-external-rest-endpoints

2. Now use the REST data provider to configure your Jigx solution to integrate with your Azure SQL data.