JSON Code Examples

This section is related to JSON code sample object for households, accounts, positions and cost basis.

Response Examples

Households

{
  "paging": {
    "page": 1,
    "page_size": 25,
    "total_pages": 3
  },
  "data": {
    "households": [
      {
        "id": "ba24a2890228ef70a16259bb9b72fb1b42ad5f29d7c60a0298456adb4ee11737",
        "name": "The Rogers Family"
      },
      {
        "id": "ba24a2890228ef70a16259bb9b72fb1b42ad5f29d7c60a0298456adb4ee11737",
        "name": "Scott Brown"
      }
    ]
  }
}

Accounts

{
  "paging": {
    "page": 1,
    "page_size": 25,
    "total_pages": 3
  },
  "data": {
    "household_id": "f2e7d7530b68dee392284b2ce9c49075d63478502ea4c9de74c41ce6b8d2c5f0",
    "accounts": [
      {
        "id": "c87d1cd9511f5ab47d2eb9b55afb0bf6a23346e6af9b8b7e709a19389b93e989",
        "rep_code": "3AAABC",
        "account_type": "INDIVIDUAL",
        "account_name": "Self-directed IRA",
        "status": "ACTIVE",
        "date_open": "2019/01/15",
        "date_closed": null,
        "as_of_date": "2022/08/15",
        "account_balance": 603698
      },
      {
        "id": "c87d1cd9511f5ab47d2eb9b55afb0bf6a23346e6af9b8b7e709a19389b93e989",
        "rep_code": "3AAABC",
        "account_type": "INDIVIDUAL",
        "account_name": "Roth IRA",
        "status": "ACTIVE",
        "date_open": "2018/05/03",
        "date_closed": null,
        "as_of_date": "2022/08/15",
        "account_balance": 12478.36
      }
    ]
  }
}

Positions

{
  "paging": {
    "page": 1,
    "page_size": 25,
    "total_pages": 3
  },
  "data": {
    "account_id": "c87d1cd9511f5ab47d2eb9b55afb0bf6a23346e6af9b8b7e709a19389b93e989",
    "positions": [
      {
        "id": "f5b46399dcd17b3a6e4f7142801a32742b3e56c3fa8216a4b518f0e78a91aac2",
        "cusip": "46429B663",
        "symbol": "HDV",
        "description": "ISHARES CORE HIGH DIVIDEND ETF",
        "long_short_indicator": "long",
        "currency_code": "USD",
        "quantity": 50,
        "as_of_date": "2022/08/15",
        "security_type": "ETF",
        "market_value": 5100
      },
      {
        "id": "974833d6fe6da59bfd66d2ad8f2fe8fd21221e396a167449266b33f1ee1ee5b1",
        "cusip": "46429B663",
        "symbol": "EFA",
        "description": "ISHARES MSCI EAFE ETF",
        "long_short_indicator": "long",
        "currency_code": "USD",
        "quantity": 100,
        "as_of_date": "2022/08/15",
        "security_type": "ETF",
        "market_value": 7200
      }
    ]
  }

Cost Basis

{
  "paging": {
    "page": 1,
    "page_size": 25,
    "total_pages": 3
  },
  "data": {
    "account_id": "b14233218302b48cdc8164ea4bb55adb730437535e0853e9c9801d366c61214f",
    "cost_basis": [
      {
        "id": "f5b46399dcd17b3a6e4f7142801a32742b3e56c3fa8216a4b518f0e78a91aac2",
        "cusip": "46429B663",
        "symbol": "HDV",
        "description": "ISHARES CORE HIGH DIVIDEND ETF",
        "quantity": 50,
        "market_value": 5100,
        "cost_basis_unadjusted": 5000,
        "cost_basis_adjusted": 5000,
        "unrealized_gain_loss": 100,
        "as_of_date": "2022/08/15",
        "open_date": "2022/01/15"
      },
      {
        "id": "12c0039fffadcb3a3a07b263497dfd3e12c784c85fe4797e07ec1197db396180",
        "cusip": "46429B663",
        "symbol": "EFA",
        "description": "ISHARES MSCI EAFE ETF",
        "quantity": 100,
        "market_value": 7200,
        "cost_basis_unadjusted": 4000,
        "cost_basis_adjusted": 4000,
        "unrealized_gain_loss": 3200,
        "as_of_date": "2022/08/15",
        "open_date": "2021/07/10"
      }
    ]
  }

Data Feed

{
	"data": {
		"id": "ba24a2890228ef70a16259bb9b72fb1b42ad5f29d7c60a0298456adb4ee11737",
		"data_feed_status": "active",
		"message": "Data feed will be initiated on the next business day",
		"data_files": [
			"Demographics",
			"Positions",
			"Transactions"
			],
		"repcodes": [
			"A100"
			]
	}
}