Help on extractin datas from reliefweb database

178 views
Skip to first unread message

forma...@gmail.com

unread,
Jan 17, 2019, 3:28:28 AM1/17/19
to ReliefWeb API Developers
Hi all,

I would like to extract the following datas from reliefweb database fro Job offer on WaSH in the Middle East (Lybia, Lebanon Jordan, OTP, SYria, Turkey, Iraq, Yemen, Egypt) for the last 3 years:

·        -  Type of position versus time length of position open

·        -  Skills + knowledge or experience + tasks + level of study + year of experience required for coordinator based in capital 

·        -  Skills + knowledge or experience + tasks + level of study + year of experience required for manager based at project level

Can anybody help me on this?


Thanks,


Edith







Andy Footner

unread,
Jan 23, 2019, 1:49:21 PM1/23/19
to ReliefWeb API Developers
Hi Edith, thanks for your question.

I think you'll have to do some digging in the job descriptions to get some of the details you're after, but you can find the relevant positions with this POST request to:

https://api.reliefweb.int/v1/jobs?appname=<your-project-name-or-email>


```
{
  "profile": "minimal",
  "preset": "analysis",
  "limit": 1,
  "fields": {
    "include": ["experience.name", "body", "career_categories.name", "type.name", "theme.name", "date.created", "date.closing"]
  },
  "filter": {
    "conditions": [
      {
        "conditions": [
          {
            "field": "country.id",
            "value": 82
          },
          {
            "field": "country.id",
            "value": 122
          },
          {
            "field": "country.id",
            "value": 129
          },
          {
            "field": "country.id",
            "value": 137
          },
          {
            "field": "country.id",
            "value": 140
          },
          {
            "field": "country.id",
            "value": 180
          },
          {
            "field": "country.id",
            "value": 226
          },
          {
            "field": "country.id",
            "value": 236
          },
          {
            "field": "country.id",
            "value": 255
          }
        ],
        "operator": "OR"
      },
      {
        "field": "theme.id",
        "value": 4604
      },
      {
        "field": "date.created",
        "value": {
          "from": "2016-01-01T00:00:00+00:00",
          "to": "2019-01-02T00:00:00+00:00"
        }
      }
    ],
    "operator": "AND"
  }
}
```

adjusting the `limit` and `offset` parameters to page through the results (I see just under 800 jobs that fit your criteria at the moment).

Hope that helps!

Andy
Reply all
Reply to author
Forward
0 new messages