dRofus icon

dRofus

dRofus API: rooms, items, occurrences, room groups, room templates, systems, and RDL PDF reporting

Actions69

Occurrence → Get Many

AI-generated

Summary

Retrieves a list of occurrence records from a dRofus project, with optional OData filtering, sorting, field selection, and pagination. Returns all matches or a capped number.

Inputs

  • Return All — When on, fetches every matching occurrence by following the API's pagination Link header. Default off.
  • Limit — Maximum number of results to return when Return All is off (min 1, default 50).
  • Filter Mode — None (no $filter), Builder (structured conditions), or Raw (hand-written OData $filter).
  • Filter Builder — Shown in Builder mode. Pick a field (loaded from the occurrence fields endpoint), an operator suited to the field's data type, and a value (hidden for isNull/isNotNull). Conditions are combined with AND/OR, and nested sub-groups are supported. Strings are auto-quoted, and 'In' takes comma-separated values.
  • Filter (Raw OData) — Shown in Raw mode. An OData expression such as name eq 'Office' and programmed_area gt 10. Supports contains, notcontains, startswith, endswith, and in.
  • Query Parameters — Optional collection with Order By ($orderby), Select ($select, comma-separated fields), Page Size ($top, default 100, ignored when Return All is on), Skip ($skip, ignored when Return All is on), and Extra Query Parameters as a JSON object for non-OData params.

Output shape

A list of occurrence records, emitted as one n8n item per occurrence, with all default fields or only those named in Select.

The source for the occurrence handler was not shown in detail, so the exact item shape is inferred from the declared behavior. With Return All on, the node follows Link-header pagination, and the requests are subject to the node's rate limiting and retry logic.

Examples

Example 1: Fetch every occurrence whose name contains 'Chair', sorted by name.

Return All on; Filter Mode Raw with contains(name,'Chair'); Query Parameters Order By 'name asc'.

Example 2: Get the first 20 occurrences with only a few fields.

Return All off; Limit 20; Filter Mode None; Select 'name,room_id_id'.

Example 3: Find occurrences matching either of two conditions without writing OData.

Filter Mode Builder; Combinator OR; add two conditions by choosing a field, operator, and value for each.

Links

Discussion