MarkMpn / Sql4Cds

SQL 4 CDS core engine and XrmToolbox tool
MIT License
74 stars 22 forks source link

Enhancement to Execute Support #442

Closed SiPurdy closed 1 month ago

SiPurdy commented 7 months ago

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