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.
siretStringSIRET number of the company.
e_invoice_addressStringAddress used on electronic invoices.
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.
files[File]Attachments.
variant_priceVariantPriceVariant-specific price for this customer. Requires variant_id argument.

VariantPrice

FieldTypeDescription
idIDUnique identifier.
amountFloatPrice amount.
currencyCurrencyCurrency for this price.
variantVariantLinked product variant.
priceable_typeVariantPriceTypeType of priceable entity (Customer, Supplier, or PriceLevel).
priceable_idIntPriceable entity ID.
created_atDateTimeCreation time.
updated_atDateTimeLast update time.

Example Query:

query GetCustomerVariantPrice($customerId: ID!, $variantId: ID!) {
  Customer(id: $customerId) {
    id
    label
    variant_price(variant_id: $variantId) {
      id
      amount
      currency { code }
    }
  }
}

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

Trashed records:

The trashed argument controls whether soft-deleted records are returned. It is a top-level argument of the Customers query, not a where condition:

ValueEffect
ONLYReturn only deleted records.
WITHReturn both deleted and non-deleted records.
WITHOUTReturn only non-deleted records (default).

EInvoiceDirectoryLines — Looks up official company details for e-invoicing

Looks up the legal name and addressing details registered for a company, so you can fill the electronic invoicing fields (siret, e_invoice_address) from an authoritative source instead of typing them.

Parameters:

ParameterTypeDescription
sirenString!SIREN of the company to look up (9 digits).

Example Query:

query GetEInvoiceDirectoryLines($siren: String!) {
  EInvoiceDirectoryLines(siren: $siren) {
    addressingIdentifier
    addressingSuffix
    name
    routingIdentifier
    siret
  }
}
Return TypeDescription
[EInvoiceDirectoryLine!]!The directory entries matching this SIREN.

EInvoiceDirectoryLine

A single entry returned by the official company directory.

FieldTypeDescription
addressingIdentifierString!Addressing identifier (code and key).
addressingSuffixStringAddressing suffix (cedex, service, etc.).
nameStringRegistered company name.
routingIdentifierStringRouting identifier used for delivery.
siretStringSIRET number of the establishment.

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).

VariantPriceType

ValueDescription
CustomerCustomer entity.
SupplierSupplier entity.
PriceLevelPrice level entity.

TaxType

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