Database functoid will return the record set for a given row id. Using Table Extractors, you can get a specific column value for any column. For example, if you have 100 columns in the table and want to get the values for 10 columns, you will have to use 10 table extractor functoids. If you are planning to retrieve multiple rows in one DB lookup functoid, I don't think there is a way to do it. Anyway, there are some known issues with DB loopup functoid. It will not work properly if you use it for the situation where you are sending a bunch of messages at a time from the map. You better write your own script for this purpose.
Search this Site:
Recent Posts
- Logic App Consumption deployment: The secret of KeyVault parameter cannot be retrieved. Http status code: ‘Forbidden’. Error message: ‘Access denied to first party service
- BizTalk Server Visual Studio project: attempted re-targeting of the project has been canceled.
- BizTalk Oracle Adapter error: The assembly required for type mapping not found.
- PowerShell script to identify all SQL V1 actions and triggers inside Logic Apps Consumption
- Friday (funny) Fact: There is no size limit for the Logic App parameter name