# processingXmlFiles

State Resource

This is a State Resource as provided by the tymly-etl-plugin plugin.

# Purpose

Takes an XML file and converts it to CSV

# Usage

# Example

{
  "ProcessingXmlFiles": {
    "Type": "Task",
    "InputPath": "$",
    "Resource": "module:processingXmlFiles",
    "ResourceConfig": {
      "rootXMLElement": "EstablishmentDetail",
      "headerMap": [
        [
          "FHRSID",
          "fhrsid",
          "integer"
        ],
        [
          "LocalAuthorityBusinessID",
          "local_authority_business_id",
          "string"
        ],
        [
          "BusinessName",
          "business_name",
          "string"
        ],
        [
          "BusinessType",
          "business_type",
          "string"
        ],
        [
          "BusinessTypeID",
          "business_type_id",
          "integer"
        ],
        [
          "AddressLine1",
          "address_line_1",
          "string"
        ],
        [
          "AddressLine2",
          "address_line_2",
          "string"
        ],
        [
          "AddressLine3",
          "address_line_3",
          "string"
        ],
        [
          "AddressLine4",
          "address_line_4",
          "string"
        ],
        [
          "PostCode",
          "postcode",
          "string"
        ],
        [
          "RatingValue",
          "rating_value",
          "string"
        ],
        [
          "RatingKey",
          "rating_key",
          "string"
        ],
        [
          "RatingDate",
          "rating_date",
          "date"
        ],
        [
          "LocalAuthorityCode",
          "local_authority_code",
          "integer"
        ],
        [
          "LocalAuthorityName",
          "local_authority_name",
          "string"
        ],
        [
          "LocalAuthorityWebSite",
          "local_authority_website",
          "string"
        ],
        [
          "LocalAuthorityEmailAddress",
          "local_authority_email_address",
          "string"
        ],
        [
          "Hygiene",
          "hygiene",
          "integer",
          "Scores"
        ],
        [
          "Structural",
          "structural",
          "integer",
          "Scores"
        ],
        [
          "ConfidenceInManagement",
          "confidence_in_management",
          "integer",
          "Scores"
        ],
        [
          "SchemeType",
          "scheme_type",
          "string"
        ],
        [
          "NewRatingPending",
          "new_rating_pending",
          "string"
        ],
        [
          "Longitude",
          "longitude",
          "integer",
          "Geocode"
        ],
        [
          "Latitude",
          "latitude",
          "integer",
          "Geocode"
        ]
      ]
    }
  }
}

# Options

# Optional properties

# entities

Identifies which XML tags map to a model.

  • Type: object
Last Updated: 9/10/2023, 11:30:14 AM