Usually I use SharePoint Lists as my data Source and us the ‘Get List by View’ if I have a very large database (to speed up results).
However, I am hooking into a Smart Object that has a SQL Database as a source, and the only Method available is ‘List’ …. Is this a restriction of using a SQL database or is it because this is the way the service instance is set up? Could this method be made available by editing the service instance and redeploying a smart object?
(I am a novice where SQL is concerned).