Hello. I would like to use Trello API to get and store in database information about all Actions taken in given Project (for example add Member to Project, add Section, create Task in Section, assign Member to Task etc.). I want to have such information for all Actions, since the creation of the Project. Is such a thing possible?
I have tried following attitudes, however they are not satisfying:
- using Stories - information contained in Stories is satisfactory, however Stories apply only to Tasks. While this isn’t a gigantic problem, another thing is an issue - I would have to get all Tasks in a Project and then request for a Story for each of the Tasks (let’s call this operation import) and save data from each Story to the database. Then, after some time have passed and users have added more Tasks to the Project, AFAIK I have no way of knowing which Tasks have been added since the last import, so I would have to iterate over all of the Tasks in Project, for each of them ask for a Story, and then check if that Story already is in my database (from previous import). That’s extremely inefficient - please correct me if I’m wrong in my logic.
- using Events - this causes two problems:
- List item
Firstly, AFAIK due to the sync token mechanism, I am able to only get Events since the last request using sync token. Therefore, I am not able to get historic Events (for example from the beginning of the Project, 1 year ago).
- List item
- Secondly, please consider this case. I get Events at 3 p.m. and save returned sync token. Then at 5.pm. I want to get Events again using that previously returned sync token to save in my database data about Events done between 3 p.m. and 5 p.m. However, as I understand it, if I lose that sync token for some reason (error, corrupted data, or sync token expiring earlier, as described in docs), I will never be able to get the Events that happened between 3 p.m. and 5 p.m., because when I make request again for Events after 5 p.m. without the sync token (because I’ve lost it or it expired), I will get 412 error and a new sync token, without any Events data.
I would be extremely thankful for any help.
Thank you in advance