Search for answers here or ask a question

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?

6replies Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
    • Ian MacdonaldAdmin
    • Team Lead - Product Management
    • Ian_Macdonald
    • 4 mths 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.


  • Hi Ian.


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



  • 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

  • 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?


    • Avi PerezAdmin
    • "making the sophisticated simple"
    • AviPerez
    • 3 mths ago
    • Reported - view

    Use the OData feed. 

Like Follow
  • Status Answered
  • 3 mths agoLast active
  • 6Replies
  • 58Views
  • 5 Following