StoredProcedures / Web API Actions in Sql4CDS

[PRusakPL]

Hi @MarkMpn,

Can you tell how you are retrieving list of Web API available Functions / Actions (Sql4CDS nomenclature: Stored Procedures)?
I am missing e.g. GrantAccess action (why ?) Are there any restrictions in showing / enabling actions from DV in your tool?

BR
Piotr Rusak

[MarkMpn]

The code to retrieve the list of actions is at

Sql4Cds/MarkMpn.Sql4Cds.Engine/MessageCache.cs

Line 54 in 1ddcc99

public MessageCache(IOrganizationService org, IAttributeMetadataCache metadata)

It will retrieve all the available actions, but not all are made available to invoke as stored procedures or table valued functions.

In order to be executable as a table valued function, a message must have:

1. request fields only of scalar values (except for a single PagingInfo parameter if the output is an entity collection)
2. response fields that are EITHER:
   a. A single field of an entity-derived type, OR
   b. A single field of an entity collection, OR
   c. one or more fields of a scalar type

To be executable as a stored procedure the same conditions apply, except that messages with no response fields are also acceptable.

In the case of the GrantAccess message, the input parameter is a complex type and therefore can't be represented using standard SQL values.

[PRusakPL]

Thank you @MarkMpn - it was really fast. Kudos for what you are sharing with community - You Rock Man !!