Property description

The mappings property determines how ingested data is stored, specifying which object types and attributes the data will be assigned to.

Minimal JSON

{
  "queryKey": "",
  "objectTypeKey": "",
  "mapping": [
    {
      "fieldKey": "",
      "attributeTypeKey": ""
    }
  ]
}
{
  "applicationKey": "app",
  "mappings": [
    {
      "queryKey": "database",
      "objectTypeKey": "database",
      "mapping": [
        {
          "fieldKey": "description",
          "attributeTypeKey": "core_description_scanned"
        }
      ]
    }
  ]
}

Example taken from the core_sql_server package.

Nested properties

PropertyDescriptionValuesMandatory
queryKeyKey of the query created in data source definitions.stringYes
objectTypeKeyKey of the object type that the ingested table corresponds to. Each database row will be created as an instance of this object type.stringYes
mappingArray of definitions that map database columns to attribute types within the object type. Each mapping includes: fieldKey: The table column that contains the attribute value., attributeTypeKey: The corresponding attribute type in Dawiso where the value will be stored.arrayYes