list_sync_orders
GET /list_sync_orders
To get a list of orders that need to be synchronized. The result is ordered by the date that the change occurred.
/list_sync_orders?token=XXXXX&records=500
| field |
description |
| token |
Credentials provided by Powersoft that allow access to the API |
| records |
The number of records to retrieve. The maximum is 500 per request |
Returns
{
"api_response": {
"response_code": "1",
"response_msg": "OK",
"response_id": ""
},
"list_sync_orders": [
{
"change_id_365": 24384,
"change_date_time_utc0": "2016-09-01 13:45:29",
"change_type_code": "CLOSE",
"shopping_cart_code": "CART1088",
"order_code_365": "OI00100096",
"order_date_local": "2016-02-25 10:00:00",
"order_date_utc0": "2016-09-01 13:45:29",
"order_date_deliverby_utc0": "2016-03-25 08:00:00",
"customer_code_365": "00100001",
"customer_email": "jdoe@test.com",
"customer_name": "John Doe",
"total_sub": 42.02,
"total_discount": 2.52,
"total_vat": 7.5,
"total_grand": 47,
"comments": "special instructions",
"delivery_address_line_1": "39 Larnakos Ave",
"delivery_address_line_2": "",
"delivery_address_line_3": "Pallouriotissa",
"delivery_postal_code": "1641",
"delivery_town": "Nicosia",
"delivery_country_code_iso2": "CY",
"delivery_country_name": "CYPRUS",
"payment_term_code_365": "",
"delivery_term_code_365": "",
"order_status_code_365": "COMPLETED",
"order_status_name": "COMPLETED"
},
{
"change_id_365": 24385,
"change_date_time_utc0": "2016-09-01 15:30:10",
"change_type_code": "RETUR",
"shopping_cart_code": "CART185",
"order_code_365": "OI00100085",
"order_date_local": "2014-12-17 10:00:00",
"order_date_utc0": "2014-12-17 08:00:00",
"order_date_deliverby_utc0": "2014-12-24 08:00:00",
"customer_code_365": "00100001",
"customer_email": "jdoe@test.com",
"customer_name": "John Doe",
"total_sub": 0,
"total_discount": 0,
"total_vat": 0,
"total_grand": 0,
"comments": "special instructions",
"delivery_address_line_1": "39 Larnakos Ave",
"delivery_address_line_2": "",
"delivery_address_line_3": "Pallouriotissa",
"delivery_postal_code": "1641",
"delivery_town": "Nicosia",
"delivery_country_code_iso2": "CY",
"delivery_country_name": "CYPRUS",
"payment_term_code_365": "",
"delivery_term_code_365": "",
"order_status_code_365": "CANCELLED",
"order_status_name": "CANCELLED"
},
{
"change_id_365": 24386,
"change_date_time_utc0": "2016-09-01 15:33:23",
"change_type_code": "CLOSE",
"shopping_cart_code": "CART123",
"order_code_365": "OI00100009",
"order_date_local": "2014-12-17 10:00:00",
"order_date_utc0": "2014-12-17 08:00:00",
"order_date_deliverby_utc0": "2014-12-24",
"customer_code_365": "00100001",
"customer_email": "jdoe@test.com",
"customer_name": "John Doe",
"total_sub": 0,
"total_discount": 0,
"total_vat": 0,
"total_grand": 0,
"comments": "special instructions",
"delivery_address_line_1": "10 Larnakos Ave",
"delivery_address_line_2": "",
"delivery_address_line_3": "Pallouriotissa",
"delivery_postal_code": "1641",
"delivery_town": "Nicosia",
"delivery_country_code_iso2": "CY",
"delivery_country_name": "CYPRUS",
"payment_term_code_365": "",
"delivery_term_code_365": "",
"order_status_code_365": "PARTIALCOMPLETED",
"order_status_name": "PARTIAL COMPLETED"
},
{
"change_id_365": 24387,
"change_date_time_utc0": "2016-09-02 05:37:30",
"change_type_code": "CLOSE",
"shopping_cart_code": "CART123",
"order_code_365": "OI00100009",
"order_date_local": "2014-12-17 10:00:00",
"order_date_utc0": "2014-12-17 08:00:00",
"order_date_deliverby_utc0": "2014-12-24",
"customer_code_365": "00100001",
"customer_email": "jdoe@test.com",
"customer_name": "John Doe",
"total_sub": 0,
"total_discount": 0,
"total_vat": 0,
"total_grand": 0,
"comments": "special instructions",
"delivery_address_line_1": "10 Larnakos Ave",
"delivery_address_line_2": "",
"delivery_address_line_3": "Pallouriotissa",
"delivery_postal_code": "1641",
"delivery_town": "Nicosia",
"delivery_country_code_iso2": "CY",
"delivery_country_name": "CYPRUS",
"payment_term_code_365": "",
"delivery_term_code_365": "",
"order_status_code_365": "PARTIALCOMPLETED",
"order_status_name": "PARTIAL COMPLETED"
},
{
"change_id_365": 24388,
"change_date_time_utc0": "2016-09-02 05:37:38",
"change_type_code": "RETUR",
"shopping_cart_code": "CART123",
"order_code_365": "OI00100009",
"order_date_local": "2014-12-17 10:00:00",
"order_date_utc0": "2014-12-17 08:00:00",
"order_date_deliverby_utc0": "2014-12-24",
"customer_code_365": "00100001",
"customer_email": "jdoe@test.com",
"customer_name": "John Doe",
"total_sub": 0,
"total_discount": 0,
"total_vat": 0,
"total_grand": 0,
"comments": "special instructions",
"delivery_address_line_1": "10 Larnakos Ave",
"delivery_address_line_2": "",
"delivery_address_line_3": "Pallouriotissa",
"delivery_postal_code": "1641",
"delivery_town": "Nicosia",
"delivery_country_code_iso2": "CY",
"delivery_country_name": "CYPRUS",
"payment_term_code_365": "",
"delivery_term_code_365": "",
"order_status_code_365": "PARTIALCOMPLETED",
"order_status_name": "PARTIAL COMPLETED"
},
{
"change_id_365": 24389,
"change_date_time_utc0": "2016-09-02 05:44:20",
"change_type_code": "CLOSE",
"shopping_cart_code": "CART155",
"order_code_365": "OI00100057",
"order_date_local": "2014-12-17 10:00:00",
"order_date_utc0": "2014-12-17 08:00:00",
"order_date_deliverby_utc0": "2014-12-24 08:00:00",
"customer_code_365": "00100001",
"customer_email": "jdoe@test.com",
"customer_name": "John Doe",
"total_sub": 0,
"total_discount": 0,
"total_vat": 0,
"total_grand": 0,
"comments": "special instructions",
"delivery_address_line_1": "39 Larnakos Ave",
"delivery_address_line_2": "",
"delivery_address_line_3": "Pallouriotissa",
"delivery_postal_code": "1641",
"delivery_town": "Nicosia",
"delivery_country_code_iso2": "CY",
"delivery_country_name": "CYPRUS",
"payment_term_code_365": "",
"delivery_term_code_365": "",
"order_status_code_365": "PARTIALCOMPLETED",
"order_status_name": "PARTIAL COMPLETED"
},
{
"change_id_365": 24390,
"change_date_time_utc0": "2016-09-02 05:45:09",
"change_type_code": "RETUR",
"shopping_cart_code": "CART155",
"order_code_365": "OI00100057",
"order_date_local": "2014-12-17 10:00:00",
"order_date_utc0": "2014-12-17 08:00:00",
"order_date_deliverby_utc0": "2014-12-24 08:00:00",
"customer_code_365": "00100001",
"customer_email": "jdoe@test.com",
"customer_name": "John Doe",
"total_sub": 0,
"total_discount": 0,
"total_vat": 0,
"total_grand": 0,
"comments": "special instructions",
"delivery_address_line_1": "39 Larnakos Ave",
"delivery_address_line_2": "",
"delivery_address_line_3": "Pallouriotissa",
"delivery_postal_code": "1641",
"delivery_town": "Nicosia",
"delivery_country_code_iso2": "CY",
"delivery_country_name": "CYPRUS",
"payment_term_code_365": "",
"delivery_term_code_365": "",
"order_status_code_365": "PARTIALCOMPLETED",
"order_status_name": "PARTIAL COMPLETED"
},
{
"change_id_365": 24392,
"change_date_time_utc0": "2016-09-02 05:55:07",
"change_type_code": "CLOSE",
"shopping_cart_code": "CART201",
"order_code_365": "OI00100094",
"order_date_local": "2016-02-25 10:00:00",
"order_date_utc0": "2016-09-02 05:55:07",
"order_date_deliverby_utc0": "2016-03-25 08:00:00",
"customer_code_365": "00100001",
"customer_email": "jdoe@test.com",
"customer_name": "John Doe",
"total_sub": 42.02,
"total_discount": 2.52,
"total_vat": 7.5,
"total_grand": 47,
"comments": "special instructions",
"delivery_address_line_1": "39 Larnakos Ave",
"delivery_address_line_2": "",
"delivery_address_line_3": "Pallouriotissa",
"delivery_postal_code": "1641",
"delivery_town": "Nicosia",
"delivery_country_code_iso2": "CY",
"delivery_country_name": "CYPRUS",
"payment_term_code_365": "",
"delivery_term_code_365": "",
"order_status_code_365": "COMPLETED",
"order_status_name": "COMPLETED"
}
]
}