SQL Server stored procedures (Upcoming features)

(0) Share

Report

Posted on by belleye

Hey all,

Some strange behaviour when using the preview connection.

Within the procedure I'm invoking an external rest endpoint using the sys.sp_invoke_external_rest_endpoint, which returns a JSON string, within SQL I then parse that into a table and return the result. The only way I can get it to work is to modify the proc:

Alter Procedure dbo.myHeadache 
 @url nvarchar(max)
 @query nvarchar(max)
AS
Begin

Select 
 'hello' as fieldName
 -- add other required fields

-- Replace the select statement with the sys.sp_invoke_external_rest_endpoint
-- After importing into PowerApps

End

After the first load in PowerApps I can then implement the external rest call by reverting the procedure. I've also tried:

modifying the procedure to use a flag to switch the return results from the sudo table to the parsed json table
calling the procedure from another procedure

I hope this saves someone some pain.

Categories:

Issue