There is extensive documentation of our REST API online. Many entries have example code in a variety of languages.
Take a tour through the available functions to see if it will support what you are trying to achieve.
Hope that helps.
Let me jump in to the conversation, with a more specific question.
We are looking to connect Pyramid discoveries to Excel. Seems that Query API is the way and PowerQuery in Excel is supposed to support this in theory. But it seems that authentication is not working properly.
Is there a documentation from your side on connecting Query API to Excel source?