Stored Transformation
Stored transformation detail
Inspect version history, edit inputs, and save a new version without overwriting prior records.
{ "input": {object:{externalId:.id,name:{value:.name.value,lang:"es"},hasDescription:{object:{shortDescription:{value:.shortDescription.value,lang:"es"},longDescription:{value:.description.value,lang:"es"},keyword:[.extraInfo.value]}},hasAdditionalType:.category.value,hasLocation:{object:{lat:.location.value.coordinates[1],long:.location.value.coordinates[0],autonomousCommunity:"Comunidad de Madrid",country:"España",municipality:"Las Rozas de Madrid",postalCode:"28290",province:"Madrid"}}}} }
{
"input": {
"object": {
"externalId": "trailroute_lr-01",
"hasAdditionalType": "TrailRoute",
"hasDescription": {
"object": {
"keyword": [
"Encinar"
],
"longDescription": {
"lang": "es",
"value": "Comenzamos"
},
"shortDescription": {
"lang": "es",
"value": "Dificultad: baja"
}
}
},
"hasLocation": {
"object": {
"autonomousCommunity": "Comunidad de Madrid",
"country": "Espa\u00f1a",
"lat": 40.4845294,
"long": -3.8565638,
"municipality": "Las Rozas de Madrid",
"postalCode": "28290",
"province": "Madrid"
}
},
"name": {
"lang": "es",
"value": "Majalacabra"
}
}
}
}
Trace Details
{
"attempts": [
{
"attempt_number": 1,
"compile_ok": true,
"error_message": null,
"execution_ok": true,
"jq_expression": "{object:{externalId:.id,name:{value:.name.value,lang:\"es\"},hasDescription:{object:{shortDescription:{value:.shortDescription.value,lang:\"es\"},longDescription:{value:.description.value,lang:\"es\"},keyword:[.extraInfo.value]}},hasAdditionalType:.category.value,hasLocation:{object:{lat:.location.value.coordinates[1],long:.location.value.coordinates[0],autonomousCommunity:\"Comunidad de Madrid\",country:\"Espa\u00f1a\",municipality:\"Las Rozas de Madrid\",postalCode:\"28290\",province:\"Madrid\"}}}}",
"schema_valid": true,
"stage": "field",
"target_field": "input",
"used_hints": true
},
{
"attempt_number": 1,
"compile_ok": true,
"error_message": null,
"execution_ok": true,
"jq_expression": "{ \"input\": {object:{externalId:.id,name:{value:.name.value,lang:\"es\"},hasDescription:{object:{shortDescription:{value:.shortDescription.value,lang:\"es\"},longDescription:{value:.description.value,lang:\"es\"},keyword:[.extraInfo.value]}},hasAdditionalType:.category.value,hasLocation:{object:{lat:.location.value.coordinates[1],long:.location.value.coordinates[0],autonomousCommunity:\"Comunidad de Madrid\",country:\"Espa\u00f1a\",municipality:\"Las Rozas de Madrid\",postalCode:\"28290\",province:\"Madrid\"}}}} }",
"schema_valid": true,
"stage": "global",
"target_field": null,
"used_hints": true
}
],
"events": [
{
"payload": {
"field_name": "input",
"hint_hash": "b5b2894ce110d4fce77883bcd66aa89fdd2e012dcdf10f71c1e810fcb2c5e301",
"match_result": {
"candidate_source_path": ".",
"confidence": 0.95,
"identified": true,
"reasoning": "The target field \u0027input\u0027 represents the entire input JSON, which matches the root of the source data."
},
"prompt_payload": {
"field_name": "input",
"field_schema": {
"properties": {
"object": {
"properties": {
"externalId": {
"type": "string"
},
"hasAdditionalType": {
"type": "string"
},
"hasDescription": {
"properties": {
"object": {
"properties": {
"keyword": {
"items": {
"type": "string"
},
"type": "array"
},
"longDescription": {
"properties": {
"lang": {
"type": "string"
},
"value": {
"type": "string"
}
},
"type": "object"
},
"shortDescription": {
"properties": {
"lang": {
"type": "string"
},
"value": {
"type": "string"
}
},
"type": "object"
}
},
"type": "object"
}
},
"type": "object"
},
"hasLocation": {
"properties": {
"object": {
"properties": {
"autonomousCommunity": {
"type": "string"
},
"country": {
"type": "string"
},
"lat": {
"type": "number"
},
"long": {
"type": "number"
},
"municipality": {
"type": "string"
},
"postalCode": {
"type": "string"
},
"province": {
"type": "string"
}
},
"type": "object"
}
},
"required": [
"object"
],
"type": "object"
},
"name": {
"properties": {
"lang": {
"type": "string"
},
"value": {
"type": "string"
}
},
"type": "object"
}
},
"type": "object"
}
},
"type": "object"
},
"hints": "Use exactly this jq filter, do not modify it, do not add or remove anything:\r\n\r\n{object:{externalId:.id,name:{value:.name.value,lang:\"es\"},hasDescription:{object:{shortDescription:{value:.shortDescription.value,lang:\"es\"},longDescription:{value:.description.value,lang:\"es\"},keyword:[.extraInfo.value]}},hasAdditionalType:.category.value,hasLocation:{object:{lat:.location.value.coordinates[1],long:.location.value.coordinates[0],autonomousCommunity:\"Comunidad de Madrid\",country:\"Espa\u00f1a\",municipality:\"Las Rozas de Madrid\",postalCode:\"28290\",province:\"Madrid\"}}}}",
"input_summary": {
"path_count": 42,
"paths": [
"alternateName",
"alternateName.metadata",
"alternateName.type",
"alternateName.value",
"category",
"category.metadata",
"category.type",
"category.value",
"dataProvider",
"dataProvider.metadata",
"dataProvider.type",
"dataProvider.value",
"description",
"description.metadata",
"description.type",
"description.value",
"extraInfo",
"extraInfo.metadata",
"extraInfo.type",
"extraInfo.value",
"id",
"location",
"location.metadata",
"location.type",
"location.value",
"location.value.coordinates",
"location.value.coordinates[0]",
"location.value.coordinates[1]",
"location.value.type",
"name",
"name.metadata",
"name.type",
"name.value",
"shortDescription",
"shortDescription.metadata",
"shortDescription.type",
"shortDescription.value",
"source",
"source.metadata",
"source.type",
"source.value",
"type"
],
"root_type": "dict"
},
"output_schema": {
"properties": {
"input": {
"properties": {
"object": {
"properties": {
"externalId": {
"type": "string"
},
"hasAdditionalType": {
"type": "string"
},
"hasDescription": {
"properties": {
"object": {
"properties": {
"keyword": {
"items": {
"type": "string"
},
"type": "array"
},
"longDescription": {
"properties": {
"lang": {
"type": "string"
},
"value": {
"type": "string"
}
},
"type": "object"
},
"shortDescription": {
"properties": {
"lang": {
"type": "string"
},
"value": {
"type": "string"
}
},
"type": "object"
}
},
"type": "object"
}
},
"type": "object"
},
"hasLocation": {
"properties": {
"object": {
"properties": {
"autonomousCommunity": {
"type": "string"
},
"country": {
"type": "string"
},
"lat": {
"type": "number"
},
"long": {
"type": "number"
},
"municipality": {
"type": "string"
},
"postalCode": {
"type": "string"
},
"province": {
"type": "string"
}
},
"type": "object"
}
},
"required": [
"object"
],
"type": "object"
},
"name": {
"properties": {
"lang": {
"type": "string"
},
"value": {
"type": "string"
}
},
"type": "object"
}
},
"type": "object"
}
},
"type": "object"
}
},
"type": "object"
},
"required": false,
"task": "match"
},
"response": "{\"identified\":true,\"candidate_source_path\":\".\",\"reasoning\":\"The target field \u0027input\u0027 represents the entire input JSON, which matches the root of the source data.\",\"confidence\":0.95}",
"system_prompt": "You perform semantic field matching between a target schema field and source JSON paths. Return exactly one flat JSON object and nothing else. Do not wrap the result in markdown. Do not nest the result under keys like match, result, mapping, output, or data. Use exactly these keys: \"identified\", \"candidate_source_path\", \"reasoning\", \"confidence\". \"identified\" must be a JSON boolean. \"candidate_source_path\" must be a string path or null. \"reasoning\" must be a short string. \"confidence\" must be a JSON number between 0.0 and 1.0. If no reliable match exists, return identified=false, candidate_source_path=null, a brief reasoning string, and confidence=0.0. Example valid output: {\"identified\":true,\"candidate_source_path\":\"datetime\",\"reasoning\":\"The source field semantically matches the target date.\",\"confidence\":0.92}",
"used_hints": true
},
"stage": "semantic_match",
"timestamp": "2026-05-20T08:02:30.421335+00:00"
},
{
"payload": {
"field_name": "input",
"hint_hash": "b5b2894ce110d4fce77883bcd66aa89fdd2e012dcdf10f71c1e810fcb2c5e301",
"jq_expression": "{object:{externalId:.id,name:{value:.name.value,lang:\"es\"},hasDescription:{object:{shortDescription:{value:.shortDescription.value,lang:\"es\"},longDescription:{value:.description.value,lang:\"es\"},keyword:[.extraInfo.value]}},hasAdditionalType:.category.value,hasLocation:{object:{lat:.location.value.coordinates[1],long:.location.value.coordinates[0],autonomousCommunity:\"Comunidad de Madrid\",country:\"Espa\u00f1a\",municipality:\"Las Rozas de Madrid\",postalCode:\"28290\",province:\"Madrid\"}}}}",
"prompt_payload": {
"candidate_source_path": ".",
"field_name": "input",
"field_schema": {
"properties": {
"object": {
"properties": {
"externalId": {
"type": "string"
},
"hasAdditionalType": {
"type": "string"
},
"hasDescription": {
"properties": {
"object": {
"properties": {
"keyword": {
"items": {
"type": "string"
},
"type": "array"
},
"longDescription": {
"properties": {
"lang": {
"type": "string"
},
"value": {
"type": "string"
}
},
"type": "object"
},
"shortDescription": {
"properties": {
"lang": {
"type": "string"
},
"value": {
"type": "string"
}
},
"type": "object"
}
},
"type": "object"
}
},
"type": "object"
},
"hasLocation": {
"properties": {
"object": {
"properties": {
"autonomousCommunity": {
"type": "string"
},
"country": {
"type": "string"
},
"lat": {
"type": "number"
},
"long": {
"type": "number"
},
"municipality": {
"type": "string"
},
"postalCode": {
"type": "string"
},
"province": {
"type": "string"
}
},
"type": "object"
}
},
"required": [
"object"
],
"type": "object"
},
"name": {
"properties": {
"lang": {
"type": "string"
},
"value": {
"type": "string"
}
},
"type": "object"
}
},
"type": "object"
}
},
"type": "object"
},
"hints": "Use exactly this jq filter, do not modify it, do not add or remove anything:\r\n\r\n{object:{externalId:.id,name:{value:.name.value,lang:\"es\"},hasDescription:{object:{shortDescription:{value:.shortDescription.value,lang:\"es\"},longDescription:{value:.description.value,lang:\"es\"},keyword:[.extraInfo.value]}},hasAdditionalType:.category.value,hasLocation:{object:{lat:.location.value.coordinates[1],long:.location.value.coordinates[0],autonomousCommunity:\"Comunidad de Madrid\",country:\"Espa\u00f1a\",municipality:\"Las Rozas de Madrid\",postalCode:\"28290\",province:\"Madrid\"}}}}",
"source_fragment": {
"alternateName": {
"metadata": {},
"type": "string",
"value": "LR-01"
},
"category": {
"metadata": {},
"type": "string",
"value": "TrailRoute"
},
"dataProvider": {
"metadata": {},
"type": "string",
"value": "nec-ccoc"
},
"description": {
"metadata": {},
"type": "string",
"value": "Comenzamos"
},
"extraInfo": {
"metadata": {},
"type": "string",
"value": "Encinar"
},
"id": "trailroute_lr-01",
"location": {
"metadata": {},
"type": "geo:json",
"value": {
"coordinates": [
-3.8565638,
40.4845294
],
"type": "Point"
}
},
"name": {
"metadata": {},
"type": "string",
"value": "Majalacabra"
},
"shortDescription": {
"metadata": {},
"type": "string",
"value": "Dificultad: baja"
},
"source": {
"metadata": {},
"type": "string",
"value": "portal-randev6"
},
"type": "PointOfInterest"
},
"source_json": {
"alternateName": {
"metadata": {},
"type": "string",
"value": "LR-01"
},
"category": {
"metadata": {},
"type": "string",
"value": "TrailRoute"
},
"dataProvider": {
"metadata": {},
"type": "string",
"value": "nec-ccoc"
},
"description": {
"metadata": {},
"type": "string",
"value": "Comenzamos"
},
"extraInfo": {
"metadata": {},
"type": "string",
"value": "Encinar"
},
"id": "trailroute_lr-01",
"location": {
"metadata": {},
"type": "geo:json",
"value": {
"coordinates": [
-3.8565638,
40.4845294
],
"type": "Point"
}
},
"name": {
"metadata": {},
"type": "string",
"value": "Majalacabra"
},
"shortDescription": {
"metadata": {},
"type": "string",
"value": "Dificultad: baja"
},
"source": {
"metadata": {},
"type": "string",
"value": "portal-randev6"
},
"type": "PointOfInterest"
},
"task": "synthesize"
},
"response": "{\"jq_expression\":\"{object:{externalId:.id,name:{value:.name.value,lang:\\\"es\\\"},hasDescription:{object:{shortDescription:{value:.shortDescription.value,lang:\\\"es\\\"},longDescription:{value:.description.value,lang:\\\"es\\\"},keyword:[.extraInfo.value]}},hasAdditionalType:.category.value,hasLocation:{object:{lat:.location.value.coordinates[1],long:.location.value.coordinates[0],autonomousCommunity:\\\"Comunidad de Madrid\\\",country:\\\"Espa\u00f1a\\\",municipality:\\\"Las Rozas de Madrid\\\",postalCode:\\\"28290\\\",province:\\\"Madrid\\\"}}}}\"}",
"system_prompt": "You generate a jq expression for one target field. Return exactly one flat JSON object and nothing else. Do not wrap the result in markdown. Do not nest the result under keys like result, output, data, or expression. Use exactly this output schema: {\"jq_expression\": string}. \"jq_expression\" must be a JSON string containing only the jq expression for the target field. Use candidate_source_path as the primary source location, verify it against source_json, and use source_fragment as the focused local value. Do not return explanations or extra keys. Example valid output: {\"jq_expression\":\".datetime\"}",
"used_hints": true
},
"stage": "jq_synthesis",
"timestamp": "2026-05-20T08:03:12.876483+00:00"
},
{
"payload": {
"field_expressions": {
"input": "{object:{externalId:.id,name:{value:.name.value,lang:\"es\"},hasDescription:{object:{shortDescription:{value:.shortDescription.value,lang:\"es\"},longDescription:{value:.description.value,lang:\"es\"},keyword:[.extraInfo.value]}},hasAdditionalType:.category.value,hasLocation:{object:{lat:.location.value.coordinates[1],long:.location.value.coordinates[0],autonomousCommunity:\"Comunidad de Madrid\",country:\"Espa\u00f1a\",municipality:\"Las Rozas de Madrid\",postalCode:\"28290\",province:\"Madrid\"}}}}"
},
"jq_filter": "{ \"input\": {object:{externalId:.id,name:{value:.name.value,lang:\"es\"},hasDescription:{object:{shortDescription:{value:.shortDescription.value,lang:\"es\"},longDescription:{value:.description.value,lang:\"es\"},keyword:[.extraInfo.value]}},hasAdditionalType:.category.value,hasLocation:{object:{lat:.location.value.coordinates[1],long:.location.value.coordinates[0],autonomousCommunity:\"Comunidad de Madrid\",country:\"Espa\u00f1a\",municipality:\"Las Rozas de Madrid\",postalCode:\"28290\",province:\"Madrid\"}}}} }",
"validation_passed": true
},
"stage": "generation_complete",
"timestamp": "2026-05-20T08:03:12.886968+00:00"
},
{
"payload": {
"jq_filter": "{ \"input\": {object:{externalId:.id,name:{value:.name.value,lang:\"es\"},hasDescription:{object:{shortDescription:{value:.shortDescription.value,lang:\"es\"},longDescription:{value:.description.value,lang:\"es\"},keyword:[.extraInfo.value]}},hasAdditionalType:.category.value,hasLocation:{object:{lat:.location.value.coordinates[1],long:.location.value.coordinates[0],autonomousCommunity:\"Comunidad de Madrid\",country:\"Espa\u00f1a\",municipality:\"Las Rozas de Madrid\",postalCode:\"28290\",province:\"Madrid\"}}}} }",
"output_json": {
"input": {
"object": {
"externalId": "trailroute_lr-01",
"hasAdditionalType": "TrailRoute",
"hasDescription": {
"object": {
"keyword": [
"Encinar"
],
"longDescription": {
"lang": "es",
"value": "Comenzamos"
},
"shortDescription": {
"lang": "es",
"value": "Dificultad: baja"
}
}
},
"hasLocation": {
"object": {
"autonomousCommunity": "Comunidad de Madrid",
"country": "Espa\u00f1a",
"lat": 40.4845294,
"long": -3.8565638,
"municipality": "Las Rozas de Madrid",
"postalCode": "28290",
"province": "Madrid"
}
},
"name": {
"lang": "es",
"value": "Majalacabra"
}
}
}
},
"schema_valid": true,
"validation_errors": []
},
"stage": "transform_complete",
"timestamp": "2026-05-20T08:03:12.889461+00:00"
}
],
"run_id": "6617aaca-8470-4f46-88a8-fdb2e9e38e78"
}