Sql4Cds icon indicating copy to clipboard operation
Sql4Cds copied to clipboard

Enhancement to Execute Support

Open SiPurdy opened this issue 3 months ago • 0 comments

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:

  1. For specific OrganizationRequests, hardcoded metadata would be used to process the output. or
  2. 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

SiPurdy avatar Mar 20 '24 10:03 SiPurdy