{"id":21326,"date":"2023-05-24T16:19:11","date_gmt":"2023-05-24T14:19:11","guid":{"rendered":"https:\/\/help.openbee.com\/open-bee-scan-capture\/knowledge-base\/how-to-guides\/scripts-in-capture\/case-studies\/index\/index-consistency-via-dms-metadata\/"},"modified":"2026-05-13T09:36:50","modified_gmt":"2026-05-13T07:36:50","slug":"index-consistency-via-dms-metadata","status":"publish","type":"page","link":"https:\/\/help.openbee.com\/en\/open-bee-scan-capture\/knowledge-base\/how-to-guides\/scripts-in-capture\/case-studies\/index\/index-consistency-via-dms-metadata\/","title":{"rendered":"Index: Consistency via DMS metadata"},"content":{"rendered":"\n<ul class=\"wp-block-list\">\n<li>DMS API key to change<\/li>\n\n\n\n<li>DMS ID to change<\/li>\n\n\n\n<li>Find the document on the DMS via the document&#8217;s Metadata ID number 11350Type ***** (enter the correct ID)<\/li>\n\n\n\n<li>Comparison of the Account and the amount found on the DMS doc. Metadata ID 11349 and 11355, respectively<\/li>\n<\/ul>\n\n<p><\/p>\n\n<pre class=\"wp-block-code has-white-color has-black-background-color has-text-color has-background\"><code>\/*---------------  DMS CONNEXION  ------------------*\/\r\n\r\nvar portal_api_key = \"<mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-luminous-vivid-amber-color\">5c62623b0f63**********262475fc9dff10a1ee252a74959a068d26d***************6c1ddcf14a171591f45b85<\/mark>\";\r\nvar pHeader = {};\r\npHeader&#91;\"Authorization\"] = \"Key \"+portal_api_key;\r\nvar ws = new JSE_WebService(\"<mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-luminous-vivid-amber-color\">127.0.0.1<\/mark>\", \"<mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-luminous-vivid-amber-color\">http<\/mark>\", <mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-luminous-vivid-amber-color\">8000<\/mark>);\r\n\r\n\r\n\/*--------------- FUNCTIONS ----------------------*\/\r\n\r\nvar getIDDMSFromNumBL = function(pNumBL){\r\n\tvar pQueryParams = {};\r\n\tpQueryParams&#91;\"metadatas&#91;<mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-luminous-vivid-amber-color\">11350<\/mark>]\"] = pNumBL;\r\n\tpQueryParams&#91;\"documentType\"] = \"<mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-luminous-vivid-amber-color\">****<\/mark>\";\r\n\tpQueryParams&#91;\"itemPerPage\"] = 1;\r\n\tpQueryParams&#91;\"page\"] = 0;\r\n\tpQueryParams&#91;\"includeFolders\"] = \"false\";\r\n\r\n\tvar res = ws.send(\"\/ws\/v2\/search\", \"GET\", pHeader, 60000, true, pQueryParams);\r\n\tif(res == null)\r\n\t\treturn \"\";\r\n\r\n\tvar jsonResponse = JSON.parse(res.StringResponse);\r\n\tif(jsonResponse != null &amp;&amp; jsonResponse.documents != null &amp;&amp; jsonResponse.documents.length > 0)\r\n\t\treturn jsonResponse.documents&#91;0].document.idDocument;\r\n\r\n\treturn \"\";\r\n}\r\n\r\n\/*--------------- MAIN CODE ----------------------*\/\r\n\r\nvar numBL = getTextFromIndexInfo(getFirstIndexFromID(pParameters,\"NUM_BL_INDEX\"));\r\nvar montant = getTextFromIndexInfo(getFirstIndexFromID(pParameters,\"AMOUNT_INCLUDING_VAT_INDEX\"));\r\nvar compteTF = THIRDPART.personalAccount.personalAccountNumber;\r\nvar gap_montant = 0.02;\r\n\r\nvar result = new JSE_Result();\r\nresult.values = &#91;\"BL COHERENT\",\"PETIT ECART\",\"ECART CONSEQUENT\",\"PAS DE COHERENCE\"];\r\nresult.calculatedValue = \"PAS DE COHERENCE\";\r\n\r\nif(numBL  != null &amp;&amp; numBL != \"\" &amp;&amp; montant != null &amp;&amp; montant != \"\"){\r\n\tvar idDMSBL = getIDDMSFromNumBL(numBL);\r\n\tif(idDMSBL == \"\" || idDMSBL == null)\r\n\t\treturn result;\r\n\r\n\tvar res = ws.send(\"\/ws\/v2\/document\/\"+idDMSBL, \"GET\", pHeader, 60000);\r\n\tif(res == null)\r\n\t\treturn result;\r\n\r\n\tvar jsonResponse = JSON.parse(res.StringResponse);\r\n\tif(jsonResponse == null || jsonResponse.metadatas == null || jsonResponse.metadatas.length == 0)\r\n\t\treturn result;\r\n\t\r\n\tvar metadatas = jsonResponse.metadatas;\r\n\tvar montantF = Math.abs(parseFloat(montant.replace(',', '.')));\r\n\tvar montantBL = 0;\r\n\tvar compteTBL = \"\";\r\n\r\n\tfor(var i =0; i&lt; metadatas.length;i++){\r\n\t\tif(metadatas&#91;i].metadata.idMetadata == \"<mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-luminous-vivid-amber-color\">11349<\/mark>\")\r\n\t\t   compteTBL = metadatas&#91;i].metadata.value;\r\n\t\tif(metadatas&#91;i].metadata.idMetadata == \"<mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-luminous-vivid-amber-color\">11355<\/mark>\" &amp;&amp; metadatas&#91;i].metadata.value != \"\")\r\n\t\t\tmontantBL = Math.abs(parseFloat(metadatas&#91;i].metadata.value.replace(',', '.')));\r\n\t}\r\n\r\n\tif(compteTF == compteTBL){\r\n\t   if(montantF == montantBL)\r\n\t\t   result.calculatedValue = \"BL COHERENT\";\r\n\t   else if(Math.abs(montantF - montantBL) &lt;= gap_montant)\r\n\t\t   result.calculatedValue = \"PETIT ECART\";\r\n\t   else if(Math.abs(montantF - montantBL) > gap_montant)\r\n\t\t   result.calculatedValue = \"ECART CONSEQUENT\";\r\n\t}\r\n}\r\n\r\nreturn result;\r\n<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"","protected":false},"author":97,"featured_media":0,"parent":21276,"menu_order":11,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-21326","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/help.openbee.com\/en\/wp-json\/wp\/v2\/pages\/21326","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/help.openbee.com\/en\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/help.openbee.com\/en\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/help.openbee.com\/en\/wp-json\/wp\/v2\/users\/97"}],"replies":[{"embeddable":true,"href":"https:\/\/help.openbee.com\/en\/wp-json\/wp\/v2\/comments?post=21326"}],"version-history":[{"count":1,"href":"https:\/\/help.openbee.com\/en\/wp-json\/wp\/v2\/pages\/21326\/revisions"}],"predecessor-version":[{"id":21329,"href":"https:\/\/help.openbee.com\/en\/wp-json\/wp\/v2\/pages\/21326\/revisions\/21329"}],"up":[{"embeddable":true,"href":"https:\/\/help.openbee.com\/en\/wp-json\/wp\/v2\/pages\/21276"}],"wp:attachment":[{"href":"https:\/\/help.openbee.com\/en\/wp-json\/wp\/v2\/media?parent=21326"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}