# Projet Open Access Compliance Check Tool (OACCT) 

Projet P5 de la bibliothèque de l'EPFL en collaboration avec les bibliothèques des Universités de Genève, Lausanne et Berne : https://www.swissuniversities.ch/themen/digitalisierung/p-5-wissenschaftliche-information/projekte/swiss-mooc-service-1-1-1-1

Ce notebook permet d'importer les données en utilisant l'API :

https://oacct-test.epfl.ch/api/

Exemple avec Journals :

https://oacct-test.epfl.ch/api/journal/

GET /api/journal/

HTTP 200 OK
Allow: GET, POST, HEAD, OPTIONS
Content-Type: application/json
Vary: Accept

[]

Media type: application/json

Content:
``` json
{
    "issn": [],
    "name": "",
    "name_short_iso_4": "",
    "website": "",
    "oa_options": "",
    "starting_year": null,
    "end_year": null,
    "doaj_seal": false,
    "doaj_status": false,
    "lockss": false,
    "nlch": false,
    "portico": false,
    "qoam_av_score": null
}
```



```python
import json
import requests
import codecs
oacct_login = 'oacct_test'
oacct_pwd = '2f4dBRhyj7'
headers = {'accept': 'application/json'}
```


```python
# test sans authentifications
url = 'https://oacct-test.epfl.ch/api/country/'
r = requests.get(url)
print(r)
```

    <Response [200]>



```python
print(r.text)
```

    [{"id":1,"name":"Afghanistan","iso_code":"AF"},{"id":249,"name":"Åland Islands","iso_code":"AX"},{"id":2,"name":"Albania","iso_code":"AL"},{"id":3,"name":"Algeria","iso_code":"DZ"},{"id":4,"name":"American Samoa","iso_code":"AS"},{"id":5,"name":"Andorra","iso_code":"AD"},{"id":6,"name":"Angola","iso_code":"AO"},{"id":7,"name":"Anguilla","iso_code":"AI"},{"id":8,"name":"Antarctica","iso_code":"AQ"},{"id":9,"name":"Antigua and Barbuda","iso_code":"AG"},{"id":10,"name":"Argentina","iso_code":"AR"},{"id":11,"name":"Armenia","iso_code":"AM"},{"id":12,"name":"Aruba","iso_code":"AW"},{"id":13,"name":"Australia","iso_code":"AU"},{"id":14,"name":"Austria","iso_code":"AT"},{"id":15,"name":"Azerbaijan","iso_code":"AZ"},{"id":16,"name":"Bahamas (the)","iso_code":"BS"},{"id":17,"name":"Bahrain","iso_code":"BH"},{"id":18,"name":"Bangladesh","iso_code":"BD"},{"id":19,"name":"Barbados","iso_code":"BB"},{"id":20,"name":"Belarus","iso_code":"BY"},{"id":21,"name":"Belgium","iso_code":"BE"},{"id":22,"name":"Belize","iso_code":"BZ"},{"id":23,"name":"Benin","iso_code":"BJ"},{"id":24,"name":"Bermuda","iso_code":"BM"},{"id":25,"name":"Bhutan","iso_code":"BT"},{"id":26,"name":"Bolivia (Plurinational State of)","iso_code":"BO"},{"id":27,"name":"Bonaire, Sint Eustatius and Saba","iso_code":"BQ"},{"id":28,"name":"Bosnia and Herzegovina","iso_code":"BA"},{"id":29,"name":"Botswana","iso_code":"BW"},{"id":30,"name":"Bouvet Island","iso_code":"BV"},{"id":31,"name":"Brazil","iso_code":"BR"},{"id":32,"name":"British Indian Ocean Territory (the)","iso_code":"IO"},{"id":33,"name":"Brunei Darussalam","iso_code":"BN"},{"id":34,"name":"Bulgaria","iso_code":"BG"},{"id":35,"name":"Burkina Faso","iso_code":"BF"},{"id":36,"name":"Burundi","iso_code":"BI"},{"id":37,"name":"Cabo Verde","iso_code":"CV"},{"id":38,"name":"Cambodia","iso_code":"KH"},{"id":39,"name":"Cameroon","iso_code":"CM"},{"id":40,"name":"Canada","iso_code":"CA"},{"id":41,"name":"Cayman Islands (the)","iso_code":"KY"},{"id":42,"name":"Central African Republic (the)","iso_code":"CF"},{"id":43,"name":"Chad","iso_code":"TD"},{"id":44,"name":"Chile","iso_code":"CL"},{"id":45,"name":"China","iso_code":"CN"},{"id":46,"name":"Christmas Island","iso_code":"CX"},{"id":47,"name":"Cocos (Keeling) Islands (the)","iso_code":"CC"},{"id":48,"name":"Colombia","iso_code":"CO"},{"id":49,"name":"Comoros (the)","iso_code":"KM"},{"id":50,"name":"Congo (the Democratic Republic of the)","iso_code":"CD"},{"id":51,"name":"Congo (the)","iso_code":"CG"},{"id":52,"name":"Cook Islands (the)","iso_code":"CK"},{"id":53,"name":"Costa Rica","iso_code":"CR"},{"id":59,"name":"Côte d'Ivoire","iso_code":"CI"},{"id":54,"name":"Croatia","iso_code":"HR"},{"id":55,"name":"Cuba","iso_code":"CU"},{"id":56,"name":"Curaçao","iso_code":"CW"},{"id":57,"name":"Cyprus","iso_code":"CY"},{"id":58,"name":"Czechia","iso_code":"CZ"},{"id":60,"name":"Denmark","iso_code":"DK"},{"id":61,"name":"Djibouti","iso_code":"DJ"},{"id":62,"name":"Dominica","iso_code":"DM"},{"id":63,"name":"Dominican Republic (the)","iso_code":"DO"},{"id":64,"name":"Ecuador","iso_code":"EC"},{"id":65,"name":"Egypt","iso_code":"EG"},{"id":66,"name":"El Salvador","iso_code":"SV"},{"id":67,"name":"Equatorial Guinea","iso_code":"GQ"},{"id":68,"name":"Eritrea","iso_code":"ER"},{"id":69,"name":"Estonia","iso_code":"EE"},{"id":70,"name":"Eswatini","iso_code":"SZ"},{"id":71,"name":"Ethiopia","iso_code":"ET"},{"id":72,"name":"Falkland Islands (the) [Malvinas]","iso_code":"FK"},{"id":73,"name":"Faroe Islands (the)","iso_code":"FO"},{"id":74,"name":"Fiji","iso_code":"FJ"},{"id":75,"name":"Finland","iso_code":"FI"},{"id":76,"name":"France","iso_code":"FR"},{"id":77,"name":"French Guiana","iso_code":"GF"},{"id":78,"name":"French Polynesia","iso_code":"PF"},{"id":79,"name":"French Southern Territories (the)","iso_code":"TF"},{"id":80,"name":"Gabon","iso_code":"GA"},{"id":81,"name":"Gambia (the)","iso_code":"GM"},{"id":82,"name":"Georgia","iso_code":"GE"},{"id":83,"name":"Germany","iso_code":"DE"},{"id":84,"name":"Ghana","iso_code":"GH"},{"id":85,"name":"Gibraltar","iso_code":"GI"},{"id":86,"name":"Greece","iso_code":"GR"},{"id":87,"name":"Greenland","iso_code":"GL"},{"id":88,"name":"Grenada","iso_code":"GD"},{"id":89,"name":"Guadeloupe","iso_code":"GP"},{"id":90,"name":"Guam","iso_code":"GU"},{"id":91,"name":"Guatemala","iso_code":"GT"},{"id":92,"name":"Guernsey","iso_code":"GG"},{"id":93,"name":"Guinea","iso_code":"GN"},{"id":94,"name":"Guinea-Bissau","iso_code":"GW"},{"id":95,"name":"Guyana","iso_code":"GY"},{"id":96,"name":"Haiti","iso_code":"HT"},{"id":97,"name":"Heard Island and McDonald Islands","iso_code":"HM"},{"id":98,"name":"Holy See (the)","iso_code":"VA"},{"id":99,"name":"Honduras","iso_code":"HN"},{"id":100,"name":"Hong Kong","iso_code":"HK"},{"id":101,"name":"Hungary","iso_code":"HU"},{"id":102,"name":"Iceland","iso_code":"IS"},{"id":103,"name":"India","iso_code":"IN"},{"id":104,"name":"Indonesia","iso_code":"ID"},{"id":250,"name":"International Agency","iso_code":"OI"},{"id":105,"name":"Iran (Islamic Republic of)","iso_code":"IR"},{"id":106,"name":"Iraq","iso_code":"IQ"},{"id":107,"name":"Ireland","iso_code":"IE"},{"id":108,"name":"Isle of Man","iso_code":"IM"},{"id":109,"name":"Israel","iso_code":"IL"},{"id":110,"name":"Italy","iso_code":"IT"},{"id":111,"name":"Jamaica","iso_code":"JM"},{"id":112,"name":"Japan","iso_code":"JP"},{"id":113,"name":"Jersey","iso_code":"JE"},{"id":114,"name":"Jordan","iso_code":"JO"},{"id":115,"name":"Kazakhstan","iso_code":"KZ"},{"id":116,"name":"Kenya","iso_code":"KE"},{"id":117,"name":"Kiribati","iso_code":"KI"},{"id":118,"name":"Korea (the Democratic People's Republic of)","iso_code":"KP"},{"id":119,"name":"Korea (the Republic of)","iso_code":"KR"},{"id":120,"name":"Kuwait","iso_code":"KW"},{"id":121,"name":"Kyrgyzstan","iso_code":"KG"},{"id":122,"name":"Lao People's Democratic Republic (the)","iso_code":"LA"},{"id":123,"name":"Latvia","iso_code":"LV"},{"id":124,"name":"Lebanon","iso_code":"LB"},{"id":125,"name":"Lesotho","iso_code":"LS"},{"id":126,"name":"Liberia","iso_code":"LR"},{"id":127,"name":"Libya","iso_code":"LY"},{"id":128,"name":"Liechtenstein","iso_code":"LI"},{"id":129,"name":"Lithuania","iso_code":"LT"},{"id":130,"name":"Luxembourg","iso_code":"LU"},{"id":131,"name":"Macao","iso_code":"MO"},{"id":132,"name":"Madagascar","iso_code":"MG"},{"id":133,"name":"Malawi","iso_code":"MW"},{"id":134,"name":"Malaysia","iso_code":"MY"},{"id":135,"name":"Maldives","iso_code":"MV"},{"id":136,"name":"Mali","iso_code":"ML"},{"id":137,"name":"Malta","iso_code":"MT"},{"id":138,"name":"Marshall Islands (the)","iso_code":"MH"},{"id":139,"name":"Martinique","iso_code":"MQ"},{"id":140,"name":"Mauritania","iso_code":"MR"},{"id":141,"name":"Mauritius","iso_code":"MU"},{"id":142,"name":"Mayotte","iso_code":"YT"},{"id":143,"name":"Mexico","iso_code":"MX"},{"id":144,"name":"Micronesia (Federated States of)","iso_code":"FM"},{"id":145,"name":"Moldova (the Republic of)","iso_code":"MD"},{"id":146,"name":"Monaco","iso_code":"MC"},{"id":147,"name":"Mongolia","iso_code":"MN"},{"id":148,"name":"Montenegro","iso_code":"ME"},{"id":149,"name":"Montserrat","iso_code":"MS"},{"id":150,"name":"Morocco","iso_code":"MA"},{"id":151,"name":"Mozambique","iso_code":"MZ"},{"id":152,"name":"Myanmar","iso_code":"MM"},{"id":153,"name":"Namibia","iso_code":"NA"},{"id":154,"name":"Nauru","iso_code":"NR"},{"id":155,"name":"Nepal","iso_code":"NP"},{"id":156,"name":"Netherlands (the)","iso_code":"NL"},{"id":157,"name":"New Caledonia","iso_code":"NC"},{"id":158,"name":"New Zealand","iso_code":"NZ"},{"id":159,"name":"Nicaragua","iso_code":"NI"},{"id":160,"name":"Niger (the)","iso_code":"NE"},{"id":161,"name":"Nigeria","iso_code":"NG"},{"id":162,"name":"Niue","iso_code":"NU"},{"id":163,"name":"Norfolk Island","iso_code":"NF"},{"id":164,"name":"North Macedonia","iso_code":"MK"},{"id":165,"name":"Northern Mariana Islands (the)","iso_code":"MP"},{"id":166,"name":"Norway","iso_code":"NO"},{"id":167,"name":"Oman","iso_code":"OM"},{"id":168,"name":"Pakistan","iso_code":"PK"},{"id":169,"name":"Palau","iso_code":"PW"},{"id":170,"name":"Palestine, State of","iso_code":"PS"},{"id":171,"name":"Panama","iso_code":"PA"},{"id":172,"name":"Papua New Guinea","iso_code":"PG"},{"id":173,"name":"Paraguay","iso_code":"PY"},{"id":174,"name":"Peru","iso_code":"PE"},{"id":175,"name":"Philippines (the)","iso_code":"PH"},{"id":176,"name":"Pitcairn","iso_code":"PN"},{"id":177,"name":"Poland","iso_code":"PL"},{"id":178,"name":"Portugal","iso_code":"PT"},{"id":179,"name":"Puerto Rico","iso_code":"PR"},{"id":180,"name":"Qatar","iso_code":"QA"},{"id":184,"name":"Réunion","iso_code":"RE"},{"id":181,"name":"Romania","iso_code":"RO"},{"id":182,"name":"Russian Federation (the)","iso_code":"RU"},{"id":183,"name":"Rwanda","iso_code":"RW"},{"id":185,"name":"Saint Barthélemy","iso_code":"BL"},{"id":186,"name":"Saint Helena, Ascension and Tristan da Cunha","iso_code":"SH"},{"id":187,"name":"Saint Kitts and Nevis","iso_code":"KN"},{"id":188,"name":"Saint Lucia","iso_code":"LC"},{"id":189,"name":"Saint Martin (French part)","iso_code":"MF"},{"id":190,"name":"Saint Pierre and Miquelon","iso_code":"PM"},{"id":191,"name":"Saint Vincent and the Grenadines","iso_code":"VC"},{"id":192,"name":"Samoa","iso_code":"WS"},{"id":193,"name":"San Marino","iso_code":"SM"},{"id":194,"name":"Sao Tome and Principe","iso_code":"ST"},{"id":195,"name":"Saudi Arabia","iso_code":"SA"},{"id":196,"name":"Senegal","iso_code":"SN"},{"id":197,"name":"Serbia","iso_code":"RS"},{"id":198,"name":"Seychelles","iso_code":"SC"},{"id":199,"name":"Sierra Leone","iso_code":"SL"},{"id":1000000,"name":"Sildavie2","iso_code":"II"},{"id":200,"name":"Singapore","iso_code":"SG"},{"id":201,"name":"Sint Maarten (Dutch part)","iso_code":"SX"},{"id":202,"name":"Slovakia","iso_code":"SK"},{"id":203,"name":"Slovenia","iso_code":"SI"},{"id":204,"name":"Solomon Islands","iso_code":"SB"},{"id":205,"name":"Somalia","iso_code":"SO"},{"id":206,"name":"South Africa","iso_code":"ZA"},{"id":207,"name":"South Georgia and the South Sandwich Islands","iso_code":"GS"},{"id":208,"name":"South Sudan","iso_code":"SS"},{"id":209,"name":"Spain","iso_code":"ES"},{"id":210,"name":"Sri Lanka","iso_code":"LK"},{"id":211,"name":"Sudan (the)","iso_code":"SD"},{"id":212,"name":"Suriname","iso_code":"SR"},{"id":213,"name":"Svalbard and Jan Mayen","iso_code":"SJ"},{"id":214,"name":"Sweden","iso_code":"SE"},{"id":215,"name":"Switzerland","iso_code":"CH"},{"id":216,"name":"Syrian Arab Republic (the)","iso_code":"SY"},{"id":217,"name":"Taiwan (Province of China)","iso_code":"TW"},{"id":218,"name":"Tajikistan","iso_code":"TJ"},{"id":219,"name":"Tanzania, the United Republic of","iso_code":"TZ"},{"id":220,"name":"Thailand","iso_code":"TH"},{"id":221,"name":"Timor-Leste","iso_code":"TL"},{"id":222,"name":"Togo","iso_code":"TG"},{"id":223,"name":"Tokelau","iso_code":"TK"},{"id":224,"name":"Tonga","iso_code":"TO"},{"id":225,"name":"Trinidad and Tobago","iso_code":"TT"},{"id":226,"name":"Tunisia","iso_code":"TN"},{"id":227,"name":"Turkey","iso_code":"TR"},{"id":228,"name":"Turkmenistan","iso_code":"TM"},{"id":229,"name":"Turks and Caicos Islands (the)","iso_code":"TC"},{"id":230,"name":"Tuvalu","iso_code":"TV"},{"id":231,"name":"Uganda","iso_code":"UG"},{"id":232,"name":"Ukraine","iso_code":"UA"},{"id":233,"name":"United Arab Emirates (the)","iso_code":"AE"},{"id":234,"name":"United Kingdom of Great Britain and Northern Ireland (the)","iso_code":"GB"},{"id":235,"name":"United States Minor Outlying Islands (the)","iso_code":"UM"},{"id":236,"name":"United States of America (the)","iso_code":"US"},{"id":999999,"name":"UNKNOWN","iso_code":"__"},{"id":237,"name":"Uruguay","iso_code":"UY"},{"id":238,"name":"Uzbekistan","iso_code":"UZ"},{"id":239,"name":"Vanuatu","iso_code":"VU"},{"id":240,"name":"Venezuela (Bolivarian Republic of)","iso_code":"VE"},{"id":241,"name":"Viet Nam","iso_code":"VN"},{"id":242,"name":"Virgin Islands (British)","iso_code":"VG"},{"id":243,"name":"Virgin Islands (U.S.)","iso_code":"VI"},{"id":244,"name":"Wallis and Futuna","iso_code":"WF"},{"id":245,"name":"Western Sahara*","iso_code":"EH"},{"id":246,"name":"Yemen","iso_code":"YE"},{"id":247,"name":"Zambia","iso_code":"ZM"},{"id":248,"name":"Zimbabwe","iso_code":"ZW"}]



```python
# test avec authentification
url = 'https://oacct-test.epfl.ch/api/country/3'
r2 = requests.get(url, auth=(oacct_login, oacct_pwd))
print(r2)
```

    <Response [200]>



```python
print(r2.text)
```

    {"id":3,"name":"Algeria","iso_code":"DZ"}



```python
journal =   {
    "id": 1,
    "name": "Revue médicale suisse",
    "name_short_iso_4": "Rev. méd. suisse",
    "starting_year": "2005",
    "end_year": "9999",
    "website": "",
    "country": 215.0,
    "language": "138",
    "publisher": "1",
    "doaj_seal": 0,
    "doaj_status": 0,
    "lockss": 0,
    "portico": 0,
    "nlch": 0,
    "qoam_av_score": "",
    "oa_status": 1,
    "issn": "1234-5678"
  }
```


```python
# test avec post
url = 'https://oacct-test.epfl.ch/api/journal/'
r2 = requests.post(url, auth=(oacct_login, oacct_pwd), headers=headers, data=journal)
print(r2)
```

    <Response [400]>



```python
print(r2.text)
```

    {"issn":["This field is required."]}



```python
country = {
    "name": "Sildavie",
    "iso_code": "II",
    "id": 333
  }
```


```python
# test avec post
url = 'https://oacct-test.epfl.ch/api/country/'
r2 = requests.post(url, auth=(oacct_login, oacct_pwd), headers=headers, data=country)
print(r2)
```

    <Response [201]>



```python
print(r2.json())
```

    {'id': 1000001, 'name': 'Sildavie', 'iso_code': 'II'}



```python
country2 = {
    "id": 1000000,
    "name": "Sildavie3",
    "iso_code": "II"
}
```


```python
# test avec put
url = 'https://oacct-test.epfl.ch/api/country/1000000'
r2 = requests.put(url, auth=(oacct_login, oacct_pwd), headers=headers, data=country2)
print(r2)
```

    <Response [200]>



```python
print(r2.json())
```

    {'id': 1000000, 'name': 'Sildavie2', 'iso_code': 'II'}



```python
# convert to json
json_response = r2.json()
print(json_response)
```

    {'id': 1000000, 'name': 'Sildavie2', 'iso_code': 'II'}



```python
# get the name
name = json_response['name']
name
```




    'Sildavie2'