Base URL: - https://api.devinit.org
- /all_tables
- /meta_data (just serves di_concept_in_dh, not too useful at the moment)
- /single_table
- /multi_table
| Parameter | Description | Usage Example |
|---|---|---|
| indicator | The table ID from which to retrieve the data | ?indicator=population_total |
| entities | Country code | ?entities=UG,KE,NA |
| start_year | Lower year limit for the returned data | ?start_year=2000 |
| end_year | Upper year limit for the returned data | ?end_year=2001 |
| limit | Number of rows returned | ?limit=100 |
| offset | The results page to return e.g. if the limit is 10 out 30 rows, an offset of 2 will return the second 10 records | ?offset=2 |
| format | The data format of the returned results | ?format=xml (available options are xml, json, or csv) |
/single_table?indicator=population_total&entities=UG,KE&start_year=2000&end_year=2000&limit=2&offset=0&format=xml
| Parameter | Description | Usage Example |
|---|---|---|
| indicator | The table name from which to retrieve the data | ?indicators=population_total,govt_revenue_pc_gdp |
| entities | Country code | ?entities=UG,KE,NA |
| start_year | Lower year limit for the returned data | ?start_year=2000 |
| end_year | Upper year limit for the returned data | ?end_year=2001 |
| limit | Number of rows returned | ?limit=100 |
| offset | The results page to return e.g. if the limit is 10 out 30 rows, an offset of 2 will return the second 10 records | ?offset=2 |
| format | The data format of the returned results | ?format=xml (available options are xml, json, or csv) |
/multi_table?indicators=population_total,govt_revenue_pc_gdp&entities=UG&start_year=2015&format=xml
This section documents how to retrieve data from the API partaining to common Data Hub (DDH) visualisations
Certificates are renewed with a certbot.sh run on a Cronjob like so:
#!/bin/bash
renewal_result="$(command certbot renew --webroot -w /home/alex/ddw-external-api/letsencrypt)"
#Check if successful result is received
result="$(echo $renewal_result | grep -o Congratulations )"
#If successful copy certs to the correct folder and refresh nginx docker node
if [ $result ]; then
cd /home/alex/ddw-external-api/
cp -f /etc/letsencrypt/live/api.devinit.org/privkey.pem /home/alex/ddw-external-api/ssl/
cp -f /etc/letsencrypt/live/api.devinit.org/fullchain.pem /home/alex/ddw-external-api/ssl/
command docker-compose restart nginx
fi