Data Source strings from the API

Is it possible to use the API to get a list of data source connection strings used for Power BI datasets and dataflows? Not just the Connection String, but the underlying assets that the connection is using.

I ask because we have a wild garden of bespoke datasets and dataflows in our capacity connecting to an oracle warehouse, and are trying to get a consolidated view of the tables that are in use. Power BI developers have connected by either connecting directly to the tables, or by connecting using a sql query.

We are able to extract the connection string through the API, so can identify which datasets and dataflows are using the oracle connection, but want to go the next step to find out WHAT is being queried.

Is this possible? Thank you.