GenHealth integration

Normalize Worksheet

Perform Normalize Worksheet through GenHealth.

View as Markdown

genhealth_normalize_worksheet

write

Inputs

document_id
expression
Document Id
Optional literal value or workflow expression.
source_format
select
Source Format
Optional selected identifier or value.
Default: "auto"
Options: Auto Detect ("auto"), CSV ("csv"), Excel (.xlsx) ("xlsx")
target_fields
repeatable_grouprequired
Target Fields
Required list of structured items.
- key
  textrequired
  Key
  Required text value.
- semantic_type
  selectrequired
  Semantic Type
  Required selected identifier or value.
  Default: "text"
  Options: Text ("text"), Currency ("currency"), Date ("date"), Identifier ("identifier")
- description
  textarearequired
  Description
  Required text value.
- required
  boolean
  Required
  Optional true-or-false value.
  Default: "false"
derived_fields
repeatable_group
Derived Fields
Optional list of structured items.
- key
  textrequired
  Key
  Required text value.
- source_field
  textrequired
  Source Field
  Required text value.
- pattern
  textrequired
  Pattern
  Required text value.
- match_group
  number
  Match Group
  Optional numeric value.
  Default: 1

Outputs

document_idDocument Id
file_nameFile Name
source_formatSource Format
sheet_nameSheet Name
columnsColumns
raw_row_countRaw Row Count
countCount
rowsRows
schemaSchema
messageMessage
errorError

Output schema completeness: best_effort_declared

Safety

External effect: write
Confirmation recommended: No
Retry safe: No
Dry run supported: No

Schemas

These schemas are first-pass authoring guidance. Runtime validation remains authoritative.

Input schema

{
  "type": "object",
  "required": [
    "target_fields"
  ],
  "properties": {
    "document_id": {
      "description": "Optional literal value or workflow expression.",
      "x-workflow-field-type": "expression"
    },
    "source_format": {
      "enum": [
        "auto",
        "csv",
        "xlsx"
      ],
      "type": "string",
      "default": "auto",
      "description": "Optional selected identifier or value.",
      "x-workflow-field-type": "select"
    },
    "target_fields": {
      "type": "array",
      "items": {
        "type": "object",
        "required": [
          "key",
          "semantic_type",
          "description"
        ],
        "properties": {
          "key": {
            "type": "string",
            "description": "Required text value.",
            "x-workflow-field-type": "text"
          },
          "required": {
            "type": "boolean",
            "description": "Optional true-or-false value.",
            "x-workflow-field-type": "boolean"
          },
          "description": {
            "type": "string",
            "description": "Required text value.",
            "x-workflow-field-type": "textarea"
          },
          "semantic_type": {
            "enum": [
              "text",
              "currency",
              "date",
              "identifier"
            ],
            "type": "string",
            "default": "text",
            "description": "Required selected identifier or value.",
            "x-workflow-field-type": "select"
          }
        },
        "additionalProperties": false
      },
      "description": "Required list of structured items.",
      "x-workflow-field-type": "repeatable_group"
    },
    "derived_fields": {
      "type": "array",
      "items": {
        "type": "object",
        "required": [
          "key",
          "source_field",
          "pattern"
        ],
        "properties": {
          "key": {
            "type": "string",
            "description": "Required text value.",
            "x-workflow-field-type": "text"
          },
          "pattern": {
            "type": "string",
            "description": "Required text value.",
            "x-workflow-field-type": "text"
          },
          "match_group": {
            "type": "number",
            "default": 1,
            "description": "Optional numeric value.",
            "x-workflow-field-type": "number"
          },
          "source_field": {
            "type": "string",
            "description": "Required text value.",
            "x-workflow-field-type": "text"
          }
        },
        "additionalProperties": false
      },
      "description": "Optional list of structured items.",
      "x-workflow-field-type": "repeatable_group"
    }
  },
  "additionalProperties": false
}

Output schema

{
  "type": "object",
  "properties": {
    "rows": {},
    "count": {},
    "error": {},
    "schema": {},
    "columns": {},
    "message": {},
    "file_name": {},
    "sheet_name": {},
    "document_id": {},
    "raw_row_count": {},
    "source_format": {}
  },
  "additionalProperties": true
}

View all GenHealth actions