Skip to main content
dandre
dandre
Contributor ⭐️⭐️⭐️⭐️⭐️
Jan 8, 2024 12:29 AM UTC
Solved

Rest API access for report data?

Hi folks,

Having a hard time searching for this topic now that the community has merged with other products - but is there any capability in the Rest API to pull report data? We often do manual calculations each month / quarter for case deflection, and it would be nice to automate this in Power BI and Rest API. The rest API docs seem to only provide provisions to manage users and community content rather than extract report data though.

    olimarrio
    olimarrioAnswer
    Gainsight Employee ⭐️
    Jan 8, 2024 9:20 AM UTC

    Hey @dandre 👋,

    We have built a BI connector which can connect tools like Power BI to our Data Lake for more granular and automated reporting. I can add you to the list for our ongoing beta if this sounds like something that will be useful here? 

    View in thread

    10 replies

    Padolfi
    Padolfi
    Contributor ⭐️⭐️⭐️⭐️
    Jan 8, 2024 8:22 AM UTC

    Hi @dandre, 

    I believe that we can only get the raw data from the APIs created(Company, Relationship, Custom Object, Success Plan, Timeline, Cockpit, etc), so if your reports are getting the raw data from them it would be pretty straightforward to get it and process it in Power BI. I don.’t believe you could do the same with a dataspace though bc I believe we don’t have access to dataspaces since they are created as a system object type. 

    I don’t know much about how it would be processed in Power BI. Why would you need a specific report instead of the same raw data with filters and everything collected directly from the source object?

    Translate
    Padolfi
    olimarrio
    Gainsight Employee ⭐️
    olimarrioAnswer
    Gainsight Employee ⭐️
    Jan 8, 2024 9:20 AM UTC

    Hey @dandre 👋,

    We have built a BI connector which can connect tools like Power BI to our Data Lake for more granular and automated reporting. I can add you to the list for our ongoing beta if this sounds like something that will be useful here? 

    Translate
      dandre
      dandreAuthor
      Contributor ⭐️⭐️⭐️⭐️⭐️
      Jan 10, 2024 10:22 PM UTC

      Hey @dandre 👋,

      We have built a BI connector which can connect tools like Power BI to our Data Lake for more granular and automated reporting. I can add you to the list for our ongoing beta if this sounds like something that will be useful here? 

      Thanks @olimarrio - sounds like a plausible solution. Yes, I’d like to be involved in the beta. I’ll connect with our CSM on it as well (Vishwas).

      Translate
      When things get tough, we ask, what is best for the customer?
      dandre
      dandreAuthor
      Contributor ⭐️⭐️⭐️⭐️⭐️
      Jan 10, 2024 10:22 PM UTC

      Hi @dandre, 

      I believe that we can only get the raw data from the APIs created(Company, Relationship, Custom Object, Success Plan, Timeline, Cockpit, etc), so if your reports are getting the raw data from them it would be pretty straightforward to get it and process it in Power BI. I don.’t believe you could do the same with a dataspace though bc I believe we don’t have access to dataspaces since they are created as a system object type. 

      I don’t know much about how it would be processed in Power BI. Why would you need a specific report instead of the same raw data with filters and everything collected directly from the source object?

      Ah - I think you may be referring to another gainsight product - I was specifically looking for Rest API access to reports for the community platform (aka inSided).

      Translate
      When things get tough, we ask, what is best for the customer?
      Chris Hackett
      Chris Hackett
      Helper ⭐️⭐️⭐️
      Jan 11, 2024 7:58 PM UTC

      Hi @olimarrio - I would like to be part of the beta as well. Currently I export the needed information and BI pulls from the spreadsheets. Thank you!

      Translate
      Chris
      olimarrio
      Gainsight Employee ⭐️
      olimarrio
      Gainsight Employee ⭐️
      Jan 15, 2024 9:25 AM UTC

      Hi @Chris Hackett 👋,

      Can you please let me know what BI tool you are using?

      Translate
      Chris Hackett
      Chris Hackett
      Helper ⭐️⭐️⭐️
      Jan 15, 2024 8:21 PM UTC

      Hi @olimarrio Tableau 

      Translate
      Chris
        TomW
        TomW
        Helper ⭐️⭐️
        Feb 5, 2024 8:26 AM UTC

        Hi @olimarrio, we'd like to be added to the list as well. We use the Microsoft package with Power BI and other power tools. Thanks a lot!

        Translate
        vishalm
        Contributor ⭐️
        Apr 9, 2025 2:17 AM UTC

        Hi ​@olimarrio  can I be added as well? I am using PowerBI. 
        We are facing big problems connecting Gainsight to Power BI. Any help will be great. Thanks!

        Translate
        olimarrio
        Gainsight Employee ⭐️
        olimarrio
        Gainsight Employee ⭐️
        Apr 9, 2025 7:51 AM UTC

        Hi ​@vishalm 👋,

        This functionality has now been released:

        You can set up this connection from Control via Integrations → Apps

        Note: this integration is for Gainsight Customer Communities.

        Translate
        Terms & ConditionsAccessibility statement