Queries

Currencies define the monetary units used across the company and their exchange rates.

Available queries

Currency - Returns a single currency based on the id provided

GraphQL

query {
  Currency (id: 100012) {
    label
    exchange_rate
  }
}

Currencies - Returns a list of currencies based on the filter define

GraphQL

query {
  Currencies {
    data {
      label
      exchange_rate
      active
    }
  }
}

---

Available fields

id Int
Unique identifier of the currency

label String
Name of the currency (USD, GBP, ...)

exchange_rate Float
Currency exchange rate against default currency (1 for the default rate)

default Boolean
If true, the rate is the default for the documents created

active Boolean
If true, the rate is active and can be used in documents

---

Filters

You can create filters based on following fields

label
Example:{ "column" : "LABEL", "operator" : "EQ", "value" : "EUR" }

exchange rate
Example: { "column" : "EXCHANGE_RATE", "operator" : "GT", "value" : 1.1 }

default
Example: { "column": "DEFAULT", "operator": "NEQ", "value": true }

active
Example:{ "column": "ACTIVE", "operator": "EQ", "value": true }

---

Sorting

You can sort data based on following fields : id, label, exchange_rate, default, active

GraphQL

query Currencies(
  $where: QueryCurrenciesWhereWhereConditions, 
) {
  Currencies(
    orderBy: [{column: LABEL, order: ASC}]
    where: $where
  ) {
    paginatorInfo {
      total
    }
    data {
      id
      label
      default
      exchange_rate
    }
  }
}

Variables (JSON)

{
  "where": {
    "AND": [
      {
        "column": "ACTIVE",
        "operator": "EQ",
        "value": true
      }
    ]
  }
}

Example of data returned

JSON

{
  "data": {
    "Currencies": {
      "paginatorInfo": {
        "total": 1
      },
      "data": [
        {
          "id": 100002,
          "label": "EUR",
          "default": true,
          "exchange_rate": null
        }
      ]
    }
  }
}