Quick Shortcuts

Introduction

In this article, we will delve into the intricacies of migrating from our API v1 to our enhanced API v2. We understand the challenges that may arise during this transition, and we aim to provide you with a clear roadmap to navigate the migration process seamlessly.

With API v2, we have introduced notable updates, including new endpoints, modified key structures, and updated values. This guide will equip you with the necessary knowledge and examples to effortlessly adapt to the changes, ensuring a smooth transition for your applications and services.

Understanding the Changes

To begin, we will outline the key differences between API v1 and API v2.

By highlighting the modified endpoints, updated keys, and transformed values, we aim to empower you to make the necessary mapping changes required to interface with our new API.

A Step-by-Step Migration Process

We understand the importance of a systematic approach to migration. Therefore, we will walk you through a comprehensive, step-by-step process to ensure a successful migration from API v1 to API v2. Each step will be accompanied by detailed examples, enabling you to grasp the nuances of the migration process.

  1. Review the Endpoint Changes: We will provide you with a detailed overview of the modified endpoints in API v2. By understanding these changes, you can update your existing API calls accordingly.
  2. Mapping Changes for Keys and Values: We will compare the key structures of API v1 and API v2, highlighting any modifications. This section will guide you through the necessary adjustments needed for a successful transition.
  3. Testing and Fine-Tuning: Once you have made the necessary adjustments, we will guide you through the testing and fine-tuning phase. This will ensure that your newly migrated applications are functioning smoothly and without any issues.

Root Endpoint Changes

-    https://api.wealthtechs.com/v1/
+    https://api.wealthtechs.com/v2/odata/

Resources Changes

🔀 Accounts

API VersionRoot Endpoint URL
API v1.0https://api.wealthtechs.com/v1/Accounts
API v2.0https://api.wealthtechs.com/v2/odata/Accounts
Key ChangesAPI v1.0 KeyAPI v2.0 Key
No ChangescustodianIdCustodianId
No ChangesaccountStatusAccountStatus
No ChangesprimaryContactPrimaryContact
No ChangesdateOpenedDateOpened
RenamedmstrAcctMaster
RenamedaccountIDNumber
RenamedaccountTitleLine1Name
RenamedacctTypeAccountType
RenamedmailingAddressLine1MailingAddress
RenamedaccountMailingCityMailingCity
RenamedacctMailZipMailingZipCode
RenamedacctMailingCtryCodeMailingCountry
RenamedemailAddressEmail
RenamedphoneNBRPhone
RenamedbusinessPhBusinessPhone
JoinedcurrencyCurrency.Alpha2Code
DeletedmasterAccountName
DeletedbusinessDate
DeletedaccountTitleLine2
DeletedaccountTitleLine3
DeletedacctRegis
DeletedtxpryrTitle
DeletedtaxpayerFirstName
DeletedtaxpayerMiddleName
DeletedtaxpayerLastName
DeletedaliasName
DeletedmailingAddressLine2
DeletedmailingAddressLine3
DeletedmanagedAccountMoneyManager
DeletedmanagedAccountInvestmentStrategy
DeletedcorporateTaxStatus
Deletedacst
Accessing Updated & Removed Keys with OData Protocol
'https://api.wealthtechs.com/v2/odata/Accounts?&$expand=Currency($select=Alpha2Code)&$select=custodianID,Master,Number,Name,accountStatus,accountType,primaryContact,mailingAddress,MailingCity,MailingZipCode,MailingCountry,Email,phone,bussinesPhone,dateOpened'									

🔀 Custodians

API VersionRoot Endpoint URL
API v1.0https://api.wealthtechs.com/v1/Custodians
API v2.0https://api.wealthtechs.com/v2/odata/Custodians
Key ChangesAPI v1.0 KeyAPI v2.0 Key
No ChangesidId
No ChangesnameName
Deletedstatus
DeletedaccountActiveCount
DeletedaccountMissingCount
DeletedaccountClosedCount
Deletedamount
DeleteddeliveryMethod
DeleteddeliverySubMethod

🔀 FxRates

API VersionRoot Endpoint URL
API v1.0https://api.wealthtechs.com/v1/FxRates
API v2.0https://api.wealthtechs.com/v2/odata/FxRates
Key ChangesAPI v1.0 KeyAPI v2.0 Key
JoinedcurrencyLocalCurrency.Alpha2Code
JoinedbaseCurrencyBaseCurrency.Alpha2Code
RenamedpriceFactor
Accessing Updated & Removed Keys with OData Protocol
'https://api.wealthtechs.com/v2/odata/FxRates?&$expand=LocalCurrency($select=Alpha2Code)&$expand=BaseCurrency($select=Alpha2Code)&$select=Factor'									

🔀 Positions

API VersionRoot Endpoint URL
API v1.0https://api.wealthtechs.com/v1/Positions
API v2.0https://api.wealthtechs.com/v2/odata/Positions
Key ChangesAPI v1.0 KeyAPI v2.0 Key
No ChangesorigCotDateOrigCotDate
No ChangesquantityQuantity
No ChangesoriginalCostOriginalCost
No ChangesoriginalFaceOriginalFace
JoinedportfolioCodeAccount.Number
JoinedsymbolSecurity.PrimarySymbol
MappingtypeSecurity.SecurityType.Code + Security.Currency.Alpha2Code
RenamedtransactionCodeShortPosition
RenamedtradeDateProcessDate
RenamedtradeAmountMarketValue
Deletedcomment
DeletedsettlementDate
Values Mapping
FieldAPI v1.0 ValueAPI v2.0 Value
ShortPosition‘SI’TRUE
ShortPosition‘LI’FALSE
Accessing Updated & Removed Keys with OData Protocol
'https://api.wealthtechs.com/v2/odata/Positions?$expand=Security($select=PrimarySymbol;$expand=SecurityType($select=Code)&$expand=Currency($select=Alpha2Code))&$expand=Account($select=Number)&$select=ShortPosition,ProcessDate,Quantity,MarketValue,OriginalCostDate,OriginalCost,OriginalFace'					

🔀 Prices

API VersionRoot Endpoint URL
API v1.0https://api.wealthtechs.com/v1/Prices
API v2.0https://api.wealthtechs.com/v2/odata/Prices
Key ChangesAPI v1.0 KeyAPI v2.0 Key
JoinedsymbolSecurity.PrimarySymbol
MappingtypeSecurity.SecurityType.Code + Security.Currency.Alpha2Code
RenamedpricePriceValue
Accessing Updated & Removed Keys with OData Protocol
'https://api.wealthtechs.com/v2/odata/Prices?$expand=Security($select=PrimarySymbol;$expand=SecurityType($select=Code)&$expand=Currency($select=Alpha2Code))&$select=PriceValue'									

🔀 TaxLots

API VersionRoot Endpoint URL
API v1.0https://api.wealthtechs.com/v1/TaxLots
API v2.0https://api.wealthtechs.com/v2/odata/TaxLots
Key ChangesAPI v1.0 KeyAPI v2.0 Key
No ChangestradeDateTradeDate
No ChangesquantityQuantity
No ChangesoriginalCostOriginalCost
No ChangesoriginalFaceOriginalFace
JoinedportfolioCodeAccount.Number
JoinedsymbolSecurity.PrimarySymbol
MappingtypeSecurity.SecurityType.Code + Security.Currency.Alpha2Code
RenamedtransactionCodeShortPosition
RenamedorigCostDateOriginalCostDate
RenamedtradeAmountAmount
Deletedcomment
Values Mapping
FieldAPI v1.0 ValueAPI v2.0 Value
ShortPosition‘SI’TRUE
ShortPosition‘LI’FALSE
Accessing Updated & Removed Keys with OData Protocol
'https://api.wealthtechs.com/v2/odata/TaxLots?$expand=Security($select=PrimarySymbol;$expand=SecurityType($select=Code)&$expand=Currency($select=Alpha2Code))&$expand=Account($select=Number)&$select=ShortPosition,TradeDate,Quantity,Amount,OriginalCostDate,OriginalCost,OriginalFace'

🔀 Transactions

API VersionRoot Endpoint URL
API v1.0https://api.wealthtechs.com/v1/Positions
API v2.0https://api.wealthtechs.com/v2/odata/Transactions
Key ChangesAPI v1.0 KeyAPI v2.0 Key
No ChangescommentComment
No ChangestradeDateTradeDate
No ChangessettlementDateSettlementDate
No ChangesquantityQuantity
No ChangesoriginalCostOriginalCost
No ChangesexchangeFeeExchangeFee
No ChangescommissionCommission
No ChangesbrokerBroker
No ChangesotherFeesOtherFees
No ChangeswhtTypeWhtType
No ChangeswhtSymbolWhtSymbol
No ChangesexecPriExecPri
No ChangesexecPriCalcExecPriCalc
JoinedportfolioCodeAccount.Number
JoinedtransactionCodeTransactionCode.Code
JoinedsymbolSecurity.PrimarySymbol
MappingtypeSecurity.SecurityType.Code + Security.Currency.Alpha2Code
RenamedorigCostDateOriginalCostDate
RenamedsrcDesTypeSdType
RenamedsrcDesSymbolSdSymbol
RenamedtradeAmountAmount
DeletedtrDateFX
DeletedsetDateFX
DeletedimpComm
DeletedcommissionPurpose
Deletedpledge
DeletedlotLocation
DeletedoriginalFace
Deletedpost
DeletedperfCont
Values Mapping
FieldAPI v1.0 ValueAPI v2.0 ValueNotes
WhtType‘WhtType’‘WhtSecurityId’For WHT Transactions, you need to join with Securities to identify the type of the security related to the tax.
WhtSymbolWhtSymbol’‘WhtSecurityId’For WHT Transactions, you need to join with Securities to identify the security related to the tax.
Accessing Updated & Removed Keys with OData Protocol
'https://api.wealthtechs.com/v2/odata/Transactions?$expand=Security($select=PrimarySymbol;$expand=SecurityType($select=Code)&$expand=Currency($select=Alpha2Code))&$expand=Account($select=Number)&$expand=TransactionCode($select=Code)&$select=Comment,TradeDate,SettlementDate,Quantity,Sdtype,Sdsymbol,Amount,ExchangeFee,Commission,Broker,OtherFees,OriginalCostDate,OriginalCost,ExecPri,ExecPriCalc'									

🔀 Vehicles

API VersionRoot Endpoint URL
API v1.0https://api.wealthtechs.com/v1/Vehicles
API v2.0https://api.wealthtechs.com/v2/odata/Securities
Key ChangesAPI v1.0 KeyAPI v2.0 Key
No ChangesidId
No ChangesprimarySymbolPrimarySymbol
No ChangescusipCusip
No ChangessedolSedol
No ChangesisinIsin
No ChangestickerTicker
JoinedtypeSecurityType.Code
JoinedcurrencyCurrency.Alpha2Code
JoinedprimaryTypeSecurityType.MajorAssetClass.PrimaryTypeCode
JoinedmajorAassetClassSecurityType.MajorAssetClass.Name
Renameddescription1Description
Deletedcins
Deleteddescription2
Deleteddescription3
Deleteddescription4
Deleteddescription5
DeleteddinorAssetClass
DeletedminorAssetClass
DeletedcountryOfIssue
DeletedtradeCurrency
DeletedissueCurrency
DeletedriskCurrency
DeletedsnpRating
DeletedmoodyRating
DeletedexDividendDate
DeletedrecordDate
DeleteddividendRate
DeletedpayableDate
DeletedaccrualCalendar
DeletedmaturityCurrency
DeletedvariableRate
DeletedissueDate
DeleteddatedDate
DeletedmaturityDate
DeletedannualRate
DeletedyieldToMaturity
DeletedincomeFrequency
DeletedfirstInterestPaymentDate
DeletedcallPut1
DeletedcallPut1Date
DeletedcallPut1Price
DeletedcallPut2
DeletedcallPut2Date
DeletedcallPut2Price
DeletedcallPut3
DeletedcallPut3Date
DeletedcallPut3Price
DeletedcurrentAmortizationFactorDate
DeletedcurrentAmortizationFactor
DeletedpreviousAmortizationFactorDate
DeletedpreviousAmortizationFactor
DeletedprePreviousAmortizationFactorDate
DeletedprePreviousAmortizationFactor
DeletedgnmapoolNumber
DeletedunpricedIndicator
DeletedoptionExpirationDate
DeletedoptionStrikePrice
DeletedoptionCallPutIndicator
DeletedsecurtiesClearingCorpCode
DeletedfinalPaymentDate
DeletedsecondInterestPaymentDate
DeletedthirdInterestPaymentDate
DeletedfourthInterestPaymentDate
DeleteddiscountZeroCouponOid
DeletedprimaryExchange
DeleteddtcCode
DeletedfundFamily
DeletedcouponDelay
DeletedbondType
DeletedshareMultiplier
DeletednextDividendAmount
DeletedfederalTax
DeletedbondFactor
DeletedforeingCode
DeletedworthlessCode
DeletedmarginCode
DeletedfactDate
DeletedcusipUnderlyingSecurity
DeletedrefundType
Deletedtaxable
DeletedoriginalIssueDiscount
Deletedduration
DeletedmadatoryRedemptionDate
DeletedprerefundingDate
DeletedprerefundingPrice
DeletedaverageLife
Accessing Updated & Removed Keys with OData Protocol
'https://api.wealthtechs.com/v2/odata/Securities?$expand=SecurityType($select=Code)&$expand=Currency($select=Alpha2Code)&$expand=Sector($select=Name)&$select=Id,PrimarySymbol,Cusip,Sedol,Isin,Ticker,Description,Industry'