A Free REST API for Johns Hopkins University COVID-19 dataset

1
mongodb+srv://readonly:readonly@covid-19.hip2i.mongodb.net/covid19

1
function log_ip(payload) {
2
  const log = context.services.get("pre-prod").db("logs").collection("ip");
3
  let ip = "IP missing";
4
  try {
5
    ip = payload.headers["X-Envoy-External-Address"][0];
6
  } catch (error) {
7
    console.log("Can't retrieve IP address.")
8
  }
9
  console.log(ip);
10
  log.updateOne({"_id": ip}, {"$inc": {"queries": 1}}, {"upsert": true})
11
    .then( result => {
12
      console.log("IP + 1: " + ip);
13
    });
14
}

1
function isPositiveInteger(str) {
2
    return ((parseInt(str, 10).toString() == str) && str.indexOf('-') === -1);
3
}
4
5
exports = function(payload, response) {
6
  log_ip(payload);
7
8
  const {uid, country, state, country_iso3, min_date, max_date, hide_fields} = payload.query;
9
  const coll = context.services.get("mongodb-atlas").db("covid19").collection("global_and_us");
10
11
  var query = {};
12
  var project = {};
13
  const sort = {'date': 1};
14
15
  if (uid !== undefined && isPositiveInteger(uid)) {
16
    query.uid = parseInt(uid, 10);
17
  }
18
  if (country !== undefined) {
19
    query.country = country;
20
  }
21
  if (state !== undefined) {
22
    query.state = state;
23
  }
24
  if (country_iso3 !== undefined) {
25
    query.country_iso3 = country_iso3;
26
  }
27
  if (min_date !== undefined && max_date === undefined) {
28
    query.date = {'$gte': new Date(min_date)};
29
  }
30
  if (max_date !== undefined && min_date === undefined) {
31
    query.date = {'$lte': new Date(max_date)};
32
  }
33
  if (min_date !== undefined && max_date !== undefined) {
34
    query.date = {'$gte': new Date(min_date), '$lte': new Date(max_date)};
35
  }
36
  if (hide_fields !== undefined) {
37
    const fields = hide_fields.split(',');
38
    for (let i = 0; i < fields.length; i++) {
39
      project[fields[i].trim()] = 0
40
    }
41
  }
42
43
  console.log('Query: ' + JSON.stringify(query));
44
  console.log('Projection: ' + JSON.stringify(project));
45
  // [...]
46
};

1
exports = function(payload, response) {
2
  // [...]
3
  coll.find(query, project).sort(sort).toArray()
4
    .then( docs => {
5
      response.setBody(JSON.stringify(docs));
6
      response.setHeader("Contact","devrel@mongodb.com");
7
    });
8
};

1
function isPositiveInteger(str) {
2
    return ((parseInt(str, 10).toString() == str) && str.indexOf('-') === -1);
3
}
4
5
function log_ip(payload) {
6
  const log = context.services.get("pre-prod").db("logs").collection("ip");
7
  let ip = "IP missing";
8
  try {
9
    ip = payload.headers["X-Envoy-External-Address"][0];
10
  } catch (error) {
11
    console.log("Can't retrieve IP address.")
12
  }
13
  console.log(ip);
14
  log.updateOne({"_id": ip}, {"$inc": {"queries": 1}}, {"upsert": true})
15
    .then( result => {
16
      console.log("IP + 1: " + ip);
17
    });
18
}
19
20
exports = function(payload, response) {
21
  log_ip(payload);
22
23
  const {uid, country, state, country_iso3, min_date, max_date, hide_fields} = payload.query;
24
  const coll = context.services.get("mongodb-atlas").db("covid19").collection("global_and_us");
25
26
  var query = {};
27
  var project = {};
28
  const sort = {'date': 1};
29
30
  if (uid !== undefined && isPositiveInteger(uid)) {
31
    query.uid = parseInt(uid, 10);
32
  }
33
  if (country !== undefined) {
34
    query.country = country;
35
  }
36
  if (state !== undefined) {
37
    query.state = state;
38
  }
39
  if (country_iso3 !== undefined) {
40
    query.country_iso3 = country_iso3;
41
  }
42
  if (min_date !== undefined && max_date === undefined) {
43
    query.date = {'$gte': new Date(min_date)};
44
  }
45
  if (max_date !== undefined && min_date === undefined) {
46
    query.date = {'$lte': new Date(max_date)};
47
  }
48
  if (min_date !== undefined && max_date !== undefined) {
49
    query.date = {'$gte': new Date(min_date), '$lte': new Date(max_date)};
50
  }
51
  if (hide_fields !== undefined) {
52
    const fields = hide_fields.split(',');
53
    for (let i = 0; i < fields.length; i++) {
54
      project[fields[i].trim()] = 0
55
    }
56
  }
57
58
  console.log('Query: ' + JSON.stringify(query));
59
  console.log('Projection: ' + JSON.stringify(project));
60
61
  coll.find(query, project).sort(sort).toArray()
62
    .then( docs => {
63
      response.setBody(JSON.stringify(docs));
64
      response.setHeader("Contact","devrel@mongodb.com");
65
    });
66
};

1
curl --location --request GET 'https://webhooks.mongodb-stitch.com/api/client/v2.0/app/covid-19-qppza/service/REST-API/incoming_webhook/metadata'

1
curl --location --request GET 'https://webhooks.mongodb-stitch.com/api/client/v2.0/app/covid-19-qppza/service/REST-API/incoming_webhook/global_and_us?country=Canada&state=Alberta&min_date=2020-04-22T00:00:00.000Z&max_date=2020-04-27T00:00:00.000Z&hide_fields=_id,%20country,%20country_code,%20country_iso2,%20country_iso3,%20loc,%20state'