Hello,
I have created a free helper Add-on to explore a file using execute-data-api and to create queries which you can use for the real Data API. The Add-on is free and featured in the Claris marketplace
You can also download the Add-on from my freeware website where there is also an example-file where the DAE already is integrated, with a few example-queries.
Cheers Menno