The City Platform allows organizations to automatically pull in position and balance information from their existing back office systems. To do so, organizations can utilize either the City API or the platform's built-in support for SunGuard's Stream GMI.
Account Reconciliation with SunGuard's Stream GMI
To pull in data from Stream GMI, an organization must publish three files to an SFTP server and provide the City Platform with the details for accessing these files.
The required files and columns are documented below.
|Positions||POFFIC, PACCT, PSDSC1, PFC, PSUBTY, PEXPDT, PSTRIK, PQTY, PBS, PTPRIC, PEXCH|
|Transactions||PRECID, POFFIC, PACCT, PSDSC1, PCARD, PFC, PSUBTY, PEXPDT, PCTYM, PSTRIK, PQTY, PBS, PTPRIC, PTDATE, PEXCH|
|Balances||MOFFIC, MACCT, MATYPE, MBAL, MLQVAL, MTAR, MWF, MFIR, MME, MOTE, MMTDC, MEIR, MEMR, MPREM, MUNUPL, MTE|
|Customers (optional)||YSNAME, YOFFIC, YACCT|
The columns can appear in any order. The City Platform can identify the columns either by including a header row with the names referenced above, or columns can be manually mapped under Trading Groups / Trading Group / GMI Columns.
Account Reconciliation with the City API
To update the City Platform using the City API, an organization will need to make use of two distinct API calls:
- To update an account's position, the organization will need to POST a reference position snapshot to
/refpositions. Documentation for this endpoint can be found here.
- To update an account's balances, the organization will need to POST the balances to
/accounts/:id/moneyvals. Documentation for this endpoint can be found here.
- To update an account's transactions, the organization will need to POST the transactions to
/transactions. Documentation for this endpoint can be found here.
Force Account Synchronization
If the account syncs with files provided via an FTP, that sync automatically occurs every 30 minutes. Additionally, once a file is processed, it won't ever be processed again. If an organization would like to have the most recently provided files processed immediately, even if they have already been processed, the organization can use the Force Sync functionality.
To do so, navigate to the Trading Groups section of the website and select the applicable trading group (the trading group with the FTP you would like to sync). In the trading group, press the Force Sync button to have the system (re)process the FTP files immediately.