{"id":4132,"date":"2017-12-15T20:52:50","date_gmt":"2017-12-15T19:52:50","guid":{"rendered":"http:\/\/gpmfactory.com\/?p=4132"},"modified":"2017-12-16T11:50:15","modified_gmt":"2017-12-16T10:50:15","slug":"api-open-data-temps-reel-de-la-ratp","status":"publish","type":"post","link":"https:\/\/gpmfactory.com\/index.php\/2017\/12\/15\/api-open-data-temps-reel-de-la-ratp\/","title":{"rendered":"API Open Data Temps r\u00e9el de la RATP"},"content":{"rendered":"

T\u00e9l\u00e9charger l’application apex de d\u00e9mo depuis Github.<\/a><\/p>\n

Pour utiliser l’API\u00a0API Open Data Temps r\u00e9el<\/span>\u00a0 de la RATP<\/a> depuis Oracle Apex, c’est \u00e0 dire depuis une database Oracle, on peut utiliser la m\u00e9thode suivante:<\/p>\n

Appel\u00a0 d’un service<\/h3>\n

Liste des stations pour une ligne donn\u00e9e (RER A dans l’example ci-dessous)<\/p>\n

declare\n l_envelope CLOB;\nBEGIN\n\n-- Build a SOAP document appropriate for the web service.\n l_envelope := '\n<soap:Envelope xmlns:soap=\"http:\/\/www.w3.org\/2003\/05\/soap-envelope\" xmlns:wsiv=\"http:\/\/wsiv.ratp.fr\" xmlns:xsd=\"http:\/\/wsiv.ratp.fr\/xsd\">\n <soap:Header\/>\n   <soap:Body>\n     <wsiv:getStations> \n      <wsiv:station>\n        <xsd:line>\n          <xsd:id>RA<\/xsd:id>\n        <\/xsd:line>\n       <\/wsiv:station>\n     <\/wsiv:getStations>\n   <\/soap:Body>\n<\/soap:Envelope>\n';\n\napex_web_service.make_request(\n p_url => 'http:\/\/opendata-tr.ratp.fr\/wsiv\/services\/Wsiv',\n p_collection_name => 'RATP',\n p_version => '1.2',\n p_envelope => l_envelope );\n\nend;<\/pre>\n
Le document XML est enregistr\u00e9 dans la colonne nomm\u00e9e XMLTYPE001 d’une collection APEX<\/a> par la proc\u00e9dure apex_web_service.make_request<\/a>.<\/p>\n
Parsing du r\u00e9sultat<\/h3>\n
Le r\u00e9sultat est enregistr\u00e9 dans une collection dont le nom, arbitrairement donn\u00e9, est : ‘RATP’.<\/p>\n
Observer que l’on pr\u00e9cise des namespaces dans l’appel \u00e0 la fonction XMLTABLE<\/a>:<\/p>\n
SELECT xt.name Station\nFROM apex_collections x,\n XMLTABLE(\n     XMLNAMESPACES ('http:\/\/www.w3.org\/2003\/05\/soap-envelope' AS \"soapenv\",\n                    'http:\/\/wsiv.ratp.fr' AS \"ns2\", \n                    default 'http:\/\/wsiv.ratp.fr\/xsd' \n     ),\n     '\/soapenv:Envelope\/soapenv:Body\/ns2:getStationsResponse\/ns2:return\/stations' PASSING x.xmltype001\n     COLUMNS \n        name VARCHAR2(100) PATH 'name\/text()'\n ) xt\nwhere collection_name = 'RATP'\norder by station<\/pre>\n
Conclusion<\/h3>\n
Une fois que les donn\u00e9es sont disponibles sous forme de table, il est tr\u00e8s simple d’utiliser n’importe quel composant d’Apex pour restituer les informations.<\/p>\n
\"\"<\/p>\n
<\/pre>\n
\"\"<\/p>\n
Requete pour obtenir les prochains passages<\/h3>\n
SELECT xt.codem code, to_date(xt.stationsDates,'YYYYMMDDHH24MI') passage, to_date(xt.stationsDates,'YYYYMMDDHH24MI') delai, xt.direction direction \nFROM apex_collections x,\n XMLTABLE(\n XMLNAMESPACES ('http:\/\/www.w3.org\/2003\/05\/soap-envelope' AS \"soapenv\",\n 'http:\/\/wsiv.ratp.fr' AS \"ns2\",\n default 'http:\/\/wsiv.ratp.fr\/xsd'\n ),\n '\/soapenv:Envelope\/soapenv:Body\/ns2:getMissionsNextResponse\/ns2:return\/missions' PASSING x.xmltype001\n COLUMNS \n stationsDates VARCHAR2(100) PATH 'stationsDates\/text()',\n codem VARCHAR2(100) PATH 'code\/text()',\n direction VARCHAR2(100) PATH 'direction\/sens\/text()'\n ) xt\nwhere COLLECTION_NAME='RATPH'\norder by passage ASC<\/pre>\n
Code PLSQL pour obtenir les prochains passages<\/h3>\n
declare\n l_envelope CLOB;\nBEGIN\n\n-- Build a SOAP document appropriate for the web service.\n l_envelope := '<soap:Envelope xmlns:soap=\"http:\/\/www.w3.org\/2003\/05\/soap-envelope\" xmlns:wsiv=\"http:\/\/wsiv.ratp.fr\" xmlns:xsd=\"http:\/\/wsiv.ratp.fr\/xsd\">\n <soap:Header\/>\n <soap:Body>\n <wsiv:getMissionsNext>\n <wsiv:station>\n <xsd:id>' || :P6_STATIONID ||'<\/xsd:id>\n <xsd:line>\n <xsd:id>' || :P4_LIGNE ||'<\/xsd:id>\n <\/xsd:line>\n <xsd:name><\/xsd:name>\n <\/wsiv:station>\n <wsiv:direction> \n <xsd:sens>*<\/xsd:sens>\n <\/wsiv:direction>\n <\/wsiv:getMissionsNext>\n <\/soap:Body>\n<\/soap:Envelope>\n';apex_web_service.make_request(\n p_url => 'http:\/\/opendata-tr.ratp.fr\/wsiv\/services\/Wsiv',\n p_collection_name => 'RATPH',\n p_version => '1.2',\n p_envelope => l_envelope );\nend;<\/pre>\n","protected":false},"excerpt":{"rendered":"
T\u00e9l\u00e9charger l’application apex de d\u00e9mo depuis Github. Pour utiliser l’API\u00a0API Open Data Temps r\u00e9el\u00a0 de la RATP depuis Oracle Apex, c’est \u00e0 dire depuis…<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[6,7,1],"tags":[],"ppma_author":[150],"class_list":["post-4132","post","type-post","status-publish","format-standard","hentry","category-demo-2","category-dev","category-non-classe"],"authors":[{"term_id":150,"user_id":1,"is_guest":0,"slug":"admin8700","display_name":"Patrick","avatar_url":"https:\/\/secure.gravatar.com\/avatar\/209d5ed69b74d288390621ab4c1d3773?s=96&d=mm&r=g","0":null,"1":"","2":"","3":"","4":"","5":"","6":"","7":"","8":""}],"_links":{"self":[{"href":"https:\/\/gpmfactory.com\/index.php\/wp-json\/wp\/v2\/posts\/4132","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/gpmfactory.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/gpmfactory.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/gpmfactory.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/gpmfactory.com\/index.php\/wp-json\/wp\/v2\/comments?post=4132"}],"version-history":[{"count":9,"href":"https:\/\/gpmfactory.com\/index.php\/wp-json\/wp\/v2\/posts\/4132\/revisions"}],"predecessor-version":[{"id":4147,"href":"https:\/\/gpmfactory.com\/index.php\/wp-json\/wp\/v2\/posts\/4132\/revisions\/4147"}],"wp:attachment":[{"href":"https:\/\/gpmfactory.com\/index.php\/wp-json\/wp\/v2\/media?parent=4132"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/gpmfactory.com\/index.php\/wp-json\/wp\/v2\/categories?post=4132"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/gpmfactory.com\/index.php\/wp-json\/wp\/v2\/tags?post=4132"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/gpmfactory.com\/index.php\/wp-json\/wp\/v2\/ppma_author?post=4132"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}