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]}}}} }
{
"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": {
"lat": 40.4845294,
"long": -3.8565638
}
},
"name": {
"lang": "es",
"value": "Majalacabra"
}
}
}
}
Trace Details
{
"attempts": [
{
"attempt_number": 1,
"compile_ok": false,
"error_message": "jq: error: syntax error, unexpected INVALID_CHARACTER at \u003ctop-level\u003e, line 1, column 54:\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]}}}}\n ^\njq: 1 compile error",
"execution_ok": false,
"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]}}}}",
"schema_valid": false,
"stage": "field",
"target_field": "input",
"used_hints": true
},
{
"attempt_number": 2,
"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]}}}}",
"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]}}}} }",
"schema_valid": true,
"stage": "global",
"target_field": null,
"used_hints": true
}
],
"events": [
{
"payload": {
"field_name": "input",
"hint_hash": "c6223bb589e57decc691c2a1b76b7dfdad6f40b6ce6e2bad22ed51ca8cbe47e9",
"match_result": {
"candidate_source_path": ".",
"confidence": 0.95,
"identified": true,
"reasoning": "The target field \u0027input\u0027 represents the entire source JSON object."
},
"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": {
"lat": {
"type": "number"
},
"long": {
"type": "number"
}
},
"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]}}}}",
"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": {
"lat": {
"type": "number"
},
"long": {
"type": "number"
}
},
"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 source JSON object.\",\"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-19T17:59:19.494654+00:00"
},
{
"payload": {
"field_name": "input",
"hint_hash": "c6223bb589e57decc691c2a1b76b7dfdad6f40b6ce6e2bad22ed51ca8cbe47e9",
"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]}}}}",
"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": {
"lat": {
"type": "number"
},
"long": {
"type": "number"
}
},
"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]}}}}",
"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]}}}}\"}",
"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-19T17:59:27.488737+00:00"
},
{
"payload": {
"field_name": "input",
"hint_hash": "c6223bb589e57decc691c2a1b76b7dfdad6f40b6ce6e2bad22ed51ca8cbe47e9",
"prompt_payload": {
"attempt_history": [
{
"attempt_number": 1,
"compile_ok": false,
"error_message": "jq: error: syntax error, unexpected INVALID_CHARACTER at \u003ctop-level\u003e, line 1, column 54:\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]}}}}\n ^\njq: 1 compile error",
"execution_ok": false,
"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]}}}}",
"schema_valid": false,
"stage": "field",
"target_field": "input",
"used_hints": true
}
],
"candidate_source_path": ".",
"error_message": "jq: error: syntax error, unexpected INVALID_CHARACTER at \u003ctop-level\u003e, line 1, column 54:\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]}}}}\n ^\njq: 1 compile error",
"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": {
"lat": {
"type": "number"
},
"long": {
"type": "number"
}
},
"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]}}}}",
"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": {
"lat": {
"type": "number"
},
"long": {
"type": "number"
}
},
"type": "object"
}
},
"required": [
"object"
],
"type": "object"
},
"name": {
"properties": {
"lang": {
"type": "string"
},
"value": {
"type": "string"
}
},
"type": "object"
}
},
"type": "object"
}
},
"type": "object"
}
},
"type": "object"
},
"previous_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]}}}}",
"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"
},
"stage": "field",
"task": "repair"
},
"repaired_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]}}}}",
"response": "{\"repaired_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]}}}}\"}",
"stage_name": "field",
"system_prompt": "You repair a jq expression after a compile, execution, or validation error. 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: {\"repaired_jq_expression\": string}. \"repaired_jq_expression\" must be a JSON string containing only the repaired jq expression. Do not return explanations or extra keys. Example valid output: {\"repaired_jq_expression\":\".payload.customer.name\"}",
"used_hints": true
},
"stage": "jq_repair",
"timestamp": "2026-05-19T18:00:03.996710+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]}}}}"
},
"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]}}}} }",
"validation_passed": true
},
"stage": "generation_complete",
"timestamp": "2026-05-19T18:00:04.003756+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]}}}} }",
"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": {
"lat": 40.4845294,
"long": -3.8565638
}
},
"name": {
"lang": "es",
"value": "Majalacabra"
}
}
}
},
"schema_valid": true,
"validation_errors": []
},
"stage": "transform_complete",
"timestamp": "2026-05-19T18:00:04.006921+00:00"
}
],
"run_id": "15c24091-bd3d-409f-8b0b-ab66c65e2e4a"
}