{"id":3217,"date":"2016-05-27T13:13:46","date_gmt":"2016-05-27T12:13:46","guid":{"rendered":"http:\/\/iamwcew.fr.oracle.com\/blog\/?p=3217"},"modified":"2017-08-28T20:21:32","modified_gmt":"2017-08-28T18:21:32","slug":"oracle-pcs-reporting-a-partir-des-apis-rest","status":"publish","type":"post","link":"https:\/\/gpmfactory.com\/index.php\/2016\/05\/27\/oracle-pcs-reporting-a-partir-des-apis-rest\/","title":{"rendered":"Oracle PCS &#8211; Reports et Dashboards \u00e0 partir des APIs REST"},"content":{"rendered":"<p>Oracle Process Cloud Service propose des APIs permettant d\u2019acc\u00e9der \u00e0 des informations structurelles et \u00e0 des indicateurs agr\u00e9g\u00e9s d&rsquo;activit\u00e9s (Les APIS de\u00a0<em><a href=\"https:\/\/docs.oracle.com\/cloud\/latest\/process_gs\/CPRRA\/api-Manage%20Analytics.html\">Analytics<\/a>\u00a0sont<\/em>\u00a0disponible sur le serveur GSE).<br \/>\nOn peut ensuite\u00a0utiliser BI Publisher pour la production de rapport d&rsquo;activit\u00e9 en format pdf.<\/p>\n<p>cf <a href=\"https:\/\/docs.oracle.com\/cloud\/latest\/process_gs\/CPRRA\/index.html\">Documentation<\/a>\u00a0des APIS<\/p>\n<p>Voici un exemple \u00e0 partir de DHC:<\/p>\n<p>&nbsp;<\/p>\n<p><em>Retrieves the process-definitions with forms, without forms, docs or all using the interfaceFilter. Filter can have four values &#8211; form, noForm, doc or all. The value doc can be used to fetch process definitions that can be started by a document\/folder.<\/em><\/p>\n<div>\n<ul class=\"nav nav-tabs\">\n<li class=\"active\"><em><a href=\"https:\/\/docs.oracle.com\/cloud\/latest\/process_gs\/CPRRA\/op-process-definitions-get.html#request\" data-toggle=\"tab\"> Request<\/a><\/em><\/li>\n<li><a href=\"https:\/\/docs.oracle.com\/cloud\/latest\/process_gs\/CPRRA\/op-process-definitions-get.html#response\" data-toggle=\"tab\"> Response<\/a><\/li>\n<\/ul>\n<\/div>\n<p>Les APIS renvoient un body en format Json. je n&rsquo;ai pas r\u00e9ussi \u00e0 lui faire g\u00e9n\u00e9rer un autre format.<\/p>\n<h3>Cas Particulier de Analytics<\/h3>\n<p>Il s&rsquo;agit des APIs qui seront les plus int\u00e9ressantes \u00e0 utiliser pour la r\u00e9alisation de <em>dashboard<\/em> sp\u00e9cifiques.<\/p>\n<p>Obtention de la d\u00e9finition d&rsquo;une requ\u00eate:<\/p>\n<p style=\"padding-left: 30px;\">pcs-gse00000181.process.us2.oraclecloud.com:443\/bpm\/api\/3.0\/analytics\/ootbqueries-definitions\/DUE_DATE_ANALYSIS_BY_OPEN_TASKS_TREEMAP<\/p>\n<p>L&rsquo;appel suivant d\u00e9clenche une requ\u00eate analytique<\/p>\n<p style=\"padding-left: 30px;\">pcs-gse00000181.process.us2.oraclecloud.com:443\/bpm\/api\/3.0\/analytics\/ootbqueries\/DUE_DATE_ANALYSIS_BY_OPEN_TASKS_TREEMAP<\/p>\n<p>Je n&rsquo;ai pas exploit\u00e9 plus loin les possibilit\u00e9s, mais il est facile d&rsquo;imaginer \u00a0qu&rsquo;avec Oracle Jet, par exemple, c&rsquo;est simple de produire une repr\u00e9sentation graphique de ces infos.<\/p>\n<h3>Exploitation dans BI Publisher<\/h3>\n<p>J&rsquo;ai ensuite <a href=\"http:\/\/convertjson.com\/json-to-xml.htm\">converti le document json en format XML<\/a> afin de l&rsquo;exploiter avec BI Publisher (qui ne prend pas de Json en entr\u00e9e).<\/p>\n<p>Dans Word, il suffit alors de construire un template d&rsquo;affichage prenant comme \u00e9chantillon le fichier XML pr\u00e9alablement g\u00e9n\u00e9r\u00e9. Remarque: Il faut avoir install\u00e9 le plugin <a href=\"http:\/\/www.oracle.com\/technetwork\/middleware\/bi-publisher\/downloads\/index.html\" target=\"_blank\" rel=\"noopener\">Oracle BI Publisher Desktop<\/a>.<\/p>\n<p><a href=\"http:\/\/iamwcew.fr.oracle.com\/blog\/wp-content\/uploads\/2016\/05\/snap02311.jpg\" rel=\"attachment wp-att-3219\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-3219 size-large\" src=\"http:\/\/iamwcew.fr.oracle.com\/blog\/wp-content\/uploads\/2016\/05\/snap02311-1024x762.jpg\" alt=\"snap02311\" width=\"720\" height=\"536\" \/><\/a><\/p>\n<p>Voici un <a href=\"http:\/\/iamwcew.fr.oracle.com\/blog\/wp-content\/uploads\/2016\/05\/861464350909030out.pdf\" target=\"_blank\" rel=\"noopener\">Exemple de restitution au format pdf<\/a><\/p>\n<h3>Observations:<\/h3>\n<p>Le serveur PCS supporte <em>CORS<\/em>, et on peut \u00a0manipuler ces APIs REST depuis Javascript dans un browser.<br \/>\nOracle Jet comprend pas mal de widgets graphique et sera donc int\u00e9ressant \u00e0 consid\u00e9rer.<\/p>\n<p>Pour l&rsquo;authentification, c&rsquo;est de la <em>Basic Authentication<\/em> sur https.<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Oracle Process Cloud Service propose des APIs permettant d\u2019acc\u00e9der \u00e0 des informations structurelles et \u00e0 des indicateurs agr\u00e9g\u00e9s d&rsquo;activit\u00e9s (Les APIS de\u00a0Analytics\u00a0sont\u00a0disponible sur le&#8230;<\/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,10,11],"tags":[],"ppma_author":[150],"class_list":["post-3217","post","type-post","status-publish","format-standard","hentry","category-demo-2","category-dev","category-notes","category-paas"],"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\/3217","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=3217"}],"version-history":[{"count":1,"href":"https:\/\/gpmfactory.com\/index.php\/wp-json\/wp\/v2\/posts\/3217\/revisions"}],"predecessor-version":[{"id":3611,"href":"https:\/\/gpmfactory.com\/index.php\/wp-json\/wp\/v2\/posts\/3217\/revisions\/3611"}],"wp:attachment":[{"href":"https:\/\/gpmfactory.com\/index.php\/wp-json\/wp\/v2\/media?parent=3217"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/gpmfactory.com\/index.php\/wp-json\/wp\/v2\/categories?post=3217"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/gpmfactory.com\/index.php\/wp-json\/wp\/v2\/tags?post=3217"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/gpmfactory.com\/index.php\/wp-json\/wp\/v2\/ppma_author?post=3217"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}