I'm trying to create an external content type from a stored procedure. I'm hitting one problem, when creating a Read List Operation, though:
The wizard is not able to find any return parameters (see image), when my stored procedure ends with
CREATE PROCEDURE getData AS BEGIN DECLARE @sql NVARCHAR ( MAX); EXEC @sql; END
Now, if I use a common select, SharePoint is able to recognize return parameters:
CREATE PROCEDURE getData AS BEGIN SELECT * FROM data_table; END
I need to use EXEC, as I use a lot of metadata in my procedure. Is this a limitation of Sharepoint? Can I get a workaround?