2.3.3 - Export Endpoints

Owned by Former user (Deleted)
Last updated: 22 März, 2021 by Meike Blobel (Unlicensed)

wiki.poe.de / poe Standardschnittstelle




GET api/dx/exports/{fromId}/{toId} dient zum lesen mehrerer Export-Datensätze. Es empfiehlt sich die letzte erfolgreich gelesene ID als Wiederaufsetzpunkt zu speichern. Es werden alle Datensätze zurückgegeben für deren ID’s gilt: 

fromId <= ID < toId

 

PUT api/dx/exports/{fromId}/{toId} setzt auf allen Export Datensätzen in der Tabelle export2 das done Feld auf True für deren ID gilt:

fromId <= ID < toId.

Liefert im Erfolgsfall:

{ “success“: true, “affected_rows“: <number> }

 

DELETE api/dx/exports/{fromId}/{toId} löscht alle Export Datensätze aus der Tabelle export2 für deren ID gilt: fromId <= ID < toId.

Liefert im Erfolgsfall:

{ “success“: true, “affected_rows“: <number> }


GET api/dx/exports/{id} liefert den durch {id} identifizierten Export Datensatz aus der Tabelle export2; oder HTTP-Fehler 404 – Not Found zurück.


Achtung! Oben beschriebene PUT und DELETE calls melden Erfolg auch dann zurück wenn die angegebenen Datensätze nicht gefunden wurden. Zur genaueren Ergebnis-Prüfung empfiehlt es sich das affected_rows Feld auszuwerten oder die Operation durch einen der GET call zu überprüfen.

Beispiel

GET https://{instanz}.poslive.de/api/dx/exports/5/11

Ergebnis
[
{"id":5,"cdate":"20180316164258","done":false,"stype":"FDR","ctype":0,"target":0,"c1":"BON","c2":"BON;Bon","c3":"","c4":"","c5":"","c6":"","c7":"","c8":"","c9":"","c10":"","c11":"","c12":"","c13":"","c14":"","s1":"","s2":"","s3":"","s4":"","s5":"","s6":"","s7":"","s8":"","s9":"","s10":"","t1":"","b1":false,"b2":false,"b3":false,"b4":false,"b5":false,"b6":false,"i1":2671,"i2":267,"i3":221,"i4":458,"i5":0,"i6":0,"i7":0,"i8":0,"i9":0,"i10":0,"i11":0,"i12":0,"i13":0,"i14":0,"f1":0,"f2":0,"f3":0,"f4":0,"f5":0,"f6":0,"f7":0,"d1":"20171128","d2":"205251","d3":"","d4":""},
{"id":6,"cdate":"20180316164258","done":false,"stype":"VAB","ctype":0,"target":0,"c1":"","c2":"Mastercard","c3":"","c4":"","c5":"","c6":"","c7":"","c8":"","c9":"","c10":"1111111xxxxxx1111","c11":"","c12":"","c13":"","c14":"","s1":"","s2":"","s3":"","s4":"","s5":"","s6":"","s7":"92","s8":"","s9":"","s10":"","t1":"","b1":false,"b2":false,"b3":false,"b4":false,"b5":false,"b6":false,"i1":221,"i2":2671,"i3":3375,"i4":1,"i5":0,"i6":4,"i7":1,"i8":458,"i9":3,"i10":0,"i11":0,"i12":0,"i13":267,"i14":0,"f1":37.8,"f2":31.76,"f3":0,"f4":0,"f5":0,"f6":0,"f7":0,"d1":"20171128","d2":"205251","d3":"","d4":""},
{"id":7,"cdate":"20180316164258","done":false,"stype":"ART","ctype":0,"target":0,"c1":"791093","c2":"","c3":"Verkaufsraum","c4":"0","c5":"","c6":"0","c7":"","c8":"0","c9":"","c10":"","c11":"","c12":"","c13":"","c14":"","s1":"Artikel 791093","s2":"","s3":"","s4":"","s5":"","s6":"","s7":"","s8":"","s9":"","s10":"","t1":"","b1":false,"b2":false,"b3":false,"b4":false,"b5":false,"b6":false,"i1":1,"i2":458,"i3":2671,"i4":0,"i5":0,"i6":0,"i7":0,"i8":267,"i9":0,"i10":3375,"i11":0,"i12":0,"i13":0,"i14":0,"f1":1,"f2":6.95,"f3":6.95,"f4":6.95,"f5":5.84,"f6":0,"f7":0,"d1":"","d2":"","d3":"","d4":""},
{"id":8,"cdate":"20180316164258","done":false,"stype":"ART","ctype":0,"target":0,"c1":"257406","c2":"","c3":"Verkaufsraum","c4":"0","c5":"","c6":"0","c7":"","c8":"0","c9":"","c10":"","c11":"","c12":"","c13":"","c14":"","s1":"Artikel 257406","s2":"","s3":"","s4":"","s5":"","s6":"","s7":"","s8":"","s9":"","s10":"","t1":"","b1":false,"b2":false,"b3":false,"b4":false,"b5":false,"b6":false,"i1":1,"i2":458,"i3":2671,"i4":0,"i5":0,"i6":0,"i7":0,"i8":267,"i9":0,"i10":3375,"i11":0,"i12":0,"i13":0,"i14":0,"f1":1,"f2":6.95,"f3":6.95,"f4":6.95,"f5":5.84,"f6":0,"f7":0,"d1":"","d2":"","d3":"","d4":""},
{"id":9,"cdate":"20180316164258","done":false,"stype":"ART","ctype":0,"target":0,"c1":"271068","c2":"","c3":"Verkaufsraum","c4":"0","c5":"","c6":"0","c7":"","c8":"0","c9":"","c10":"","c11":"","c12":"","c13":"","c14":"","s1":"Artikel 271068","s2":"","s3":"","s4":"","s5":"","s6":"","s7":"","s8":"","s9":"","s10":"","t1":"","b1":false,"b2":false,"b3":false,"b4":false,"b5":false,"b6":false,"i1":1,"i2":458,"i3":2671,"i4":0,"i5":0,"i6":0,"i7":0,"i8":267,"i9":0,"i10":3375,"i11":0,"i12":0,"i13":0,"i14":0,"f1":1,"f2":5.95,"f3":5.95,"f4":5.95,"f5":5,"f6":0,"f7":0,"d1":"","d2":"","d3":"","d4":""},
{"id":10,"cdate":"20180316164258","done":false,"stype":"ART","ctype":0,"target":0,"c1":"270090","c2":"","c3":"Verkaufsraum","c4":"0","c5":"","c6":"0","c7":"","c8":"0","c9":"","c10":"","c11":"","c12":"","c13":"","c14":"","s1":"Artikel 270090","s2":"","s3":"","s4":"","s5":"","s6":"","s7":"","s8":"","s9":"","s10":"","t1":"","b1":false,"b2":false,"b3":false,"b4":false,"b5":false,"b6":false,"i1":1,"i2":458,"i3":2671,"i4":0,"i5":0,"i6":0,"i7":0,"i8":267,"i9":0,"i10":3375,"i11":0,"i12":0,"i13":0,"i14":0,"f1":1,"f2":17.95,"f3":17.95,"f4":17.95,"f5":15.08,"f6":0,"f7":0,"d1":"","d2":"","d3":"","d4":""}
]

In diesem Beispiel sind 6 Datensätze die zu einem Beleg gehören zu sehen, ein FDR Satz mit Daten zum Druck, ein VAB Satz mit Zahlungsdaten und 4 ART Sätze mit Artikeldaten.


Vertraulichkeitshinweis
Dieses Dokument und etwaige Anlagen können vertrauliche sowie der beruflichen Schweigepflicht unterliegende Informationen enthalten. Sollten Sie dieses Dokument irrtümlich erhalten haben, benachrichtigen Sie uns bitte durch eine Antwort-Mail und löschen Sie dieses Dokument nebst Anlagen von Ihrem System. Das unerlaubte Kopieren sowie die Weitergabe sind nicht gestattet. Vielen Dank!

Confidentiality note
This document, including any attachment, may contain confidential and privileged information. If you have received it by mistake, please notify us by reply e-mail and then delete this document and any attachment from your system. Any unauthorized copying, disclosure or distribution of the material in this document is strictly forbidden. Thank you.