Skip to main content
Question

is there a way to query factsheet data as of a date in the past

  • September 19, 2025
  • 6 replies
  • 71 views

I have a need to report on factsheet changes. however to use the audit logs, i have to query them factsheet by factsheet which is expensive. So I was looking to find the rev as of a date and get that rev data and compare with current version.

Any other suggestions are welcome too

6 replies

Thomas Schreiner
Forum|alt.badge.img+3
  • Everlasting Love
  • 384 replies
  • September 19, 2025

Hi ​@anupradhan 

You cannot query older revisions of a fact sheet, but maybe the changelog export works for you. Usually it’s triggered manually, but you can generate and download it via the API and process the resulting xlsx file via an Excel library.


  • Author
  • Rookie
  • 3 replies
  • September 19, 2025

thanks. What is the api to export the changelog? - found it,


Thomas Schreiner
Forum|alt.badge.img+3
  • Everlasting Love
  • 384 replies
  • September 19, 2025

Didier.Nowak
Forum|alt.badge.img
  • Veteran
  • 50 replies
  • September 22, 2025

Hi ​@anupradhan ,
Based on my own experience, the change log can help you but you will struggle to get to the result you expect to get. 
What we do , in my company, is that we replicate the leanIX data to an Azure Datalake (using the APIs to extract the data), and we add a timestamp in order to keep multiple snapshots of our data. In  our case, this was mostly meant to enable us to build quality dashboards showing trends over time. But, of course, that also means that we keep historical versions of our factsheets.


  • Author
  • Rookie
  • 3 replies
  • September 22, 2025

Thank you Didier,

We wanted to do the same. Tried couple times to put our data in datalake. Long process for us. Wish LeanIx had some options. They have the time slidebar on the reports and also save versions. would be nice if they can expose it  


Forum|alt.badge.img
  • Royalty For Loyalty
  • 30 replies
  • September 22, 2025

Good conversation !

Maybe there is an opportunity here for a tool/feature that SUPPORTS viewing a subset of the fields in a factsheet - and let you click on a time line (like the ones in the LeanIX reports) where there are DOTS based on the dates in th changelog.

Yes, the size of the DOTS in the timeline can be related to the number of changes that day in the factsheet (to help the human visualize differentiate between days when there is one change vs days where many changes were applied).  I’ll be glad to help design such tool.

I think this is important - what do others think?