Skip to content

import https://www.hatvp.fr/le-repertoire/#open-data-repertoire

The information from http://www.hatvp.fr/agora/opendata/agora_repertoire_opendata.json is convenient for user display.

  • create a postgresql table agora_repertoire_opendata
    • id is a concatenation of "typeIdentifiantNational" and "identifiantNational"
    • content is the entire JSON
  • a row is created for each entry in the "publications" table

The tables from https://www.hatvp.fr/agora/opendata/csv/Vues_Separees_CSV.zip can be mapped directly to postgresql tables and are convenient to query.

A REST Api such as GET /nomUsage/April could select identifiant_national, type_identifiant_national where nom_usage_HATVP = 'April' and select the JSON from the agora_repertoire_opendata table with the result to return the corresponding JSON.