farmos-land-portfolioQuery land ownership, leases, landlord info, and land payments. Write operations for payment management and lease renewals.
Install via ClawdBot CLI:
clawdbot install brianppetty/farmos-land-portfolioTrack owned and leased land, lease terms, landlord relationships, payments, and annual land costs.
NEVER use partial or truncated data. These rules are non-negotiable:
/api/integration/dashboard — it truncates results to 5 items. Partial payment data is worse than no data because it creates a false sense of completeness./all endpoints listed below for complete data.Lease terms, rent amounts, and landlord info are sensitive business data. Restrict to admin or manager roles only.
Role mapping: Check the sender's role in ~/.openclaw/farmos-users.json. If the user is not admin or manager, tell them they don't have access to land portfolio data.
http://100.102.77.110:8009
IMPORTANT: Use auth endpoints for WRITE operations (mark-paid, renewals). Use integration /all endpoints for READ operations (listing payments, leases, landlords).
GET /api/integration/payments/all
status — pending, paid, overdue, scheduledpayment_type — rent, mortgage, property_tax, insurance, improvement, otherparcel_id — filter by specific parceldue_date_from — YYYY-MM-DD range startdue_date_to — YYYY-MM-DD range endcrop_year — filter by crop year/api/integration/payments/all?status=overdue/api/integration/payments/all?due_date_from=2026-03-01&due_date_to=2026-03-31/api/integration/payments/all?payment_type=rentGET /api/integration/payments/upcoming?days=30
days=60 or days=90 for longer lookaheadGET /api/integration/leases/all
status — active, expiredlandlord_id — filter by landlordGET /api/integration/leases/expiring?days=90
GET /api/integration/landlords/all
GET /api/integration/parcels
ownership_type — owned, leasedGET /api/integration/summary
GET /api/integration/finance/costs?year=2026
year, entity_idGET /api/integration/finance/cost-per-field?year=2026
year, entity_idGET /api/integration/tasks/overdue
GET /api/integration/tasks/actionable?days_ahead=30
These require JWT auth. See Authentication section below.
This skill accesses protected FarmOS endpoints that require a JWT token.
To get a token: Run the auth helper with the appropriate role:
TOKEN=$(~/clawd/scripts/farmos-auth.sh admin)To use the token: Include it as a Bearer token:
curl -H "Authorization: Bearer $TOKEN" http://100.102.77.110:8009/api/endpointToken expiry: Tokens last 15 minutes. If you get a 401 response, request a new token.
POST /api/payments/{id}/mark-paid
Authorization: Bearer {token}
Content-Type: application/json
Body:
{
"paid_date": "2026-02-15",
"notes": "Check #1234"
}POST /api/payments/bulk/mark-paid
Authorization: Bearer {token}
Content-Type: application/json
Body:
{
"payment_ids": [12, 34, 56],
"paid_date": "2026-02-15",
"notes": "Batch check run"
}POST /api/payments/bulk/mark-paid-by-date
Authorization: Bearer {token}
Content-Type: application/json
Body:
{
"due_date_from": "2026-03-01",
"due_date_to": "2026-03-31",
"paid_date": "2026-02-15",
"payment_type": "rent",
"notes": "March rent payments"
}Use this when the user says "mark all March payments as paid" or similar bulk date-based operations.
POST /api/leases/renewal-preview
Authorization: Bearer {token}
Content-Type: application/json
Body:
{
"lease_ids": [5, 12],
"new_start_date": "2027-03-01",
"rent_increase_percent": 3.0
}Returns: Preview of what the renewed leases would look like, including new payment schedules. Use this BEFORE executing bulk renewals so the user can confirm.
POST /api/leases/bulk-renew
Authorization: Bearer {token}
Content-Type: application/json
Body:
{
"lease_ids": [5, 12],
"new_start_date": "2027-03-01",
"new_end_date": "2028-02-28",
"new_rent_amount": 52000.00,
"rent_increase_percent": 3.0,
"notes": "Annual renewal with 3% increase"
}IMPORTANT: Always preview first, confirm with user, then execute.
POST /api/payments/year-end-rollover/preview
Authorization: Bearer {token}
Content-Type: application/json
Body:
{
"from_year": 2026,
"to_year": 2027
}Returns: Preview of payment schedules that would be created for the new crop year.
POST /api/payments/year-end-rollover/execute
Authorization: Bearer {token}
Content-Type: application/json
Body:
{
"from_year": 2026,
"to_year": 2027,
"apply_rent_increase": true,
"rent_increase_percent": 2.5
}IMPORTANT: This creates next year's payment schedules based on current year leases. Always preview first.
| Endpoint | Why |
|----------|-----|
| GET /api/integration/dashboard | Truncates to 5 items. NEVER use this. |
/api/integration/payments/all with date filtering to get the COMPLETE picture./api/integration/payments/all with /api/integration/finance/costs for the full view.Generated Mar 1, 2026
A farm financial manager needs to forecast cash requirements for the upcoming month by retrieving all scheduled payments due within 30 days, ensuring no partial data from truncated endpoints. They use the upcoming payments endpoint with days=30 to get a complete list, then summarize totals by payment type to plan fund allocation.
An administrator monitors active leases to identify those expiring within the next 90 days, using the expiring leases endpoint to avoid missing any. They review landlord contact details and lease terms to prepare for renewal negotiations or land reallocation, adhering to access control for sensitive data.
A farm operator analyzes annual land expenses by querying the finance costs endpoint for a specific year, breaking down monthly costs by category like rent and taxes. They use this to compare against budget projections and adjust operational plans, ensuring data completeness by verifying total record counts.
An auditor checks for overdue payments and marks them as paid in bulk after verification, using authenticated endpoints with JWT tokens. They filter payments by status=overdue, then execute bulk mark-paid operations with notes for audit trails, following strict data rules to report any endpoint failures.
A manager maintains landlord relationships by accessing the full landlords endpoint to review contact info and active lease counts. They use this to communicate lease renewals or payment updates, restricting access to admin roles only to protect sensitive business data.
Offer tiered subscriptions where farms pay monthly fees for access to land portfolio tracking, with premium tiers including automated payment reminders and lease renewal alerts. Revenue is generated from recurring subscriptions and upsells for advanced analytics like cost-per-field reports.
Charge a small percentage fee on each payment processed through the skill's mark-paid operations, such as rent or tax payments. Integrate with farm accounting systems to streamline transactions, with revenue scaling based on the volume and value of payments managed.
Sell annual enterprise licenses to large farming corporations for unlimited access to all land portfolio features, including custom integrations and priority support. Revenue comes from high-value contracts tailored to specific operational needs like multi-entity cost tracking.
💬 Integration Tip
Always use the /all endpoints for read operations to ensure data completeness, and implement robust error handling to report failures explicitly rather than falling back to partial data.
Query Copilot Money personal finance data (accounts, transactions, net worth, holdings, asset allocation) and refresh bank connections. Use when the user asks about finances, account balances, recent transactions, net worth, investment allocation, or wants to sync/refresh bank data.
Stripe API integration with managed OAuth. Manage customers, subscriptions, invoices, products, prices, and payments. Use this skill when users want to process payments, manage billing, or handle subscriptions with Stripe. For other third party apps, use the api-gateway skill (https://clawhub.ai/byungkyu/api-gateway). Requires network access and valid Maton API key.
QuickBooks API integration with managed OAuth. Manage customers, invoices, payments, bills, and run financial reports. Use this skill when users want to interact with QuickBooks accounting data. For other third party apps, use the api-gateway skill (https://clawhub.ai/byungkyu/api-gateway).
Advanced financial calculator with future value tables, present value, discount calculations, markup pricing, and compound interest. Use when calculating investment growth, pricing strategies, loan values, discounts, or comparing financial scenarios across different rates and time periods. Includes both CLI and interactive web UI.
Track expenses via natural language, get spending summaries, set budgets
Query and manage personal finances via the official Actual Budget Node.js API. Use for budget queries, transaction imports/exports, account management, categorization, rules, schedules, and bank sync with self-hosted Actual Budget instances.