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.
To enable these commands, an IT admin first creates a VTS connector.
Deals export
To export deals as JSON from the VTS API, use a Deals export command.
Properties
| Property | 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
To export portfolio as JSON from VTS API, use a Portfolio export command.
Properties
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 |