To export portfolio and deal data from View the Space® (VTS®) into a common standard comma-separated values (CSV) format as part of a chain, add a step that includes a VTS connection command. You can then use the output with an array of cloud and on-premise technologies, such as:
- Anaplan®
- IBM® Planning Analytics
- Oracle® PBCS and EPBCS
Connection Properties
To enable these commands, an IT admin first creates a VTS Connector connection and configures its credentials and properties. The connection interacts with VTS via the published REST API, and doesn't require anything specialized except connectivity to the respective service.
| Input | Detail |
| API Key | Enter the VTS API key |
| API Secret | Enter the VTS API secret |
Note: All sensitive credentials are automatically encrypted and stored at 2,048-bit encryption.
Deals Export
Exports deals as JSON from the VTS API
Inputs
| Input | Detail |
| Deal ID | Enter the ID of the VTS deal. To extract all deals in the environment, leave blank. |
| Date | Enter the modification start date of the deals to return, in a YYYY-MM-DD format (optional). The command returns deals that were last modified after this date. |
| Deal Stage | Select the stage of the deal to return (optional) |
Outputs
| Output | Output Type |
| Deals File Path | File |
| Deals Properties File Path | File |
| Properties File Path | File |
| Property Spaces File Path | File |
| Tenant Contracts File Path | File |
| Brokers File Path | File |
| Deal Stages File Path | File |
| Deal Comments File Path | File |
| Deal Terms File Path | File |
| Budgets File Path | File |
| Appraisals File Path | File |
| Tenant Improvements File Path | File |
| Building Improvements File Path | File |
| Free Rents File Path | File |
| Base Rents File Path | File |
| Rent Escalations File Path | File |
| Other Credits File Path | File |
| Commissions File Path | File |
Exit Codes
| Code | Type | Detail |
| 0 | Success | Success |
| 1 | Error | General failure |
| 10 | Error | Error from the VTS API |
| 20 | Warning | Exited with warning |
Portfolio Export
Exports portfolio as JSON from VTS API
Inputs
None
Outputs
| Output | Output Type |
| Office Parks File Path | File |
| Properties File Path | File |
| Spaces File Path | File |
| Floors File Path | File |
| Leases File Path | File |
| Portfolio Rights File Path | File |
| Deal Terms File Path | File |
| Base Rents File Path | File |
| Free Rents File Path | File |
| OpExes File Path | File |
| Real Estate Taxes File Path | File |
| Other Revenues File Path | File |
Exit Codes
| Code | Type | Detail |
| 0 | Success | Success |
| 1 | Error | General failure |
| 10 | Error | Error from the VTS API |
| 20 | Warning | Exited with warning |