Creates an import job.

An import job ingests data into the Intelligent Risk Platform.

This operation supports the creation of the following types of import jobs: CEDE, EDM, EXPOSURE_BULK_EDIT, EXPOSURE_RESOURCE, EXPOSURE_VARIATION, MRI, OED, RDM_DATABRIDGE RDM, RISK_SOURCE.

Each import type imports exposure or results data into an Intelligent Risk Platform resource (e.g. EDM). Most of these import types import data that was previously uploaded to an import folder.

CEDE Import Job

The CEDE import import type creates a CEDE_IMPORT job that imports CEDE data uploaded to a CEDE import folder.

CEDE™ (Catastrophe Exposure Data Exchange) is an open-source exposure data schema that is designed to facilitate the exchange of exposure data and development of models for analyzing risk. The CEDE data schema was developed by AIR Worldwide and is used by the Touchstone® risk management platform.

The request specifies the URI of an exposure set, the ID of the import folder on Amazon S3 that contains the uploaded CEDE file, and the ID of a Platform server instance.

{
  "importType": "CEDE",
  "resourceUri": "/platform/riskdata/v1/exposuresets/8888",
  "settings": {
    "folderId": "5678",
    "exposureName": "TEST_CEDE_NEW_2",
    "cedeSchemaVersion": "10.0",
    "serverId": 56
  }
}

🍊

Postman Collection

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

The CEDE Import collection demonstrates a workflow importing CEDE data.

EDM Import Job

An EDM import job imports the database artifact uploaded to an EDM import folder and creates a new EDM on the specified database server.

The request specifies the URI of an exposure set, the ID import folder on Amazon S3 that contains the uploaded database artifact in BAK or MDF format, and the ID of a database server.

{
  "importType": "EDM",
  "resourceUri": "{{new_exposureset_resource_uri}}",
  "settings": {
    "folderId": "1273",
    "exposureName": "TEST_EDM_NEW_2",
    "serverId": 345
  }
}

The request can specify the name of the new EDM or maintain the name of the original database. The preserveName parameter accepts a Boolean value. If true, EDM is imported using the name of the original EDM, i.e. the one uploaded to the import folder. If false or undefined, the exposureName parameter is required.

🍊

Postman Collection

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

The EDM Import collection demonstrates a workflow that imports an EDM.

For step-by-step instructions, see EDM Import.

Exposure Bulk Edit Import Job

An EXPOSURE_BULK_EDIT import type creates a BULK_EDIT job imports exposure data uploaded to an EXPOSURE_BULK_EDIT import folder on Amazon S3.

Large volumes of exposure data may be uploaded to an import folder in JSON format. The EXPOSURE_BULK_EDIT import folder accepts both JSON files and compressed JSON files (GZ).

The request specifies the URI of an exposure set and the ID of an import folder on Amazon S3 that contains the exposure data in JSON format.

{
  "importType": "EXPOSURE_BULK_EDIT",
  "resourceUri": "/platform/riskdata/v1/exposures/555",
  "settings": {
    "folderId": 245
  }
}

Exposure Resource Import Job

An EXPOSURE_RESOURCE import job creates a new exposure (account, aggregate portfolio, or portfolio) resource based on an existing exposure variation.

The newly created exposure is attached to the specific exposure set and stored in a new EDM.

The request specifies the URI of an exposure set, the name of the EDM to create, and the name of exposure variation.

{
  "importType": "EXPOSURE_RESOURCE",
  "resourceUri": "/platform/riskdata/v1/exposuresets/8888",
  "settings": {
    "exposureName": "NEW_EDM_NAME",
    "exposureVariationId": 5555
  }
}

Exposure Variation Import Job

An EXPOSURE_VARIATION import job creates a new exposure variation (account variation, aggregate portfolio variation, or portfolio variation) from a Parquet file uploaded to an import folder on Amazon S3.

An exposure variation is an immutable snapshot of an exposure (portfolio, account, aggregate portfolio) that is stored as a Parquet file in the Exposure Variation Store.

The request specifies the URI of an exposure set, the ID import folder on Amazon S3 that contains the uploaded Parquet file, and, optionally, the ID of a related exposure.

{
  "importType": "EXPOSURE_VARIATION",
  "resourceUri": "/platform/riskdata/v1/exposuresets/8888",
  "settings": {
    "folderId": "35275",
    "exposureResourceId": 12345
  }
}

Exposure variations (v2) can be used in accumulation, ALM, DLM, and HD analysis workflows. To learn more, see Exposure Variation.

MRI Import Job

The MRI import type creates an MRI_IMPORT job that imports MRI data uploaded to an MRI import folder.

Multi-relational import (MRI) is a data migration process that enables Intelligent Risk Platform™ tenants to import exposure data into an EDM.

{
  "importType": "MRI",
  "resourceUri": "/platform/riskdata/v1/exposures/10171/portfolios/1",
  "settings": {
    "folderId": "2954"
  }
}

MRI utilizes flat files of account, location, reinsurance exposure data. A flat file is a delimited text file that stores structured data in a plain text format. MRI leverages a separate mapping file to define the relationships between the account, location, and reinsurance exposures.

🍊

Postman Collection

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

The MRI Import collection demonstrates a workflow importing exposure data using the MRI workflow.

For step-by-step instructions, see MRI Import.

OED Import Job

The OED import type creates an OED_IMPORT job that imports OED data uploaded to a OED import folder.

The OED (Open Exposure Data) schema is an exposure database format defined by OASIS that is serves as an industry standard schema for Oasis LMF-based models.

For step-by-step instructions, see OED Import.

RDM Import Job

The RDM import type creates an IMPORT_RDM job that imports result data uploaded to an RDM import folder.

The Results Data Module (RDM) is a database structure that stores results data (loss estimates and other outputs) during catastrophe modeling.

The request specifies the URI of an exposure set, the ID of the import folder on Amazon S3 that contains the uploaded data artifact in BAK or MDF format, and the name of the RDM.

{
  "importType": "RDM",
  "resourceUri": "/platform/riskdata/v1/exposuresets/8888",
  "settings": {
    "folderId": "35312",
    "rdmName": "RDM_NAME"
  }
}

🍊

Postman Collection

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

The RDM Import collection demonstrates a workflow importing results data.

RDM Data Bridge Import Job

A RDM_DATABRIDGE import job imports an RDM database from a managed server instance on Data Bridge.

🪰

Entitlements

RI-EXPOSUREIQRI-RISKMODLERRI-UNDERWRITEIQ

Risk Source Import Job

The RISK_SOURCE import type creates an IMPORT_RISKSOURCE job that imports loss table data (ELT or PLT) as a risk source from the specified import folder.

A risk source is a representation of risk to a cedant including modeled losses that underlies a program (reinsurance program) or business hierarchy position. The risk source links the program or business hierarchy to EDMs that contain the portfolios or analysis results.

The request specifies the import type, resource URI of a risk source, and import job settings:

{
  "importType": "RISK_SOURCE",
  "resourceUri": "/platform/riskdata/v1/programs/432342",
  "settings": {
    "folderId": "35312",
    "riskSourceName": "Imported ELT data",
    "riskSourceDescription": "Risk source imported from external system",
    "riskSourceType": "ELT",
    "delimiter": "TAB",
    "jobname": "Test Job Name",
    "modelUuid": "550e8400-e29b-41d4-a716-446655440000",
    "currencyCode": "USD"
  }
}

Use the Get ELT Risk Sources and Get PLT Risk Sources operations to view the imported risk sources.

The client must belong to a group that has been assigned the Treaty Underwriter or TreatyIQ Admin role.

🪰

Entitlements

RI-TREATYIQ

/platform/import/v1/jobs, BAK, CEDE, CSV, EDM, EXPOSURE_BULK_EDIT, EXPOSURE_RESOURCE, JSON, , JZ, MDF, MRI, OED, RDM, RDM_DATABRIDGE, RISK_SOURCE, TXT, XLSX, appendLocations, cedeSchemaVersion, createimportjob, deferMetricCalculation, delimiter, folderId, importType, resourceUri, sheets, skipLines