Export data module to file

Exports EDM or RDM data.

The service support three different workflows depending on the type attribute specified in the request body:

  • If the ExposureExportInput type is specified, the service enables you to export exposure data in one EDM to another EDM and optionally download that data as a database artifact.
  • If LocationResultsExportInput type is specified, the service enables you to export and download location results as CSV files.
  • If ResultsExportInputV2 type is specified, the service enables you to export and download results data as BAK or MDF database artifacts or CSV or PARQUET flat files.

The required exportType attribute identifies the database to export (EDM, LOCATION_RESULTS, or RDM), the exportFormat specified the format of the exported data (BAK, CSV, MDF, or PARQUET). Depending on the value jobtype parameter, the service accepts different job-specific parameters in the request body.

Export EDM to EDM

The ExposureExportInput job type supports three scenarios for exporting EDMs. Depending the parameters specified in the request body, the service may export exposure data to a new or existing EDM.

  • If the value of the createNew attribute is true and the value of the destinationDatasource is null or undefined, the service exports exposure data to a temporary database that is deleted at the end of the EDM2EDM job.
  • If the value of the createNew attribute is false and value of the destinationDatasource specifies an existing datasource, the service exports exposure data to an existing managed data source.
  • If the value of the createNew attribute is true and value of the destinationDatasource specifies a unique name for the data source, the service creates a new data source.

Exposure data exported to a new or existing managed data source may be downloaded if the value of the download attribute is true.

{
    "type": "ExposureExportInput",
    "exportType": "EDM",
    "sourceDatasource": "test_edm2edm_changes",
    "destinationDatasource": "test_local_pr_edm_export",
    "exposureType": "PORTFOLIO",
    "exposureIds": [
        1
    ],
    "download": false,
    "createnew": true,
    "exportOptions": {
        "exportAccounts": true,
        "exportLocations": true,
        "exportPolicies": true,
        "exportTreaties": true,
        "exportReinsuranceInfo": true,
        "exportPerilDetailsInfo": true
    },
    "exportFormat": "BAK",
    "sqlVersion": "2019"
}

If successful, returns a 202 Accepted HTTP response and initates a EDM2EDM job on the workflow engine.

Download location results

The LocationResultsExportInput job type enables you to export location results a flat file using the CSV format.

{
    "type" : "LocationResultsExportInput",
    "exportType" : "LOCATION_RESULTS",
    "analysisIds" : [4446, 4447],
    "exportFields" : ["locationId", "locationNumber", "locationName"],
    "perspectives" : ["GR", "GU"],
    "fileName" : "LocationResults"
}

The locationId attribute must be specified in the exportsFields array, if multiple analysis result IDs are specified in the analysisIds array or the workflow engine will return an error.

If successful, returns a 202 Accepted HTTP response and initates a DOWNLOAD_LOCATION_RESULTS job on the workflow engine.

Export RDM as database artifact or flat file

The ResultsExportInputV2 job type supports two scenarios: exporting results data as BAK or MDF database artifacts or exporting results as CSV or PARQUET files.

Export RDM to database artifact

The service enables you to identify a subset of the analysis results stored in an existing cloud-based RDM and export those analysis results to a new RDM instance, which you can then download as a BAK or MDF database artifact. Once downloaded, the RDM can then be imported into an existing on-premise RDM.

{
    "type": "ResultsExportInputV2",
    "analysisIds": [1424,1433,1438],
    "rdmName": "MultiAnalyses",
    "createnew": true,
    "exportType": "RDM",
    "exportFormat": "MDF", 
    "sqlVersion": 2019 
}

If successful, returns a 202 Accepted HTTP response and initates a DOWNLOAD_RDM job on the workflow engine.

Export results to flat file

Alternatively, the service also supports exporting result data as CSV or PARQUET files.

{
    "analysisIds": [
        64605
    ],
    "lossDetails": [
        {
            "lossType": "STATS",
            "outputLevels": [
                "Admin2"
            ],
            "perspectives": [
                "GU"
            ]
        },
        {
            "lossType": "EP",
            "outputLevels": [
                "Admin1"
            ],
            "perspectives": [
                "GU"
            ]
        },
        {
            "lossType": "LOSS_TABLES",
            "outputLevels": [
                "Admin1"
            ],
            "perspectives": [
                "GU"
            ]
        }
    ],
    "exportType": "RDM",
    "type": "ResultsExportInputV2",
    "exportFormat": "CSV",
    "nonWeightedPlt": true,
    "additionalOutputs": []
}

If the exportFormat attribute is set to CSV or Parquet, the service also accepts a Boolean nonWeightedPlt attribute in the request body. If true, HD earthquake EP analysis results are exported as equally-weighted PLTs to CSV or Parquet flat files for download. By default, these results are exported as the weighted PLTs originally generated using the HD Earthquake model. At least one loss table must be specified in the lossDetails array of the request body, or the service returns an error.

If successful, returns a 202 Accepted HTTP response and initates a DOWNLOAD_RESULTS job on the workflow engine.

Language
Authentication
Header
URL