Solved
Data extraction via API
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
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.