Hi Nivi,
The only way to access this information is using the Lookback API.
Excel and the apps access the current information. You are asking for changes made yesterday which don't have to be current. There may have been subsequent changes to those made yesterday , or it could be that a number of changes happened to a certain object yesterday.
The only way to access this data is using the Lookback API.
You will have a number of challenges:
1. The amount of data (as John mentioned already).
2. The Lookback API doesn't support expressions to lookup by dates. You can't build a query that says: "yesterday" and expect that Lookback API will know every day which day was yesterday. The API takes hard coded dates.
Here is an example:
https://rally1.rallydev.com/analytics/v2.0/service/rally/workspace/<WorkSpakce_ObjectID>/artifact/snapshot/query.js?find={"FormattedID":"US239","_ValidFrom":{"$gt":"2018-08-13T00:00:00.000Z"}}&fields=["ScheduleState","_SnapshotDate","_SnapshotNumber"]&hydrate=["ScheduleState"]&compress=true&sort={ "_ValidFrom": 1 }
This query above is asking for the changes for a user story that has FormattedID = US239 since 08-13-2018.
You can't have an expression that will dynamically compute a date. This means that you will have to re-generate a similar query every day.
There are even more challenges such as taking into account the types of artifacts you'd like to query about, also converting the output JSON to your desired format.
I just wanted to give you a 'feel' as to what is involved with this.
Sagi