I have an existing workbook which has both number/epoch dates and text. Based on the number in each row, I am looking to query an API that returns the subsequent columns. However, I want to return only the reward data based on each day (displayed as epoch time). Although, I consider myself an average excel user, I do not really know how to use power query. I'm using Excel 2021. Appreciate all help.
For e.g., below is the API code for the first row item = 67907.
https://api-apollo.pegaxy.io/v1/game-api/race/history/pega/67907
I would like to retrieve data of the total rewards won on the given date in the column to the right.
| 01/03/22 | 02/03/22 | 03/03/22 | |
| 67907 | |||
| 69828 | |||
| 294291 |
For e.g., below is the API code for the first row item = 67907.
https://api-apollo.pegaxy.io/v1/game-api/race/history/pega/67907
I would like to retrieve data of the total rewards won on the given date in the column to the right.
