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"
}
}
}