Forum Discussion
Viva Insights query integration with enterprise systems
Hi Dazza,
- In WpA/Viva Insight can we have API with date filters?
- Is it possible to extract data via API for incremental loads based on last updated timestamp (like monthly, daily or date range based).
We are currently loading data from Mar,2021 to Mar,2022 with 60 million records and this takes around 4 days to load and this volume is expected to grow every month and we find it not feasible to load this every month.
If we have API which can fetch all the data that has changed since our last extract then the number of records would be manageable to extract and merge into already existing historical load. Please suggest us an approach to handle incremental load via API.
Thanks,
Glen
I second this request. we need a more efficient way to pull data automatically each month. the current process is fine for adhoc analysis but difficult to scale. A timeline on more flexible API would be great. In fact if there could be an api that makes it easier to build some of the different types of queries through a more advance interface it would make running analysis fair more powerful.
No we did not accept the solution since it is what we are already doing please see my post yesterday
