Customers Queries

Access customer records, contact details, payment history, and associated addresses.

Customer — Returns a single customer by id

query GetCustomer($id: ID!) {
  Customer(id: $id) {
    id
    label
    email
    active
    customer_number
    customer_type
    currency { id label }
    default_billing_address { id city country }
    default_shipping_address { id city country }
  }
}

Customers — Returns a paginated list of customers with sorting and filters

query Customers(
  $where: QueryCustomersWhereWhereConditions,
  $orderBy: [QueryCustomersOrderByOrderByClause!],
  $search: String,
  $first: Int,
  $page: Int,
  $trashed: Trashed
) {
  Customers(
    where: $where,
    orderBy: $orderBy,
    search: $search,
    first: $first,
    page: $page,
    trashed: $trashed
  ) {
    paginatorInfo {
      total
      currentPage
    }
    data {
      id
      label
      email
      active
      customer_type
    }
  }
}

Available fields

FieldTypeDescription
idIntUnique identifier.
labelStringCustomer name or company name.
first_nameStringPrimary contact first name.
last_nameStringPrimary contact last name.
emailStringPrimary email address.
activeBooleanWhether the customer is active.
customer_numberStringInternal reference number.
customer_typeCustomerTypeIndividual or Company.
websiteStringWebsite URL.
phoneStringPrimary phone number.
statusStringCurrent lifecycle status.
notesStringPublic notes for documents.
private_messageStringInternal private notes.
currencyCurrencyPreferred billing currency.
locationLocationPrimary stock location.
price_levelPriceLevelAssigned price level.
account_representativeAccountRepresentativeAssigned sales rep.
tax_numberStringVAT or Tax ID.
company_registration_numberStringCommercial registration ID.
discountFloatDefault discount rate.
minimum_order_amountFloatMinimum purchase amount.
term_of_payment_daysIntNumber of days for payment.
term_of_payment_typeTermModelCalculation method for due date.
credit_limitFloatMaximum allowed credit.
current_balanceFloatCurrent unpaid amount.
last_shipping_costFloatMost recent shipping cost recorded.
languageStringPreferred communication language.
tax_typeTaxTypeExclusive or Inclusive tax application.
tax_codes[TaxCode]Applied tax configurations.
customer_tags[CustomerTag]Labels for segmentation.
addresses[Address]List of all linked addresses.
default_billing_addressAddressDefault for invoices.
default_shipping_addressAddressDefault for deliveries.
employees[Employee]List of subsidiary contacts.
integrations[Integration]Linked external platforms.
created_atDateTimeCreation time.
updated_atDateTimeLast update time.
custom_fields[EntityCustomField]Custom fields for this entity.

Filters

The following fields can be used in the where parameter:

id, label, first_name, last_name, email, active, company_id, company_registration_number, created_at, updated_at, country, city.

Example Filters:

FieldExample
active{ "column": "ACTIVE", "operator": "EQ", "value": true }
email{ "column": "EMAIL", "operator": "LIKE", "value": "%@example.com" }
country{ "column": "COUNTRY", "operator": "EQ", "value": "FR" }
created_at{ "column": "CREATED_AT", "operator": "GTE", "value": "2025-01-01" }
trashedFilter by trashed status. Accepts ALL, TRASHED, or NOT_TRASHED.

PartnerCompany — Returns a single partner company by id

A partner company is a company that is linked to your account through a partnership.

query GetPartnerCompany($id: ID!) {
  PartnerCompany(id: $id) {
    id
    label
    email
    phone
    website
    company_registration_number
    vat_number
    active
  }
}
FieldTypeDescription
idID!Unique identifier.
labelStringCompany name.
emailStringEmail address.
phoneStringPhone number.
websiteStringWebsite URL.
company_numberStringCompany registration number.
vat_numberStringVAT number.
activeBooleanWhether the partner company is active.

Sorting

You can sort results using the orderBy parameter:

  • id
  • label
  • first_name
  • last_name
  • email
  • active
  • created_at
  • updated_at

Enums

CustomerType

ValueDescription
companyCorporate entity.
individualPrivate person.

TermModel

ValueDescription
netDue after X days from document date.
eomDue at End of Month after X days.
eom_firstDue at End of Month (first day focus).

TaxType

ValueDescription
exclusiveTaxes added on top of subtotal.
inclusivePrices already include taxes.