README

CLI commands for interacting with onOffice (real estate CRM) from the command line. Designed for AI agent integration with structured JSON output.

Built on top of laravel-onoffice-adapter.

Installation

You can install the package via composer:

composer require innobrain/onoffice-cli

This package requires laravel-onoffice-adapter to be configured with your onOffice API credentials.

You can publish the config file with:

php artisan vendor:publish --tag="onoffice-cli-config"

This is the contents of the published config file:

return [
    'entities' => [
        'estate' => Innobrain\OnOfficeAdapter\Facades\EstateRepository::class,
        'address' => Innobrain\OnOfficeAdapter\Facades\AddressRepository::class,
        // ... more entities
    ],

    'field_modules' => [
        'estate' => 'estate',
        'address' => 'address',
        'activity' => 'agentslog',
        'searchcriteria' => 'searchcriteria',
    ],
];

Usage

Search Records

# Search all estates
php artisan onoffice:search estate --json

# Search with filters
php artisan onoffice:search estate --where="status=1" --where="kaufpreis<500000" --json

# Search with field selection and ordering
php artisan onoffice:search estate --select=Id --select=Ort --select=kaufpreis --orderBy=kaufpreis --limit=10 --json

# Search addresses
php artisan onoffice:search address --where="Ort=Berlin" --json

# Search activities for a specific estate
php artisan onoffice:search activity --where="Objekt_nr=12345" --json

Get Single Record

# Get estate by ID
php artisan onoffice:get estate 12345 --json

# Get address with specific fields
php artisan onoffice:get address 6789 --select=Name --select=Vorname --select=Email --json

List Available Fields

# Get all fields (compact: name and type only)
php artisan onoffice:fields estate --json

# Search fields by name
php artisan onoffice:fields estate --filter=preis --json
php artisan onoffice:fields estate --filter="*flaeche" --json

# Get single field with permitted values
php artisan onoffice:fields estate --field=objekttyp --json

# Get all fields with full details
php artisan onoffice:fields estate --full --json

Fields command options:

• --filter=pattern - Search by name (substring or wildcard like *preis*)
• --field=name - Get single field with full details including permitted values
• --full - Show all field details (length, default, permittedValues)

Supported Entities

estate - Real Estate Listings

Properties/real estate records. Common fields include:

Marketing status: Combine verkauft and reserviert fields:

• verkauft=0, reserviert=0 → Open
• verkauft=0, reserviert=1 → Reserved
• verkauft=1 → Sold/Rented

address - Contacts and Addresses

Contact records (clients, owners, prospects). Common fields include:

Note: Record number (Id) and customer number (KdNr) are different fields. Use Id for API calls.

activity - Agents Log / Activities

Activity records linked to estates and addresses. Common fields include:

Advisory levels: A (contract signed) through G (cancellation)

searchcriteria - Search Criteria

Saved property search profiles for contacts. Fields include property preferences (price ranges, locations, property types) linked to addresses.

Other Entities

• file - File attachments
• field - Field configuration
• filter - Saved filters
• relation - Links between records (buyer, owner, tenant relationships)
• link - URLs for detail views
• lastseen - Recently viewed records
• setting - System settings
• log - Log entries
• macro - Text macros
• marketplace - Marketplace data

Where Clause Operators

Supported operators for --where filters:

Multiple --where clauses are combined with AND logic.

Output Format

With --json flag, output is structured for easy parsing:

{
  "data": [
    {"id": "123", "elements": {"Ort": "Berlin", "kaufpreis": "450000"}}
  ],
  "meta": {
    "total": 42,
    "limit": 10,
    "offset": 0
  }
}

Without --json, output is displayed as a human-readable table.

Development

This is a Laravel package. To run commands locally during development:

# Copy and configure credentials
cp testbench.yaml.dist testbench.yaml
# Edit testbench.yaml with your ON_OFFICE_TOKEN and ON_OFFICE_SECRET

# Run commands via testbench
./vendor/bin/testbench onoffice:search estate --limit=5 --json

Testing

composer test

Changelog

Please see CHANGELOG for more information on what has changed recently.

Contributing

Please see CONTRIBUTING for details.

Security Vulnerabilities

Please review our security policy on how to report security vulnerabilities.

Credits

• Konstantin Auffinger
• All Contributors

License

The MIT License (MIT). Please see License File for more information.