Create export job

post

https://{host}/platform/export/v1/jobs/

This resource supports the definition and submission of the different types of export jobs: EDM, EXPOSURE_RESOURCE, EXPOSURE_VARIATION. LOCATION_RESULTS, RDM_DATABRIDGE, RDM, RESULTS, ROLLUP_RESULTS.

The request specifies the exportType, the resource URI of the data to be exported, and other job-specific settings. Depending on the export type, the job may support exporting exposure or result data to a flat file or database artifact.

Export Type	Format	Description
`EDM`	BAK, MDF	Exports EDM to database artifact.
`EXPOSURE_RESOURCE`	Parquet	Exports exposure to flat file.
`EXPOSURE_VARIATION`	Parquet	Exports exposure variation to flat file.
`LOCATION_RESULTS`	CSV	Exports results to flat file.
`RDM`	BAK, MDF	Exports results data to database artifact.
`RDM_DATABRIDGE`		Exports results to RDM on Data Bridge.
`RESULTS`	CSV, Parquet	Exports results data to flat file.
`ROLLUP_RESULTS`	CSV, Parquet	Exports rollup results data to flat file.

If the request is successful, returns a 201 Created HTTP response and adds an export job of the specified job type to the queue. Use the Get Export Job operation to poll the status of the export job.

EDM

The EDM export type creates a DOWNLOAD_EDM job that exports the specified exposure data (accounts, portfolios, or aggregate portfolios) from the specified EDM (resourceUri) to a downloadable on-premise EDM as a database artifact (BAK or MDF).

{
  "exportType": "EDM",
  "resourceType": "exposure",
  "settings": {
    "fileExtension": "BAK",
    "sqlVersion": "2019",
    "filters": {
      "exposureResourceType": "ACCOUNTS",
      "exposureResourceIds": [555, 556, 557]
    },
    "fileName": "myEDM"
  },
  "resourceUri": "/platform/riskdata/v1/exposures/5555"
}

The optional filters parameter selects the exposures to be exported by exposure type (e.g. ACCOUNTS, PORTFOLIOS, AGGREGATEPORTFOLIOS ) and ID number. If unspecified, all exposure data in the EDM (resourceUri) is exported.

The schemaVersion parameter specifies the database schema version of the exported EDM. The schemaVersion parameter accepts the following values: v18, v21, v22, v23, v24, v25.

📷
End of SQL Server 2016 Support
Microsoft plans to end extended support of SQL Server 2016 on July 14, 2026. As a result, the Intelligent Risk Platform™ will end support for SQL Server 2016 in June 2026. This change may affect Export API jobs that export data to EDM or RDM databases.

Exposure Resources

The EXPOSURE_RESOURCE export type creates a DOWNLOAD_EXPOSURE_RESOURCE job that exports a single account or portfolio exposure to a flat file in Parquet format.

{
  "exportType": "EXPOSURE_RESOURCE",
  "resourceType": "account",
  "settings": {
    "fileExtension": "PARQUET",
    "fileName": "myFile"
  },
  "resourceUri": "/platform/riskdata/v1/exposures/23/accounts/555"
}

If successful, the request creates a new DOWNLOAD_EXPOSURE_RESOURCE job and returns a 201 Created HTTP Status code. The Location header parameter returns the URL of DOWNLOAD_EXPOSURE_RESOURCE job that can be used to poll the status of the job, and download the file when the job is finished.

🍊 Postman Collection

Moody's Insurance Solutions makes Postman Collections available to licensed tenants for download from the RMS Developers public workspace.

The Export EXPOSURE_RESOURCE collection demonstrates a workflow that creates a job that exports exposure data to a flat file in Parquet format.

Exposure Variations

An EXPOSURE_VARIATION export type creates a DOWNLOAD_EXPOSURE_VARIATION job that exports an exposure variation as a downloadable flat file in Parquet format.

An exposure variation is a snapshot of an account, aggregate portfolio,or portfolio exposure. Variations enable tenants to better manage exposure data by ensuring that analyses, reports, and data exports accurately reflect the state of an exposure. This operation supports exporting three types of exposure variations: accountVariation, aggregatePortfolioVariation, portfolioVariation.

The request specifies the export type, the resource type, the resource URI of the exposure variation to export, and settings object that defines job-specific configurations:

{
  "exportType": "EXPOSURE_VARIATION",
  "resourceUri": "/platform/riskdata/v1/exposurevariations/3233774",
  "resourceType": "portfolioVariation",
  "settings": {
    "fileExtension": "parquet",
    "fileName": "my_variation_export_1",
    "schemaVersion": "v23"
  }
}

If successful, the request creates a new DOWNLOAD_EXPOSURE_VARIATION job and returns a 201 Created HTTP Status code. The Location header parameter returns the URL of DOWNLOAD_EXPOSURE_VARIATION job that can be used to poll the status of the job, and download the file when the job is finished.

Location Results

The LOCATION_RESULTS export type enables you to export location-level analysis results to a flat file in CSV format.

{
  "exportType": "LOCATION_RESULTS",
  "resourceType": "analyses",
  "settings": {
    "fileExtension": "CSV",
    "exposureFields": ["apZone", "areaUnit", "basinName", "biZone"],
    "perspectiveCodes": ["C0", "GR"],
    "fileName": "myCsvFile"
  },
  "resourceUris": [
    "/platform/riskdata/v1/analyses/555",
    "/platform/riskdata/v1/analyses/556",
    "/platform/riskdata/v1/analyses/557"
  ]
}

The number of analysis results that can be exported in a single request depends on the entitlement assigned to the client.

RI-UNDERWRITEIQ: Up to 100 analysis results can be exported.
RI-EXPOSUREIQ or RI-MODELER: Up to 15 analysis results can be exported.

Adds a DOWNLOAD_LOCATION_RESULTS export job to the queue.

🍊
Postman Collection
Moody's Insurance Solutions makes Postman Collections available to licensed tenants for download from the RMS Developers public workspace.
The Export LOCATION_RESULTS Export collection demonstrates a workflow that exports analysis results data to a flat file in CSV format.

RDM

The RDM export type creates a DOWNLOAD_RDM job that exports the specified result data to an RDM (result data module) as a database artifact (BAK or MDF).

A maximum of 100 analysis results can be exported in a single request.

{
  "exportType": "RDM",
  "resourceType": "analyses",
  "settings": {
    "fileExtension": "BAK",
    "sqlVersion": "2019",
    "rdmName": "rdm_327993",
    "exportHdLossesAs": "ELT",
    "lossDetails": [
      {
        "metricType": "STATS",
        "outputLevels": ["Policy", "Location"]
      },
      {
        "metricType": "EP",
        "outputLevels": ["Portfolio", "Account"]
      },
      {
        "metricType": "LOSS_TABLES",
        "outputLevels": ["Geographic", "Facultative"]
      }
    ]
  },
  "resourceUris": [
    "/platform/riskdata/v1/analyses/555",
    "/platform/riskdata/v1/analyses/556",
    "/platform/riskdata/v1/analyses/557",
    "/platform/riskdata/v1/analyses/558",
    "/platform/riskdata/v1/analyses/559"
  ]
}

The optional loss Details parameter specifies the metricType (EP, STATS, LOSS_TABLES) to export and the output level (granularity) of exported result data: Account, Facultative, Geographic, Policy, Location, Portfolio.

If successful, the request creates a new DOWNLOAD_RDM job and returns a 201 Created HTTP Status code. The Location header parameter returns the URL of DOWNLOAD_RDM job that can be used to poll the status of the job, and download the file when the job is finished.

📷
End of SQL Server 2016 Support
Microsoft plans to end extended support of SQL Server 2016 on July 14, 2026. As a result, the Intelligent Risk Platform™ will end support for SQL Server 2016 in June 2026. This change may affect Export API jobs that export data to EDM or RDM databases.

🍊
Postman Collection
Moody's Insurance Solutions makes Postman Collections available to licensed tenants for download from the RMS Developers public workspace.
The Export RDM Export collection demonstrates a workflow exporting RDM data.

RDM Data Bridge

The RDM_DATABRIDGE export type creates a DOWNLOAD_RDM job that exports analysis result data to a new or existing managed RDM database on Data Bridge.

Data Bridge is a data integration service that enables Intelligent Risk Platform tenants to transfer data between cloud-based and on-premise risk modeling systems. Moody’s Insurance Solutions exposure and results data uploaded to Data Bridge may be accessed and processed by applications like Risk Modeler running on Risk Intelligence™

Result data is exported to an existing RDM if the request specifies the serverId and databaseId in the settings object of the request. A maximum of 100 analysis results can be exported in a single request.

Depending on the parameters specified in the request, data can be exported to a new or existing RDM database.

To export to an existing RDM on Data Bridge, the request must specify the ID of the managed server instance and the ID of the RDM database:

{
  "exportType": "RDM_DATABRIDGE",
  "resourceType": "analyses",
  "settings": {
    "rdmName": "RDM",
    "serverId": 67,
    "databaseId": 9999,
    "exportHdLossesAs": "ELT"
  },
  "resourceUris": [
    "/platform/riskdata/v1/analyses/555",
    "/platform/riskdata/v1/analyses/556",
    "/platform/riskdata/v1/analyses/557"
  ]
}

📷
Note
Whenever result data is exported to an existing RDM, the database schema version of that RDM will be automatically updated to the latest version of the RDM database schema.

To export to a new RDM on Data Bridge, the request must specify the serverId and name parameters in the settings object of the request.

{
  "exportType": "RDM_DATABRIDGE",
  "resourceType": "analyses",
  "settings": {
    "rdmName": "rdm_export",
    "serverId": 88094,
    "exportHdLossesAs": "ELT",
    "schemaVersion": "v18"
  },
  "resourceUris": [
    "/platform/riskdata/v1/analyses/555",
    "/platform/riskdata/v1/analyses/556",
    "/platform/riskdata/v1/analyses/557"
  ]
}

The optional schemaVersion parameter can be specified when result data is exported to a new RDM on Data Bridge. The schemaVersion parameter accepts the following values: v18, v21, v22, v23, v24, v25.

If successful, the request creates a new DOWNLOAD_RDM_DATABRIDGE job and returns a 201 Created HTTP Status code. The Location header parameter returns the URL of DOWNLOAD_RDM_DATABRIDGE job that can be used to poll the status of the job, and download the file when the job is finished.

🍊
Postman Collection
Moody's Insurance Solutions makes Postman Collections available to licensed tenants for download from the RMS Developers public workspace.
The Export RDM_DATABRIDGE Export collection demonstrates a workflow that exports analysis data to an existing RDM on Data Bridge.

📷
End of SQL Server 2016 Support
Microsoft plans to end extended support of SQL Server 2016 on July 14, 2026. As a result, the Intelligent Risk Platform™ will end support for SQL Server 2016 in June 2026. This change may affect Export API jobs that export data to EDM or RDM databases.

Results

The RESULTS export type creates a DOWNLOAD_RESULTS job that exports analysis result data (loss tables, EP metrics, and statistics) to a flat file in CSV or PARQUET format.

Following one or more HD, DLM, ALM analysis, you can export the metadata, EP, stats, event loss table, period loss table, hazard data, damage data, and uncertainty data as files for manipulation outside of Risk Modeler.

For treaty losses, export of catastrophe (CATA), corporate catastrophe (CORP), stop loss (STOP), and per-risk treaty losses are supported for DLM, ALM, and HD results, but export of facultative losses is available for HD results only.

A single analysis result can be exported.

{
  "exportType": "RESULTS",
  "resourceType": "analyses",
  "settings": {
    "fileExtension": "CSV",
    "additionalOutputs": ["DAMAGE", "HAZARD", "UNCERTAINTY"],
    "lossDetails": [
      {
        "metricType": "STATS",
        "outputLevels": ["Cresta"]
      }
    ],
    "nonWeightedPlt": true
  },
  "resourceUris": ["/platform/riskdata/v1/analyses/555"]
}

The table identifies the metrics that can be exported by analysis type:

Metric Type	HD EP	HD Non-EP	DLM EP	DLM Non-EP	ALM EP	ALM Non-EP
`DAMAGE`	X	X	X	X	X	X
`EP`	X		X		X
`HAZARD`		X
`LOSS_TABLES`	X	X	X	X	X	X
`STATS`	X	X	X		X
`UNCERTAINTY`	X	X

If successful, the request creates a new DOWNLOAD_RESULTS job and returns a 201 Created HTTP Status code. The Location header parameter returns the URL of DOWNLOAD_RESULTS job that can be used to poll the status of the job, and download the file when the job is finished.

🍊
Postman Collection
Moody's Insurance Solutions makes Postman Collections available to licensed tenants for download from the RMS Developers public workspace.
The Export RESULTS Export collection demonstrates a workflow that exports analysis results to a flat file in Parquet format.

Rollup analysis results

The ROLLUP_RESULTS export type creates a DOWNLOAD_ROLLUP_RESULTS job that exports rollup analysis results to a downloadable flat file in CSV or PARQUET format.

A rollup analysis computes marginal EP curves, calculates gross and net portfolio position metrics, and breakdowns by segment for each hierarchy node in the portfolio. Rollup results include loss tables, EP curves, and statistics (aal, stddev, cv ).

This operation enables the client to export EP, PLT, or STATS for the specified analysis. Within each export loss type, data can be filtered by position or "broken down".

Exported analysis data may be segmented or unsegmented.

{
  "exportType": "ROLLUP_RESULTS",
  "resourceType": "analyses",
  "settings": {
    "fileExtension": "PARQUET",
    "lossDetails": {
      "ep": {
        "includeSegmented": true,
        "includeUnSegmented": true,
        "positionTypes": ["PROGRAM", "CONTRACT_SUBJECT", "GROSS"]
      }
    }
  },
  "resourceUris": ["/platform/riskdata/v1/analyses/555"]
}

The request can export EP, STATS, or PLT data.

Data can filtered by positionType. The following position types are supported: ASSUMED, CEDED, CONTRACT, CONTRACT_ASSUMED, CONTRACT_SUBJECT, GROSS, NET, NODE, PROGRAM, RETRO_CONTRACT, and RETRO_CONTRACT_SUBJECT.

If successful, the request creates a new DOWNLOAD_ROLLUP_RESULTS job and returns a 201 Created HTTP Status code. The Location header parameter returns the URL of DOWNLOAD_ROLLUP_RESULTS job that can be used to poll the status of the job, and download the file when the job is finished.

🪰
Entitlements
Depends on export type: RI-DATABRIDGE ∙ RI-EXPOSUREIQ ∙ RI-RISKMODLER ∙ RI-TREATYIQ ∙ RI-UNDERWRITEIQ

Language

Credentials

URL

Create export job

EDM

📷
End of SQL Server 2016 Support

Exposure Resources

Exposure Variations

Location Results

🍊
Postman Collection

RDM

📷
End of SQL Server 2016 Support

🍊
Postman Collection

RDM Data Bridge

📷
Note

🍊
Postman Collection

📷
End of SQL Server 2016 Support

Results

🍊
Postman Collection

Rollup analysis results

🪰
Entitlements

EDM

📷End of SQL Server 2016 Support

Exposure Resources

Exposure Variations

Location Results

🍊Postman Collection

RDM

📷End of SQL Server 2016 Support

🍊Postman Collection

RDM Data Bridge

📷Note

🍊Postman Collection

📷End of SQL Server 2016 Support

Results

🍊Postman Collection

Rollup analysis results

🪰Entitlements

📷
End of SQL Server 2016 Support

🍊
Postman Collection

📷
End of SQL Server 2016 Support

🍊
Postman Collection

📷
Note

🍊
Postman Collection

📷
End of SQL Server 2016 Support

🍊
Postman Collection

🪰
Entitlements