Create import job

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 job imports data into the Intelligent Risk Platform usually from data uploaded to an import folder.

CEDE Import Job

A CEDE import job 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, 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 an EDM 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, a name for the new EDM, and the ID of a database server.

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

🍊

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 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

A MRI import job 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

A OED import job 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

An RDM import job 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-EXPOSUREIQ RI-RISKMODLER RI-UNDERWRITEIQ

Risk Source Import Job

An RISK_SOURCE import job imports loss table data (ELT) 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"
  }
}

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