FetchXMLToSQL sdk message

There is an out of the box api that we can use to generate SQL from FetchXml. It’s called ‘FetchXMLToSQL’. You can call it using C# like this:

var request = new OrganizationRequest("FetchXMLToSQL");
request["FetchXml"] = "<fetch><entity name='account'><attribute name='accountid'/><attribute name='name'/></entity></fetch>";
var response = client.Execute(request);
var sql = (string)response["Response"];

The response will contain an item called ‘Response’. For this example, the outputted SQL will look like this:

select
"account0".accountid as "accountid"
, "account0".name as "name"
from
Account as "account0"

You can use this query against the Dataverse Tabular Data Stream (TDS) endpoint: https://learn.microsoft.com/en-us/power-apps/developer/data-platform/dataverse-sql-query

It seems that we cannot call this message using the OData web api, or Power Automate, so you have to use the OrganizationService to perform this action.