AssetBook

AssetBook is a data sync integration that imports households, accounts, and holdings from AssetBook’s portfolio management platform.

Overview

Attribute	Value
Integration Type	Data Sync (Read-only)
Authentication	OAuth 2.0 (Client Credentials with HTTP Basic Auth)
Data Flow	AssetBook → RightCapital (inbound)
Developer	Qianwei Hao
Cron Owner	qianwei.hao

Data Model

Household (id, name)
  └── Account (id, registration, accountNumber, accountType)
        └── Holding (id, investment, symbol, cusip, investmentType, marketValue)

Filtering Rules

• Households: Only status = 'Active' are synced
• Accounts: Only accountStatus = 'Open' are synced

Account Type Mapping

AssetBook Type	RC Subtype
401k, 403b, 401a	401K
Individual, Joint Tenants, Corporate	TAXABLE
IRA Contributory, IRA Rollover	TRADITIONAL_IRA
IRA Roth	ROTH_IRA
IRA SEP	SEP_IRA
Trust, Revocable Trust	TRUST
529 Plan	529

API Endpoints

Purpose	Endpoint
List Households	odata/households
List Accounts	odata/accounts?$filter=householdId eq {id}
Get Holdings	positions/household/{household_id}

Authentication Flow

1. Advisor submits username in RightCapital
2. Username is cached in Redis (10 min TTL)
3. AssetBook sends webhook with credentials
4. Integration is created from webhook data

Code Locations

Component	Path
Connector	retail-api/app/Integrations/AssetBook/Connector.php
Integrator	retail-api/app/Integrations/AssetBook/Integrator.php
Models	retail-api/app/Integrations/AssetBook/Models/