Stored Transformation

Stored transformation detail

Inspect version history, edit inputs, and save a new version without overwriting prior records.

Transformation ID segittur-hotel-input-from-ngsi-building-2

Selected Version v1

Versions 2

Updated 2026-04-23T11:21:31.558482+00:00

Target Stored target schema Switch between manual editing, a persisted schema, and an internal schema, then validate or translate with the selected target schema.

{"type":"object","properties":{"id":{"type":"string"},"type":{"type":"string"},"address":{"type":"object","properties":{"type":{"type":"string"},"value":{"type":["string","null"]},"metadata":{"type":"object"}}},"category":{"type":"object","properties":{"type":{"type":"string"},"value":{"type":"array","items":{"type":"string"}},"metadata":{"type":"object"}}},"dataProvider":{"type":"object","properties":{"type":{"type":"string"},"value":{"type":["string","null"]},"metadata":{"type":"object"}}},"description":{"type":"object","properties":{"type":{"type":"string"},"value":{"type":["string","null"]},"metadata":{"type":"object"}}},"location":{"type":"object","properties":{"type":{"type":"string"},"value":{"type":"object","properties":{"type":{"type":"string"},"coordinates":{"type":"array","items":{"type":"number"}}}},"metadata":{"type":"object"}}},"name":{"type":"object","properties":{"type":{"type":"string"},"value":{"type":["string","null"]},"metadata":{"type":"object"}}},"source":{"type":"object","properties":{"type":{"type":"string"},"value":{"type":["string","null"]},"metadata":{"type":"object"}}},"status":{"type":"object","properties":{"type":{"type":"string"},"value":{"type":["string","null"]},"metadata":{"type":"object"}}},"subCategory":{"type":"object","properties":{"type":{"type":"string"},"value":{"type":["string","null"]},"metadata":{"type":"object"}}}},"required":["id","type"]}

Source Stored input JSON

Hints Hints Retries Max retries Saving from this form creates a new version.

Result Generated jq filter

def v($k): .[$k].value // null; def parsed_address: (v("address") // "") as $a | try (($a | capture("^(?<streetAddress>.*?)[.,]\\s*(?<postalCode>\\d{5})\\s+(?<locality>[^.]+)")) as $m | {streetAddress: ($m.streetAddress | gsub("\\s+$"; "")), postalCode: $m.postalCode, locality: ($m.locality | gsub("\\s+$"; "") | gsub("\\.$"; "")), province: (if ($m.postalCode | startswith("28")) then "Madrid" else null end), autonomousCommunity: (if ($m.postalCode | startswith("28")) then "Comunidad de Madrid" else null end)} | with_entries(select(.value != null))) catch {address: $a}; {id: .id, type: "Hotel", name: v("name")} + (if v("description") != null then {hasDescription: {shortDescription: v("description")}} else {} end) + (if v("address") != null then {hasLocation: parsed_address} else {} end)

Output Transformed output

{
  "hasDescription": {
    "shortDescription": "Aparthotel TH Las Rozas"
  },
  "hasLocation": {
    "autonomousCommunity": "Comunidad de Madrid",
    "locality": "Las Rozas",
    "postalCode": "28230",
    "province": "Madrid",
    "streetAddress": "Camino Viejo de Madrid, 38"
  },
  "id": "building:hoteles.ayto-xlsx.141",
  "name": "Aparthotel TH Las Rozas",
  "type": "Hotel"
}