Forum Discussion
Viva Insights query integration with enterprise systems
Currently we are manually accessing our Viva Insights queries using a Microsoft API to download the query result sets to our Enterprise backbone and one of our loads takes roughly 3 days to get execu...
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
No we did not accept the solution since it is what we are already doing please see my post yesterday