> Markdown versions of all pages of this connector library are available by appending `.md` to the page URL. For the full index of connectors, see [llms.txt](https://connectors.appmixer.com/llms.txt).

# Find Records

- Component: `appmixer.superoffice.core.FindRecords`
- Kind: Action
- Version: 1.0.0
- Visibility: Public
- Connector: [appmixer.superoffice 1.2.0](https://connectors.appmixer.com/connector/appmixer.superoffice/1.2.0.md)
- Component page: <https://connectors.appmixer.com/connector/appmixer.superoffice/1.2.0/component/appmixer.superoffice.core.FindRecords>

Find companies, persons, sales, projects, follow-ups or tickets, newest first, each read in full with its owner and custom fields. Returns at most 100 records.

## Input ports

### Port `in`

| Field | Type | Description |
| --- | --- | --- |
| Object (`object`) | select | The kind of records to find. |
| Company ID (`companyId`) | text | Records of this company. Not available for projects. |
| Person ID (`personId`) | text | Records of this person. Not available for companies and projects. |
| Owner (`ownerId`) | text | Only records owned by this user (our contact, ticket owner). Pick a user, or type the associate ID. Not available for persons. |
| Additional Filter (`filter`) | textarea | Optional SuperOffice OData filter on the archive columns of the object, added with "and". For example follow-ups dated before a day: `date before '2026-11-19'`; tickets of a status: `ticketStatusId eq 2`. Dates in the filter are in the local time of the SuperOffice tenant. At most the 100 newest matching records are returned: narrow the filter to reach older ones. See the archive provider reference in the SuperOffice documentation. |
| Output Type (`outputType`) | select | Choose whether you want to receive the result set as one complete list, or first item only or one item at a time or stream the items to a file. |
| Time Zone (`timeZone`) | text | Optional. The time zone of your SuperOffice tenant, for example Europe/Oslo. SuperOffice keeps date-times in the local time of the tenant; the time zone is detected automatically (reliably for European tenants) and this setting overrides it. Date-times the component returns are always in UTC. |

## Output ports

### Port `out`

Variables are loaded dynamically from `/component/appmixer/superoffice/core/FindRecords?outPort=out&ignoreAuth=true`.

### Port `notFound`

_No fields defined for this port._

## Full metadata (component.json)

```json
{
  "name": "appmixer.superoffice.core.FindRecords",
  "label": "Find Records",
  "description": "Find companies, persons, sales, projects, follow-ups or tickets, newest first, each read in full with its owner and custom fields. Returns at most 100 records.",
  "author": "Appmixer <info@appmixer.com>",
  "version": "1.0.0",
  "auth": {
    "service": "appmixer:superoffice"
  },
  "quota": {
    "manager": "appmixer:superoffice",
    "resources": "requests",
    "scope": {
      "userId": "{{userId}}"
    }
  },
  "inPorts": [
    {
      "name": "in",
      "schema": {
        "type": "object",
        "properties": {
          "object": {
            "type": "string",
            "enum": [
              "company",
              "person",
              "sale",
              "project",
              "appointment",
              "ticket"
            ]
          },
          "companyId": {
            "type": "string"
          },
          "personId": {
            "type": "string"
          },
          "ownerId": {
            "type": "string"
          },
          "filter": {
            "type": "string"
          },
          "outputType": {
            "type": "string",
            "enum": [
              "first",
              "array",
              "object",
              "file"
            ]
          },
          "timeZone": {
            "type": "string"
          }
        },
        "required": [
          "object"
        ]
      },
      "inspector": {
        "inputs": {
          "object": {
            "type": "select",
            "index": 1,
            "label": "Object",
            "tooltip": "The kind of records to find.",
            "options": [
              {
                "label": "Company",
                "value": "company"
              },
              {
                "label": "Person",
                "value": "person"
              },
              {
                "label": "Sale",
                "value": "sale"
              },
              {
                "label": "Project",
                "value": "project"
              },
              {
                "label": "Follow-up (appointment or task)",
                "value": "appointment"
              },
              {
                "label": "Ticket (request)",
                "value": "ticket"
              }
            ]
          },
          "companyId": {
            "type": "text",
            "index": 2,
            "label": "Company ID",
            "tooltip": "Records of this company. Not available for projects."
          },
          "personId": {
            "type": "text",
            "index": 3,
            "label": "Person ID",
            "tooltip": "Records of this person. Not available for companies and projects."
          },
          "ownerId": {
            "type": "text",
            "index": 4,
            "label": "Owner",
            "tooltip": "Only records owned by this user (our contact, ticket owner). Pick a user, or type the associate ID. Not available for persons.",
            "source": {
              "url": "/component/appmixer/superoffice/core/ListUsers?outPort=out",
              "data": {
                "properties": {
                  "isSource": true
                },
                "transform": "./ListUsers#toSelectArray"
              }
            }
          },
          "filter": {
            "type": "textarea",
            "index": 5,
            "label": "Additional Filter",
            "tooltip": "Optional SuperOffice OData filter on the archive columns of the object, added with \"and\". For example follow-ups dated before a day: <code>date before '2026-11-19'</code>; tickets of a status: <code>ticketStatusId eq 2</code>. Dates in the filter are in the local time of the SuperOffice tenant. At most the 100 newest matching records are returned: narrow the filter to reach older ones. See the archive provider reference in the SuperOffice documentation."
          },
          "outputType": {
            "type": "select",
            "index": 6,
            "label": "Output Type",
            "defaultValue": "array",
            "tooltip": "Choose whether you want to receive the result set as one complete list, or first item only or one item at a time or stream the items to a file.",
            "options": [
              {
                "label": "First Item Only",
                "value": "first"
              },
              {
                "label": "All items at once",
                "value": "array"
              },
              {
                "label": "One item at a time",
                "value": "object"
              },
              {
                "label": "Store to CSV file",
                "value": "file"
              }
            ]
          },
          "timeZone": {
            "type": "text",
            "index": 7,
            "label": "Time Zone",
            "tooltip": "Optional. The time zone of your SuperOffice tenant, for example Europe/Oslo. SuperOffice keeps date-times in the local time of the tenant; the time zone is detected automatically (reliably for European tenants) and this setting overrides it. Date-times the component returns are always in UTC.",
            "source": {
              "url": "/component/appmixer/superoffice/core/ListTimeZones?outPort=out",
              "data": {
                "transform": "./ListTimeZones#toSelectArray"
              }
            }
          }
        }
      }
    }
  ],
  "outPorts": [
    {
      "name": "out",
      "source": {
        "url": "/component/appmixer/superoffice/core/FindRecords?outPort=out&ignoreAuth=true",
        "data": {
          "properties": {
            "generateOutputPortOptions": true
          },
          "messages": {
            "in/outputType": "inputs/in/outputType",
            "in/object": "inputs/in/object"
          }
        }
      }
    },
    {
      "name": "notFound"
    }
  ],
  "icon": "(data URI omitted)"
}
```
