Organizations and Reference Data

3 min

These lists are the base of an integration. You use their keys to filter the documents, and their codes to map Expressoft to your ERP. They are not paged.

Query

query GetReferenceData {
  miscellaneous {
    organizations {
      key
      name
      fiscalAttribute
      fiscalCode
      registrationCode
    }
    locations {
      key
      id
      name
      externalCode
    }
    payments {
      key
      name
      externalCode
      paymentType
    }
    warehouses {
      key
      id
      name
      externalCode
      isActive
      warehouseType
      location { key name }
    }
    currencies {
      key
      name
      rate
    }
    consumptionTypes {
      id
      name
    }
  }
}

cURL

curl --location 'https://sandbox.expressoft.eu/connect/api/interopgql' \
--header 'Content-Type: application/json' \
--header 'Authorization: Bearer <token>' \
--data '{"query": "query GetReferenceData { miscellaneous { organizations { key name fiscalAttribute fiscalCode registrationCode } locations { key id name externalCode } payments { key name externalCode paymentType } warehouses { key id name externalCode isActive warehouseType location { key name } } currencies { key name rate } consumptionTypes { id name } } }"}'

Response

{
  "data": {
    "miscellaneous": {
      "organizations": [
        {
          "key": "00000000-0000-0000-0000-000000000001",
          "name": "Example Organization SRL",
          "fiscalAttribute": "RO",
          "fiscalCode": "12345678",
          "registrationCode": "J40/1234/2020"
        }
      ],
      "locations": [
        {
          "key": "00000000-0000-0000-0000-000000000005",
          "id": 1,
          "name": "Downtown Store",
          "externalCode": "LOC1"
        }
      ],
      "payments": [
        {
          "key": "00000000-0000-0000-0000-000000000006",
          "name": "Cash",
          "externalCode": "CASH",
          "paymentType": "Cash"
        }
      ],
      "warehouses": [
        {
          "key": "00000000-0000-0000-0000-000000000004",
          "id": 1,
          "name": "Main warehouse",
          "externalCode": "WH1",
          "isActive": "true",
          "warehouseType": "Quantity",
          "location": {
            "key": "00000000-0000-0000-0000-000000000005",
            "name": "Downtown Store"
          }
        }
      ],
      "currencies": [
        {
          "key": 1,
          "name": "RON",
          "rate": 1.0
        }
      ],
      "consumptionTypes": [
        {
          "id": 1,
          "name": "Internal consumption"
        }
      ]
    }
  }
}

Field	Meaning
organizations	Your entities registered in Expressoft. A document belongs to one organization.
locations	The places where you work: stores, restaurants. externalCode is the code you can map to your ERP.
payments	The payment methods. paymentType is Cash, Card, Ticket, Virament, Mobile, PMS, ContactDebt, AccountDebt, ElectronicTicket, Cashless.
warehouses	The warehouses (gestiuni). warehouseType is Unknown, Quantity, Value, Services.
currencies	The currencies and their exchange rate.
consumptionTypes	The types of consumption used by consumption notes.

💡 TIP Read these lists once, keep them in your ERP, and refresh them on a schedule. They change rarely.

ℹ️ INFO The key of a currency is a number, not a GUID.