Pyramid Analytics API
I would like to connect Excel to Pyramid and extract a database using the REST API's. Is there any guidance on how to use these APIs?
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.
Thanks for your response, much appreciated. Do you have any examples of how to use these REST APIs?
thanks for the reply. Is there any specific topic you would be interested in? Ian mentioned the example code in the Help pages, would that be a good start?
P.S. Congratulations to the certification
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?
Use the OData feed.