Secure Azure Logic App using Azure SQL Row Level Security

Question

How can I create a system using Azure logic app & Azure SQL with the given functionality:

Whenever a user invokes the logic app, logic app gets the uuid of the user. This uuid is passed to Azure SQL and on the basis of uuid row level security is applied. After applying the row level security, Azure SQL sends back all the generated rows to logic app.

It will be better if Azure AD can be used for row level security

Answer 1

This is possible and can be achieved with the following

1. Set up authentication for Logic Apps either directing with Logic Apps or using Azure APIM. The APIM approach allows for a single setup for all of your logic apps and even extracting the UPN from the token, passing it directly to Logic Apps.
2. Extract the unique ID for the user from the passed token
3. Fetch the rows using the unique ID as shown in this example from the SQL docs.