People/Trusts/Entities

In the Wealth.com application, there are cards representing people (individuals), trusts, and other entities (e.g., LLCs).

The SFTP interface allows connected systems to programmatically add or update people, trust, and entity cards in bulk. Deleting people, trust, and entity cards via SFTP is currently not supported (given the irreversible nature of that operation). Adding or updating these cards is performed by uploading a JSONL (JSON Lines) file, where each line represents a person, trust, or entity object.

SFTP

People/Trusts/Entities File Specification

The schema for people, trust, and entity cards are different. See below for the respective schemas. These should all appear in a single file. The field type in each row will indicate what type of card it is, and therefore how it should be processed.

JSONL File Schema for People

Name
id
Type
string (Max 255)
Description
Your firm's unique identifier for the person.
Name
top_account_id
Type
string (Max 255)
Description
The id of the top account associated with the person. This should correspond to an already existing top account, or to the id of a top account within the Add/Update Top Accounts file.
Name
type
Type
string (constant)
Description
This field must always be "Individual" for people.
Name
first_name
Type
string (Max 255)
Description
The first name of the person.
Name
middle_name
Type
string (Max 255), optional
Description
The middle name of the person.
Name
last_name
Type
string (Max 255)
Description
The last name of the person.

Example JSONL Rows for People

people-trusts-entities.jsonl

{
  "id": "ca7e299a-5404-4d10-82f4-584ebb1bee54",
  "top_account_id": "123e4567-e89b-12d3-a456-426614174000",
  "type": "Individual",
  "first_name": "John",
  "middle_name": "Michael",
  "last_name": "Doe"
}
{
  "id": "4c59a99e-49e9-4364-afa6-22d62d9af3a7",
  "top_account_id": "123e4567-e89b-12d3-a456-426614174000",
  "type": "Individual",
  "first_name": "Jane",
  "last_name": "Doe"
}
{
  "id": "1694a501-5aad-48d0-8888-75801e16b1e2",
  "top_account_id": "987e6543-e21b-45c6-b789-123456789abc",
  "type": "Individual",
  "first_name": "John",
  "middle_name": "A.",
  "last_name": "Smith"
}
{
  "id": "56f0fdc7-c0d5-408d-a42d-17e52de2682f",
  "top_account_id": "987e6543-e21b-45c6-b789-123456789abc",
  "type": "Individual",
  "first_name": "Rebecca",
  "last_name": "Smith"
}
{
  "id": "4d89cf09-d77c-4d44-b682-f7fc4522099f",
  "top_account_id": "987e6543-e21b-45c6-b789-123456789abc",
  "type": "Individual",
  "first_name": "James",
  "last_name": "Smith"
}

JSONL File Schema for Trusts

Name
id
Type
string (Max 255)
Description
Your firm's unique identifier for the trust.
Name
top_account_id
Type
string (Max 255)
Description
The id of the top account associated with the trust. This should correspond to an already existing top account, or to the id of a top account within the Add/Update Top Accounts file.
Name
type
Type
string (constant)
Description
This field must always be "Trust" for trusts.
Name
legal_name
Type
string (Max 500)
Description
The legal name of the trust.
Name
trust_type
Type
enum (IndividualRevocableTrust | JointRevocableTrust | IrrevocableLifeInsuranceTrust | GrantorRetainedAnnuityTrust | CharitableRemainderUnitTrust | CharitableRemainderAnnuityTrust | SpousalLifetimeAccessTrust | DynastyTrust | QualifiedPersonalResidenceTrust | OtherIrrevocableTrust)
Description
The type of trust.
Name
trust_creator
Type
array of strings (Max 255 per string), optional
Description
The ids of the trust creators.
Name
initial_trustee
Type
array of strings (Max 255 per string), optional
Description
The ids of the initial trustees.
Name
governing_state
Type
enum (two-letter US state abbreviation), optional
Description
The two-letter US state abbreviation for the governing state of the trust. For example, "AZ" for Arizona.
Name
creation_date
Type
date (YYYY-MM-DD), optional
Description
The creation date (YYYY-MM-DD) of the trust.

Example JSONL Rows for Trusts

people-trusts-entities.jsonl

{
  "id": "893703bf-041b-45e2-8f41-9ff8d705a6bd",
  "top_account_id": "123e4567-e89b-12d3-a456-426614174000",
  "type": "Trust",
  "legal_name": "The Doe Family Trust",
  "trust_type": "JointRevocableTrust",
  "trust_creator": ["ca7e299a-5404-4d10-82f4-584ebb1bee54", "4c59a99e-49e9-4364-afa6-22d62d9af3a7"],
  "initial_trustee": ["ca7e299a-5404-4d10-82f4-584ebb1bee54", "4c59a99e-49e9-4364-afa6-22d62d9af3a7"],
  "governing_state": "OR",
  "creation_date": "2020-01-02"
}
{
  "id": "9351bd69-4348-4415-8b3b-f3482e92d723",
  "top_account_id": "987e6543-e21b-45c6-b789-123456789abc",
  "type": "Trust",
  "legal_name": "The John A. Smith Trust",
  "trust_type": "IndividualRevocableTrust",
  "trust_creator": ["1694a501-5aad-48d0-8888-75801e16b1e2"]
}

JSONL File Schema for Entities

Name
id
Type
string (Max 255)
Description
Your firm's unique identifier for the entity.
Name
top_account_id
Type
string (Max 255)
Description
The id of the top account associated with the entity. This should correspond to an already existing top account, or to the id of a top account within the Add/Update Top Accounts file.
Name
type
Type
string (constant)
Description
This field must always be "Entity" for entities.
Name
legal_name
Type
string (Max 255)
Description
The legal name of the entity.
Name
incorporation_state
Type
enum (two-letter US state abbreviation), optional
Description
The two-letter US state abbreviation for the state of incorporation. For example, "CA" for California.
Name
incorporation_form
Type
enum (CCorporation | SCorporation | DonorAdvisorFund | LimitedLiabilityCompany | PrivateFoundation | SoleProprietorship | Other), optional
Description
The form of incorporation of the entity.
Name
ownership
Type
array of JSON, optional
Description
An array of ownership details for the entity. If ownership is provided, then each ownership entry must include:
- percentage: float - The percentage of ownership (between 0 and 100).
- owner_id: array of strings (Max 255 per string) - The id of the owner(s). An owner should be a person, trust, or entity. The only instance in which multiple owner ids should be provided in this owner_id array is in the case of multiple people having joint ownership with right of survivorship. Other forms of shared ownership, e.g., ABC Trust owns 25%, DEF Entity owns 75%, would be indicated by providing multiple objects in the ownership array.

Example JSONL Rows for Entities

people-trusts-entities.jsonl

{
  "id": "c6f68d35-61d3-4e92-b206-18391ba61cdb",
  "top_account_id": "123e4567-e89b-12d3-a456-426614174000",
  "type": "Entity",
  "legal_name": "Doe Family Corporation",
  "incorporation_form": "CCorporation"
}
{
  "id": "c3eafedf-35dc-470c-96ee-b360b34c942c",
  "top_account_id": "987e6543-e21b-45c6-b789-123456789abc",
  "type": "Entity",
  "legal_name": "Smith LLC",
  "incorporation_state": "TX",
  "incorporation_form": "LimitedLiabilityCompany",
  "ownership": [
    {
      "percentage": 100.0,
      "owner_id": ["9351bd69-4348-4415-8b3b-f3482e92d723"]
    }
  ]
}