notshi
commented
3 years ago Hi @markbrough we will take a look at this but you're better off using the new dquery stuff as this is our old method of querying the database and was only designed for d-portal and not external use.
This URLOR(%0A%09root%3D%27%2Fiati-activities%2Fiati-activity%2Ftitle%2Fnarrative%27%20AND%0A%09to_tsvector(%27simple%27%2C%20xson-%3E%3E%27%27)%20%40%40%20to_tsquery(%27simple%27%2C%27COVID-19%27)%0A)OR(%0A%09root%3D%27%2Fiati-activities%2Fiati-activity%2Fdescription%2Fnarrative%27%20AND%0A%09to_tsvector(%27simple%27%2C%20xson-%3E%3E%27%27)%20%40%40%20to_tsquery(%27simple%27%2C%27COVID-19%27)%0A)OR(%0A%09root%3D%27%2Fiati-activities%2Fiati-activity%2Ftransaction%2Fdescription%2Fnarrative%27%20AND%0A%09to_tsvector(%27simple%27%2C%20xson-%3E%3E%27%27)%20%40%40%20to_tsquery(%27simple%27%2C%27COVID-19%27)%0A)%0A%0A) should get you what you need.
Or visit https://d-portal.org/dquery and under 'EXAMPLES', choose COVID-19 then hover over 'DOWNLOAD XSON' to choose which formats you need. Let me know if this works (or not) for you.
The above error could possibly be due to a timed out error or it has hit a memory limit but we'll need to look at it further.
markbrough
Hello! Thanks again for all of your help earlier this year in helping me understand how to access COVID-19 activities from D-Portal.
The COVID-19 visualisation is still using D-Portal as the source for COVID-19 data. However, the following URL is leading to a 502 Bad Gateway error at the moment. Please could you help (or let me know if there is a different URL I should be using)?
Many thanks!
This is the URL that is leading to a 502 Bad Gateway error:
https://d-portal.org/q.xml?from=act&limit=-1&distincton=aid&text_search=COVID-19