GetAllInvoices

Function returns all invoices

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

Authorization1 Body data7 Response68 Example request

Authorization

1 Sent in the request headers

Bearer varchar

Auth token

Body data

7 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 or taxable_date

page integer

Pagination of results (default is 0)

limit integer

Limit of results per page (Max si 10000)

invoice_type varchar

Invoice type to filter data by.
Options: issued or received.

subtype varchar

Invoice subtype to filter data by.
Options: regular or proforma or credit_note.

Response

68 HTTP 200

Function returns all invoices

id integer

Invoice ID

inv_type varchar

Type of invoice (e.g. issued, received)

subtype varchar

Subtype of invoice (e.g. credit_note, proforma)

name varchar

Invoice title

created_by integer

ID of user who created the invoice

user_id integer

Assigned user ID

supplier_name varchar

Name of supplier

supplier_id integer

Supplier ID

purchaser_name varchar

Name of purchaser

purchaser_id integer

Purchaser ID

currency_id integer

Currency ID

created_at datetime

Date of creation

updated_at datetime

Date of last update

invoice_due date

Invoice due date

taxable_date date

Taxable supply date

status_id integer

Status of invoice

var_symbol varchar

Variable symbol

aktivnep_id integer

Related product ID (if any) <br> Reference: <a href="https://rest.crmango.com/documentation/GetAllLists/detail" target="_blank"> GetAllLists </a>

rad_code varchar

Invoice number prefix

rad_id integer

Invoice number series ID

rad_year integer

Year of invoice number series

sum float

Total invoice amount (incl. VAT)

note varchar

Invoice note / description

paid float

Amount paid

url varchar

External PDF link (if exists)

is_id integer

External system ID (e.g. superfaktura)

is_deleted boolean

Whether invoice is deleted (0 = no, 1 = yes)

multiple_orders boolean

Is linked to multiple orders

accounting_center varchar

Accounting center code (if any)

deleted_in_is boolean

Deleted in external system (0 = no, 1 = yes)

exchange_rate float

Exchange rate to base currency

fully_paid_date date

Date of full payment

bank_data json

Bank details used for the invoice

lang varchar

Language of the invoice

visual_id integer

Template/visual version ID

note_after varchar

Footer note or post-message

notif boolean

Whether notification is active

sent_to varchar

Email the invoice was sent to

sent_at datetime

Date/time when invoice was sent

opened_at datetime

Date/time when invoice was opened

is_tax_document boolean

Is this a tax document

custom_code_format varchar

Custom format of invoice number (e.g. YYYYNNN)

transporter_id integer

Transporter ID (if applicable)

vehicle_id integer

Vehicle ID (if applicable)

trailer_id integer

Trailer ID (if applicable)

driver1_id integer

Driver 1 ID (if applicable)

driver2_id integer

Driver 2 ID (if applicable)

proforma_invoice_link varchar

Linked proforma invoice (if any)

creditnote_invoice_link json

Linked credit notes

purchaser_is_company boolean

Is purchaser a company (1 = yes)

purchaser_company_name varchar

Company name of purchaser

purchaser_company_id integer

Company ID (IČO)

purchaser_company_tax varchar

Company VAT number

purchaser_individual_name varchar

First name (if private person)

purchaser_individual_surname varchar

Last name (if private person)

purchaser_individual_id integer

Person ID

purchaser_company_address varchar

Billing address

purchaser_company_city varchar

Billing city

purchaser_company_postal varchar

Postal code

purchaser_company_country_id integer

Country ID

purchaser_company_user integer

User responsible for this company

purchaser_company_invoice_days integer

Payment terms (days)

purchaser_company_invoice_email varchar

Email to send invoice to

purchaser_company_bank_data json

Additional bank data (if any)

invoice_code varchar

Invoice number

purchaser_company_country_ISO2 varchar

Country ISO code (e.g. CZ, SK)

currency_code varchar

Currency (e.g. EUR, CZK)

products json

Array of product items on invoice

Example request

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

$curl = curl_init();

curl_setopt_array($curl, array(
  CURLOPT_URL => 'https://rest.crmango.com/api/GetAllInvoices',
  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",
    "invoice_type": "varchar",
    "subtype": "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",
  "invoice_type": "varchar",
  "subtype": "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/GetAllInvoices");
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/GetAllInvoices"

payload = json.dumps({
  "date_from": "timestamp",
  "date_to": "timestamp",
  "date_type": "varchar",
  "page": "integer",
  "limit": "integer",
  "invoice_type": "varchar",
  "subtype": "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": 1356,
            "inv_type": "issued",
            "subtype": "credit_note",
            "name": "My invoice - fictitiouslogix.",
            "created_by": 5,
            "user_id": 17,
            "supplier_name": "crmango systems s.r.o.",
            "supplier_id": 44,
            "purchaser_name": "FICTITIOUS LOGIX, s.r.o.",
            "purchaser_id": 433,
            "currency_id": 202,
            "created_at": "2025-07-31 11:14:10",
            "updated_at": "2025-07-31 12:19:33",
            "invoice_due": "2025-08-14",
            "taxable_date": "2025-06-30",
            "status_id": 0,
            "var_symbol": "CNX2025",
            "aktivnep_id": 0,
            "rad_code": "CNX",
            "rad_id": 1,
            "rad_year": 2025,
            "sum": -180,
            "profit": 0,
            "note": "We are issuing you a credit note:",
            "paid": 0,
            "url": "",
            "is_id": "",
            "is_deleted": 0,
            "multiple_orders": "",
            "accounting_center": "",
            "deleted_in_is": 0,
            "exchange_rate": 1,
            "fully_paid_date": "",
            "bank_data": [
                {
                    "bank_iban": "CZ9808000000000123456789",
                    "bank_note": "",
                    "swift_bic": "FIKTCZPP",
                    "bank_account": "123456789\/0800",
                    "bank_connection": "Bank of Fiction EUR"
                }
            ],
            "lang": "cz",
            "visual_id": 11,
            "note_after": "incorrect billing",
            "notif": 1,
            "sent_to": "",
            "sent_at": "",
            "opened_at": "",
            "is_tax_document": 1,
            "custom_code_format": "",
            "transporter_id": "",
            "vehicle_id": "",
            "trailer_id": "",
            "driver1_id": "",
            "driver2_id": "",
            "proforma_invoice_link": "",
            "creditnote_invoice_link": [
                "1156"
            ],
            "purchaser_is_company": 1,
            "purchaser_company_name": "FICTITIOUS LOGIX, s.r.o.",
            "purchaser_company_id": 76543210,
            "purchaser_company_tax": "CZ76543210",
            "purchaser_individual_name": "",
            "purchaser_individual_surname": "",
            "purchaser_individual_id": "",
            "purchaser_company_address": "Imaginary Lane 42",
            "purchaser_company_city": "Liberec",
            "purchaser_company_postal": "46001",
            "purchaser_company_country_id": 56,
            "purchaser_company_user": 17,
            "purchaser_company_invoice_days": 14,
            "purchaser_company_invoice_email": "billing@fictitiouslogix.com",
            "purchaser_company_bank_data": [],
            "invoice_code": "CNX-1-2025",
            "purchaser_company_country_ISO2": "CZ",
            "currency_code": "EUR",
            "products": [
                {
                    "product_id": 0,
                    "product_code": "",
                    "name": "Basic user license",
                    "quantity": 3,
                    "measure_unit": "x",
                    "unit_price": 0,
                    "discount": 0,
                    "total_price": 0,
                    "vat": 21
                },
                {
                    "product_id": 0,
                    "product_code": "",
                    "name": "Basic user license",
                    "quantity": 2,
                    "measure_unit": "x",
                    "unit_price": -7.25,
                    "discount": 0,
                    "total_price": -17.55,
                    "vat": 21
                },
                {
                    "product_id": 0,
                    "product_code": "",
                    "name": "Activated extensions",
                    "quantity": 1,
                    "measure_unit": "x",
                    "unit_price": -133,
                    "discount": 0,
                    "total_price": -162.45,
                    "vat": 21
                }
            ]
        },
        {
            "id": 1204,
            "inv_type": "issued",
            "subtype": "",
            "name": "My invoice - digitalpowercz.",
            "created_by": 21,
            "user_id": 1,
            "supplier_name": "crmango systems s.r.o.",
            "supplier_id": 44,
            "purchaser_name": "Digital Power Solutions, a.s.",
            "purchaser_id": 3,
            "currency_id": 202,
            "created_at": "2025-07-01 00:00:00",
            "updated_at": "2025-07-31 18:01:08",
            "invoice_due": "2025-07-31",
            "taxable_date": "2025-06-30",
            "status_id": 1,
            "var_symbol": "2025432",
            "aktivnep_id": 0,
            "rad_code": "INV",
            "rad_id": 436,
            "rad_year": 2025,
            "sum": 2210.5,
            "profit": 0,
            "note": "We are invoicing you for the monthly usage of the crmango system based on your registration at https:\/\/crmango.com. Billing period: 06\/2025",
            "paid": 2210.5,
            "url": "",
            "is_id": 9876543,
            "is_deleted": 0,
            "multiple_orders": "",
            "accounting_center": "",
            "deleted_in_is": 0,
            "exchange_rate": 24.75,
            "fully_paid_date": "2025-07-31",
            "bank_data": [
                {
                    "bank_iban": "CZ9808000000000123456789",
                    "bank_note": "",
                    "swift_bic": "FIKTCZPP",
                    "bank_account": "123456789\/0800",
                    "bank_connection": "Bank of Fiction EUR"
                }
            ],
            "lang": "",
            "visual_id": 0,
            "note_after": "",
            "notif": 0,
            "sent_to": "",
            "sent_at": "",
            "opened_at": "",
            "is_tax_document": 1,
            "custom_code_format": "YYYYNNN",
            "transporter_id": "",
            "vehicle_id": "",
            "trailer_id": "",
            "driver1_id": "",
            "driver2_id": "",
            "proforma_invoice_link": "",
            "creditnote_invoice_link": [],
            "purchaser_is_company": 1,
            "purchaser_company_name": "Digital Power Solutions, a.s.",
            "purchaser_company_id": 11223344,
            "purchaser_company_tax": "CZ11223344",
            "purchaser_individual_name": "",
            "purchaser_individual_surname": "",
            "purchaser_individual_id": "",
            "purchaser_company_address": "Power Drive 99",
            "purchaser_company_city": "Prague",
            "purchaser_company_postal": "10000",
            "purchaser_company_country_id": 56,
            "purchaser_company_user": 1,
            "purchaser_company_invoice_days": 30,
            "purchaser_company_invoice_email": "billing@digitalpower.cz",
            "purchaser_company_bank_data": [],
            "purchaser_company_country_ISO2": "CZ",
            "currency_code": "EUR",
            "products": [
                {
                    "product_id": 0,
                    "product_code": "",
                    "name": "Mango monthly license fee",
                    "quantity": 1,
                    "measure_unit": "x",
                    "unit_price": 1826.45,
                    "discount": 0,
                    "total_price": 2210.5,
                    "vat": 21
                }
            ]
        }
    ]
}

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