New Projects not appearing on data-file

[benfoxall]

On the page : http://aidview.net/data-file?Funder=SE-2&SectorCategory=122

The "New Projects" widget doesn't seem to be populated.

[benfoxall]

Looks like this is the result of api limiting

[siwhitehouse]

Hi Ben

My understanding of the AidView API (at our end) is that there isn't any limits on the calls you can make to it. As the "New Projects" widget still doesn't seem to be populating can we take another look at this, please?

I'm happy to take any suggestions on what we can do to help you troubleshoot this.

[siwhitehouse]

Ben - I'm not sure that I fully understand this query. What ought the "New Projects" widget be doing?

[benfoxall]

It looks like it's a problem with the new api too:

http://localhost:3000/data-file?Funder=SE-2&SectorCategory=122

The actual widget page url:

http://localhost:3000/widgets/new_projects?Funder=SE-2&SectorCategory=122&view=full

And the api request made to build it:

http://109.104.101.243:8080/exist/rest/db/apps/iati/xquery/woapi.xq?Funder=SE-2&SectorCategory=122&corpus=test&format=json&orderby=start-actual&pagesize=5&result=values

looks like there isn't any data coming back in there. Removing "orderby=start-actual" - seems to return some activities.

I think this widget is supposed to show the most recent 5 items.

[benfoxall]

Aidinfo to Check with Chris on the API.

"wondering why, http://109.104.101.243:8080/exist/rest/db/apps/iati/xquery/woapi.xq?Funder=SE-2&SectorCategory=122&corpus=test&format=json&orderby=start-actual&pagesize=5&result=values returns no activities - but http://109.104.101.243:8080/exist/rest/db/apps/iati/xquery/woapi.xq?Funder=SE-2&SectorCategory=122&corpus=test&format=json&pagesize=5&result=values (without orderby=start-actual) does"

[KitWallace]

The API was somewhat over-protective and was ignoring activities without a start-actual date when ordering by start-actual. Both queries return the same result now

[siwhitehouse]

http://aidview-dev.herokuapp.com/data-file?Funder=SE-2&SectorCategory=122 is now pulling through 5 new projects. When I click on the widget the resulting page lists the projects but doesn't contain clickable links through to them.