elasticsearch reindex nested date formats

elasticsearch reindex nested date formats.json

PUT _ingest/pipeline/route_restriction_date_converter
{
  "description": "Convert dates to ISO format",
  "processors": [
    {
      "date": {
        "field": "start_date",
        "target_field": "start_date",
        "formats": [
          "strict_date_optional_time || MM/dd/yyyy || MM/dd/yyyy HH:mm"
        ]
      }
    },
    {
      "date": {
        "field": "end_date",
        "target_field": "end_date",
        "formats": [
          "strict_date_optional_time || MM/dd/yyyy || MM/dd/yyyy HH:mm || epoch_millis"
        ]
      }
    },
    {
      "foreach": {
        "ignore_missing": true,
        "field": "route_restrictions",
        "processor": {
          "date": {
            "field": "_ingest._value.end_date",
            "target_field": "_ingest._value.end_date",
            "formats": [
              "strict_date_optional_time || MM/dd/yyyy || MM/dd/yyyy HH:mm || epoch_millis"
            ]
          }
        }
      }
    },
     {
      "foreach": {
        "ignore_missing": true,
        "field": "route_restrictions",
        "processor": {
          "date": {
            "field": "_ingest._value.start_date",
            "target_field": "_ingest._value.start_date",
            "formats": [
              "strict_date_optional_time || MM/dd/yyyy || MM/dd/yyyy HH:mm || epoch_millis"
            ]
          }
        }
      }
    }
  ]
}

POST _reindex
{
  "source": {
    "index": "route_policy"
  },
  "dest": {
    "index": "route_policy_back",
    "pipeline": "route_restriction_date_converter"
  }
}