{ "info": { "_postman_id": "f90155f3-66f9-4c79-b74e-a82ee6ae773e", "name": "Divalto On premise", "schema": "https://schema.getpostman.com/json/collection/v2.1.0/collection.json", "_exporter_id": "39326476" }, "item": [ { "name": "Purchase Order Copy", "item": [ { "name": "📋 DOCUMENTATION RAPIDE", "item": [ { "name": "LIRE D'ABORD - Configuration variables", "request": { "method": "GET", "header": [], "url": { "raw": "https://placeholder.local", "protocol": "https", "host": [ "placeholder", "local" ] }, "description": "## ⚙️ VARIABLES À CONFIGURER\n\n### Variables d'environnement obligatoires :\n\n1. **env** : Votre numéro de site Divalto\n - Exemple: `SITE001`\n - Emplacement: Collection → Variables\n\n2. **access_token** : Token d'authentification\n - Obtenu via endpoint d'authentification\n - Durée: 45 minutes\n - Emplacement: Collection → Variables\n\n### Endpoints utilisés :\n\n```\nhttps://api.divaltocloud.com/{{env}}/testing/api/v1/RecordSQL/Execute\n```\n\n### Structure GTFI obligatoire :\n\n- **IPAR** : Paramètres d'intégration (trait=M/C)\n- **ENT** : En-tête de pièce\n- **MOUV** : Mouvements (lignes)\n\n### Flux recommandé :\n\n1. **CAS 1 - Litige** : Modifier quantité/montant\n2. **CAS 2 - Réception** : Créer BL partiel\n3. **CAS 3 - Clôture** : Marquer périmée\n" }, "response": [] } ] }, { "name": "🔴 CAS 1 - LITIGE (IPAR.TRAIT=M)", "item": [ { "name": "1.1 Litige Quantité + Montant", "event": [ { "listen": "prerequest", "script": { "exec": [ "const token = pm.environment.get('access_token');", "const env = pm.environment.get('env');", "", "if (!token) {", " console.error('❌ Token manquant. Vérifier les variables d\\'environnement');", "} else if (!env) {", " console.error('❌ Variable env manquante');", "} else {", " console.log('✅ Configuration OK');", " console.log('Environnement: ' + env);", "}" ], "type": "text/javascript", "packages": {}, "requests": {} } }, { "listen": "test", "script": { "exec": [ "const response = pm.response.json();", "", "if (response.error === 0) {", " console.log('✅ SUCCÈS - Commande modifiée');", " console.log('Résultat: ' + JSON.stringify(response.result));", " pm.test('Modification litige réussie', function() {", " pm.expect(response.error).to.equal(0);", " });", "} else {", " console.error('❌ ERREUR: ' + response.txterr);", " console.error('Code erreur: ' + response.error);", " pm.test('Erreur detectée', function() {", " pm.expect(response.error).to.not.equal(0);", " });", "}" ], "type": "text/javascript", "packages": {}, "requests": {} } } ], "request": { "method": "POST", "header": [ { "key": "Content-Type", "value": "application/json" }, { "key": "Authorization", "value": "Bearer {{access_token}}" } ], "body": { "mode": "raw", "raw": "{\n \"action\": \"SYNCHRO_INFINITY_AGILEO\",\n \"param\": \"IM998F2CCDE001A998F2CCDE001FURN001OP01DEPOT01C1998ALB000150412.50\",\n \"access_token\": \"{{ACCESS_TOKEN}}\"\n}" }, "url": { "raw": "https://{{domain}}/DhsDivaltoServiceDivaApiRest/api/v1/RecordSQL/Execute", "protocol": "https", "host": [ "{{domain}}" ], "path": [ "DhsDivaltoServiceDivaApiRest", "api", "v1", "RecordSQL", "Execute" ] }, "description": "**CAS 1.1 : Litige Quantité + Montant**\n\n**Contexte** :\n- Commande originale : 100 unités @ 10.50 €\n- Facture reçue : 50 unités @ 12.50 €\n- Écart : Quantité ET prix incorrects\n\n**Action** :\n- IPAR.TRAIT = M (Modification)\n- Ajuste quantité : 100 → 50\n- Ajuste prix : 10.50 € → 12.50 €\n\n**Paramètres clés** :\n- `cdqte=50` : Nouvelle quantité commandée\n- `pcod=4` : Prix manuel\n- `pub=12.50` : Nouveau prix unitaire\n\n**Résultat attendu** :\n- Commande CCDE001 mise à jour\n- Montant recalculé : 625.00 €\n- Yooz peut rapprocher la facture" }, "response": [] }, { "name": "1.2 Litige Quantité uniquement", "event": [ { "listen": "test", "script": { "exec": [ "const response = pm.response.json();", "", "if (response.error === 0) {", " console.log('✅ SUCCÈS - Quantité modifiée seule');", " pm.test('Modification quantité réussie', function() {", " pm.expect(response.error).to.equal(0);", " });", "} else {", " console.error('❌ ERREUR: ' + response.txterr);", "}" ], "type": "text/javascript", "packages": {}, "requests": {} } } ], "request": { "method": "POST", "header": [ { "key": "Content-Type", "value": "application/json" }, { "key": "Authorization", "value": "Bearer {{access_token}}" } ], "body": { "mode": "raw", "raw": "{\n \"action\": \"SYNCHRO_INFINITY_AGILEO\",\n \"param\": \"IM998F2CCDE002A998F2CCDE002FURN001OP01DEPOT01C1998ALB000245\",\n \"access_token\": \"{{ACCESS_TOKEN}}\"\n}" }, "url": { "raw": "https://{{domain}}/DhsDivaltoServiceDivaApiRest/api/v1/RecordSQL/Execute", "protocol": "https", "host": [ "{{domain}}" ], "path": [ "DhsDivaltoServiceDivaApiRest", "api", "v1", "RecordSQL", "Execute" ] }, "description": "**CAS 1.2 : Litige Quantité uniquement**\n\n**Contexte** :\n- Commande originale : 100 unités @ 10.50 €\n- Facture reçue : 45 unités @ 10.50 €\n- Écart : Quantité incorrecte (prix OK)\n\n**Action** :\n- Modifie UNIQUEMENT la quantité\n- Prix unitaire conservé\n\n**Résultat attendu** :\n- Commande CCDE002 : 45 unités\n- Prix unitaire inchangé : 10.50 €\n- Montant recalculé : 472.50 €" }, "response": [] }, { "name": "1.3 Litige Montant uniquement", "event": [ { "listen": "test", "script": { "exec": [ "const response = pm.response.json();", "", "if (response.error === 0) {", " console.log('✅ SUCCÈS - Montant/Prix modifié seul');", " pm.test('Modification prix réussie', function() {", " pm.expect(response.error).to.equal(0);", " });", "} else {", " console.error('❌ ERREUR: ' + response.txterr);", "}" ], "type": "text/javascript", "packages": {}, "requests": {} } } ], "request": { "method": "POST", "header": [ { "key": "Content-Type", "value": "application/json" }, { "key": "Authorization", "value": "Bearer {{access_token}}" } ], "body": { "mode": "raw", "raw": "{\n \"action\": \"SYNCHRO_INFINITY_AGILEO\",\n \"param\": \"IM998F2CCDE003A998F2CCDE003FURN001OP01DEPOT01C1998ALB0003415.75\",\n \"access_token\": \"{{ACCESS_TOKEN}}\"\n}" }, "url": { "raw": "https://{{domain}}/DhsDivaltoServiceDivaApiRest/api/v1/RecordSQL/Execute", "protocol": "https", "host": [ "{{domain}}" ], "path": [ "DhsDivaltoServiceDivaApiRest", "api", "v1", "RecordSQL", "Execute" ] }, "description": "**CAS 1.3 : Litige Montant uniquement**\n\n**Contexte** :\n- Commande originale : 100 unités @ 10.50 €\n- Facture reçue : 100 unités @ 15.75 €\n- Écart : Prix incorrect (quantité OK)\n\n**Action** :\n- Modifie UNIQUEMENT le prix\n- Quantité conservée\n- PCOD=4 obligatoire pour prix manuel\n\n**Résultat attendu** :\n- Commande CCDE003 : 100 unités (inchangé)\n- Prix unitaire : 15.75 € (changé)\n- Montant recalculé : 1575.00 €" }, "response": [] } ] }, { "name": "🟡 CAS 2 - RÉCEPTION PARTIELLE (IPAR.TRAIT=C)", "item": [ { "name": "2.1 Créer BL partiel avec reliquat", "event": [ { "listen": "prerequest", "script": { "exec": [ "console.log('🔄 Création BL partiel (Reliquat automatique)');", "console.log('Quantité commandée (source): 100 unités');", "console.log('Quantité à recevoir: 50 unités');", "console.log('Reliquat auto-généré: 50 unités');" ], "type": "text/javascript", "packages": {}, "requests": {} } }, { "listen": "test", "script": { "exec": [ "const response = pm.response.json();", "", "if (response.error === 0) {", " console.log('✅ SUCCÈS - BL créé avec reliquat');", " console.log('BL créé + Reliquat automatique généré');", " pm.test('Création BL réussie', function() {", " pm.expect(response.error).to.equal(0);", " });", "} else {", " console.error('❌ ERREUR: ' + response.txterr);", " console.error('Vérifier: quantité_reçue <= quantité_commandée');", "}" ], "type": "text/javascript", "packages": {}, "requests": {} } } ], "request": { "method": "POST", "header": [ { "key": "Content-Type", "value": "application/json" }, { "key": "Authorization", "value": "Bearer {{access_token}}" } ], "body": { "mode": "raw", "raw": "{\n \"action\": \"SYNCHRO_INFINITY_AGILEO\",\n \"param\": \"IC998F3A998F3FURN001OP01DEPOT0120250122C1998ALB00015020250122CCDE001\",\n \"access_token\": \"{{ACCESS_TOKEN}}\"\n}" }, "url": { "raw": "https://{{domain}}/DhsDivaltoServiceDivaApiRest/api/v1/RecordSQL/Execute", "protocol": "https", "host": [ "{{domain}}" ], "path": [ "DhsDivaltoServiceDivaApiRest", "api", "v1", "RecordSQL", "Execute" ] }, "description": "**CAS 2.1 : Réception Partielle avec Reliquat Automatique**\n\n**Contexte** :\n- Commande CCDE001 : 100 unités ALB0001\n- Livraison reçue : 50 unités (partielle)\n- Reliquat : 50 unités à recevoir ultérieurement\n\n**Action** :\n- IPAR.TRAIT = C (Création BL)\n- PICOD = 3 (Bon de livraison)\n- Divalto crée automatiquement reliquat\n\n**Paramètres clés** :\n- `blqte=50` : Quantité reçue\n- `bldt=20250122` : Date de livraison\n- `cdno=CCDE001` : Lien vers commande source\n\n**Résultat attendu** :\n- BL créé (ex: BL001)\n- Reliquat créé automatiquement : 50 unités\n- État commande : PARTIELLEMENT_REÇUE\n- Yooz peut rapprocher facture partielle" }, "response": [] }, { "name": "2.2 Créer BL partiel sans lieu de stockage", "event": [ { "listen": "test", "script": { "exec": [ "const response = pm.response.json();", "", "if (response.error === 0) {", " console.log('✅ SUCCÈS - BL créé sans lieu spécifié');", " pm.test('Création BL sans lieu réussie', function() {", " pm.expect(response.error).to.equal(0);", " });", "} else {", " console.error('❌ ERREUR: ' + response.txterr);", "}" ], "type": "text/javascript", "packages": {}, "requests": {} } } ], "request": { "method": "POST", "header": [ { "key": "Content-Type", "value": "application/json" }, { "key": "Authorization", "value": "Bearer {{access_token}}" } ], "body": { "mode": "raw", "raw": "{\n \"action\": \"SYNCHRO_INFINITY_AGILEO\",\n \"param\": \"IC998F3A998F3FURN001OP01DEPOT0120250123C1998ALB000212020250123CCDE002\",\n \"access_token\": \"{{ACCESS_TOKEN}}\"\n}" }, "url": { "raw": "https://{{domain}}/DhsDivaltoServiceDivaApiRest/api/v1/RecordSQL/Execute", "protocol": "https", "host": [ "{{domain}}" ], "path": [ "DhsDivaltoServiceDivaApiRest", "api", "v1", "RecordSQL", "Execute" ] }, "description": "**CAS 2.2 : BL Partiel sans Lieu de Stockage**\n\n**Contexte** :\n- Commande CCDE002 : 200 unités ALB0002\n- Livraison reçue : 120 unités\n- Pas de lieu de stockage spécifié\n\n**Action** :\n- Créer BL sans paramètre lieu\n- Reliquat auto : 200 - 120 = 80 unités\n\n**Paramètres** :\n- Identique à 2.1 mais sans LIEU\n- Divalto utilise dépôt par défaut\n\n**Résultat attendu** :\n- BL créé\n- Reliquat : 80 unités\n- Lieu stockage : Par défaut dépôt" }, "response": [] }, { "name": "2.3 Créer BL complet (réception totale)", "event": [ { "listen": "prerequest", "script": { "exec": [ "console.log('🟢 Création BL complet (Aucun reliquat)');" ], "type": "text/javascript", "packages": {}, "requests": {} } }, { "listen": "test", "script": { "exec": [ "const response = pm.response.json();", "", "if (response.error === 0) {", " console.log('✅ SUCCÈS - BL complet créé');", " console.log('Note: Aucun reliquat généré (quantité reçue = commandée)');", " pm.test('Création BL complet réussie', function() {", " pm.expect(response.error).to.equal(0);", " });", "} else {", " console.error('❌ ERREUR: ' + response.txterr);", "}" ], "type": "text/javascript", "packages": {}, "requests": {} } } ], "request": { "method": "POST", "header": [ { "key": "Content-Type", "value": "application/json" }, { "key": "Authorization", "value": "Bearer {{access_token}}" } ], "body": { "mode": "raw", "raw": "{\n \"action\": \"SYNCHRO_INFINITY_AGILEO\",\n \"param\": \"IC998F3A998F3FURN001OP01DEPOT0120250124C1998ALB000110020250124CCDE001\",\n \"access_token\": \"{{ACCESS_TOKEN}}\"\n}" }, "url": { "raw": "https://{{domain}}/DhsDivaltoServiceDivaApiRest/api/v1/RecordSQL/Execute", "protocol": "https", "host": [ "{{domain}}" ], "path": [ "DhsDivaltoServiceDivaApiRest", "api", "v1", "RecordSQL", "Execute" ] }, "description": "**CAS 2.3 : BL Complet (Réception Totale)**\n\n**Contexte** :\n- Commande CCDE001 : 100 unités\n- Livraison reçue : 100 unités\n- Réception COMPLÈTE (pas de reliquat)\n\n**Action** :\n- Créer BL avec toute la quantité\n- Divalto détecte : BLQTE (100) = CDQTE (100)\n- Aucun reliquat généré\n\n**Paramètres** :\n- `blqte=100` : Quantité reçue = quantité commandée\n\n**Résultat attendu** :\n- BL créé\n- Aucun reliquat\n- État commande : COMPLÈTEMENT_REÇUE" }, "response": [] } ] }, { "name": "🔵 CAS 3 - COMMANDE PÉRIMÉE (IPAR.TRAIT=M)", "item": [ { "name": "3.1 Clôturer commande - Statut PÉRIMÉE", "event": [ { "listen": "prerequest", "script": { "exec": [ "console.log('⏸️ Fermeture commande - PÉRIMÉE');" ], "type": "text/javascript", "packages": {}, "requests": {} } }, { "listen": "test", "script": { "exec": [ "const response = pm.response.json();", "", "if (response.error === 0) {", " console.log('✅ SUCCÈS - Commande périmée');", " console.log('Commande fermée pour date expiration');", " pm.test('Fermeture PÉRIMÉE réussie', function() {", " pm.expect(response.error).to.equal(0);", " });", "} else {", " console.error('❌ ERREUR: ' + response.txterr);", "}" ], "type": "text/javascript", "packages": {}, "requests": {} } } ], "request": { "method": "POST", "header": [ { "key": "Content-Type", "value": "application/json" }, { "key": "Authorization", "value": "Bearer {{access_token}}" } ], "body": { "mode": "raw", "raw": "{\n \"action\": \"SYNCHRO_INFINITY_AGILEO\",\n \"param\": \"IM998F2CCDE001A998F2CCDE001FURN001OP01DEPOT01PERIME\",\n \"access_token\": \"{{ACCESS_TOKEN}}\"\n}" }, "url": { "raw": "https://{{domain}}/DhsDivaltoServiceDivaApiRest/api/v1/RecordSQL/Execute", "protocol": "https", "host": [ "{{domain}}" ], "path": [ "DhsDivaltoServiceDivaApiRest", "api", "v1", "RecordSQL", "Execute" ] }, "description": "**CAS 3.1 : Clôturer Commande - PÉRIMÉE**\n\n**Contexte** :\n- Commande CCDE001 ouverte depuis longtemps\n- Date limite dépassée\n- Fournisseur ne peut pas livrer\n- Commande expirée\n\n**Action** :\n- IPAR.TRAIT = M (Modification statut)\n- Nouveau statut : PÉRIMÉE\n- Commande conservée en base (audit)\n\n**Paramètres clés** :\n- `status=PERIME` : Statut péremption\n- Pino obligatoire (identifie la commande)\n\n**Impacts** :\n- ✅ Aucun nouveau BL possible\n- ✅ Aucune nouvelle facture\n- ✅ Historique préservé\n- ✅ Yooz : Rapprochement suspendu\n\n**Résultat attendu** :\n- Commande marquée PÉRIMÉE\n- Aucun document ne peut être ajouté" }, "response": [] }, { "name": "3.2 Clôturer commande - Statut ANNULÉE", "event": [ { "listen": "test", "script": { "exec": [ "const response = pm.response.json();", "", "if (response.error === 0) {", " console.log('✅ SUCCÈS - Commande annulée');", " console.log('Demande explicite annulation');", " pm.test('Fermeture ANNULÉE réussie', function() {", " pm.expect(response.error).to.equal(0);", " });", "} else {", " console.error('❌ ERREUR: ' + response.txterr);", "}" ], "type": "text/javascript", "packages": {}, "requests": {} } } ], "request": { "method": "POST", "header": [ { "key": "Content-Type", "value": "application/json" }, { "key": "Authorization", "value": "Bearer {{access_token}}" } ], "body": { "mode": "raw", "raw": "{\n \"action\": \"SYNCHRO_INFINITY_AGILEO\",\n \"param\": \"IM998F2CCDE002A998F2CCDE002FURN001OP01DEPOT01ANNULE\",\n \"access_token\": \"{{ACCESS_TOKEN}}\"\n}" }, "url": { "raw": "https://{{domain}}/DhsDivaltoServiceDivaApiRest/api/v1/RecordSQL/Execute", "protocol": "https", "host": [ "{{domain}}" ], "path": [ "DhsDivaltoServiceDivaApiRest", "api", "v1", "RecordSQL", "Execute" ] }, "description": "**CAS 3.2 : Clôturer Commande - ANNULÉE**\n\n**Contexte** :\n- Erreur de saisie initiale ou annulation commerciale complète.\n- La commande ne doit plus être traitable ni par Yooz, ni par Divalto.\n\n**Action** :\n- IPAR.TRAIT = M\n- Nouveau statut : ANNULE\n\n**Impacts** :\n- Libère les engagements de commande.\n- Empêche toute réception ou facturation ultérieure.\n\n**Résultat attendu** :\n- Statut mis à jour dans Divalto.\n- Information synchronisée vers Yooz pour rejeter la facture associée." }, "response": [] } ] }, { "name": "1. Toutes les commandes", "request": { "method": "POST", "header": [ { "key": "Content-Type", "value": "application/json" }, { "key": "Authorization", "value": "Bearer {{access_token}}" } ], "body": { "mode": "raw", "raw": "{\n \"dhoq\": \"gtrshqpce.dhoq\",\n \"recordsql\": \"MOUVEMENT_RANGEMENT\",\n \"access_token\" : \"{{ACCESS_TOKEN}}\"\n}" }, "url": { "raw": "https://{{domain}}/DhsDivaltoServiceDivaApiRest/api/v1/RecordSQL/Execute", "protocol": "https", "host": [ "{{domain}}" ], "path": [ "DhsDivaltoServiceDivaApiRest", "api", "v1", "RecordSQL", "Execute" ] }, "description": "Récupère TOUTES les commandes du dossier (peut être très volumineux)" }, "response": [] }, { "name": "2. Commandes d'un fournisseur", "request": { "method": "POST", "header": [ { "key": "Content-Type", "value": "application/json" }, { "key": "Authorization", "value": "Bearer {{access_token}}" } ], "body": { "mode": "raw", "raw": "{\n \"dhoq\": \"gtrshqpce.dhoq\",\n \"recordsql\": \"MOUVEMENT_RANGEMENT\",\n \"where\": \"Equal_Tiers\",\n \"where_parameters\": \"FURN001\",\n \"fields\": \"CDNO;CDQTE;BLQTE;REF;TIERS;PIDT\",\n \"access_token\" : \"{{ACCESS_TOKEN}}\"\n}" }, "url": { "raw": "https://{{domain}}/DhsDivaltoServiceDivaApiRest/api/v1/RecordSQL/Execute", "protocol": "https", "host": [ "{{domain}}" ], "path": [ "DhsDivaltoServiceDivaApiRest", "api", "v1", "RecordSQL", "Execute" ] }, "description": "Récupère les commandes d'un fournisseur spécifique. Modifier FURN001 par le code fournisseur souhaité." }, "response": [] }, { "name": "3. Commande spécifique (CCDE001)", "request": { "method": "POST", "header": [ { "key": "Content-Type", "value": "application/json" }, { "key": "Authorization", "value": "Bearer {{access_token}}" } ], "body": { "mode": "raw", "raw": "{\n \"dhoq\": \"gtrshqpce.dhoq\",\n \"recordsql\": \"MOUVEMENT_RANGEMENT\",\n \"where\": \"Equal_Cdno\",\n \"where_parameters\": \"CCDE001\",\n \"fields\": \"CDNO;CDQTE;BLQTE;REF;DESIGNATION;TIERS;PUB;MONT;PIDT;BLDT\",\n \"access_token\" : \"{{ACCESS_TOKEN}}\"\n}" }, "url": { "raw": "https://{{domain}}/DhsDivaltoServiceDivaApiRest/api/v1/RecordSQL/Execute", "protocol": "https", "host": [ "{{domain}}" ], "path": [ "DhsDivaltoServiceDivaApiRest", "api", "v1", "RecordSQL", "Execute" ] }, "description": "Récupère une commande précise. Remplacer CCDE001 par le numéro de commande souhaité." }, "response": [] }, { "name": "4. Commandes non livrées (reliquats)", "request": { "method": "POST", "header": [ { "key": "Content-Type", "value": "application/json" }, { "key": "Authorization", "value": "Bearer {{access_token}}" } ], "body": { "mode": "raw", "raw": "{\n \"dhoq\": \"gtrshqpce.dhoq\",\n \"recordsql\": \"MOUVEMENT_RANGEMENT\",\n \"where\": \"Inferior_BlqteVsCdqte\",\n \"fields\": \"CDNO;CDQTE;BLQTE;REF;TIERS;PIDT\",\n \"offset\": \"0\",\n \"count\": \"100\",\n \"access_token\" : \"{{ACCESS_TOKEN}}\"\n}" }, "url": { "raw": "https://{{domain}}/DhsDivaltoServiceDivaApiRest/api/v1/RecordSQL/Execute", "protocol": "https", "host": [ "{{domain}}" ], "path": [ "DhsDivaltoServiceDivaApiRest", "api", "v1", "RecordSQL", "Execute" ] }, "description": "Récupère les commandes avec reliquat (quantité livrée < quantité commandée). Paginé par 100." }, "response": [] }, { "name": "5. Commandes avec pagination", "request": { "method": "POST", "header": [ { "key": "Content-Type", "value": "application/json" }, { "key": "Authorization", "value": "Bearer {{access_token}}" } ], "body": { "mode": "raw", "raw": "{\n \"dhoq\": \"gtrshqpce.dhoq\",\n \"recordsql\": \"MOUVEMENT_RANGEMENT\",\n \"fields\": \"CDNO;CDQTE;BLQTE;REF;TIERS\",\n \"offset\": \"0\",\n \"count\": \"50\",\n \"access_token\": \"{{access_token}}\"\n}" }, "url": { "raw": "https://{{domain}}/DhsDivaltoServiceDivaApiRest/api/v1/RecordSQL/Execute", "protocol": "https", "host": [ "{{domain}}" ], "path": [ "DhsDivaltoServiceDivaApiRest", "api", "v1", "RecordSQL", "Execute" ] }, "description": "Récupère les commandes par pages de 50. Pour la page suivante, changer offset de 0 à 50, puis 100, etc." }, "response": [] }, { "name": "6. Commandes triées par date", "request": { "method": "POST", "header": [ { "key": "Content-Type", "value": "application/json" }, { "key": "Authorization", "value": "Bearer {{access_token}}" } ], "body": { "mode": "raw", "raw": "{\n \"dhoq\": \"gtrshqpce.dhoq\",\n \"recordsql\": \"MOUVEMENT_RANGEMENT\",\n \"fields\": \"CDNO;PIDT;CDQTE;BLQTE;REF;TIERS\",\n \"orderby\": \"Par_DateCommande\",\n \"access_token\" : \"{{ACCESS_TOKEN}}\"\n}" }, "url": { "raw": "https://{{domain}}/DhsDivaltoServiceDivaApiRest/api/v1/RecordSQL/Execute", "protocol": "https", "host": [ "{{domain}}" ], "path": [ "DhsDivaltoServiceDivaApiRest", "api", "v1", "RecordSQL", "Execute" ] }, "description": "Récupère les commandes triées par date de création" }, "response": [] }, { "name": "RÉFÉRENCE - Champs disponibles", "request": { "method": "GET", "header": [], "url": { "raw": "https://placeholder.local", "protocol": "https", "host": [ "placeholder", "local" ] }, "description": "CHAMPS PRINCIPAUX POUR MOUVEMENT_RANGEMENT:\n\nCDNO : Numéro de commande (ex: CCDE001) \nCDQTE : Quantité commandée \nBLQTE : Quantité livrée \nREF : Référence article \nDESIGNATION : Libellé article \nTIERS : Code fournisseur \nPUB : Prix unitaire \nMONT : Montant total (CDQTE × PUB) \nPIDT : Date de commande \nBLDT : Date de livraison souhaitée \nDEPO : Dépôt livraison \nOP : Code opération \nSTATUS : Statut commande \nPCOD : Code prix \nENRNO : Numéro d'enregistrement (ligne) \nCDENRNO : Lien vers commande source (reliquat)\n\nCLAUSES WHERE DISPONIBLES:\n\nEqual_Tiers : WHERE TIERS = 'FURN001' \nEqual_Cdno : WHERE CDNO = 'CCDE001' \nEqual_Ref : WHERE REF = 'ALB0001' \nLike_Cdno : WHERE CDNO LIKE 'CCDE%' \nInferior_BlqteVsCdqte : WHERE BLQTE < CDQTE (non complètement livré) \nSuperior_BlqteVsCdqte : WHERE BLQTE > CDQTE (surlivraison) \nEqual_Status : WHERE STATUS = 'OUVERTE' \nBetween_DateCommande : WHERE PIDT BETWEEN date1 AND date2" }, "response": [] } ] }, { "name": "Référentiels", "item": [ { "name": "Import orga", "request": { "method": "POST", "header": [ { "key": "Content-Type", "value": "application/json", "type": "text" } ], "body": { "mode": "raw", "raw": "{\n\"dhoq\" : \"ccrsdos.dhoq\",\n\"recordsql\" : \"DosCpt\",\n\"access_token\" : \"{{ACCESS_TOKEN}}\",\n\"parameters\" : \"\",\n\"fields\" : \"DOS;NOM;ADRCPL1;RUE;VIL;CPOSTAL;PAY;SIREN;NIC;USERMODH\",\n\"filter\": \"\",\n\"offset\" : 0,\n\"count\" : 10\n}", "options": { "raw": { "language": "json" } } }, "url": { "raw": "https://{{domain}}/DhsDivaltoServiceDivaApiRest/api/v1/RecordSQL/Execute", "protocol": "https", "host": [ "{{domain}}" ], "path": [ "DhsDivaltoServiceDivaApiRest", "api", "v1", "RecordSQL", "Execute" ] } }, "response": [] }, { "name": "Import client", "request": { "method": "POST", "header": [ { "key": "Content-Type", "value": "application/json", "type": "text" } ], "body": { "mode": "raw", "raw": "{\n\"dhoq\" : \"gtrstiers.dhoq\",\n\"recordsql\" : \"client\",\n\"access_token\" : \"{{ACCESS_TOKEN}}\",\n\"parameters\" : \"MZ.Dos='100'\",\n\"fields\" : \"\",\n\"offset\" : 2,\n\"count\" : \"all\",\n\"orderby\" : \"\",\n\"having\" : \" \",\n\"having_parameters\" : \" \",\n\"infos\" : \" \"\n}", "options": { "raw": { "language": "json" } } }, "url": { "raw": "https://{{domain}}/DhsDivaltoServiceDivaApiRest/api/v1/RecordSQL/Execute", "protocol": "https", "host": [ "{{domain}}" ], "path": [ "DhsDivaltoServiceDivaApiRest", "api", "v1", "RecordSQL", "Execute" ] } }, "response": [] }, { "name": "Import fournisseur", "request": { "method": "POST", "header": [ { "key": "Content-Type", "value": "application/json", "type": "text" } ], "body": { "mode": "raw", "raw": "{\n\"dhoq\" : \"gtrstiers.dhoq\",\n\"recordsql\" : \"fournisseur\",\n\"access_token\" : \"{{ACCESS_TOKEN}}\",\n\"parameters\" : \"MZ.Dos='100'\",\n\"fields\" : \"TIERS;HSDT;USERMODH;nom\",\n\"offset\" : 0,\n\"count\" : 100\n}", "options": { "raw": { "language": "json" } } }, "url": { "raw": "https://{{domain}}/DhsDivaltoServiceDivaApiRest/api/v1/RecordSQL/Execute", "protocol": "https", "host": [ "{{domain}}" ], "path": [ "DhsDivaltoServiceDivaApiRest", "api", "v1", "RecordSQL", "Execute" ] } }, "response": [] }, { "name": "Import fournisseur contacts", "request": { "method": "POST", "header": [ { "key": "Content-Type", "value": "application/json", "type": "text" } ], "body": { "mode": "raw", "raw": "{\n\"dhoq\" : \"gtrstiers.dhoq\",\n\"recordsql\" : \"contact\",\n\"access_token\" : \"{{ACCESS_TOKEN}}\",\n\"parameters\" : \"MZ.Dos='1'\",\n\"fields\" : \"\",\n\"filter\": \"\",\n\"where\": \"Equal_TIERS\",\n\"where_parameters\": \"F0000001\",\n\"offset\" : 0,\n\"count\" : 100\n}", "options": { "raw": { "language": "json" } } }, "url": { "raw": "https://{{domain}}/DhsDivaltoServiceDivaApiRest/api/v1/RecordSQL/Execute", "protocol": "https", "host": [ "{{domain}}" ], "path": [ "DhsDivaltoServiceDivaApiRest", "api", "v1", "RecordSQL", "Execute" ] } }, "response": [] }, { "name": "Import fournisseur rib", "request": { "method": "POST", "header": [ { "key": "Content-Type", "value": "application/json", "type": "text" } ], "body": { "mode": "raw", "raw": "{\n\"dhoq\" : \"gtrstiers.dhoq\",\n\"recordsql\" : \"rib\",\n\"access_token\" : \"{{ACCESS_TOKEN}}\",\n\"parameters\" : \"MZ.Dos='998'\",\n\"fields\" : \"\",\n\"filter\": \"\",\n\"where\": \"Equal_TIERS\",\n\"where_parameters\": \"F0000001\",\n\"offset\" : 0,\n\"count\" : 100\n}", "options": { "raw": { "language": "json" } } }, "url": { "raw": "https://{{domain}}/DhsDivaltoServiceDivaApiRest/api/v1/RecordSQL/Execute", "protocol": "https", "host": [ "{{domain}}" ], "path": [ "DhsDivaltoServiceDivaApiRest", "api", "v1", "RecordSQL", "Execute" ] } }, "response": [] }, { "name": "Import accounts", "request": { "method": "POST", "header": [ { "key": "Content-Type", "value": "application/json", "type": "text" } ], "body": { "mode": "raw", "raw": "{\n\"dhoq\" : \"ccrsjca.dhoq\",\n\"recordsql\" : \"Compte\",\n\"access_token\" : \"{{ACCESS_TOKEN}}\",\n\"parameters\" : \"MZ.DOS='100'\",\n\"fields\" : \"CPT;LIB;USERMODH;CPTNAT;HSDT\",\n\"filter\": \"\",\n\"offset\" : 0,\n\"count\" : 1000\n}", "options": { "raw": { "language": "json" } } }, "url": { "raw": "https://{{domain}}/DhsDivaltoServiceDivaApiRest/api/v1/RecordSQL/Execute", "protocol": "https", "host": [ "{{domain}}" ], "path": [ "DhsDivaltoServiceDivaApiRest", "api", "v1", "RecordSQL", "Execute" ] } }, "response": [] }, { "name": "Import article", "request": { "method": "POST", "header": [ { "key": "Content-Type", "value": "application/json", "type": "text" } ], "body": { "mode": "raw", "raw": "{\n\"dhoq\" : \"gtrsart.dhoq\",\n\"recordsql\" : \"article\",\n\"access_token\" : \"{{ACCESS_TOKEN}}\",\n\"parameters\" : \"MZ.Dos='998'\",\n\"fields\" : \"\",\n\"filter\": \"\",\n\"offset\" : 0,\n\"count\" : 1\n}", "options": { "raw": { "language": "json" } } }, "url": { "raw": "https://{{domain}}/DhsDivaltoServiceDivaApiRest/api/v1/RecordSQL/Execute", "protocol": "https", "host": [ "{{domain}}" ], "path": [ "DhsDivaltoServiceDivaApiRest", "api", "v1", "RecordSQL", "Execute" ] } }, "response": [] }, { "name": "Import tax", "request": { "method": "POST", "header": [ { "key": "Content-Type", "value": "application/json", "type": "text" } ], "body": { "mode": "raw", "raw": "{\n\"dhoq\" : \"gtrstab.dhoq\",\n\"recordsql\" : \"TauxTvaN\",\n\"access_token\" : \"{{ACCESS_TOKEN}}\",\n\"parameters\" : \"MZ.Dos='100'\",\n\"fields\" : \"\",\n\"filter\": \"\",\n\"offset\" : 0,\n\"count\" : 100\n}", "options": { "raw": { "language": "json" } } }, "url": { "raw": "https://{{domain}}/DhsDivaltoServiceDivaApiRest/api/v1/RecordSQL/Execute", "protocol": "https", "host": [ "{{domain}}" ], "path": [ "DhsDivaltoServiceDivaApiRest", "api", "v1", "RecordSQL", "Execute" ] } }, "response": [] }, { "name": "Import ledgers", "request": { "method": "POST", "header": [ { "key": "Content-Type", "value": "application/json", "type": "text" } ], "body": { "mode": "raw", "raw": "{\n\"dhoq\" : \"ccrsjca.dhoq\",\n\"recordsql\" : \"Journal\",\n\"access_token\" : \"{{ACCESS_TOKEN}}\",\n\"parameters\" : \"\",\n\"fields\" : \"JNL;LIB;JNLTYP;USERMODH\",\n\"filter\": \"\",\n\"offset\" : 0,\n\"count\" : 2\n}", "options": { "raw": { "language": "json" } } }, "url": { "raw": "https://{{domain}}/DhsDivaltoServiceDivaApiRest/api/v1/RecordSQL/Execute", "protocol": "https", "host": [ "{{domain}}" ], "path": [ "DhsDivaltoServiceDivaApiRest", "api", "v1", "RecordSQL", "Execute" ] } }, "response": [] }, { "name": "Import dimensions", "request": { "method": "POST", "header": [ { "key": "Content-Type", "value": "application/json", "type": "text" } ], "body": { "mode": "raw", "raw": "{\n\"dhoq\" : \"ccrsjca.dhoq\",\n\"recordsql\" : \"Axe\",\n\"access_token\" : \"{{ACCESS_TOKEN}}\",\n\"parameters\" : \"MZ.Dos='1'\",\n\"fields\" : \"\",\n\"filter\": \"\",\n\"offset\" : 0,\n\"count\" : 1000,\n\"where\": \"Equal_AXENO\",\n\"where_parameters\": \"1\"\n}", "options": { "raw": { "language": "json" } } }, "url": { "raw": "https://{{domain}}/DhsDivaltoServiceDivaApiRest/api/v1/RecordSQL/Execute", "protocol": "https", "host": [ "{{domain}}" ], "path": [ "DhsDivaltoServiceDivaApiRest", "api", "v1", "RecordSQL", "Execute" ] } }, "response": [] } ] }, { "name": "Feedbacks", "item": [ { "name": "RÉFÉRENCE - Champs et clauses", "request": { "method": "GET", "header": [], "url": { "raw": "https://placeholder.local", "protocol": "https", "host": [ "placeholder", "local" ] }, "description": "CHAMPS DISPONIBLES FACTURES:\n\nERCNO : Numéro enregistrement unique (immuable)\nFANO : Numéro facture\nPIDT : Date facture reçue\nMONTANT : Montant TTC\nTIERS : Code fournisseur\nSTATUS : Statut (PAYEE, EN_COURS, EN_LITIGE)\nDATESYS_PAIEMENT : Date paiement réel en Divalto\nDATEECH : Date d'échéance\nMODREG : Mode règlement (Virement, Chèque)\nNUMREF_PAIEMENT : Numéro référence paiement\n\nCLAUSES WHERE:\n\nEqual_Ercno : Chercher par ERCNO spécifique\nEqual_Fano : Chercher par numéro facture\nEqual_Tiers : Chercher par fournisseur\nEqual_Status : Chercher par statut\nBetween_DatePaiement : Entre deux dates de paiement\nSuperior_DatePaiement : À partir d'une date\nInferior_DatePaiement : Avant une date\n\nPOINTS IMPORTANTS:\n\n✅ ERCNO = Identifiant unique (jamais changé, à utiliser pour traçabilité)\n✅ BAP = Autorisation paiement (pas paiement lui-même)\n✅ DATESYS_PAIEMENT = Date paiement réel (après échéance)\n✅ Facture créée → BAP envoyé → Paiement (quelques jours plus tard)\n\n❌ BAPSALCOD obligatoire en BAP\n❌ Numéro facture BAP doit correspondre à création\n❌ Validateur (VALDM001) doit exister en Divalto" }, "response": [] }, { "name": "Toutes les factures payées", "request": { "method": "POST", "header": [ { "key": "Content-Type", "value": "application/json" }, { "key": "Authorization", "value": "Bearer {{access_token}}" } ], "body": { "mode": "raw", "raw": "{\n \"dhoq\": \"gtrsfat.dhoq\",\n \"recordsql\": \"FACTURE_PAYEE\",\n \"fields\": \"ERCNO;FANO;PIDT;MONTANT;TIERS;STATUS;DATESYS_PAIEMENT\",\n \"offset\": \"0\",\n \"count\": \"100\",\n \"access_token\":\"{{ACCESS_TOKEN}}\"\n}" }, "url": { "raw": "https://{{domain}}/DhsDivaltoServiceDivaApiRest/api/v1/RecordSQL/Execute", "protocol": "https", "host": [ "{{domain}}" ], "path": [ "DhsDivaltoServiceDivaApiRest", "api", "v1", "RecordSQL", "Execute" ] }, "description": "Récupère TOUTES les factures payées avec ERCNO, montant, date paiement." }, "response": [] }, { "name": "Facture payée spécifique (par ERCNO)", "request": { "method": "POST", "header": [ { "key": "Content-Type", "value": "application/json" }, { "key": "Authorization", "value": "Bearer {{access_token}}" } ], "body": { "mode": "raw", "raw": "{\n \"dhoq\": \"gtrsfat.dhoq\",\n \"recordsql\": \"FACTURE_PAYEE\",\n \"where\": \"Equal_Ercno\",\n \"where_parameters\": \"9876\",\n \"fields\": \"ERCNO;FANO;PIDT;MONTANT;TIERS;STATUS;DATESYS_PAIEMENT;DATEECH\",\n \"access_token\":\"{{ACCESS_TOKEN}}\"\n}" }, "url": { "raw": "https://{{domain}}/DhsDivaltoServiceDivaApiRest/api/v1/RecordSQL/Execute", "protocol": "https", "host": [ "{{domain}}" ], "path": [ "DhsDivaltoServiceDivaApiRest", "api", "v1", "RecordSQL", "Execute" ] }, "description": "Récupère une facture payée spécifique par ERCNO. Remplacer 9876 par l'ERCNO souhaité." }, "response": [] }, { "name": "Factures payées d'un fournisseur", "request": { "method": "POST", "header": [ { "key": "Content-Type", "value": "application/json" }, { "key": "Authorization", "value": "Bearer {{access_token}}" } ], "body": { "mode": "raw", "raw": "{\n \"dhoq\": \"gtrsfat.dhoq\",\n \"recordsql\": \"FACTURE_PAYEE\",\n \"where\": \"Equal_Tiers\",\n \"where_parameters\": \"FURN001\",\n \"fields\": \"ERCNO;FANO;PIDT;MONTANT;TIERS;DATESYS_PAIEMENT\",\n \"orderby\": \"Par_DatePaiement\",\n \"offset\": \"0\",\n \"count\": \"50\",\n \"access_token\":\"{{ACCESS_TOKEN}}\"\n}" }, "url": { "raw": "https://{{domain}}/DhsDivaltoServiceDivaApiRest/api/v1/RecordSQL/Execute", "protocol": "https", "host": [ "{{domain}}" ], "path": [ "DhsDivaltoServiceDivaApiRest", "api", "v1", "RecordSQL", "Execute" ] }, "description": "Récupère factures payées d'un fournisseur spécifique, triées par date. Remplacer FURN001 par le fournisseur souhaité." }, "response": [] }, { "name": "Factures payées entre 2 dates", "request": { "method": "POST", "header": [ { "key": "Content-Type", "value": "application/json" }, { "key": "Authorization", "value": "Bearer {{access_token}}" } ], "body": { "mode": "raw", "raw": "{\n \"dhoq\": \"gtrsfat.dhoq\",\n \"recordsql\": \"FACTURE_PAYEE\",\n \"where\": \"Between_DatePaiement\",\n \"where_parameters\": \"20250101;20250131\",\n \"fields\": \"ERCNO;FANO;PIDT;MONTANT;TIERS;DATESYS_PAIEMENT\",\n \"offset\": \"0\",\n \"count\": \"100\",\n \"access_token\":\"{{ACCESS_TOKEN}}\"\n}" }, "url": { "raw": "https://{{domain}}/DhsDivaltoServiceDivaApiRest/api/v1/RecordSQL/Execute", "protocol": "https", "host": [ "{{domain}}" ], "path": [ "DhsDivaltoServiceDivaApiRest", "api", "v1", "RecordSQL", "Execute" ] }, "description": "Récupère factures payées entre deux dates. Remplacer 20250101 et 20250131 par les dates souhaitées (format AAAAMMJJ)." }, "response": [] } ] }, { "name": "BAP", "item": [ { "name": "Envoyer Bon à Payer (BAP)", "event": [ { "listen": "test", "script": { "exec": [ "const response = pm.response.json();", "if (response.error === 0) {", " console.log('✅ BAP envoyé avec succès');", " console.log('Facture prête pour paiement');", " console.log('Attendre quelques jours puis vérifier paiement avec ÉTAPE 3');", "} else {", " console.error('❌ Erreur BAP: ' + response.txterr);", "}" ], "type": "text/javascript", "packages": {}, "requests": {} } } ], "request": { "method": "POST", "header": [ { "key": "Content-Type", "value": "application/json" }, { "key": "Authorization", "value": "Bearer {{access_token}}" } ], "body": { "mode": "raw", "raw": "{\n \"action\": \"SYNCHRO_INFINITY_AGILEO\",\n \"param\": \"IM998F4FAC_FURN001_20250122A998F4FAC_FURN001_20250122FURN001OP01DEPOT01VALDM001BAP\",\n \"access_token\":\"{{ACCESS_TOKEN}}\"\n}" }, "url": { "raw": "https://{{domain}}/DhsDivaltoServiceDivaApiRest/api/v1/RecordSQL/Execute", "protocol": "https", "host": [ "{{domain}}" ], "path": [ "DhsDivaltoServiceDivaApiRest", "api", "v1", "RecordSQL", "Execute" ] }, "description": "Envoie le BAP pour la facture créée. IMPORTANT: Le numéro de facture (PINO) doit correspondre à celui créé en ÉTAPE 1. BAPSALCOD doit être un validateur existant en Divalto." }, "response": [] } ] }, { "name": "Get token", "event": [ { "listen": "test", "script": { "exec": [ "let jsonData = pm.response.json();\r", "pm.environment.set(\"ACCESS_TOKEN\", jsonData.access_token);\r", "" ], "type": "text/javascript", "packages": {} } } ], "protocolProfileBehavior": { "disabledSystemHeaders": {} }, "request": { "method": "POST", "header": [ { "key": "Content-Type", "value": "application/json", "type": "text" } ], "body": { "mode": "raw", "raw": "{\n \"user\": \"{{USER}}\",\n \"password\": \"{{PASSWORD}}\",\n \"env\" : \"{{env}}\"\n}", "options": { "raw": { "language": "json" } } }, "url": { "raw": "https://{{domain}}/DhsDivaltoServiceDivaApiRest/api/v1/Authent/Auth", "protocol": "https", "host": [ "{{domain}}" ], "path": [ "DhsDivaltoServiceDivaApiRest", "api", "v1", "Authent", "Auth" ] } }, "response": [] }, { "name": "Post écriture comptable DataHub REST", "request": { "method": "POST", "header": [], "body": { "mode": "raw", "raw": "{ \n \"action\":\"SYNCHRO_INFINITY_AGILEO\",\n \"access_token\":\"{{ACCESS_TOKEN}}\",\n \"param\":\"\"\n}", "options": { "raw": { "language": "json" } } }, "url": { "raw": "https://{{domain}}/DhsDivaltoServiceDivaApiRest/api/v1/WebService/Execute", "protocol": "https", "host": [ "{{domain}}" ], "path": [ "DhsDivaltoServiceDivaApiRest", "api", "v1", "WebService", "Execute" ] } }, "response": [] }, { "name": "Post écriture comptable API", "request": { "method": "POST", "header": [], "body": { "mode": "raw", "raw": "{\n \"action\": \"WEB_SERVICE_INFINITY\",\n \"access_token\": \"{{ACCESS_TOKEN}}\",\n \"param\": \"{'action':{'swinfinity':'integration_ecriture','parameters':{'doscpt':'1','dos':'1','etb':'','withlog':'1'}},'data':{'EntryTable':[{'EntryLineTable':[{'EntryLine':{'ESTABLISHMENT':'','ACCOUNT':'F0000002','ENTRYDATE':'20201216','DESCRIPTION':'55374619 LEFRANC ET BOURGEOIS','JOURNAL':'A2','CURRENCY':'EUR','AMOUNT':2085,'FOREIGNCURRENCYTAMOUNT':2085,'FLOW':'CREDIT','THIRDPARTYDOCUMENTNO':'55374619','PAYMENTMODE':'VIR','DUEDATE':''}},{'EntryLine':{'ESTABLISHMENT':'','ACCOUNT':'60700000','ENTRYDATE':'20201216','DESCRIPTION':'55374619 LEFRANC ET BOURGEOIS','JOURNAL':'A2','CURRENCY':'EUR','AMOUNT':1737.5,'FOREIGNCURRENCYTAMOUNT':1737.5,'FLOW':'DEBIT','THIRDPARTYDOCUMENTNO':'55374619','VATLigneTable':[{'VATLigne':{'ITEMVAT':'1','THIRDPARTYVAT':'0','AMOUNTEXTAXES':1737.5,'VATAMOUNT':347.5,'VATONDEBITORCREDIT':'1'}}]}},{'EntryLine':{'ESTABLISHMENT':'','ACCOUNT':'44571000','ENTRYDATE':'20201216','DESCRIPTION':'55374619 LEFRANC ET BOURGEOIS','JOURNAL':'A2','CURRENCY':'EUR','AMOUNT':347.5,'FOREIGNCURRENCYTAMOUNT':347.5,'FLOW':'DEBIT','THIRDPARTYDOCUMENTNO':'55374619'}}]}]}}\"\n}", "options": { "raw": { "language": "json" } } }, "url": { "raw": "https://{{domain}}/DhsDivaltoServiceDivaApiRest/api/v1/WebService/Execute", "protocol": "https", "host": [ "{{domain}}" ], "path": [ "DhsDivaltoServiceDivaApiRest", "api", "v1", "WebService", "Execute" ] } }, "response": [] } ] }