Sql4Cds
Sql4Cds copied to clipboard
Enhancement to Execute Support
This is a nice to have. Some Execute calls are not permitted due to request/return types.
I have a specific scenario with the /api/data/v9.2/RetrievePowerAppsConnections call where it returns an EntityCollection of expando objects that would be really nice to call as a table.
I appreciate with expandos, there is no metadata source to process the result, it would be nice if either:
- For specific OrganizationRequests, hardcoded metadata would be used to process the output. or
- Have some means of specifying the metadata for the result within the script (and I'm not sure of the best sql-esq way of formatting this).
Use case is to produce a script that would return connectionReferences where the connection has an error, RetrievePowerAppsConnections is the method to get at the connection stati.
Thanks