Bestellungen auslesen
Die Bestellungen können über einen GET
-Request über die URL /api/legacy/order?oid=1023
geladen werden.
Das Ergebnis wird als Dataset zurückgeliefert.
Parameter
Parameter |
Beschreibung |
oid |
Alvine Bestellnummer OID |
billNumber |
Rechnungsnummer |
companyOrderID |
Bestellnummer Mandant |
Felder
Feld |
Beschreibung |
Beispiel |
uid |
Benutzer UID |
|
companyOrderID |
Bestellnummer Mandant |
|
daid |
ID der Lieferadresse |
|
aaid |
ID der Rechnungsadresse |
|
customerIdentCode |
|
|
shippingDcid |
ID der Lieferkondition DCID |
|
shippingNotice |
Liefernotiz |
|
companyOrderData |
Original Daten einer externen Bestellung |
|
companyOrderState |
Status einer externen Bestellung |
|
companyOrderDate |
Datum einer externen Bestellung |
|
p_provider_id |
|
|
p_provider |
|
|
p_date |
|
|
p_intern_state |
|
|
data |
|
|
exportFlag |
|
|
exportDate |
|
|
fraud |
|
|
affiliateID |
|
|
deliveryNotice |
|
|
oid |
Bestellnummer |
|
cegReid |
|
|
ip |
|
|
ticketIDs |
|
|
state |
|
|
date |
|
|
date_f |
|
09.10.2017 09:22:12 |
date_date_f |
|
09.10.2017 |
date_timestamp |
|
1507540932 |
resubmission_f |
|
00.00.0000 |
p_date_f |
|
09.10.2017 09:27:15 |
p_state |
|
15 |
p_notice |
|
CAPTURED |
notice |
Notiz |
|
shid |
Mandant ID |
1 |
aid |
Adress ID |
38 |
contact |
Kontakt |
|
company |
Firma |
schukai GmbH |
address1 |
Strasse und Hausnummer |
An den Linden 34 |
address2 |
Adresszusatz / CO |
Max Mustermann |
zipcode |
Postleitzahl |
85214 |
city |
Stadt |
Lindenhain |
country |
Land |
de |
systemSpecial |
Lieferung an eine Packstation (intern) |
|
pid |
Payment ID |
358 |
personalName |
Name |
Hans Eckert |
personalFormofaddress |
Anrede |
Herr |
personal_lt_formofaddress |
Briefanrede |
Sehr geehrter Herr Eckert |
personalTitle |
Titel |
Dr. |
personalSurname |
Nachname |
Eckert |
personalFirstname |
Vorname |
Hans |
personalBirthday |
Geburtstag |
0000-00-00 |
personalCustom1 |
Kundenspezifische Daten |
|
personalCustom2 |
Kundenspezifische Daten 2 |
|
username |
Benutzername |
[email protected]_20180117101948 |
type |
|
6 |
__maxrowcount |
|
1 |
personal |
|
Eckert, Herr Hans |
personal_tooltip |
|
|
noticeShort |
|
|
personal_lt |
|
|
positions |
Positionen |
|
deliveries |
Lieferungen |
|
Position
Feld |
Beschreibung |
Beispiel |
scid |
Warenkorb ID |
1472 |
pscid |
|
|
uid |
Benutzer ID |
43 |
item_name |
Name |
Waschmittel |
item_number |
Artikelnummer |
10085 |
customer_number |
Kundennummer |
|
packaging_gift_iid |
|
0 |
sid |
Session ID |
|
iid |
Produkt IID |
10085 |
optional |
Variante |
UNIQUE |
ean |
EAN |
3625974522478 |
count |
Menge |
1 |
oid |
Bestellnummer |
1023 |
reorder |
|
0 |
price |
Brutto Preis |
1299 |
netto |
Netto Preis |
1092 |
did |
ID der Lieferung |
1021 |
flag_stockupdated |
Bestandsbuchung |
1 |
custom1 |
|
|
custom2 |
|
|
custom3 |
|
|
price_type |
|
0 |
description |
Beschreibung |
|
currency |
Währung |
EUR |
pdid |
|
0 |
lid |
Lagerort ID |
0 |
vat |
Steuern |
1900 |
data |
|
|
serialnumber |
|
|
customertext |
|
|
price_recommended |
|
0 |
netto_recommended |
|
0 |
delivery_type |
|
0 |
delivery_id |
|
0 |
salesman_uid |
|
0 |
base_price_net |
|
0 |
base_price_gross |
|
0 |
base_measure_unit |
|
|
base_measure_reference |
|
0 |
base_measure_value |
|
0 |
sales_group |
|
1 |
images |
Bilder |
"main": "/image/alvine/gfx/item/10085/alvine.jpg?time=1522983724" |
Lieferung
Feld |
Beschreibung |
Beispiel |
did |
ID |
1021 |
date |
Datum |
2017-10-09 10:27:39 |
picklist_id |
ID der Pickliste |
0 |
bill_number |
Rechnungsnummer |
1021-1023-43 |
oid |
Bestellnummer |
1023 |
fdate |
Datum formatiert |
09.10.2017 10:27:39 |
timestamp_unix_date |
|
1507544859 |
timestamp_unix_billdate |
|
1507544859 |
state |
Status |
15 |
servicenumber |
|
|
servicecompany |
|
0 |
deliverydate |
Datum der Auslieferung |
2017-10-09 09:27:48 |
fdeliverydate |
Datum der Auslieferung formatiert |
09.10.2017 09:27:48 |
receiving_date |
|
0000-00-00 00:00:00 |
receiving_date_f |
|
00.00.0000 |
packet_number |
Paketnummer |
|
packet_number_retoure |
Paketnummer des Retourenscheines |
|
resubmission |
|
0000-00-00 |
resubmission_info |
|
|
flag_ |
|
0 |
notice |
Notitz |
|
address_account |
Rechnungsadresse |
|
address_delivery |
Lieferadresse |
|
Adresse
Feld |
Beschreibung |
Beispiel |
aid |
|
38 |
uid |
|
43 |
company |
|
|
contact |
|
Herr Hans Eckert |
address1 |
|
An den Linden 34 |
address2 |
|
|
city |
|
Lindenhain |
state |
|
|
zipcode |
|
85214 |
country |
|
de |
preset |
|
1 |
description |
|
|
type |
|
4 |
system_special |
|
|
erpid |
|
|
erpname |
|
|
erpnumber |
|
|
additive1 |
|
|
additive2 |
|
|
lt_formofaddress |
|
Sehr geehrter Herr Eckert |
formofaddress |
|
Herr |
firstname |
|
Hans |
name |
|
Eckert |
{
"dataset": {
"7d0a1810-472b-42bf-ea1e-4ab16a4ff680": {
"uid": "43",
"company_orderid": "",
"daid": "38",
"aaid": "38",
"customer_identcode": "",
"shipping_dcid": "1",
"shipping_notice": "",
"shipping_data": "",
"company_orderdata": "",
"company_orderstate": "0",
"company_orderdate": "0000-00-00 00:00:00",
"p_provider_id": "0",
"p_provider": "",
"p_date": "2017-10-09 09:27:15",
"p_intern_state": "15",
"data": "",
"exportflag": "0",
"exportdate": "",
"fraud": "0",
"affiliate_id": "0",
"delivery_notice": "",
"oid": "1023",
"ceg_reid": "0",
"ip": "::1",
"ticket_ids": "",
"state": "57",
"date": "2017-10-09 09:22:12",
"date_f": "09.10.2017 09:22:12",
"date_date_f": "09.10.2017",
"date_timestamp": "1507540932",
"resubmission_f": "00.00.0000",
"p_date_f": "09.10.2017 09:27:15",
"p_state": "15",
"p_notice": "CAPTURED",
"notice": "",
"shid": "1",
"aid": "38",
"contact": "",
"company": "",
"address1": "An den Linden 34",
"address2": "",
"zipcode": "85214",
"city": "Lindenhain",
"country": "de",
"system_special": "",
"pid": "358",
"personal_name": "Hans Eckert",
"personal_formofaddress": "Herr",
"personal_lt_formofaddress": "Sehr geehrter Herr Eckert",
"personal_title": "",
"personal_surname": "Eckert",
"personal_firstname": "Hans",
"personal_birthday": "0000-00-00",
"personal_custom1": "",
"personal_custom2": "",
"username": "[email protected]_20180117101948",
"type": "6",
"__maxrowcount": "1",
"personal": "Eckert, Herr Hans",
"personal_tooltip": {
"Kontakt": [
[
{
"value": "E-Mail"
},
{
"value": "[email protected]",
"link": "mailto:[email protected]"
}
]
]
},
"noticeshort": "...",
"personal_lt": "Herr Hans Eckert",
"positions": [
{
"scid": "1472",
"pscid": "",
"uid": "43",
"item_name": "Waschmittel",
"item_number": "10085",
"customer_number": "",
"packaging_gift_iid": "0",
"sid": "",
"iid": "10085",
"optional": "_UNIQUE_",
"ean": "3625974522478",
"count": "1",
"oid": "1023",
"reorder": "0",
"price": "1299",
"netto": "1092",
"did": "1021",
"flag_stockupdated": "1",
"custom1": "",
"custom2": "",
"custom3": "",
"price_type": "0",
"description": "",
"currency": "EUR",
"pdid": "0",
"lid": "0",
"vat": "1900",
"data": "",
"serialnumber": "",
"customertext": "",
"price_recommended": "0",
"netto_recommended": "0",
"delivery_type": "0",
"delivery_id": "0",
"salesman_uid": "0",
"base_price_net": "0",
"base_price_gross": "0",
"base_measure_unit": "",
"base_measure_reference": "0",
"base_measure_value": "0",
"sales_group": "1",
"images": {
"main": "/image/alvine/gfx/item/10085/alvine.jpg?time=1522983724"
}
}
],
"deliveries": [
{
"did": "1021",
"date": "2017-10-09 10:27:39",
"picklist_id": "0",
"bill_number": "1021-1023-43",
"oid": "1023",
"fdate": "09.10.2017 10:27:39",
"timestamp_unix_date": "1507544859",
"timestamp_unix_billdate": "1507544859",
"state": "15",
"servicenumber": "",
"servicecompany": "0",
"deliverydate": "2017-10-09 09:27:48",
"fdeliverydate": "09.10.2017 09:27:48",
"receiving_date": "0000-00-00 00:00:00",
"receiving_date_f": "00.00.0000",
"packet_number": "",
"packet_number_retoure": "",
"resubmission": "0000-00-00",
"resubmission_info": "",
"flag_": "0",
"notice": "",
"address_account": {
"aid": "38",
"uid": "43",
"company": "",
"contact": "Herr Hans Eckert",
"address1": "An den Linden 34",
"address2": "",
"city": "Lindenhain",
"state": "",
"zipcode": "85214",
"country": "de",
"preset": "1",
"description": "",
"type": "4",
"system_special": "",
"erpid": "",
"erpname": "",
"erpnumber": "",
"additive1": "",
"additive2": "",
"lt_formofaddress": "Sehr geehrter Herr Eckert",
"formofaddress": "Herr",
"firstname": "Hans",
"name": "Eckert"
},
"address_delivery": {
"aid": "38",
"uid": "43",
"company": "",
"contact": "Herr Hans Eckert",
"address1": "An den Linden 34",
"address2": "",
"city": "Lindenhain",
"state": "",
"zipcode": "85214",
"country": "de",
"preset": "1",
"description": "",
"type": "4",
"system_special": "",
"erpid": "",
"erpname": "",
"erpnumber": "",
"additive1": "",
"additive2": "",
"lt_formofaddress": "Sehr geehrter Herr Eckert",
"formofaddress": "Herr",
"firstname": "Hans",
"name": "Eckert"
}
}
]
}
}
}
Fehlermeldungen
Wenn die Bestellung nicht gefunden wurde wird der Status Code 404 gesendet
{
"sys": {
"error": {
"code": 404,
"message": "404 Not Found"
}
}
}