SLslopesoftware
ScenarioTables

Create a scenario table using an existing file.

The excel sheet name field is required for excel files and the delimiter field, which defaults to a comma if not set, is required for non-excel files. <br/>The row limit is 150,000 for excel files and 2 million for csv files. <br/>To avoid request timeouts on large files, set validateFile to false to skip validation on upload; the file will then be validated when a projection is run.

post/api/v1/ScenarioTables

Request

Request body

fileIdinteger nullable

File ID

filePathstring nullable

File Path

fileVersioninteger nullable

File Version

delimiterstring nullable

Delimiter

excelSheetNamestring nullable

Excel Sheet Name

modelIdinteger

Model ID

namestring required

Scenario Table Name

startDatestring required

Scenario Start Date

yieldCurveRateType'BondEquivalent' | 'AnnualEffective' | 'SpotRate'
shortTermInterpolationMethod'AnnualEffectiveRate' | 'FromZero'
validateFileboolean nullable

Validate the uploaded file. Defaults to true. Set to false to skip validation on upload and avoid request timeouts for large files; the file will instead be validated when a projection is run.

Response

OK

idinteger

Scenario Table ID

modelIdinteger

Model ID

namestring nullable

Scenario Table Name

startDatestring date-time

Start Date

filePathstring nullable

File Path

versioninteger

Version

Changes

No recorded changes to this operation across all 1 revision of this API.