Hi! We’re looking to extract data via API to recreate the below table and to be able to filter it by date
Any ideas?
Cheers,
Stine
Solved
Data extraction via API
Best answer by rhall
Hi
You can certainly pull this data using the data export (CSV) which you can find in the console and also the API….but to be able to filter this by date will be tricky unless you collect deltas on a daily basis, then store that data in your own DB and apply your data logic there.
I would strongly recommend you see if you can get involved in the BI Connector Beta (the link is below).
https://communities.gainsight.com/groups/bi-connector-to-cc-data-lake-silver-layer-beta-207
If you can see that link, you may need to as your CSM about this.
I have been using this for a while and have been able to build pretty much exactly what you are after. You will need to be able to write SQL, but the granular data is there. I think I have actually posted an example in that group as well. However, it may be a little out of date since the schema has changed a little over the last few months.
Hi
You can certainly pull this data using the data export (CSV) which you can find in the console and also the API….but to be able to filter this by date will be tricky unless you collect deltas on a daily basis, then store that data in your own DB and apply your data logic there.
I would strongly recommend you see if you can get involved in the BI Connector Beta (the link is below).
https://communities.gainsight.com/groups/bi-connector-to-cc-data-lake-silver-layer-beta-207
If you can see that link, you may need to as your CSM about this.
I have been using this for a while and have been able to build pretty much exactly what you are after. You will need to be able to write SQL, but the granular data is there. I think I have actually posted an example in that group as well. However, it may be a little out of date since the schema has changed a little over the last few months.
Thank you
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 E-mail address. We'll send you an e-mail with instructions to reset your password.