Transactions

Transactions

GET

/transactions

Returns all the transactions related data points for a particular investment product within a date range and reporting period.

Prod:
https://api.seic.com/v1/investments/transactions
Query Parameters
Name Description Data Type Required
accountIds

SEIAccountIds for which the user has requested data. Can be individual or multiple delimited by comma.

string

startDate

StartDate in YYYY-MM-DD format. Will check midnight until 11:59.59.9999 of a date.

string

endDate

EndDate in YYYY-MM-DD format. Will check midnight until 11:59.59.9999 of a date.

string

dateType

The date criteria for which user wants to filter the transaction details. Ex- ActualSettlementDate, ContractualSettlementDate, EndDate, EntryDate, EventCreatedDate, KnowledgeDate, TradeDate

string

reportDataType

Report type(Daily/Closed)

string

limit

Response page size.

string

Header Parameters
Name Description Data Type Required
Authorization

access_token value obtained from the Token endpoint.This is passed as "Bearer access_token "

string

AppKey

This is the Consumer Key provided during the App Registration process and is used to identify the user's application.

string

HTTP Responses
  • Code
    Description
  • 200

    OK- The request has succeeded and the response has been returned.

  • 400

    Bad request - The server cannot or will not process the request due to an inaccurate request submitted by the client application. Please resubmit the request after making the required corrections indicated in the error response. For more Info on SEI Error Standards please refer to the API Standards FAQ under Support.

  • 401

    Unauthorized - Invalid authentication details have been provided. Also useful to trigger an authorization pop up if the API is used from a browser.

  • 403

    Forbidden-The SEI Server understood the request but refuses to fulfill it.

  • 404

    Not Found- The requested resource or the underlying resource does not exist. Please resubmit the request after making the required corrections

  • 500

    Internal Server Error - The SEI server was unable to fulfill the request due to an unknown condition. Please contact SEI for support. For More Info please refer to the "Response & Errors" FAQ under support.

TEST ENDPOINT
accountIds

SEIAccountIds for which the user has requested data. Can be individual or multiple delimited by comma.

startDate

StartDate in YYYY-MM-DD format. Will check midnight until 11:59.59.9999 of a date.

endDate

EndDate in YYYY-MM-DD format. Will check midnight until 11:59.59.9999 of a date.

dateType

The date criteria for which user wants to filter the transaction details. Ex- ActualSettlementDate, ContractualSettlementDate, EndDate, EntryDate, EventCreatedDate, KnowledgeDate, TradeDate

reportDataType

Report type(Daily/Closed)

limit

Response page size.

Authorization

access_token value obtained from the Token endpoint.This is passed as "Bearer access_token "

AppKey

This is the Consumer Key provided during the App Registration process and is used to identify the user's application.

Request Body

HTTP Basic

OAuth 2.0

API Key

Working...

Transactions

Transactions

GET

/transactions

Returns all the transactions related data points for a particular investment product within a date range and reporting period.

Prod:
https://api.seic.com/v1/investments/transactions
Query Parameters
Name Description Data Type Required
accountIds

SEIAccountIds for which the user has requested data. Can be individual or multiple delimited by comma.

string

startDate

StartDate in YYYY-MM-DD format. Will check midnight until 11:59.59.9999 of a date.

string

endDate

EndDate in YYYY-MM-DD format. Will check midnight until 11:59.59.9999 of a date.

string

dateType

The date criteria for which user wants to filter the transaction details. Ex- ActualSettlementDate, ContractualSettlementDate, EndDate, EntryDate, EventCreatedDate, KnowledgeDate, TradeDate

string

reportDataType

Report type(Daily/Closed)

string

limit

Response page size.

string

Header Parameters
Name Description Data Type Required
Authorization

access_token value obtained from the Token endpoint.This is passed as "Bearer access_token "

string

AppKey

This is the Consumer Key provided during the App Registration process and is used to identify the user's application.

string

HTTP Responses
  • Code
    Description
  • 200

    OK- The request has succeeded and the response has been returned.

  • 400

    Bad request - The server cannot or will not process the request due to an inaccurate request submitted by the client application. Please resubmit the request after making the required corrections indicated in the error response. For more Info on SEI Error Standards please refer to the API Standards FAQ under Support.

  • 401

    Unauthorized - Invalid authentication details have been provided. Also useful to trigger an authorization pop up if the API is used from a browser.

  • 403

    Forbidden-The SEI Server understood the request but refuses to fulfill it.

  • 404

    Not Found- The requested resource or the underlying resource does not exist. Please resubmit the request after making the required corrections

  • 500

    Internal Server Error - The SEI server was unable to fulfill the request due to an unknown condition. Please contact SEI for support. For More Info please refer to the "Response & Errors" FAQ under support.

TEST ENDPOINT
accountIds

SEIAccountIds for which the user has requested data. Can be individual or multiple delimited by comma.

startDate

StartDate in YYYY-MM-DD format. Will check midnight until 11:59.59.9999 of a date.

endDate

EndDate in YYYY-MM-DD format. Will check midnight until 11:59.59.9999 of a date.

dateType

The date criteria for which user wants to filter the transaction details. Ex- ActualSettlementDate, ContractualSettlementDate, EndDate, EntryDate, EventCreatedDate, KnowledgeDate, TradeDate

reportDataType

Report type(Daily/Closed)

limit

Response page size.

Authorization

access_token value obtained from the Token endpoint.This is passed as "Bearer access_token "

AppKey

This is the Consumer Key provided during the App Registration process and is used to identify the user's application.

Request Body

HTTP Basic

OAuth 2.0

API Key

Working...

Test: https://test.api.seic.com/v1/investments/transactions
TLS*: https://mtls.api.seic.com/v1/investments/transactions
*The TLS endpoint is only used if Server Based Application was selected during the App Registration process.

Pass the oAuth Token and the App key to invoke this endpoint for a particular application.

Transactions

Transactions

GET

/transactions

Returns all the transactions related data points for a particular investment product within a date range and reporting period.

Prod:
https://api.seic.com/v1/investments/transactions
Query Parameters
Name Description Data Type Required
accountIds

SEIAccountIds for which the user has requested data. Can be individual or multiple delimited by comma.

string

startDate

StartDate in YYYY-MM-DD format. Will check midnight until 11:59.59.9999 of a date.

string

endDate

EndDate in YYYY-MM-DD format. Will check midnight until 11:59.59.9999 of a date.

string

dateType

The date criteria for which user wants to filter the transaction details. Ex- ActualSettlementDate, ContractualSettlementDate, EndDate, EntryDate, EventCreatedDate, KnowledgeDate, TradeDate

string

reportDataType

Report type(Daily/Closed)

string

limit

Response page size.

string

Header Parameters
Name Description Data Type Required
Authorization

access_token value obtained from the Token endpoint.This is passed as "Bearer access_token "

string

AppKey

This is the Consumer Key provided during the App Registration process and is used to identify the user's application.

string

HTTP Responses
  • Code
    Description
  • 200

    OK- The request has succeeded and the response has been returned.

  • 400

    Bad request - The server cannot or will not process the request due to an inaccurate request submitted by the client application. Please resubmit the request after making the required corrections indicated in the error response. For more Info on SEI Error Standards please refer to the API Standards FAQ under Support.

  • 401

    Unauthorized - Invalid authentication details have been provided. Also useful to trigger an authorization pop up if the API is used from a browser.

  • 403

    Forbidden-The SEI Server understood the request but refuses to fulfill it.

  • 404

    Not Found- The requested resource or the underlying resource does not exist. Please resubmit the request after making the required corrections

  • 500

    Internal Server Error - The SEI server was unable to fulfill the request due to an unknown condition. Please contact SEI for support. For More Info please refer to the "Response & Errors" FAQ under support.

TEST ENDPOINT
accountIds

SEIAccountIds for which the user has requested data. Can be individual or multiple delimited by comma.

startDate

StartDate in YYYY-MM-DD format. Will check midnight until 11:59.59.9999 of a date.

endDate

EndDate in YYYY-MM-DD format. Will check midnight until 11:59.59.9999 of a date.

dateType

The date criteria for which user wants to filter the transaction details. Ex- ActualSettlementDate, ContractualSettlementDate, EndDate, EntryDate, EventCreatedDate, KnowledgeDate, TradeDate

reportDataType

Report type(Daily/Closed)

limit

Response page size.

Authorization

access_token value obtained from the Token endpoint.This is passed as "Bearer access_token "

AppKey

This is the Consumer Key provided during the App Registration process and is used to identify the user's application.

Request Body

HTTP Basic

OAuth 2.0

API Key

Working...

SAMPLE REQUEST

curl -X GET \
  'https://api.seic.com/v1/investments/positions?reportDataType=Daily&accountIds=9999-3-56789&asOfDate=2019-03-24' \
  -H 'AppKey: gsedgaerhDSHGRSH' \
  -H 'Authorization: Bearer ADsgdnnkjnfdIKJN'


REQUEST HEADER

Authorization: Bearer ADsgdnnkjnfdIKJN
AppKey: gsedgaerhDSHGRSH
RESPONSE HEADER

Content-Type: application/json 
Status: 200 OK 
requesttrackingid: 67e1ff68-164f-03ad-0f2d-5cbbfda56ec9



SAMPLE RESPONSE

{
	"data": {
		"startDate": "2019-01-01T00:00:00",
		"endDate": "2019-03-24T23:59:59.999",
		"reportDataType": "Daily Investments",
		"dateType": "EndDate",
		"accounts": [{
			"id": "9999-3-56789",
			"name": "Name_GV_S",
			"externalId": "Test2_GV_S",
			"transactionsCount": 25
		}],
		"transactions": [{
			"id": 348438,
			"accountId": "9999-3-56789",
			"alternateId": 156985,
			"type": "Buy",
			"description": "Buy",
			"tradeDate": "2019-03-20T00:00:00",
			"actualSettlementDate": "2019-03-22T00:00:01",
			"contractualSettlementDate": "2019-03-22T00:00:01",
			"quantity": 139,
			"comment": " ",
			"custodian": {
				"name": "Charles Schwab",
				"accountId": 1189,
				"accountDescription": "9999-3-56789 Name_GV_S"
			},
			"reference": {
				"cusip": "459200101",
				"isin": "US4592001014",
				"sedol": "2005973",
				"ticker": "IBM",
				"reportDataTypeName": "Daily Investments",
				"lin": "",
				"investmentId": 825351,
				"investmentName": "INTL BUSINESS MACHINES CORP",
				"investmentDescription": "INTL BUSINESS MACHINES CORP",
				"brokerName": "JPMALGO",
				"currencyIsoName": "United States Dollar",
				"currencyIsoCode": "USD"
			},
			"base": {
				"brokerCommissionAmount": -0.7,
				"costAmount": 6563.64,
				"grossAmount": -6563.64,
				"incomePurchaseSoldAmount": 0,
				"netAmount": -6563.64,
				"notionalAmount": null,
				"priceAmount": 47.2154,
				"principalAmount": -6562.9406,
				"realizedGainLoss": 0,
				"secFees": 0,
				"totalGainLoss": 0,
				"otherExpense": 0
			},
			"local": {
				"brokerCommissionAmount": -0.7,
				"costAmount": 6563.64,
				"grossAmount": -6563.64,
				"incomePurchaseSoldAmount": 0,
				"netAmount": -6563.64,
				"notionalAmount": null,
				"priceAmount": 47.2154,
				"principalAmount": -6562.9406,
				"realizedGainLoss": 0,
				"secFees": 0,
				"otherExpense": 0
			}
		}]
	}
}
MODEL
Operations
Name Description Data Type (L)
startDate

The earliest date within a range in ISO 8601 format YYYY-MM-DD.

boolean
endDate

The latest date within a range in ISO 8601 format YYYY-MM-DD.

string
reportDataType

Report data type for investment positions, such as Closed or Daily.

string
dateType

The date criteria by which user wants to filter.

string
id

The SEI system's internal identifier for an Account, position, lot, tranasction, investor, product or any other entity indicated by the oject grouping in the API response. 

string
name

The business description for an entity in the context of the API, sometimes called a proper name. A name can apply to a Calendar, Financial Institution, Investor, Account, Advisor and various other entities.

string
externalId

Unique business identifier that represents a contact, investor, product, transaction or alternate entity recognized by SEI and a third party system or application.  Many times the externalId is used to synchronize SEI sourced data with another data source for the same record.

string
transactionsCount

Number of transactions per account in the API response.

number
accountId

SEI unique system ID that represents the account.

string
alternateId

Alternate identifier. This is a secondary identifier typically used when integrating between systems. Use of this field is optional.

string (100)
description

This field holds additional information about the field, and is provided during setup.

string
tradeDate

The date the order was executed, e.g., the effective date, in ISO 8601 format YYYY-MM-DD.

string
actualSettlementDate

Settle date of transaction.

string
contractualSettlementDate

The date the transaction is expected to settle.

string
quantity

The current face amount, or quantity of shares held, for an investment or noted on a transaction.

number
comment

Free form text field available to user on most transaction types.

string
accountDescription

A short description of the account 

string
cusip

A 9-digit alphanumeric securities identifier assigned by the Committee on Uniform Security Identification Procedures (CUSIP) for the purposes of facilitating clearing and settlement of trades.

string
sedol

The Stock Exchange Daily Official List (SEDOL) is a list of security identifiers used in the United Kingdom and Ireland for clearing purposes.

string
isin

The International Securities Identification Number (ISIN) is an alphanumeric code that identifies a specific securities issue.

string
ticker

A ticker symbol used to identify a stock.

string
reportDataTypeName

Report data type for investment positions, such as Closed or Daily.

string
lin

LIN

string
investmentId

The SEI system identifier that represents the investment.

number
investmentName

Name of the investment.

string
investmentDescription

The full text description of an investment.

string
brokerName

The name of the trading broker on a transaction.

string
currencyIsoName

The currency name of income payments.

string
currencyIsoCode

The currency code in which the transaction is paid in.

string
brokerCommissionAmount

The amount of brokerage commission on a trade expressed in local and base currency.

number
costAmount

Total base or local net cost of the lots being sold or purchased.

number
grossAmount

Net cash amount of a transaction less traded accrued interest and withholding tax in base and local currency.

number
incomePurchaseSoldAmount

Amount of cash paid or received to cover accrued interest on a position. Available for base and local currency.

number
netAmount

The net cash amount of a transactions after associated charges and deductions have been subtracted.

number
notionalAmount

Notional exposure amount. Notional value helps distinguish the total value of a trade from the cost of taking the trade.

number
priceAmount

Price of the transaction expressed in the local and base currency.

number
principalAmount

The total amount of uninvested principal cash held in an Account expressed in base and local currency.

number
realizedGainLoss

The investment gain realized when an investment is disposed expressed in base and local currency.

number
secFees

Security Exchange Commission fees applied to trades expressed in base and local currency.

number
totalGainLoss

Combined short term and long term gain loss expressed in the base and local currency.

number
otherExpense number


Transactions

Transactions

GET

/transactions

Returns all the transactions related data points for a particular investment product within a date range and reporting period.

Prod:
https://api.seic.com/v1/investments/transactions
Query Parameters
Name Description Data Type Required
accountIds

SEIAccountIds for which the user has requested data. Can be individual or multiple delimited by comma.

string

startDate

StartDate in YYYY-MM-DD format. Will check midnight until 11:59.59.9999 of a date.

string

endDate

EndDate in YYYY-MM-DD format. Will check midnight until 11:59.59.9999 of a date.

string

dateType

The date criteria for which user wants to filter the transaction details. Ex- ActualSettlementDate, ContractualSettlementDate, EndDate, EntryDate, EventCreatedDate, KnowledgeDate, TradeDate

string

reportDataType

Report type(Daily/Closed)

string

limit

Response page size.

string

Header Parameters
Name Description Data Type Required
Authorization

access_token value obtained from the Token endpoint.This is passed as "Bearer access_token "

string

AppKey

This is the Consumer Key provided during the App Registration process and is used to identify the user's application.

string

HTTP Responses
  • Code
    Description
  • 200

    OK- The request has succeeded and the response has been returned.

  • 400

    Bad request - The server cannot or will not process the request due to an inaccurate request submitted by the client application. Please resubmit the request after making the required corrections indicated in the error response. For more Info on SEI Error Standards please refer to the API Standards FAQ under Support.

  • 401

    Unauthorized - Invalid authentication details have been provided. Also useful to trigger an authorization pop up if the API is used from a browser.

  • 403

    Forbidden-The SEI Server understood the request but refuses to fulfill it.

  • 404

    Not Found- The requested resource or the underlying resource does not exist. Please resubmit the request after making the required corrections

  • 500

    Internal Server Error - The SEI server was unable to fulfill the request due to an unknown condition. Please contact SEI for support. For More Info please refer to the "Response & Errors" FAQ under support.

TEST ENDPOINT
accountIds

SEIAccountIds for which the user has requested data. Can be individual or multiple delimited by comma.

startDate

StartDate in YYYY-MM-DD format. Will check midnight until 11:59.59.9999 of a date.

endDate

EndDate in YYYY-MM-DD format. Will check midnight until 11:59.59.9999 of a date.

dateType

The date criteria for which user wants to filter the transaction details. Ex- ActualSettlementDate, ContractualSettlementDate, EndDate, EntryDate, EventCreatedDate, KnowledgeDate, TradeDate

reportDataType

Report type(Daily/Closed)

limit

Response page size.

Authorization

access_token value obtained from the Token endpoint.This is passed as "Bearer access_token "

AppKey

This is the Consumer Key provided during the App Registration process and is used to identify the user's application.

Request Body

HTTP Basic

OAuth 2.0

API Key

Working...