Syfre le 2 janvier 2021 à 18:44

2021-01-02T18:44:38Z

Syfre le 31 décembre 2020 à 16:13

2020-12-31T16:13:08Z

Syfre : a déplacé Import d'écriture (API) vers Import d'écritures (API)

2020-12-31T15:40:21Z

a déplacé Import d'écriture (API) vers Import d'écritures (API)

Syfre le 31 décembre 2020 à 15:36

2020-12-31T15:36:27Z

Syfre : Page créée avec « Ce exemple montre comment importer des écritures en utilisant l'API SData. Pour réaliser l'import d'écriture on utilise le processus d'import des écritures basée sur... »

2020-12-31T14:26:55Z

Page créée avec « Ce exemple montre comment importer des écritures en utilisant l'API SData. Pour réaliser l'import d'écriture on utilise le processus d'import des écritures basée sur... »

Nouvelle page

Ce exemple montre comment importer des écritures en utilisant l'API SData.

Pour réaliser l'import d'écriture on utilise le processus d'import des écritures basée sur des sessions d'import.

Pour cela il faut :

# Créer une session d'import (TSessionImport)
# Créer les écritures d'import (TEcritureImport) rattachées à cette session
# Exécuter le processus d'exécution de session d'import (TProcessusPlanifImport)

<pre>
{
"$": {"$transaction":["atomic"]},
"$resources": [
{
"$httpMethod":"POST",
"$url":"cptimport/tsessionimport",
"$uuid":"session",
"Caption":"Session import par API - 4",
"CompteEquilibre":{"$url":"TCompteGeneral(codeCompte eq '10500000')"},
},
{
"$httpMethod":"POST",
"$url":"cptimport/timportecritures",
"SessionImport":{"$uuid":"session"},
"codeJournal": "ACH",
"compteAuxiliaire": "F-ABI 007",
"compteGeneral": "40110000",
"dateEcheance": "2019-01-30T23:00:00.000Z",
"datePiece": "2018-12-31T23:00:00.000Z",
"deviseEcriture": "EUR",
"deviseTenueCompte": "EUR",
"etablissement": "ETS1-S01",
"modePaiement": "LCR",
"montant": 1200,
"montantEnDevise": 1200,
"numeroPiece": "AC2009/01-000147",
"sens": "C",
"typeCompte": "X",
"typeEcriture": "Brouillard",
"typePiece": "AF"
},
{
"$httpMethod":"POST",
"$url":"cptimport/timportecritures",
"codeJournal": "ACH",
"compteGeneral": "60114000",
"dateEcheance": "1899-12-30T00:00:00.000Z",
"datePiece": "2018-12-31T23:00:00.000Z",
"deviseEcriture": "EUR",
"deviseTenueCompte": "EUR",
"etablissement": "ETS1-S01",
"montant": 1200,
"montantEnDevise": 1200,
"numeroPiece": "AC2009/01-000147",
"sens": "D",
"typeEcriture": "Brouillard",
"typePiece": "AF"
},
{
"$httpMethod":"POST",
"$url":"cptimport/timportecritures",
"SessionImport":{"$uuid":"session"},
"codeJournal": "ACH",
"compteGeneral": "47100000",
"dateEcheance": "1899-12-30T00:00:00.000Z",
"datePiece": "2018-12-31T23:00:00.000Z",
"deviseEcriture": "EUR",
"deviseTenueCompte": "EUR",
"etablissement": "ETS1-S01",
"montant": 1000,
"montantEnDevise": 1000,
"numeroPiece": "AC2009/01-000148",
"sens": "C",
"typeEcriture": "Brouillard",
"typePiece": "AF"
},
{
"$httpMethod":"POST",
"$url":"cptimport/timportecritures",
"SessionImport":{"$uuid":"session"},
"codeJournal": "ACH",
"compteGeneral": "60114000",
"dateEcheance": "1899-12-30T00:00:00.000Z",
"datePiece": "2018-12-31T23:00:00.000Z",
"deviseEcriture": "EUR",
"deviseTenueCompte": "EUR",
"etablissement": "ETS1-S01",
"montant": 1000,
"montantEnDevise": 1000,
"numeroPiece": "AC2009/01-000148",
"sens": "D",
"typeEcriture": "Brouillard",
"typePiece": "AF"
},
{
"$httpMethod":"POST",
"$url":"cptimport/timportecritures",
"SessionImport":{"$uuid":"session"},
"codeJournal": "ACH",
"compteAuxiliaire": "F-BARRES",
"compteGeneral": "40110000",
"dateEcheance": "2019-01-30T23:00:00.000Z",
"datePiece": "2018-12-31T23:00:00.000Z",
"deviseEcriture": "EUR",
"deviseTenueCompte": "EUR",
"etablissement": "ETS1-S01",
"modePaiement": "LCR",
"montant": 1000,
"montantEnDevise": 1000,
"numeroPiece": "AC2009/01-000149",
"sens": "C",
"typeCompte": "X",
"typeEcriture": "Brouillard",
"typePiece": "AF"
},
{
"$httpMethod":"POST",
"$url":"cptimport/timportecritures",
"SessionImport":{"$uuid":"session"},
"codeJournal": "ACH",
"compteGeneral": "60114000",
"dateEcheance": "1899-12-30T00:00:00.000Z",
"datePiece": "2018-12-31T23:00:00.000Z",
"deviseEcriture": "EUR",
"deviseTenueCompte": "EUR",
"etablissement": "ETS1-S01",
"montant": 1000,
"montantEnDevise": 1000,
"numeroPiece": "AC2009/01-000149",
"sens": "D",
"typeEcriture": "Brouillard",
"typePiece": "AF"
},
{
"$httpMethod":"POST",
"$url":"cptimport/timportecritures",
"SessionImport":{"$uuid":"session"},
"codeJournal": "ACH",
"compteGeneral": "47100000",
"dateEcheance": "1899-12-30T00:00:00.000Z",
"datePiece": "2018-12-31T23:00:00.000Z",
"deviseEcriture": "EUR",
"deviseTenueCompte": "EUR",
"etablissement": "ETS1-S01",
"montant": 100,
"montantEnDevise": 100,
"numeroPiece": "AC2009/01-000150",
"sens": "C",
"typeEcriture": "Brouillard",
"typePiece": "AF"
},
{
"$httpMethod":"POST",
"$url":"cptimport/timportecritures",
"SessionImport":{"$uuid":"session"},
"codeJournal": "ACH",
"compteGeneral": "60114000",
"dateEcheance": "1899-12-30T00:00:00.000Z",
"datePiece": "2018-12-31T23:00:00.000Z",
"deviseEcriture": "EUR",
"deviseTenueCompte": "EUR",
"etablissement": "ETS1-S01",
"montant": 100,
"montantEnDevise": 100,
"numeroPiece": "AC2009/01-000150",
"sens": "D",
"typeEcriture": "Brouillard",
"typePiece": "AF"
},
{
"$httpMethod":"POST",
"$url":"cptimport/timportecritures",
"SessionImport":{"$uuid":"session"},
"codeJournal": "ACH",
"compteAuxiliaire": "F-BARRES",
"compteGeneral": "40110000",
"dateEcheance": "2019-07-30T22:00:00.000Z",
"datePiece": "2019-06-15T22:00:00.000Z",
"deviseEcriture": "EUR",
"deviseTenueCompte": "EUR",
"etablissement": "ETS1-S01",
"libelleEcriture": "libellé",
"modePaiement": "LCR",
"montant": 100,
"montantEnDevise": 100,
"numeroPiece": "AC2009/06-000001",
"sens": "C",
"typeCompte": "X",
"typeEcriture": "Brouillard",
"typePiece": "FF"
},
{
"$httpMethod":"POST",
"$url":"cptimport/timportecritures",
"SessionImport":{"$uuid":"session"},
"codeJournal": "ACH",
"compteGeneral": "47100000",
"dateEcheance": "1899-12-30T00:00:00.000Z",
"datePiece": "2019-06-15T22:00:00.000Z",
"deviseEcriture": "EUR",
"deviseTenueCompte": "EUR",
"etablissement": "ETS1-S01",
"libelleEcriture": "libellé",
"montant": 100,
"montantEnDevise": 100,
"numeroPiece": "AC2009/06-000001",
"sens": "D",
"typeEcriture": "Brouillard",
"typePiece": "FF"
},
{
"$": {"$transaction":["commit"]},
"$httpMethod":"EXEC"
"$url":"cptimportmouvement/TProcessusPlanifImport/Executer",
"$uuid":"processus",
"$resource" : {
"codeSessionInf":"Session import par API - 4",
"codeSessionSup":"Session import par API - 4",
"importerExterne":true,
}
},
]
}
</pre>

{{Tip|Notez l'utilisation de $transaction "commit" dans l'exécution du processus TProcessusPlanifImport, cette directive termine la transaction ouverte par le batch car ce processus ne fonctionne pas si une transaction longue est ouverte avant l'exécution.}}

Le résultat de l'exécution :

<pre>
{
"$baseUrl": "http://localhost:8080/sdata/l1000/-/-/",
"$title": "$batch - -",
"$resources": [
{
"$httpStatus": 201,
"$httpMethod": "POST",
"$httpMessage": "Created",
"$etag": "1B28EFFFF1C300020413000002450001-000001CF00000001",
"$location": "http://localhost:8080/sdata/l1000/cptimport/-/TSessionImport('1B28EFFFF1C300020413000002450001')",
"$milliseconds": "129,1544"
},
{
"$httpStatus": 201,
"$httpMethod": "POST",
"$httpMessage": "Created",
"$etag": "1B28EFFFF1C300020308000002450002-000001CF00000002",
"$location": "http://localhost:8080/sdata/l1000/cptimport/-/TImportEcritures('1B28EFFFF1C300020308000002450002')",
"$milliseconds": "2,6776"
},
{
"$httpStatus": 201,
"$httpMethod": "POST",
"$httpMessage": "Created",
"$etag": "1B28EFFFF1C300020308000002450003-000001CF00000003",
"$location": "http://localhost:8080/sdata/l1000/cptimport/-/TImportEcritures('1B28EFFFF1C300020308000002450003')",
"$milliseconds": "0,9213"
},
{
"$httpStatus": 201,
"$httpMethod": "POST",
"$httpMessage": "Created",
"$etag": "1B28EFFFF1C300020308000002450004-000001CF00000004",
"$location": "http://localhost:8080/sdata/l1000/cptimport/-/TImportEcritures('1B28EFFFF1C300020308000002450004')",
"$milliseconds": "1,0709"
},
{
"$httpStatus": 201,
"$httpMethod": "POST",
"$httpMessage": "Created",
"$etag": "1B28EFFFF1C300020308000002450005-000001CF00000005",
"$location": "http://localhost:8080/sdata/l1000/cptimport/-/TImportEcritures('1B28EFFFF1C300020308000002450005')",
"$milliseconds": "1,1676"
},
{
"$httpStatus": 201,
"$httpMethod": "POST",
"$httpMessage": "Created",
"$etag": "1B28EFFFF1C300020308000002450006-000001CF00000006",
"$location": "http://localhost:8080/sdata/l1000/cptimport/-/TImportEcritures('1B28EFFFF1C300020308000002450006')",
"$milliseconds": "0,9573"
},
{
"$httpStatus": 201,
"$httpMethod": "POST",
"$httpMessage": "Created",
"$etag": "1B28EFFFF1C300020308000002450007-000001CF00000007",
"$location": "http://localhost:8080/sdata/l1000/cptimport/-/TImportEcritures('1B28EFFFF1C300020308000002450007')",
"$milliseconds": "1,1896"
},
{
"$httpStatus": 201,
"$httpMethod": "POST",
"$httpMessage": "Created",
"$etag": "1B28EFFFF1C300020308000002450008-000001CF00000008",
"$location": "http://localhost:8080/sdata/l1000/cptimport/-/TImportEcritures('1B28EFFFF1C300020308000002450008')",
"$milliseconds": "2,8675"
},
{
"$httpStatus": 201,
"$httpMethod": "POST",
"$httpMessage": "Created",
"$etag": "1B28EFFFF1C300020308000002450009-000001CF00000009",
"$location": "http://localhost:8080/sdata/l1000/cptimport/-/TImportEcritures('1B28EFFFF1C300020308000002450009')",
"$milliseconds": "2,0515"
},
{
"$httpStatus": 201,
"$httpMethod": "POST",
"$httpMessage": "Created",
"$etag": "1B28EFFFF1C30002030800000245000A-000001CF0000000A",
"$location": "http://localhost:8080/sdata/l1000/cptimport/-/TImportEcritures('1B28EFFFF1C30002030800000245000A')",
"$milliseconds": "1,2315"
},
{
"$httpStatus": 201,
"$httpMethod": "POST",
"$httpMessage": "Created",
"$etag": "1B28EFFFF1C30002030800000245000B-000001CF0000000B",
"$location": "http://localhost:8080/sdata/l1000/cptimport/-/TImportEcritures('1B28EFFFF1C30002030800000245000B')",
"$milliseconds": "1,1972"
},
{
"$httpStatus": 200,
"$httpMethod": "EXEC",
"$httpMessage": "Executed",
"$url": "cptimportmouvement/TProcessusPlanifImport/Executer",
"$uuid": "processus",
"result": 0,
"$milliseconds": "2199,2158"
}
],
"$batch": {
"$httpStatus": 200,
"$httpMessage": "OK",
"$milliseconds": "2344,0533"
}
}
</pre>

[[Category:SData]]

@@ Ligne 213 : / Ligne 213 : @@
+         {
              "$": {"$transaction":["commit"]},
-             "$httpMethod":"EXEC"
+             "$httpMethod":"EXEC",
              "$url":"cptimportmouvement/TProcessusPlanifImport/Executer",
              "$uuid":"processus",

@@ Ligne 330 : / Ligne 330 : @@
              "$uuid": "processus",
              "result": 0,
-             "$milliseconds": "2199,2158"
+             "$milliseconds": "2044,6074",
+         }
      ],

@@ Ligne 10 : / Ligne 10 : @@
 <pre>
+{
      "$": {"$transaction":["atomic"]},

Import d'écritures (API) - Historique des versions

Syfre le 2 janvier 2021 à 18:44

Syfre le 31 décembre 2020 à 16:13

Syfre : a déplacé Import d'écriture (API) vers Import d'écritures (API)

Syfre le 31 décembre 2020 à 15:36

Syfre : Page créée avec « Ce exemple montre comment importer des écritures en utilisant l'API SData. Pour réaliser l'import d'écriture on utilise le processus d'import des écritures basée sur... »