PermID atom feed now has at most 500 entries. not enough to cover time since last bulk file

duncan.sands

Before June 21, by the end of the week the "organization" atom feed would have around 10,000 atom entries, providing all new values since the last bulk file. Since then, none of the atom feeds provides more than 500 entries. For example, right now the organization atom feed provides exactly 500 values with "updated" between "2020-07-08T00:03:33Z" and "2020-07-08T06:25:01Z". The most recent organization bulk file is from 2020-07-05. So if right now you download the bulk file then add in entries from the atom field you will be missing data from 2020-07-06 and 2020-07-07. Is this intentional?

Jirapongse

@duncan.sands

Currently, there are 500 entries in the Organization atom feed.

    <title>Organization Feed</title>
    <link rel="self" href="https://api-eit.refinitiv.com/permid/atom/organization?offset=0&amp;length=500&quot; />
    <link rel="first" href="https://api-eit.refinitiv.com/permid/atom/organization?offset=0&amp;length=500&quot; />
    <link rel="last" href="https://api-eit.refinitiv.com/permid/atom/organization?offset=0&amp;length=500&quot; />
    <author>
        <name>PermID</name>
        <uri>https://permid.org</uri&gt;
    </author>
    <subtitle>From date(UTC) : 2020-07-04T04:28:26.000Z, To date(UTC) : 2020-07-09T04:28:25.000Z, Window : Offset = 0, Length = 500, out of 500 results.</subtitle>

I will contact the PermId support team to verify it.

Jirapongse

@duncan.sands

Could you please verify if this issue has been resolved?

From my checking, the current response has 1000 results.

 <subtitle>From date(UTC) : 2020-10-28T04:12:54.000Z, To date(UTC) : 2020-11-02T04:12:53.000Z, Window : Offset = 0, Length = 500, out of 1000 results.</subtitle>

duncan.sands

No, it is not resolved. It looks like the developers just doubled the limit from 500 to 1000. Previously by the end of the week the organizations atom would have around 10,000 entries, so 1000 is nowhere near enough (in fact it's hardly enough for a single day's worth of organizations updates) yet it needs to cover as much as one week from the previous bulk file. I don't know why paging was turned off. It is true that it seemed kind of buggy before (eg: "next" link didn't work properly), but at least you could then page through all of the needed data. If it is a deliberate decision to only support a limited number of atoms, and require people to get new atoms eg several times a day (because otherwise they may get some), and too bad for people who start from a bulk file downloaded in the middle of the week, then that should at least be clearly announced and documented.

Jirapongse

Thank you for the update. I will forward this information to the support team.

Jirapongse

@duncan.sands

I got a response from the development team that 1000 are the maximum results allowed in ATOM feed.

duncan.sands

Thanks, but that reply is a bit ambiguous. 1000 was always the maximum for a single page. But previously you could move from one page to another, retrieving more than 1000 in total - this is what no longer works. Is the team just referring to the limit of 1000 per page, in which case they missed the point? Or are they saying that the total is now limited to 1000?

Jirapongse

@duncan.sands

The Open PermId team would like to see the URLs and description when retrieving 10000 entries. For example:

    <link rel="next" href="https://api-eit.refinitiv.com/permid/atom/organization?offset=50&amp;length=50&quot; />
    <link rel="self" href="https://api-eit.refinitiv.com/permid/atom/organization?offset=0&amp;length=50&quot; />
    <link rel="first" href="https://api-eit.refinitiv.com/permid/atom/organization?offset=0&amp;length=50&quot; />
    <link rel="last" href="https://api-eit.refinitiv.com/permid/atom/organization?offset=950&amp;length=50&quot; />
    <author>
        <name>PermID</name>
        <uri>https://permid.org</uri&gt;
    </author>
    <subtitle>From date(UTC) : 2020-11-13T07:51:41.000Z, To date(UTC) : 2020-11-18T07:51:40.000Z, Window : Offset = 0, Length = 50, out of 1000 results.</subtitle>

If you still have this information, please share it.

duncan.sands

That's the whole problem: there should be many thousands of results, but you can't get them. A few months ago, every Friday there were usually around 10,000 changes to "organizations" since the bulk file from the previous Sunday. You could download them all, 1000 at a time. So it was possible to get the current state by downloading the bulk file and then adding in all changes. But you can't do it any more because you can no longer get more than 1000 changes in total.

Jirapongse

@duncan.sands

I understand it.

If you still have the previous output that can retrieve 10000, it will be helpful and I will forward it to the support team. It is an indication that it was able to retrieve more than 1000 entries.

duncan.sands

This query would previously return more atoms, if there were more than 1000 available in total: https://permid.org/atom/organization?access-token=TOKEN&offset=1000&length=1000&format=ntriples