GetAllOrders

Function returns all orders. Deleted orders are not returned.

POST https://rest.crmango.com/api/GetAllOrders

Authorization1 Body data9 Response46 Example request

Authorization

1 Sent in the request headers

Bearer varchar

Auth token (required in Authorization header)

Body data

9 Sent in the request body

date_from timestamp

Date from

date_to timestamp

Date to

date_type varchar

Date type to filter data by.
Options: created_at or updated_at

page integer

Pagination of results (default is 0)

limit integer

Limit of results per page (max 100)

order_id integer

Filter: return only the order with this id

owner_id integer

Filter: owner (user) id of the order
Reference: GetAllUsers

order_type varchar

Filter: order type.
Options: received, issued, pickup, carservice, requirements

rad_code varchar

Filter: order series code (e.g. OP, OV)

Response

46 HTTP 200

Function returns all orders

id integer

Order ID

rad_kod varchar

Order line

rad_porc integer

Order line id

rad_rok integer

Order line year

name varchar

Order name

supplier varchar

Supplier name

supplier_id integer

Supplier id

customer_fa varchar

Customer name

customer_fa_id integer

Customer id

customer_os varchar

Customer person name

customer_os_id integer

Customer person id

customer_dpa datetime

Customer dpa

created_by integer

Created by user

user_id integer

User id

created datetime

Created date

edited datetime

Last edited date

sent datetime

Order sent date

opened datetime

Last opened date

conversion datetime

Conversion date

expire datetime

Expire date

sum_one float

Sum one time

sum_month float

Sum month time

sum_quart float

Sum quarterly time

sum_semi float

Sum semi-annually time

sum_year float

Sum yearly time

profit_one float

Profit one time

profit_month float

Profit month time

profit_quart float

Profit quarterly time

profit_semi float

Profit semi-annually time

profit_year float

Profit yearly time

currency_id integer

Currency id

status_id integer

Order status id

aktivnep_id varchar

Active services id

print_set_id integer

Print set id

lang_id varchar

Language

notif integer

Notificate users

text_after_header varchar

Text after header

visible boolean

Visible

offer_id integer

Offer id

sent_to varchar

Sent to e-mail

text_before_footer varchar

Text before footer

template_id integer

Template id

accepted datetime

Accepted date

note varchar

Note

own_ varchar

Own columns

transport array

Return data from transport order

Example request

curl --request POST \
  --url 'https://rest.crmango.com/api/GetAllOrders' \
  --header 'Authorization: Bearer auth_token' \
  --header 'Content-Type: application/json' \
  --data '{
    "date_from": "timestamp",
    "date_to": "timestamp",
    "date_type": "varchar",
    "page": "integer",
    "limit": "integer",
    "order_id": "integer",
    "owner_id": "integer",
    "order_type": "varchar",
    "rad_code": "varchar"
  }'

$curl = curl_init();

curl_setopt_array($curl, array(
  CURLOPT_URL => 'https://rest.crmango.com/api/GetAllOrders',
  CURLOPT_RETURNTRANSFER => true,
  CURLOPT_ENCODING => '',
  CURLOPT_MAXREDIRS => 10,
  CURLOPT_TIMEOUT => 0,
  CURLOPT_FOLLOWLOCATION => true,
  CURLOPT_HTTP_VERSION => CURL_HTTP_VERSION_1_1,
  CURLOPT_CUSTOMREQUEST => 'POST',
  CURLOPT_POSTFIELDS => '{
    "date_from": "timestamp",
    "date_to": "timestamp",
    "date_type": "varchar",
    "page": "integer",
    "limit": "integer",
    "order_id": "integer",
    "owner_id": "integer",
    "order_type": "varchar",
    "rad_code": "varchar"
  }',
  CURLOPT_HTTPHEADER => array(
    'Authorization: Bearer auth_token',
    'Content-Type: application/json'
  ),
));

$response = curl_exec($curl);

echo $response;

var data = JSON.stringify({
  "date_from": "timestamp",
  "date_to": "timestamp",
  "date_type": "varchar",
  "page": "integer",
  "limit": "integer",
  "order_id": "integer",
  "owner_id": "integer",
  "order_type": "varchar",
  "rad_code": "varchar"
});

var xhr = new XMLHttpRequest();
xhr.withCredentials = true;

xhr.addEventListener("readystatechange", function () {
  if (this.readyState === 4) {
    console.log(this.responseText);
  }
});

xhr.open("POST", "https://rest.crmango.com/api/GetAllOrders");
xhr.setRequestHeader("Authorization", "Bearer auth_token");
xhr.setRequestHeader("Content-Type", "application/json");

xhr.send(data);

import requests
import json

url = "https://rest.crmango.com/api/GetAllOrders"

payload = json.dumps({
  "date_from": "timestamp",
  "date_to": "timestamp",
  "date_type": "varchar",
  "page": "integer",
  "limit": "integer",
  "order_id": "integer",
  "owner_id": "integer",
  "order_type": "varchar",
  "rad_code": "varchar"
})
headers = {
  'Authorization': 'Bearer auth_token',
  'Content-Type': 'application/json'
}

response = requests.request("POST", url, headers=headers, data=payload)

print(response.text)

{
    "code": 200,
    "response": [
        {
            "id": 72,
            "rad_kod": "OV",
            "rad_porc": 38,
            "rad_rok": 2022,
            "name": "OPEW-222-2022",
            "supplier": "crmango s.r.o.",
            "supplier_id": 2492,
            "customer_fa": "CRM Mango, a.s.",
            "customer_fa_id": 123,
            "customer_os": "",
            "customer_os_id": -1,
            "customer_dpa": 0,
            "created_by": 7,
            "user_id": 7,
            "created": "2021-12-04 14:38:00",
            "edited": "2021-12-04 14:38:00",
            "sent": 0,
            "opened": 0,
            "conversion": 0,
            "expire": "2021-12-04 14:38:00",
            "sum_one": 0,
            "sum_month": 0,
            "sum_quart": 0,
            "sum_semi": 0,
            "sum_year": 0,
            "profit_one": 0,
            "profit_month": 0,
            "profit_quart": 0,
            "profit_semi": 0,
            "profit_year": 0,
            "currency_id": 202,
            "status_id": 1,
            "aktivnep_id": 0,
            "print_set_id": 1,
            "lang_id": "sk",
            "notif": 0,
            "text_after_header": "",
            "visible": 1,
            "offer_id": 0,
            "sent_to": "",
            "text_before_footer": "",
            "template_id": null,
            "accepted": null,
            "note": null,
            "own_Typ smlouvy": "",
            "own_Vyplaceno": 0,
            "own_Skupina": ""
        },
        {
            "id": 72,
            "rad_kod": "OV",
            "rad_porc": 38,
            "rad_rok": 2022,
            "name": "OPEW-222-2022",
            "supplier": "crmango s.r.o.",
            "supplier_id": 2492,
            "customer_fa": "CRM Mango, a.s.",
            "customer_fa_id": 123,
            "customer_os": "",
            "customer_os_id": -1,
            "customer_dpa": 0,
            "created_by": 7,
            "user_id": 7,
            "created": "2021-12-04 14:38:00",
            "edited": "2021-12-04 14:38:00",
            "sent": 0,
            "opened": 0,
            "conversion": 0,
            "expire": "2021-12-04 14:38:00",
            "sum_one": 0,
            "sum_month": 0,
            "sum_quart": 0,
            "sum_semi": 0,
            "sum_year": 0,
            "profit_one": 0,
            "profit_month": 0,
            "profit_quart": 0,
            "profit_semi": 0,
            "profit_year": 0,
            "currency_id": 202,
            "status_id": 1,
            "aktivnep_id": 0,
            "print_set_id": 1,
            "lang_id": "sk",
            "notif": 0,
            "text_after_header": "",
            "visible": 1,
            "offer_id": 0,
            "sent_to": "",
            "text_before_footer": "",
            "template_id": null,
            "accepted": null,
            "note": null,
            "own_Typ smlouvy": "",
            "own_Vyplaceno": 0,
            "own_Skupina": "",
            "transport": {
                "transporter_id": 2492,
                "vehicle_id": 126,
                "trailer_id": null,
                "driver_id": null,
                "plan_km": 376.97,
                "real_km": 0,
                "map_points": {
                    "1": {
                        "transport_load_type_1": "load",
                        "transport_point_lat_1": "48.592933654785",
                        "transport_point_long_1": "17.813209533691",
                        "transport_point_note_1": "",
                        "transport_point_address_1": "Dopravna 7, 921 01 Piestany, Slovensko",
                        "transport_point_datetime_1": "2023-10-19T11:52",
                        "transport_point_note_full_1": "Tu naloz gumy",
                        "transport_point_product_mj_1": "0",
                        "transport_point_location_by_1": "cmr",
                        "transport_point_product_ldm_1": "",
                        "transport_point_product_name_1": "",
                        "transport_point_product_type_1": "1",
                        "transport_point_product_count_1": "",
                        "transport_point_product_wight_1": "2000",
                        "transport_point_address_holder_1": "",
                        "transport_point_contact_mobile_1": "",
                        "transport_point_contact_person_1": "",
                        "transport_point_product_volume_1": ""
                    },
                    "2": {
                        "transport_load_type_2": "unload",
                        "transport_point_lat_2": "49.294681549072",
                        "transport_point_long_2": "21.276609420776",
                        "transport_point_note_2": "",
                        "transport_point_address_2": "Bardejov, Slovensko",
                        "transport_point_datetime_2": "2023-10-21T11:52",
                        "transport_point_note_full_2": "test23323",
                        "transport_point_product_mj_2": "0",
                        "transport_point_location_by_2": "cmr",
                        "transport_point_product_ldm_2": "",
                        "transport_point_product_name_2": "",
                        "transport_point_product_type_2": "1",
                        "transport_point_product_count_2": "",
                        "transport_point_product_wight_2": "2000",
                        "transport_point_address_holder_2": "",
                        "transport_point_contact_mobile_2": "",
                        "transport_point_contact_person_2": "",
                        "transport_point_product_volume_2": ""
                    }
                },
                "created_at": "2023-10-23 11:52:50",
                "telematic_route_id": null,
                "allow_online_telematics": 0,
                "additional_information": "{'custom_phm_price': 30}"
            }
        }
    ]
}

{
    "code": "int",
    "message": "string"
}