Documentation

Data Availability Status

BridgeFT’s WealthTech API Platform receives and processes data from custodial data feeds overnight, delayed by a day. We receive data drops Tuesday through Saturday depending on the custodians schedule and begin processing it when it’s made available for us.

Source Data Status

Upon arrival, new data will be normalized into models called "Source Data". This includes Lots, Positions, Balances, Realized Gain Loss and Transactions.

Users can use the BridgeFT WealthTech API to get a live status of source data processing for the each custodian.

Fetching the Status

Simply POST to Source Data Status API with a given market date.
For example, here is a curl command that would return the source data availability status for the reported date 2023-09-02.

curl --request POST 'https://api.bridgeft.com/v2/status/source-data' \
     --header 'accept: application/json' \
     --header 'content-type: application/json' \
     --data '
{
  "as_of_date": "2023-09-02"
}'

Note: source data status reporting is only live as of 2023-05-26. Attempting to get status for any date prior will return an empty response.

Understanding the Response

Source Identification

Each accessible source will be included in the response as a top level key. An accessible source is any source (custodian) that delivers data for at least one account accessible to the authenticated user.

The available custodian source options are enumerated as follows:

  • APX - Apex Fintech Solutions
  • DST - DST Systems
  • EGB - Eaglebrook Advisors
  • FPR - Fidelity 401k/403b
  • IBK - Interactive Brokers
  • MLT - Millennium Trust Company
  • NFS - Fidelity Investments
  • PER - Pershing
  • SWB - Charles Schwab
  • TIA - TIAA Financial Services

Data Type Availability

In either case, we break down the source's data availability by data type. As described above, there are five distinct
types of source data:

  • Lots: lots
  • Positions: positions
  • Balances: balances
  • Realized Gain Loss: realized_gain_losses
  • Transactions: transactions

Note that not every source delivers all of these types of data. Positions and Balances are guaranteed whereas the
existence of Lots and Realized Gain Loss data is source dependent.

Each data type includes a boolean field "available" which will denote whether all accessible feed codes for that data
type are fully normalized and ready to access.

Response Example

In the below example, the accessible sources are Fidelity Investments ("NFS") and Charles Schwab ("SWB"), where Fidelity Investments data has been fully processed in BridgeFT and available for use while Charles Schwab data is not yet processed:

{
  "object": "status.source_data",
  "NFS": {
    "balances": {
      "available": true
    },
    "lots": {
      "available": true
    },
    "positions": {
      "available": true
    },
    "realized_gain_losses": {
      "available": true
    },
    "transactions": {
      "available": true
    }
  },
  "SWB": {
    "balances": {
      "available": false
    },
    "lots": {
      "available": false
    },
    "positions": {
      "available": false
    },
    "realized_gain_losses": {
      "available": false
    },
    "transactions": {
      "available": false
    }
  }
}