# API-Question: data\_updated\_at in reviews

**URL:** <https://community.wanikani.com/t/api-question-dataupdatedat-in-reviews/44992>\
**Category:** API And Third-Party Apps\
**Created:** [July 21, 2020, 12:54pm UTC](https://community.wanikani.com/t/api-question-dataupdatedat-in-reviews/44992 "2020-07-21T12:54:38Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![Shinz](https://sea1.discourse-cdn.com/wanikanicommunity/user_avatar/community.wanikani.com/shinz/32/310650_2.png) [@Shinz](https://community.wanikani.com/u/Shinz)\
**Post date:** [July 21, 2020, 12:54pm UTC](https://community.wanikani.com/t/api-question-dataupdatedat-in-reviews/44992/1 "2020-07-21T12:54:38Z")

</div>

Hi there!

I’m currently playing around a bit with the Wanikani-API and I can already import all the data into an Access-Database. Yeah!

Now I want to do some analysis stuff with the data and found something in the data that doesn’t make sense to me. I hope someone knows the answer and can explain it to me:  
For each review item in the collection I read the data\_updated\_at and the created\_at dates and write them in my db table. Now I noticed that for about 10% of all the review records the data\_updated\_at is bigger than created\_at. Sometime even around 30 days.  
Now my question is: What’s the reason that a review record is getting updated? And why sometimes 4 weeks after the review has been created?

Thanks for your help!

Seb

---

<div class="post-metadata">

**Author:** ![ejplugge](https://sea1.discourse-cdn.com/wanikanicommunity/user_avatar/community.wanikani.com/ejplugge/32/313175_2.png) [@ejplugge](https://community.wanikani.com/u/ejplugge)\
**Post date:** [July 21, 2020, 1:20pm UTC](https://community.wanikani.com/t/api-question-dataupdatedat-in-reviews/44992/2 "2020-07-21T13:20:30Z")

</div>

Normally review records don’t get updated after they have been created. But recently the WK devs have been backfilling the review data to align with API changes on the backend: they’ve added and removed attributes related to this big backend change:

> [@Official announcement on upcoming API Version 2 breaking changes. Addition of new endpoint /spaced\_repetition\_systems](https://community.wanikani.com/t/official-announcement-on-upcoming-api-version-2-breaking-changes-addition-of-new-endpoint-spacedrepetitionsystems/44423):
>
> Hello all, This is a [follow-up on the announcement](https://community.wanikani.com/t/api-version-2-changes-in-regards-to-srs-stages/43900/) a while back about replacing /srs\_stages with /spaced\_repetition\_systems. We’ve been working to get these changes into our application since the announcement. Now that we have the implementation in place, we can share the details and a timeline with you. We do want to make clear we have not changed the timings, number of stages, or the passing stage for the two existing spaced repetition systems. All that has changed, at this very moment, is …

The result is that the updated timestamp gets bumped, even though the essentials of the review result haven’t changed.

The records you are mentioning are probably from before this change, and have been touched by that process. And the more recent review records will most likely be untouched. Your code should allow for the possibility that these kinds of changes will happen occasionally.

---

<div class="post-metadata">

**Author:** ![Shinz](https://sea1.discourse-cdn.com/wanikanicommunity/user_avatar/community.wanikani.com/shinz/32/310650_2.png) [@Shinz](https://community.wanikani.com/u/Shinz)\
**Post date:** [July 21, 2020, 1:26pm UTC](https://community.wanikani.com/t/api-question-dataupdatedat-in-reviews/44992/3 "2020-07-21T13:26:20Z")

</div>

Thank you for the answer! That could explain it. Most of the updated reviews are quite old… But I even have some from today that got updated already. But I will just ignore the updated timestamp then…

---

<div class="post-metadata">

**Author:** ![Kumirei](https://sea1.discourse-cdn.com/wanikanicommunity/user_avatar/community.wanikani.com/kumirei/32/480522_2.png) [@Kumirei](https://community.wanikani.com/u/Kumirei)\
**Post date:** [July 21, 2020, 1:31pm UTC](https://community.wanikani.com/t/api-question-dataupdatedat-in-reviews/44992/4 "2020-07-21T13:31:33Z")

</div>

> [@Shinz](#):
>
> I even have some from today that got updated already

You sure this isn’t just the time it was created?

---

<div class="post-metadata">

**Author:** ![ejplugge](https://sea1.discourse-cdn.com/wanikanicommunity/user_avatar/community.wanikani.com/ejplugge/32/313175_2.png) [@ejplugge](https://community.wanikani.com/u/ejplugge)\
**Post date:** [July 21, 2020, 1:44pm UTC](https://community.wanikani.com/t/api-question-dataupdatedat-in-reviews/44992/5 "2020-07-21T13:44:53Z")

</div>

> [@Shinz](#):
>
> Thank you for the answer! That could explain it. Most of the updated reviews are quite old… But I even have some from today that got updated already. But I will just ignore the updated timestamp then…

The updated timestamp is always filled in, even if the record has never been updated. Initially, the created timestamp and the updated timestamp will be identical. They will only drift apart if they’re updated after they’ve been created.

---

<div class="post-metadata">

**Author:** ![Shinz](https://sea1.discourse-cdn.com/wanikanicommunity/user_avatar/community.wanikani.com/shinz/32/310650_2.png) [@Shinz](https://community.wanikani.com/u/Shinz)\
**Post date:** [July 21, 2020, 6:13pm UTC](https://community.wanikani.com/t/api-question-dataupdatedat-in-reviews/44992/6 "2020-07-21T18:13:31Z")

</div>

Sorry, I might have been not really clear. When I said, got updated I mean that the timestamp of “data\_updated\_at” is newer than the one in “created\_at”. 🙂

> [@Kumirei](#):
>
> You sure this isn’t just the time it was created?

I am. 🙂

So all reviews created until June 10th have and update-date that is between mid and end of june.  
Most reviews created after june 10th, have identical update dates, but around 2-3% (estimated) are not. For most of them it’s just 1 second difference, which could be explainable. But for some it’s a couple of days…

Anyway. If the functional review data doesn’t get updated, I don’t need to worry about the updated timestamp…
