You’re offline. This is a read only version of the page.
Announcements
14
Hello everyone!
I'm having trouble when trying to connect to my Azure SQL Server database on flow using SQL Server in Azure - I'm been doing this for some time now.
I've just created a new procedure in my database and granted access to the user in flow but I'm not being able to load the fields and use the procedure.
It is happening specifically for some procedures, some work, some dont.
Here are two examples with the error messages showing the error.
Error executing the api '/v2/$metadata.json/datasets/SERVER.database.windows.net,DATABASE/procedures/%255Bschema%255D.%255BprocedureName%255D'
Has anyone seen similar problems? How to fix it?
Works
Fails (new procedure, but it happens to other procedures too)
Thanks,
30 seconds after posting the question I found the problem.
Just opened chrome console and there it was. My query inside of the procedure used an inner join and returned more than one column with the same name.
Not accepted by Flow. The error message in the interface could improve guys... just saying...
Share
Report
All responses (
Answers (
