Pyramid Analytics API

Good Day.


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?

6 replies

    • Senior Director of Product
    • Ian_Macdonald
    • 1 yr ago
    • Reported - view

    Hi Aadhil,

    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.


    • BI Consultant
    • Aadhil_Khan
    • 1 yr ago
    • Reported - view

    Hi Ian.


    Thanks for your response, much appreciated. Do you have any examples of how to use these REST APIs?



    • Let me connect you
    • Community_chris
    • 1 yr ago
    • Reported - view

    Hi Aadhil,
    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

    • Yakov_Shor
    • 1 yr ago
    • Reported - view

    Hi All

    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?


    • "making the sophisticated simple"
    • AviPerez
    • 1 yr ago
    • Reported - view

    Use the OData feed. 

Content aside

  • Status Answered
  • 1 yr agoLast active
  • 6Replies
  • 83Views
  • 4 Following