Extract MDA data via API?
None
Looking for the ability to pull data from the Customers tab/report out of Gainsight via API. Does this capability exist?
Sign up
If you ever had a profile with us, there's no need to create another one.
Don't worry if your email address has since changed, or you can't remember your login, just let us know at community@gainsight.com and we'll help you get started from where you left.
Else, please continue with the registration below.
Welcome to the Gainsight Community
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
Right now the capability does not exist. Can you please provide me some use cases so that i can understand your requirement better?
Thanks!
1. Create a rule that run a query on the source MDA table
2. Create an action which dumps the query result as a csv file in a S3 bucket
3. This rule can be scheduled to run at a fixed interval
4. Your automated process can pick up the file from the S3 bucket and load it to your data warehouse.
Would this work?
The data we pull into the Customer tab is all stored in Salesforce objects (CustomerInfo and Account). It should be possible to query this data using Salesforce's export apis. For data stored in MDA, as Sumesh mentioned, we currently don't have a direct export api exposed externally.
Thanks,
Manu
As Gainsight is moving more and more objects out of Salesforce into the MDA, we critically require the ability to hit the MDA databases via an API to support out BI platform.
Is there any ETA for API access to the MDA?
We are working towards providing API access to MDA data. ETA for the API availability is 2nd half of this year. In the meantime, you could try out one of these options
1. Create a Bionic rule on Email log data and export the data into S3
2. Create a report on Email Log data and export the data into CSV.
Thanks,
Sumesh
Message (User Unknown, Inbox Full, etc), Bounce Date, perhaps subject of message and/or body.