ElasticSearch

Book for ElasticSearch projects.

Postman Queries (pulled from reshard testing)

Postman Queries (pulled from reshard testing)

snapshot s3 repository

Put: https://vpc-rubex-elasticsearch-prod-8-6-soqlodwed3jcm7gcbrpwhguh7a.us-east-1.es.amazonaws.com/_snapshot/s3_repository?pretty&verify=false

Authorization:

image.png

 

Postman Queries (pulled from reshard testing)

snapshot s3 repository restore

Post: https://vpc-rubex-elasticsearch-prod-8-6-soqlodwed3jcm7gcbrpwhguh7a.us-east-1.es.amazonaws.com/_snapshot/s3_repository/prod-snapshot-10-1-2020/_restore

Authorization:

image.png

Postman Queries (pulled from reshard testing)

other queries

Get: https://vpc-rubex-elasticsearch-prod-8-6-soqlodwed3jcm7gcbrpwhguh7a.us-east-1.es.amazonaws.com/_snapshot/s3_repository

Get: https://vpc-rubex-elasticsearch-prod-8-6-soqlodwed3jcm7gcbrpwhguh7a.us-east-1.es.amazonaws.com/_cat/indices/twi*?v&s=index

Get: https://vpc-rubex-elasticsearch-prod-8-6-soqlodwed3jcm7gcbrpwhguh7a.us-east-1.es.amazonaws.com/_cat/indices

Delete: https://vpc-rubex-elasticsearch-prod-8-6-soqlodwed3jcm7gcbrpwhguh7a.us-east-1.es.amazonaws.com/_snapshot/s3_repository/prod-snapshot-9-18-2020

Post: https://vpc-rubex-elasticsearch-prod-8-6-soqlodwed3jcm7gcbrpwhguh7a.us-east-1.es.amazonaws.com/_snapshot/s3_repository/prod-snapshot-9-22-2020/_restore

Get: https://vpc-rubex-elasticsearch-prod-8-6-soqlodwed3jcm7gcbrpwhguh7a.us-east-1.es.amazonaws.com/_tasks?actions=*search&detailed

Post: https://vpc-rubex-elasticsearch-prod-8-6-soqlodwed3jcm7gcbrpwhguh7a.us-east-1.es.amazonaws.com/_tasks/cc2IKK9yQtKiGs1Zs46BzA:47566757/_cancel

Get: https://vpc-rubex-elasticsearch-prod-8-6-soqlodwed3jcm7gcbrpwhguh7a.us-east-1.es.amazonaws.com/_tasks?actions=*search

Put: https://vpc-rubex-elasticsearch-prod-8-6-soqlodwed3jcm7gcbrpwhguh7a.us-east-1.es.amazonaws.com/_snapshot/

Put: https://vpc-rubex-elasticsearch-prod-8-6-soqlodwed3jcm7gcbrpwhguh7a.us-east-1.es.amazonaws.com/rubex-usprod-esclusteridx/

Post: https://vpc-rubex-elasticsearch-prod-8-6-soqlodwed3jcm7gcbrpwhguh7a.us-east-1.es.amazonaws.com/_

Post: https://vpc-rubex-elasticsearch-prod-8-6-soqlodwed3jcm7gcbrpwhguh7a.us-east-1.es.amazonaws.com/

 

Postman Queries (pulled from reshard testing)

reindex

Post: https://vpc-rubex-elasticsearch-prod-8-6-soqlodwed3jcm7gcbrpwhguh7a.us-east-1.es.amazonaws.com/_reindex

Body:


{
"conflicts": "proceed",
  "source": {
    "index": "nodebaseindexitemindex"
  },
  "dest": {
    "index": "rubex-usprod-esclusteridx",
    "op_type": "create",
    "version_type": "internal"
  }
}

Put: https://vpc-rubex-elasticsearch-prod-8-6-soqlodwed3jcm7gcbrpwhguh7a.us-east-1.es.amazonaws.com/_reindex
Body:
{
  "source": {
    "index": "nodebaseindexitemindex"
  },
  "dest": {
    "index": 
  }
}

Post: https://vpc-rubex-elasticsearch-prod-8-6-soqlodwed3jcm7gcbrpwhguh7a.us-east-1.es.amazonaws.com/_reindex
Body:
{
  "source": {
    "index": "nodebaseindexitemindex"
  },
  "dest": {
    "index": "rubex_usprod_idx_012022"
  }
}

Post; https://vpc-rubex-elasticsearch-prod-8-6-soqlodwed3jcm7gcbrpwhguh7a.us-east-1.es.amazonaws.com/_reindex
Body:
{
"conflicts": "proceed",
  "source": {
    "index": "nodebaseindexitemindex"
  },
  "dest": {
    "index": "rubex_usprod_idx_012022",
    "op_type": "create",
    "version_type": "internal"
  }
}
Post: https://vpc-rubex-elasticsearch-prod-8-6-soqlodwed3jcm7gcbrpwhguh7a.us-east-1.es.amazonaws.com/_reindex
Body:
{
"version_conflicts": "proceed",
  "source": {
    "index": "nodebaseindexitemindex"
  },
  "dest": {
    "index": "rubex_foo",
    "op_type": "create",
    "version_type": "internal"
  }
}
Postman Queries (pulled from reshard testing)

Settings

Put: https://vpc-rubex-elasticsearch-prod-8-6-soqlodwed3jcm7gcbrpwhguh7a.us-east-1.es.amazonaws.com/rubex_usprod_idx_012022/_settings/


Body:


{
    “index”:{
    “refresh_interval” : “-1”
}

}
Put: https://vpc-rubex-elasticsearch-prod-8-6-soqlodwed3jcm7gcbrpwhguh7a.us-east-1.es.amazonaws.com/rubex_usprod_newindex2022/_settings
Body:
{
"index" :  {
    "number_of_replicas" : 3
  }
}
Postman Queries (pulled from reshard testing)

mapping

Put: https://vpc-rubex-elasticsearch-prod-8-6-soqlodwed3jcm7gcbrpwhguh7a.us-east-1.es.amazonaws.com/rubex_foo/_mapping

 

Body:

 

{
  "settings" : {
      "number_of_shards" : 90,
      "number_of_replicas" : 0
    },
              "analyzer" : {
            "nodeNameAnalyzer" : {
              "filter" : [ "word_delimiter_graph", "lowercase" ],
              "type" : "custom",
              "tokenizer" : "standard"
            },
    "mappings" : {
      "nodebaseindexitem" : {
        "_routing" : {
          "required" : true
        },
        "properties" : {
          "accountID" : {
            "type" : "integer"
          },
          "attachment" : {
            "properties" : {
              "author" : {
                "type" : "text",
                "fields" : {
                  "keyword" : {
                    "type" : "keyword",
                    "ignore_above" : 256
                  }
                }
              },
              "containsMetadata" : {
                "type" : "boolean"
              },
              "content" : {
                "type" : "text",
                "fields" : {
                  "keyword" : {
                    "type" : "keyword",
                    "ignore_above" : 256
                  }
                }
              },
              "content_length" : {
                "type" : "long"
              },
              "content_type" : {
                "type" : "text",
                "fields" : {
                  "keyword" : {
                    "type" : "keyword",
                    "ignore_above" : 256
                  }
                }
              },
              "date" : {
                "type" : "date"
              },
              "detect_language" : {
                "type" : "boolean"
              },
              "indexed_chars" : {
                "type" : "long"
              },
              "keywords" : {
                "type" : "text",
                "fields" : {
                  "keyword" : {
                    "type" : "keyword",
                    "ignore_above" : 256
                  }
                }
              },
              "language" : {
                "type" : "text",
                "fields" : {
                  "keyword" : {
                    "type" : "keyword",
                    "ignore_above" : 256
                  }
                }
              },
              "name" : {
                "type" : "text",
                "fields" : {
                  "keyword" : {
                    "type" : "keyword",
                    "ignore_above" : 256
                  }
                }
              },
              "title" : {
                "type" : "text",
                "fields" : {
                  "keyword" : {
                    "type" : "keyword",
                    "ignore_above" : 256
                  }
                }
              }
            }
          },
          "content" : {
            "type" : "text",
            "fields" : {
              "keyword" : {
                "type" : "keyword",
                "ignore_above" : 256
              }
            }
          },
          "deletedOn" : {
            "type" : "date"
          },
          "fileInfoId" : {
            "type" : "long"
          },
          "id" : {
            "type" : "text",
            "fields" : {
              "keyword" : {
                "type" : "keyword",
                "ignore_above" : 256
              }
            }
          },
          "joinField" : {
            "type" : "join",
            "eager_global_ordinals" : true,
            "relations" : {
              "nodeindexitem" : [
                "nodecommentindexitem",
                "nodeprofileindexitem",
                "fileindexitem"
              ]
            }
          },
          "node" : {
            "properties" : {
              "accountID" : {
                "type" : "integer"
              },
              "checkoutInfo" : {
                "properties" : {
                  "checkedOutByRoleID" : {
                    "type" : "long"
                  },
                  "checkedOutOn" : {
                    "type" : "date"
                  },
                  "nodeId" : {
                    "type" : "long"
                  },
                  "o365ClientLock" : {
                    "type" : "text",
                    "fields" : {
                      "keyword" : {
                        "type" : "keyword",
                        "ignore_above" : 256
                      }
                    }
                  },
                  "o365ClientLockedOn" : {
                    "type" : "date"
                  }
                }
              },
              "createdBy" : {
                "type" : "text",
                "fields" : {
                  "keyword" : {
                    "type" : "keyword",
                    "ignore_above" : 256
                  }
                }
              },
              "createdByUserID" : {
                "type" : "long"
              },
              "createdOn" : {
                "type" : "date"
              },
              "fileInfo" : {
                "properties" : {
                  "checkedOutByRoleID" : {
                    "type" : "long"
                  },
                  "createdOn" : {
                    "type" : "date"
                  },
                  "fileExtension" : {
                    "type" : "text",
                    "fields" : {
                      "keyword" : {
                        "type" : "keyword",
                        "ignore_above" : 256
                      }
                    }
                  },
                  "formFillDefinitionId" : {
                    "type" : "integer"
                  },
                  "id" : {
                    "type" : "long"
                  },
                  "sizeInBytes" : {
                    "type" : "long"
                  },
                  "uploadIdentifier" : {
                    "type" : "text",
                    "fields" : {
                      "keyword" : {
                        "type" : "keyword",
                        "ignore_above" : 256
                      }
                    }
                  },
                  "uploadSuccessful" : {
                    "type" : "boolean"
                  }
                }
              },
              "hasChildren" : {
                "type" : "boolean"
              },
              "id" : {
                "type" : "text",
                "fields" : {
                  "keyword" : {
                    "type" : "keyword",
                    "ignore_above" : 256
                  }
                }
              },
              "modifiedOn" : {
                "type" : "date"
              },
              "name" : {
                "type" : "text",
                "fields" : {
                  "keyword" : {
                    "type" : "keyword",
                    "ignore_above" : 256
                  },
                  "lowercase" : {
                    "type" : "keyword",
                    "ignore_above" : 32000,
                    "normalizer" : "lowercase"
                  }
                },
                "analyzer" : "nodeNameAnalyzer"
              },
              "nodeProvider" : {
                "type" : "integer"
              },
              "parentID" : {
                "type" : "text",
                "fields" : {
                  "keyword" : {
                    "type" : "keyword",
                    "ignore_above" : 256
                  }
                }
              },
              "permission" : {
                "properties" : {
                  "admin" : {
                    "type" : "boolean"
                  },
                  "childPermission" : {
                    "properties" : {
                      "admin" : {
                        "type" : "boolean"
                      },
                      "createDirectories" : {
                        "type" : "boolean"
                      },
                      "createdOn" : {
                        "type" : "date"
                      },
                      "delete" : {
                        "type" : "boolean"
                      },
                      "download" : {
                        "type" : "boolean"
                      },
                      "enforce" : {
                        "type" : "boolean"
                      },
                      "id" : {
                        "type" : "long"
                      },
                      "inheritanceBehavior" : {
                        "type" : "long"
                      },
                      "preview" : {
                        "type" : "boolean"
                      },
                      "read" : {
                        "type" : "boolean"
                      },
                      "remove" : {
                        "type" : "boolean"
                      },
                      "restrict" : {
                        "type" : "boolean"
                      },
                      "systemType" : {
                        "type" : "long"
                      },
                      "uploadFiles" : {
                        "type" : "boolean"
                      },
                      "view" : {
                        "type" : "boolean"
                      },
                      "write" : {
                        "type" : "boolean"
                      }
                    }
                  },
                  "createDirectories" : {
                    "type" : "boolean"
                  },
                  "createdBy" : {
                    "type" : "text",
                    "fields" : {
                      "keyword" : {
                        "type" : "keyword",
                        "ignore_above" : 256
                      }
                    }
                  },
                  "createdOn" : {
                    "type" : "date"
                  },
                  "delete" : {
                    "type" : "boolean"
                  },
                  "download" : {
                    "type" : "boolean"
                  },
                  "enforce" : {
                    "type" : "boolean"
                  },
                  "id" : {
                    "type" : "long"
                  },
                  "inheritanceBehavior" : {
                    "type" : "long"
                  },
                  "name" : {
                    "type" : "text",
                    "fields" : {
                      "keyword" : {
                        "type" : "keyword",
                        "ignore_above" : 256
                      }
                    }
                  },
                  "nodeID" : {
                    "type" : "long"
                  },
                  "nonInheritable" : {
                    "type" : "boolean"
                  },
                  "preview" : {
                    "type" : "boolean"
                  },
                  "read" : {
                    "type" : "boolean"
                  },
                  "remove" : {
                    "type" : "boolean"
                  },
                  "restrict" : {
                    "type" : "boolean"
                  },
                  "roleData" : {
                    "properties" : {
                      "accountID" : {
                        "type" : "integer"
                      },
                      "anonymous" : {
                        "type" : "boolean"
                      },
                      "hasLicense" : {
                        "type" : "boolean"
                      },
                      "id" : {
                        "type" : "long"
                      },
                      "includeInSalesforceMapping" : {
                        "type" : "boolean"
                      },
                      "memberOfRoles" : {
                        "type" : "object"
                      },
                      "name" : {
                        "type" : "text",
                        "fields" : {
                          "keyword" : {
                            "type" : "keyword",
                            "ignore_above" : 256
                          }
                        }
                      },
                      "password" : {
                        "type" : "text",
                        "fields" : {
                          "keyword" : {
                            "type" : "keyword",
                            "ignore_above" : 256
                          }
                        }
                      },
                      "profileID" : {
                        "type" : "integer"
                      },
                      "profileItems" : {
                        "properties" : {
                          "accountID" : {
                            "type" : "integer"
                          },
                          "id" : {
                            "type" : "integer"
                          },
                          "include" : {
                            "type" : "boolean"
                          },
                          "isDeleted" : {
                            "type" : "boolean"
                          },
                          "joinID" : {
                            "type" : "integer"
                          },
                          "name" : {
                            "type" : "text",
                            "fields" : {
                              "keyword" : {
                                "type" : "keyword",
                                "ignore_above" : 256
                              }
                            }
                          },
                          "position" : {
                            "type" : "integer"
                          },
                          "presetValueID" : {
                            "type" : "integer"
                          },
                          "presetValues" : {
                            "properties" : {
                              "id" : {
                                "type" : "integer"
                              },
                              "value" : {
                                "type" : "text",
                                "fields" : {
                                  "keyword" : {
                                    "type" : "keyword",
                                    "ignore_above" : 256
                                  }
                                }
                              }
                            }
                          },
                          "profileID" : {
                            "type" : "integer"
                          },
                          "required" : {
                            "type" : "boolean"
                          },
                          "type" : {
                            "type" : "integer"
                          },
                          "value" : {
                            "type" : "text",
                            "fields" : {
                              "keyword" : {
                                "type" : "keyword",
                                "ignore_above" : 256
                              }
                            }
                          },
                          "valueID" : {
                            "type" : "long"
                          }
                        }
                      },
                      "roleManagerID" : {
                        "type" : "long"
                      },
                      "roleMembers" : {
                        "type" : "object"
                      },
                      "roleType" : {
                        "type" : "integer"
                      },
                      "securityPolicyID" : {
                        "type" : "integer"
                      },
                      "systemPermissions" : {
                        "properties" : {
                          "accessLinksManagement" : {
                            "properties" : {
                              "description" : {
                                "type" : "text",
                                "fields" : {
                                  "keyword" : {
                                    "type" : "keyword",
                                    "ignore_above" : 256
                                  }
                                }
                              },
                              "enabled" : {
                                "type" : "boolean"
                              },
                              "name" : {
                                "type" : "text",
                                "fields" : {
                                  "keyword" : {
                                    "type" : "keyword",
                                    "ignore_above" : 256
                                  }
                                }
                              },
                              "requiredAccountFeature" : {
                                "type" : "integer"
                              }
                            }
                          },
                          "accessLinksUsage" : {
                            "properties" : {
                              "description" : {
                                "type" : "text",
                                "fields" : {
                                  "keyword" : {
                                    "type" : "keyword",
                                    "ignore_above" : 256
                                  }
                                }
                              },
                              "enabled" : {
                                "type" : "boolean"
                              },
                              "name" : {
                                "type" : "text",
                                "fields" : {
                                  "keyword" : {
                                    "type" : "keyword",
                                    "ignore_above" : 256
                                  }
                                }
                              },
                              "requiredAccountFeature" : {
                                "type" : "integer"
                              }
                            }
                          },
                          "auditLogManagement" : {
                            "properties" : {
                              "description" : {
                                "type" : "text",
                                "fields" : {
                                  "keyword" : {
                                    "type" : "keyword",
                                    "ignore_above" : 256
                                  }
                                }
                              },
                              "enabled" : {
                                "type" : "boolean"
                              },
                              "name" : {
                                "type" : "text",
                                "fields" : {
                                  "keyword" : {
                                    "type" : "keyword",
                                    "ignore_above" : 256
                                  }
                                }
                              },
                              "requiredAccountFeature" : {
                                "type" : "integer"
                              }
                            }
                          },
                          "eSignature" : {
                            "properties" : {
                              "description" : {
                                "type" : "text",
                                "fields" : {
                                  "keyword" : {
                                    "type" : "keyword",
                                    "ignore_above" : 256
                                  }
                                }
                              },
                              "enabled" : {
                                "type" : "boolean"
                              },
                              "name" : {
                                "type" : "text",
                                "fields" : {
                                  "keyword" : {
                                    "type" : "keyword",
                                    "ignore_above" : 256
                                  }
                                }
                              },
                              "requiredAccountFeature" : {
                                "type" : "integer"
                              }
                            }
                          },
                          "eSignatureManagement" : {
                            "properties" : {
                              "description" : {
                                "type" : "text",
                                "fields" : {
                                  "keyword" : {
                                    "type" : "keyword",
                                    "ignore_above" : 256
                                  }
                                }
                              },
                              "enabled" : {
                                "type" : "boolean"
                              },
                              "name" : {
                                "type" : "text",
                                "fields" : {
                                  "keyword" : {
                                    "type" : "keyword",
                                    "ignore_above" : 256
                                  }
                                }
                              },
                              "requiredAccountFeature" : {
                                "type" : "integer"
                              }
                            }
                          },
                          "groups" : {
                            "properties" : {
                              "description" : {
                                "type" : "text",
                                "fields" : {
                                  "keyword" : {
                                    "type" : "keyword",
                                    "ignore_above" : 256
                                  }
                                }
                              },
                              "enabled" : {
                                "type" : "boolean"
                              },
                              "name" : {
                                "type" : "text",
                                "fields" : {
                                  "keyword" : {
                                    "type" : "keyword",
                                    "ignore_above" : 256
                                  }
                                }
                              },
                              "requiredAccountFeature" : {
                                "type" : "integer"
                              }
                            }
                          },
                          "guests" : {
                            "properties" : {
                              "description" : {
                                "type" : "text",
                                "fields" : {
                                  "keyword" : {
                                    "type" : "keyword",
                                    "ignore_above" : 256
                                  }
                                }
                              },
                              "enabled" : {
                                "type" : "boolean"
                              },
                              "name" : {
                                "type" : "text",
                                "fields" : {
                                  "keyword" : {
                                    "type" : "keyword",
                                    "ignore_above" : 256
                                  }
                                }
                              },
                              "requiredAccountFeature" : {
                                "type" : "integer"
                              }
                            }
                          },
                          "licenseManagement" : {
                            "properties" : {
                              "description" : {
                                "type" : "text",
                                "fields" : {
                                  "keyword" : {
                                    "type" : "keyword",
                                    "ignore_above" : 256
                                  }
                                }
                              },
                              "enabled" : {
                                "type" : "boolean"
                              },
                              "name" : {
                                "type" : "text",
                                "fields" : {
                                  "keyword" : {
                                    "type" : "keyword",
                                    "ignore_above" : 256
                                  }
                                }
                              },
                              "requiredAccountFeature" : {
                                "type" : "integer"
                              }
                            }
                          },
                          "nodeExchange" : {
                            "properties" : {
                              "description" : {
                                "type" : "text",
                                "fields" : {
                                  "keyword" : {
                                    "type" : "keyword",
                                    "ignore_above" : 256
                                  }
                                }
                              },
                              "enabled" : {
                                "type" : "boolean"
                              },
                              "name" : {
                                "type" : "text",
                                "fields" : {
                                  "keyword" : {
                                    "type" : "keyword",
                                    "ignore_above" : 256
                                  }
                                }
                              },
                              "requiredAccountFeature" : {
                                "type" : "integer"
                              }
                            }
                          },
                          "nodeExchangeManagement" : {
                            "properties" : {
                              "description" : {
                                "type" : "text",
                                "fields" : {
                                  "keyword" : {
                                    "type" : "keyword",
                                    "ignore_above" : 256
                                  }
                                }
                              },
                              "enabled" : {
                                "type" : "boolean"
                              },
                              "name" : {
                                "type" : "text",
                                "fields" : {
                                  "keyword" : {
                                    "type" : "keyword",
                                    "ignore_above" : 256
                                  }
                                }
                              },
                              "requiredAccountFeature" : {
                                "type" : "integer"
                              }
                            }
                          },
                          "nodeManagement" : {
                            "properties" : {
                              "description" : {
                                "type" : "text",
                                "fields" : {
                                  "keyword" : {
                                    "type" : "keyword",
                                    "ignore_above" : 256
                                  }
                                }
                              },
                              "enabled" : {
                                "type" : "boolean"
                              },
                              "name" : {
                                "type" : "text",
                                "fields" : {
                                  "keyword" : {
                                    "type" : "keyword",
                                    "ignore_above" : 256
                                  }
                                }
                              },
                              "requiredAccountFeature" : {
                                "type" : "integer"
                              }
                            }
                          },
                          "nodePermissionOverride" : {
                            "properties" : {
                              "description" : {
                                "type" : "text",
                                "fields" : {
                                  "keyword" : {
                                    "type" : "keyword",
                                    "ignore_above" : 256
                                  }
                                }
                              },
                              "enabled" : {
                                "type" : "boolean"
                              },
                              "name" : {
                                "type" : "text",
                                "fields" : {
                                  "keyword" : {
                                    "type" : "keyword",
                                    "ignore_above" : 256
                                  }
                                }
                              },
                              "requiredAccountFeature" : {
                                "type" : "integer"
                              }
                            }
                          },
                          "profiles" : {
                            "properties" : {
                              "description" : {
                                "type" : "text",
                                "fields" : {
                                  "keyword" : {
                                    "type" : "keyword",
                                    "ignore_above" : 256
                                  }
                                }
                              },
                              "enabled" : {
                                "type" : "boolean"
                              },
                              "name" : {
                                "type" : "text",
                                "fields" : {
                                  "keyword" : {
                                    "type" : "keyword",
                                    "ignore_above" : 256
                                  }
                                }
                              },
                              "requiredAccountFeature" : {
                                "type" : "integer"
                              }
                            }
                          },
                          "reporting" : {
                            "properties" : {
                              "description" : {
                                "type" : "text",
                                "fields" : {
                                  "keyword" : {
                                    "type" : "keyword",
                                    "ignore_above" : 256
                                  }
                                }
                              },
                              "enabled" : {
                                "type" : "boolean"
                              },
                              "name" : {
                                "type" : "text",
                                "fields" : {
                                  "keyword" : {
                                    "type" : "keyword",
                                    "ignore_above" : 256
                                  }
                                }
                              },
                              "requiredAccountFeature" : {
                                "type" : "integer"
                              }
                            }
                          },
                          "retentionAdmin" : {
                            "properties" : {
                              "description" : {
                                "type" : "text",
                                "fields" : {
                                  "keyword" : {
                                    "type" : "keyword",
                                    "ignore_above" : 256
                                  }
                                }
                              },
                              "enabled" : {
                                "type" : "boolean"
                              },
                              "name" : {
                                "type" : "text",
                                "fields" : {
                                  "keyword" : {
                                    "type" : "keyword",
                                    "ignore_above" : 256
                                  }
                                }
                              },
                              "requiredAccountFeature" : {
                                "type" : "integer"
                              }
                            }
                          },
                          "retentionUnlock" : {
                            "properties" : {
                              "description" : {
                                "type" : "text",
                                "fields" : {
                                  "keyword" : {
                                    "type" : "keyword",
                                    "ignore_above" : 256
                                  }
                                }
                              },
                              "enabled" : {
                                "type" : "boolean"
                              },
                              "name" : {
                                "type" : "text",
                                "fields" : {
                                  "keyword" : {
                                    "type" : "keyword",
                                    "ignore_above" : 256
                                  }
                                }
                              },
                              "requiredAccountFeature" : {
                                "type" : "integer"
                              }
                            }
                          },
                          "salesForceManagement" : {
                            "properties" : {
                              "description" : {
                                "type" : "text",
                                "fields" : {
                                  "keyword" : {
                                    "type" : "keyword",
                                    "ignore_above" : 256
                                  }
                                }
                              },
                              "enabled" : {
                                "type" : "boolean"
                              },
                              "name" : {
                                "type" : "text",
                                "fields" : {
                                  "keyword" : {
                                    "type" : "keyword",
                                    "ignore_above" : 256
                                  }
                                }
                              },
                              "requiredAccountFeature" : {
                                "type" : "integer"
                              }
                            }
                          },
                          "systemSettings" : {
                            "properties" : {
                              "description" : {
                                "type" : "text",
                                "fields" : {
                                  "keyword" : {
                                    "type" : "keyword",
                                    "ignore_above" : 256
                                  }
                                }
                              },
                              "enabled" : {
                                "type" : "boolean"
                              },
                              "name" : {
                                "type" : "text",
                                "fields" : {
                                  "keyword" : {
                                    "type" : "keyword",
                                    "ignore_above" : 256
                                  }
                                }
                              },
                              "requiredAccountFeature" : {
                                "type" : "integer"
                              }
                            }
                          },
                          "templates" : {
                            "properties" : {
                              "description" : {
                                "type" : "text",
                                "fields" : {
                                  "keyword" : {
                                    "type" : "keyword",
                                    "ignore_above" : 256
                                  }
                                }
                              },
                              "enabled" : {
                                "type" : "boolean"
                              },
                              "name" : {
                                "type" : "text",
                                "fields" : {
                                  "keyword" : {
                                    "type" : "keyword",
                                    "ignore_above" : 256
                                  }
                                }
                              },
                              "requiredAccountFeature" : {
                                "type" : "integer"
                              }
                            }
                          },
                          "users" : {
                            "properties" : {
                              "description" : {
                                "type" : "text",
                                "fields" : {
                                  "keyword" : {
                                    "type" : "keyword",
                                    "ignore_above" : 256
                                  }
                                }
                              },
                              "enabled" : {
                                "type" : "boolean"
                              },
                              "name" : {
                                "type" : "text",
                                "fields" : {
                                  "keyword" : {
                                    "type" : "keyword",
                                    "ignore_above" : 256
                                  }
                                }
                              },
                              "requiredAccountFeature" : {
                                "type" : "integer"
                              }
                            }
                          },
                          "workflowManagement" : {
                            "properties" : {
                              "description" : {
                                "type" : "text",
                                "fields" : {
                                  "keyword" : {
                                    "type" : "keyword",
                                    "ignore_above" : 256
                                  }
                                }
                              },
                              "enabled" : {
                                "type" : "boolean"
                              },
                              "name" : {
                                "type" : "text",
                                "fields" : {
                                  "keyword" : {
                                    "type" : "keyword",
                                    "ignore_above" : 256
                                  }
                                }
                              },
                              "requiredAccountFeature" : {
                                "type" : "integer"
                              }
                            }
                          }
                        }
                      },
                      "userID" : {
                        "type" : "long"
                      },
                      "userName" : {
                        "type" : "text",
                        "fields" : {
                          "keyword" : {
                            "type" : "keyword",
                            "ignore_above" : 256
                          }
                        }
                      }
                    }
                  },
                  "roleID" : {
                    "type" : "long"
                  },
                  "roleName" : {
                    "type" : "text",
                    "fields" : {
                      "keyword" : {
                        "type" : "keyword",
                        "ignore_above" : 256
                      }
                    }
                  },
                  "systemType" : {
                    "type" : "integer"
                  },
                  "uploadFiles" : {
                    "type" : "boolean"
                  },
                  "view" : {
                    "type" : "boolean"
                  },
                  "write" : {
                    "type" : "boolean"
                  }
                }
              },
              "size" : {
                "type" : "long"
              },
              "systemType" : {
                "type" : "integer"
              }
            }
          },
          "nodeComment" : {
            "properties" : {
              "accountID" : {
                "type" : "integer"
              },
              "createdBy" : {
                "type" : "text",
                "fields" : {
                  "keyword" : {
                    "type" : "keyword",
                    "ignore_above" : 256
                  }
                }
              },
              "createdByUserID" : {
                "type" : "long"
              },
              "createdOn" : {
                "type" : "date"
              },
              "id" : {
                "type" : "integer"
              },
              "lastModifiedByUserID" : {
                "type" : "long"
              },
              "lastModifiedOn" : {
                "type" : "date"
              },
              "nodeID" : {
                "type" : "long"
              },
              "text" : {
                "type" : "text",
                "fields" : {
                  "keyword" : {
                    "type" : "keyword",
                    "ignore_above" : 256
                  },
                  "lowercase" : {
                    "type" : "keyword",
                    "ignore_above" : 32000,
                    "normalizer" : "lowercase"
                  }
                }
              }
            }
          },
          "nodeID" : {
            "type" : "text",
            "fields" : {
              "keyword" : {
                "type" : "keyword",
                "ignore_above" : 256
              }
            }
          },
          "profileID" : {
            "type" : "integer"
          },
          "profileItems" : {
            "type" : "nested",
            "properties" : {
              "boolValue" : {
                "type" : "boolean"
              },
              "dateTimeValue" : {
                "type" : "date"
              },
              "doubleValue" : {
                "type" : "float"
              },
              "id" : {
                "type" : "long"
              },
              "longValue" : {
                "type" : "long"
              },
              "presetValueID" : {
                "type" : "long"
              },
              "type" : {
                "type" : "long"
              },
              "value" : {
                "type" : "text",
                "fields" : {
                  "lowercase" : {
                    "type" : "keyword",
                    "ignore_above" : 32000,
                    "normalizer" : "lowercase"
                  }
                }
              }
            }
          }
        }
      }
    }
  }
}
Postman Queries (pulled from reshard testing)

new index

Put: https://vpc-rubex-elasticsearch-prod-8-6-soqlodwed3jcm7gcbrpwhguh7a.us-east-1.es.amazonaws.com/rubex_usprod_newindex2022

 

Body:

 

{
  "settings": {
    "index": {
      "number_of_shards": 90,  
      "number_of_replicas": 0,
     "analysis" : {
          "normalizer" : {
            "lowercase" : {
              "filter" : [ "lowercase" ],
              "type" : "custom"
            }
          },
          "analyzer" : {
            "nodeNameAnalyzer" : {
              "filter" : [ "word_delimiter_graph", "lowercase" ],
              "type" : "custom",
              "tokenizer" : "standard"
            }
          }
      
    }
    }
  },
  "mappings" : {
      "nodebaseindexitem" : {
        "_routing" : {
          "required" : true
        },
        "properties" : {
          "accountID" : {
            "type" : "integer"
          },
          "attachment" : {
            "properties" : {
              "author" : {
                "type" : "text",
                "fields" : {
                  "keyword" : {
                    "type" : "keyword",
                    "ignore_above" : 256
                  }
                }
              },
              "containsMetadata" : {
                "type" : "boolean"
              },
              "content" : {
                "type" : "text",
                "fields" : {
                  "keyword" : {
                    "type" : "keyword",
                    "ignore_above" : 256
                  }
                }
              },
              "content_length" : {
                "type" : "long"
              },
              "content_type" : {
                "type" : "text",
                "fields" : {
                  "keyword" : {
                    "type" : "keyword",
                    "ignore_above" : 256
                  }
                }
              },
              "date" : {
                "type" : "date"
              },
              "detect_language" : {
                "type" : "boolean"
              },
              "indexed_chars" : {
                "type" : "long"
              },
              "keywords" : {
                "type" : "text",
                "fields" : {
                  "keyword" : {
                    "type" : "keyword",
                    "ignore_above" : 256
                  }
                }
              },
              "language" : {
                "type" : "text",
                "fields" : {
                  "keyword" : {
                    "type" : "keyword",
                    "ignore_above" : 256
                  }
                }
              },
              "name" : {
                "type" : "text",
                "fields" : {
                  "keyword" : {
                    "type" : "keyword",
                    "ignore_above" : 256
                  }
                }
              },
              "title" : {
                "type" : "text",
                "fields" : {
                  "keyword" : {
                    "type" : "keyword",
                    "ignore_above" : 256
                  }
                }
              }
            }
          },
          "content" : {
            "type" : "text",
            "fields" : {
              "keyword" : {
                "type" : "keyword",
                "ignore_above" : 256
              }
            }
          },
          "deletedOn" : {
            "type" : "date"
          },
          "fileInfoId" : {
            "type" : "long"
          },
          "id" : {
            "type" : "text",
            "fields" : {
              "keyword" : {
                "type" : "keyword",
                "ignore_above" : 256
              }
            }
          },
          "joinField" : {
            "type" : "join",
            "eager_global_ordinals" : true,
            "relations" : {
              "nodeindexitem" : [
                "nodecommentindexitem",
                "nodeprofileindexitem",
                "fileindexitem"
              ]
            }
          },
          "node" : {
            "properties" : {
              "accountID" : {
                "type" : "integer"
              },
              "checkoutInfo" : {
                "properties" : {
                  "checkedOutByRoleID" : {
                    "type" : "long"
                  },
                  "checkedOutOn" : {
                    "type" : "date"
                  },
                  "nodeId" : {
                    "type" : "long"
                  },
                  "o365ClientLock" : {
                    "type" : "text",
                    "fields" : {
                      "keyword" : {
                        "type" : "keyword",
                        "ignore_above" : 256
                      }
                    }
                  },
                  "o365ClientLockedOn" : {
                    "type" : "date"
                  }
                }
              },
              "createdBy" : {
                "type" : "text",
                "fields" : {
                  "keyword" : {
                    "type" : "keyword",
                    "ignore_above" : 256
                  }
                }
              },
              "createdByUserID" : {
                "type" : "long"
              },
              "createdOn" : {
                "type" : "date"
              },
              "fileInfo" : {
                "properties" : {
                  "checkedOutByRoleID" : {
                    "type" : "long"
                  },
                  "createdOn" : {
                    "type" : "date"
                  },
                  "fileExtension" : {
                    "type" : "text",
                    "fields" : {
                      "keyword" : {
                        "type" : "keyword",
                        "ignore_above" : 256
                      }
                    }
                  },
                  "formFillDefinitionId" : {
                    "type" : "integer"
                  },
                  "id" : {
                    "type" : "long"
                  },
                  "sizeInBytes" : {
                    "type" : "long"
                  },
                  "uploadIdentifier" : {
                    "type" : "text",
                    "fields" : {
                      "keyword" : {
                        "type" : "keyword",
                        "ignore_above" : 256
                      }
                    }
                  },
                  "uploadSuccessful" : {
                    "type" : "boolean"
                  }
                }
              },
              "hasChildren" : {
                "type" : "boolean"
              },
              "id" : {
                "type" : "text",
                "fields" : {
                  "keyword" : {
                    "type" : "keyword",
                    "ignore_above" : 256
                  }
                }
              },
              "modifiedOn" : {
                "type" : "date"
              },
              "name" : {
                "type" : "text",
                "fields" : {
                  "keyword" : {
                    "type" : "keyword",
                    "ignore_above" : 256
                  },
                  "lowercase" : {
                    "type" : "keyword",
                    "ignore_above" : 32000,
                    "normalizer" : "lowercase"
                  }
                },
                "analyzer" : "nodeNameAnalyzer"
              },
              "nodeProvider" : {
                "type" : "integer"
              },
              "parentID" : {
                "type" : "text",
                "fields" : {
                  "keyword" : {
                    "type" : "keyword",
                    "ignore_above" : 256
                  }
                }
              },
              "permission" : {
                "properties" : {
                  "admin" : {
                    "type" : "boolean"
                  },
                  "childPermission" : {
                    "properties" : {
                      "admin" : {
                        "type" : "boolean"
                      },
                      "createDirectories" : {
                        "type" : "boolean"
                      },
                      "createdOn" : {
                        "type" : "date"
                      },
                      "delete" : {
                        "type" : "boolean"
                      },
                      "download" : {
                        "type" : "boolean"
                      },
                      "enforce" : {
                        "type" : "boolean"
                      },
                      "id" : {
                        "type" : "long"
                      },
                      "inheritanceBehavior" : {
                        "type" : "long"
                      },
                      "preview" : {
                        "type" : "boolean"
                      },
                      "read" : {
                        "type" : "boolean"
                      },
                      "remove" : {
                        "type" : "boolean"
                      },
                      "restrict" : {
                        "type" : "boolean"
                      },
                      "systemType" : {
                        "type" : "long"
                      },
                      "uploadFiles" : {
                        "type" : "boolean"
                      },
                      "view" : {
                        "type" : "boolean"
                      },
                      "write" : {
                        "type" : "boolean"
                      }
                    }
                  },
                  "createDirectories" : {
                    "type" : "boolean"
                  },
                  "createdBy" : {
                    "type" : "text",
                    "fields" : {
                      "keyword" : {
                        "type" : "keyword",
                        "ignore_above" : 256
                      }
                    }
                  },
                  "createdOn" : {
                    "type" : "date"
                  },
                  "delete" : {
                    "type" : "boolean"
                  },
                  "download" : {
                    "type" : "boolean"
                  },
                  "enforce" : {
                    "type" : "boolean"
                  },
                  "id" : {
                    "type" : "long"
                  },
                  "inheritanceBehavior" : {
                    "type" : "long"
                  },
                  "name" : {
                    "type" : "text",
                    "fields" : {
                      "keyword" : {
                        "type" : "keyword",
                        "ignore_above" : 256
                      }
                    }
                  },
                  "nodeID" : {
                    "type" : "long"
                  },
                  "nonInheritable" : {
                    "type" : "boolean"
                  },
                  "preview" : {
                    "type" : "boolean"
                  },
                  "read" : {
                    "type" : "boolean"
                  },
                  "remove" : {
                    "type" : "boolean"
                  },
                  "restrict" : {
                    "type" : "boolean"
                  },
                  "roleData" : {
                    "properties" : {
                      "accountID" : {
                        "type" : "integer"
                      },
                      "anonymous" : {
                        "type" : "boolean"
                      },
                      "hasLicense" : {
                        "type" : "boolean"
                      },
                      "id" : {
                        "type" : "long"
                      },
                      "includeInSalesforceMapping" : {
                        "type" : "boolean"
                      },
                      "memberOfRoles" : {
                        "type" : "object"
                      },
                      "name" : {
                        "type" : "text",
                        "fields" : {
                          "keyword" : {
                            "type" : "keyword",
                            "ignore_above" : 256
                          }
                        }
                      },
                      "password" : {
                        "type" : "text",
                        "fields" : {
                          "keyword" : {
                            "type" : "keyword",
                            "ignore_above" : 256
                          }
                        }
                      },
                      "profileID" : {
                        "type" : "integer"
                      },
                      "profileItems" : {
                        "properties" : {
                          "accountID" : {
                            "type" : "integer"
                          },
                          "id" : {
                            "type" : "integer"
                          },
                          "include" : {
                            "type" : "boolean"
                          },
                          "isDeleted" : {
                            "type" : "boolean"
                          },
                          "joinID" : {
                            "type" : "integer"
                          },
                          "name" : {
                            "type" : "text",
                            "fields" : {
                              "keyword" : {
                                "type" : "keyword",
                                "ignore_above" : 256
                              }
                            }
                          },
                          "position" : {
                            "type" : "integer"
                          },
                          "presetValueID" : {
                            "type" : "integer"
                          },
                          "presetValues" : {
                            "properties" : {
                              "id" : {
                                "type" : "integer"
                              },
                              "value" : {
                                "type" : "text",
                                "fields" : {
                                  "keyword" : {
                                    "type" : "keyword",
                                    "ignore_above" : 256
                                  }
                                }
                              }
                            }
                          },
                          "profileID" : {
                            "type" : "integer"
                          },
                          "required" : {
                            "type" : "boolean"
                          },
                          "type" : {
                            "type" : "integer"
                          },
                          "value" : {
                            "type" : "text",
                            "fields" : {
                              "keyword" : {
                                "type" : "keyword",
                                "ignore_above" : 256
                              }
                            }
                          },
                          "valueID" : {
                            "type" : "long"
                          }
                        }
                      },
                      "roleManagerID" : {
                        "type" : "long"
                      },
                      "roleMembers" : {
                        "type" : "object"
                      },
                      "roleType" : {
                        "type" : "integer"
                      },
                      "securityPolicyID" : {
                        "type" : "integer"
                      },
                      "systemPermissions" : {
                        "properties" : {
                          "accessLinksManagement" : {
                            "properties" : {
                              "description" : {
                                "type" : "text",
                                "fields" : {
                                  "keyword" : {
                                    "type" : "keyword",
                                    "ignore_above" : 256
                                  }
                                }
                              },
                              "enabled" : {
                                "type" : "boolean"
                              },
                              "name" : {
                                "type" : "text",
                                "fields" : {
                                  "keyword" : {
                                    "type" : "keyword",
                                    "ignore_above" : 256
                                  }
                                }
                              },
                              "requiredAccountFeature" : {
                                "type" : "integer"
                              }
                            }
                          },
                          "accessLinksUsage" : {
                            "properties" : {
                              "description" : {
                                "type" : "text",
                                "fields" : {
                                  "keyword" : {
                                    "type" : "keyword",
                                    "ignore_above" : 256
                                  }
                                }
                              },
                              "enabled" : {
                                "type" : "boolean"
                              },
                              "name" : {
                                "type" : "text",
                                "fields" : {
                                  "keyword" : {
                                    "type" : "keyword",
                                    "ignore_above" : 256
                                  }
                                }
                              },
                              "requiredAccountFeature" : {
                                "type" : "integer"
                              }
                            }
                          },
                          "auditLogManagement" : {
                            "properties" : {
                              "description" : {
                                "type" : "text",
                                "fields" : {
                                  "keyword" : {
                                    "type" : "keyword",
                                    "ignore_above" : 256
                                  }
                                }
                              },
                              "enabled" : {
                                "type" : "boolean"
                              },
                              "name" : {
                                "type" : "text",
                                "fields" : {
                                  "keyword" : {
                                    "type" : "keyword",
                                    "ignore_above" : 256
                                  }
                                }
                              },
                              "requiredAccountFeature" : {
                                "type" : "integer"
                              }
                            }
                          },
                          "eSignature" : {
                            "properties" : {
                              "description" : {
                                "type" : "text",
                                "fields" : {
                                  "keyword" : {
                                    "type" : "keyword",
                                    "ignore_above" : 256
                                  }
                                }
                              },
                              "enabled" : {
                                "type" : "boolean"
                              },
                              "name" : {
                                "type" : "text",
                                "fields" : {
                                  "keyword" : {
                                    "type" : "keyword",
                                    "ignore_above" : 256
                                  }
                                }
                              },
                              "requiredAccountFeature" : {
                                "type" : "integer"
                              }
                            }
                          },
                          "eSignatureManagement" : {
                            "properties" : {
                              "description" : {
                                "type" : "text",
                                "fields" : {
                                  "keyword" : {
                                    "type" : "keyword",
                                    "ignore_above" : 256
                                  }
                                }
                              },
                              "enabled" : {
                                "type" : "boolean"
                              },
                              "name" : {
                                "type" : "text",
                                "fields" : {
                                  "keyword" : {
                                    "type" : "keyword",
                                    "ignore_above" : 256
                                  }
                                }
                              },
                              "requiredAccountFeature" : {
                                "type" : "integer"
                              }
                            }
                          },
                          "groups" : {
                            "properties" : {
                              "description" : {
                                "type" : "text",
                                "fields" : {
                                  "keyword" : {
                                    "type" : "keyword",
                                    "ignore_above" : 256
                                  }
                                }
                              },
                              "enabled" : {
                                "type" : "boolean"
                              },
                              "name" : {
                                "type" : "text",
                                "fields" : {
                                  "keyword" : {
                                    "type" : "keyword",
                                    "ignore_above" : 256
                                  }
                                }
                              },
                              "requiredAccountFeature" : {
                                "type" : "integer"
                              }
                            }
                          },
                          "guests" : {
                            "properties" : {
                              "description" : {
                                "type" : "text",
                                "fields" : {
                                  "keyword" : {
                                    "type" : "keyword",
                                    "ignore_above" : 256
                                  }
                                }
                              },
                              "enabled" : {
                                "type" : "boolean"
                              },
                              "name" : {
                                "type" : "text",
                                "fields" : {
                                  "keyword" : {
                                    "type" : "keyword",
                                    "ignore_above" : 256
                                  }
                                }
                              },
                              "requiredAccountFeature" : {
                                "type" : "integer"
                              }
                            }
                          },
                          "licenseManagement" : {
                            "properties" : {
                              "description" : {
                                "type" : "text",
                                "fields" : {
                                  "keyword" : {
                                    "type" : "keyword",
                                    "ignore_above" : 256
                                  }
                                }
                              },
                              "enabled" : {
                                "type" : "boolean"
                              },
                              "name" : {
                                "type" : "text",
                                "fields" : {
                                  "keyword" : {
                                    "type" : "keyword",
                                    "ignore_above" : 256
                                  }
                                }
                              },
                              "requiredAccountFeature" : {
                                "type" : "integer"
                              }
                            }
                          },
                          "nodeExchange" : {
                            "properties" : {
                              "description" : {
                                "type" : "text",
                                "fields" : {
                                  "keyword" : {
                                    "type" : "keyword",
                                    "ignore_above" : 256
                                  }
                                }
                              },
                              "enabled" : {
                                "type" : "boolean"
                              },
                              "name" : {
                                "type" : "text",
                                "fields" : {
                                  "keyword" : {
                                    "type" : "keyword",
                                    "ignore_above" : 256
                                  }
                                }
                              },
                              "requiredAccountFeature" : {
                                "type" : "integer"
                              }
                            }
                          },
                          "nodeExchangeManagement" : {
                            "properties" : {
                              "description" : {
                                "type" : "text",
                                "fields" : {
                                  "keyword" : {
                                    "type" : "keyword",
                                    "ignore_above" : 256
                                  }
                                }
                              },
                              "enabled" : {
                                "type" : "boolean"
                              },
                              "name" : {
                                "type" : "text",
                                "fields" : {
                                  "keyword" : {
                                    "type" : "keyword",
                                    "ignore_above" : 256
                                  }
                                }
                              },
                              "requiredAccountFeature" : {
                                "type" : "integer"
                              }
                            }
                          },
                          "nodeManagement" : {
                            "properties" : {
                              "description" : {
                                "type" : "text",
                                "fields" : {
                                  "keyword" : {
                                    "type" : "keyword",
                                    "ignore_above" : 256
                                  }
                                }
                              },
                              "enabled" : {
                                "type" : "boolean"
                              },
                              "name" : {
                                "type" : "text",
                                "fields" : {
                                  "keyword" : {
                                    "type" : "keyword",
                                    "ignore_above" : 256
                                  }
                                }
                              },
                              "requiredAccountFeature" : {
                                "type" : "integer"
                              }
                            }
                          },
                          "nodePermissionOverride" : {
                            "properties" : {
                              "description" : {
                                "type" : "text",
                                "fields" : {
                                  "keyword" : {
                                    "type" : "keyword",
                                    "ignore_above" : 256
                                  }
                                }
                              },
                              "enabled" : {
                                "type" : "boolean"
                              },
                              "name" : {
                                "type" : "text",
                                "fields" : {
                                  "keyword" : {
                                    "type" : "keyword",
                                    "ignore_above" : 256
                                  }
                                }
                              },
                              "requiredAccountFeature" : {
                                "type" : "integer"
                              }
                            }
                          },
                          "profiles" : {
                            "properties" : {
                              "description" : {
                                "type" : "text",
                                "fields" : {
                                  "keyword" : {
                                    "type" : "keyword",
                                    "ignore_above" : 256
                                  }
                                }
                              },
                              "enabled" : {
                                "type" : "boolean"
                              },
                              "name" : {
                                "type" : "text",
                                "fields" : {
                                  "keyword" : {
                                    "type" : "keyword",
                                    "ignore_above" : 256
                                  }
                                }
                              },
                              "requiredAccountFeature" : {
                                "type" : "integer"
                              }
                            }
                          },
                          "reporting" : {
                            "properties" : {
                              "description" : {
                                "type" : "text",
                                "fields" : {
                                  "keyword" : {
                                    "type" : "keyword",
                                    "ignore_above" : 256
                                  }
                                }
                              },
                              "enabled" : {
                                "type" : "boolean"
                              },
                              "name" : {
                                "type" : "text",
                                "fields" : {
                                  "keyword" : {
                                    "type" : "keyword",
                                    "ignore_above" : 256
                                  }
                                }
                              },
                              "requiredAccountFeature" : {
                                "type" : "integer"
                              }
                            }
                          },
                          "retentionAdmin" : {
                            "properties" : {
                              "description" : {
                                "type" : "text",
                                "fields" : {
                                  "keyword" : {
                                    "type" : "keyword",
                                    "ignore_above" : 256
                                  }
                                }
                              },
                              "enabled" : {
                                "type" : "boolean"
                              },
                              "name" : {
                                "type" : "text",
                                "fields" : {
                                  "keyword" : {
                                    "type" : "keyword",
                                    "ignore_above" : 256
                                  }
                                }
                              },
                              "requiredAccountFeature" : {
                                "type" : "integer"
                              }
                            }
                          },
                          "retentionUnlock" : {
                            "properties" : {
                              "description" : {
                                "type" : "text",
                                "fields" : {
                                  "keyword" : {
                                    "type" : "keyword",
                                    "ignore_above" : 256
                                  }
                                }
                              },
                              "enabled" : {
                                "type" : "boolean"
                              },
                              "name" : {
                                "type" : "text",
                                "fields" : {
                                  "keyword" : {
                                    "type" : "keyword",
                                    "ignore_above" : 256
                                  }
                                }
                              },
                              "requiredAccountFeature" : {
                                "type" : "integer"
                              }
                            }
                          },
                          "salesForceManagement" : {
                            "properties" : {
                              "description" : {
                                "type" : "text",
                                "fields" : {
                                  "keyword" : {
                                    "type" : "keyword",
                                    "ignore_above" : 256
                                  }
                                }
                              },
                              "enabled" : {
                                "type" : "boolean"
                              },
                              "name" : {
                                "type" : "text",
                                "fields" : {
                                  "keyword" : {
                                    "type" : "keyword",
                                    "ignore_above" : 256
                                  }
                                }
                              },
                              "requiredAccountFeature" : {
                                "type" : "integer"
                              }
                            }
                          },
                          "systemSettings" : {
                            "properties" : {
                              "description" : {
                                "type" : "text",
                                "fields" : {
                                  "keyword" : {
                                    "type" : "keyword",
                                    "ignore_above" : 256
                                  }
                                }
                              },
                              "enabled" : {
                                "type" : "boolean"
                              },
                              "name" : {
                                "type" : "text",
                                "fields" : {
                                  "keyword" : {
                                    "type" : "keyword",
                                    "ignore_above" : 256
                                  }
                                }
                              },
                              "requiredAccountFeature" : {
                                "type" : "integer"
                              }
                            }
                          },
                          "templates" : {
                            "properties" : {
                              "description" : {
                                "type" : "text",
                                "fields" : {
                                  "keyword" : {
                                    "type" : "keyword",
                                    "ignore_above" : 256
                                  }
                                }
                              },
                              "enabled" : {
                                "type" : "boolean"
                              },
                              "name" : {
                                "type" : "text",
                                "fields" : {
                                  "keyword" : {
                                    "type" : "keyword",
                                    "ignore_above" : 256
                                  }
                                }
                              },
                              "requiredAccountFeature" : {
                                "type" : "integer"
                              }
                            }
                          },
                          "users" : {
                            "properties" : {
                              "description" : {
                                "type" : "text",
                                "fields" : {
                                  "keyword" : {
                                    "type" : "keyword",
                                    "ignore_above" : 256
                                  }
                                }
                              },
                              "enabled" : {
                                "type" : "boolean"
                              },
                              "name" : {
                                "type" : "text",
                                "fields" : {
                                  "keyword" : {
                                    "type" : "keyword",
                                    "ignore_above" : 256
                                  }
                                }
                              },
                              "requiredAccountFeature" : {
                                "type" : "integer"
                              }
                            }
                          },
                          "workflowManagement" : {
                            "properties" : {
                              "description" : {
                                "type" : "text",
                                "fields" : {
                                  "keyword" : {
                                    "type" : "keyword",
                                    "ignore_above" : 256
                                  }
                                }
                              },
                              "enabled" : {
                                "type" : "boolean"
                              },
                              "name" : {
                                "type" : "text",
                                "fields" : {
                                  "keyword" : {
                                    "type" : "keyword",
                                    "ignore_above" : 256
                                  }
                                }
                              },
                              "requiredAccountFeature" : {
                                "type" : "integer"
                              }
                            }
                          }
                        }
                      },
                      "userID" : {
                        "type" : "long"
                      },
                      "userName" : {
                        "type" : "text",
                        "fields" : {
                          "keyword" : {
                            "type" : "keyword",
                            "ignore_above" : 256
                          }
                        }
                      }
                    }
                  },
                  "roleID" : {
                    "type" : "long"
                  },
                  "roleName" : {
                    "type" : "text",
                    "fields" : {
                      "keyword" : {
                        "type" : "keyword",
                        "ignore_above" : 256
                      }
                    }
                  },
                  "systemType" : {
                    "type" : "integer"
                  },
                  "uploadFiles" : {
                    "type" : "boolean"
                  },
                  "view" : {
                    "type" : "boolean"
                  },
                  "write" : {
                    "type" : "boolean"
                  }
                }
              },
              "size" : {
                "type" : "long"
              },
              "systemType" : {
                "type" : "integer"
              }
            }
          },
          "nodeComment" : {
            "properties" : {
              "accountID" : {
                "type" : "integer"
              },
              "createdBy" : {
                "type" : "text",
                "fields" : {
                  "keyword" : {
                    "type" : "keyword",
                    "ignore_above" : 256
                  }
                }
              },
              "createdByUserID" : {
                "type" : "long"
              },
              "createdOn" : {
                "type" : "date"
              },
              "id" : {
                "type" : "integer"
              },
              "lastModifiedByUserID" : {
                "type" : "long"
              },
              "lastModifiedOn" : {
                "type" : "date"
              },
              "nodeID" : {
                "type" : "long"
              },
              "text" : {
                "type" : "text",
                "fields" : {
                  "keyword" : {
                    "type" : "keyword",
                    "ignore_above" : 256
                  },
                  "lowercase" : {
                    "type" : "keyword",
                    "ignore_above" : 32000,
                    "normalizer" : "lowercase"
                  }
                }
              }
            }
          },
          "nodeID" : {
            "type" : "text",
            "fields" : {
              "keyword" : {
                "type" : "keyword",
                "ignore_above" : 256
              }
            }
          },
          "profileID" : {
            "type" : "integer"
          },
          "profileItems" : {
            "type" : "nested",
            "properties" : {
              "boolValue" : {
                "type" : "boolean"
              },
              "dateTimeValue" : {
                "type" : "date"
              },
              "doubleValue" : {
                "type" : "float"
              },
              "id" : {
                "type" : "long"
              },
              "longValue" : {
                "type" : "long"
              },
              "presetValueID" : {
                "type" : "long"
              },
              "type" : {
                "type" : "long"
              },
              "value" : {
                "type" : "text",
                "fields" : {
                  "lowercase" : {
                    "type" : "keyword",
                    "ignore_above" : 32000,
                    "normalizer" : "lowercase"
                  }
                }
              }
            }
          }
        }
      }
    }
}
Postman Queries (pulled from reshard testing)

mapping with parameters

Put: https://vpc-rubex-elasticsearch-prod-8-6-soqlodwed3jcm7gcbrpwhguh7a.us-east-1.es.amazonaws.com/rubex_usprod_idx_012022/_mapping/nodebaseindexitem

 

Body:

 

{
     "properties" : {
          "accountID" : {
            "type" : "integer"
          },
          "attachment" : {
            "properties" : {
              "author" : {
                "type" : "text",
                "fields" : {
                  "keyword" : {
                    "type" : "keyword",
                    "ignore_above" : 256
                  }
                }
              },
              "containsMetadata" : {
                "type" : "boolean"
              },
              "content" : {
                "type" : "text",
                "fields" : {
                  "keyword" : {
                    "type" : "keyword",
                    "ignore_above" : 256
                  }
                }
              },
              "content_length" : {
                "type" : "long"
              },
              "content_type" : {
                "type" : "text",
                "fields" : {
                  "keyword" : {
                    "type" : "keyword",
                    "ignore_above" : 256
                  }
                }
              },
              "date" : {
                "type" : "date"
              },
              "detect_language" : {
                "type" : "boolean"
              },
              "indexed_chars" : {
                "type" : "long"
              },
              "keywords" : {
                "type" : "text",
                "fields" : {
                  "keyword" : {
                    "type" : "keyword",
                    "ignore_above" : 256
                  }
                }
              },
              "language" : {
                "type" : "text",
                "fields" : {
                  "keyword" : {
                    "type" : "keyword",
                    "ignore_above" : 256
                  }
                }
              },
              "name" : {
                "type" : "text",
                "fields" : {
                  "keyword" : {
                    "type" : "keyword",
                    "ignore_above" : 256
                  }
                }
              },
              "title" : {
                "type" : "text",
                "fields" : {
                  "keyword" : {
                    "type" : "keyword",
                    "ignore_above" : 256
                  }
                }
              }
            }
          },
          "content" : {
            "type" : "text",
            "fields" : {
              "keyword" : {
                "type" : "keyword",
                "ignore_above" : 256
              }
            }
          },
          "deletedOn" : {
            "type" : "date"
          },
          "fileInfoId" : {
            "type" : "long"
          },
          "id" : {
            "type" : "text",
            "fields" : {
              "keyword" : {
                "type" : "keyword",
                "ignore_above" : 256
              }
            }
          },
          "joinField" : {
            "type" : "join",
            "eager_global_ordinals" : true,
            "relations" : {
              "nodeindexitem" : [
                "nodecommentindexitem",
                "nodeprofileindexitem",
                "fileindexitem"
              ]
            }
          },
          "node" : {
            "properties" : {
              "accountID" : {
                "type" : "integer"
              },
              "checkoutInfo" : {
                "properties" : {
                  "checkedOutByRoleID" : {
                    "type" : "long"
                  },
                  "checkedOutOn" : {
                    "type" : "date"
                  },
                  "nodeId" : {
                    "type" : "long"
                  },
                  "o365ClientLock" : {
                    "type" : "text",
                    "fields" : {
                      "keyword" : {
                        "type" : "keyword",
                        "ignore_above" : 256
                      }
                    }
                  },
                  "o365ClientLockedOn" : {
                    "type" : "date"
                  }
                }
              },
              "createdBy" : {
                "type" : "text",
                "fields" : {
                  "keyword" : {
                    "type" : "keyword",
                    "ignore_above" : 256
                  }
                }
              },
              "createdByUserID" : {
                "type" : "long"
              },
              "createdOn" : {
                "type" : "date"
              },
              "fileInfo" : {
                "properties" : {
                  "checkedOutByRoleID" : {
                    "type" : "long"
                  },
                  "createdOn" : {
                    "type" : "date"
                  },
                  "fileExtension" : {
                    "type" : "text",
                    "fields" : {
                      "keyword" : {
                        "type" : "keyword",
                        "ignore_above" : 256
                      }
                    }
                  },
                  "formFillDefinitionId" : {
                    "type" : "integer"
                  },
                  "id" : {
                    "type" : "long"
                  },
                  "sizeInBytes" : {
                    "type" : "long"
                  },
                  "uploadIdentifier" : {
                    "type" : "text",
                    "fields" : {
                      "keyword" : {
                        "type" : "keyword",
                        "ignore_above" : 256
                      }
                    }
                  },
                  "uploadSuccessful" : {
                    "type" : "boolean"
                  }
                }
              },
              "hasChildren" : {
                "type" : "boolean"
              },
              "id" : {
                "type" : "text",
                "fields" : {
                  "keyword" : {
                    "type" : "keyword",
                    "ignore_above" : 256
                  }
                }
              },
              "modifiedOn" : {
                "type" : "date"
              },
              "name" : {
                "type" : "text",
                "fields" : {
                  "keyword" : {
                    "type" : "keyword",
                    "ignore_above" : 256
                  },
                  "lowercase" : {
                    "type" : "keyword",
                    "ignore_above" : 32000,
                    "normalizer" : "lowercase"
                  }
                },
                "analyzer" : "nodeNameAnalyzer"
              },
              "nodeProvider" : {
                "type" : "integer"
              },
              "parentID" : {
                "type" : "text",
                "fields" : {
                  "keyword" : {
                    "type" : "keyword",
                    "ignore_above" : 256
                  }
                }
              },
              "permission" : {
                "properties" : {
                  "admin" : {
                    "type" : "boolean"
                  },
                  "childPermission" : {
                    "properties" : {
                      "admin" : {
                        "type" : "boolean"
                      },
                      "createDirectories" : {
                        "type" : "boolean"
                      },
                      "createdOn" : {
                        "type" : "date"
                      },
                      "delete" : {
                        "type" : "boolean"
                      },
                      "download" : {
                        "type" : "boolean"
                      },
                      "enforce" : {
                        "type" : "boolean"
                      },
                      "id" : {
                        "type" : "long"
                      },
                      "inheritanceBehavior" : {
                        "type" : "long"
                      },
                      "preview" : {
                        "type" : "boolean"
                      },
                      "read" : {
                        "type" : "boolean"
                      },
                      "remove" : {
                        "type" : "boolean"
                      },
                      "restrict" : {
                        "type" : "boolean"
                      },
                      "systemType" : {
                        "type" : "long"
                      },
                      "uploadFiles" : {
                        "type" : "boolean"
                      },
                      "view" : {
                        "type" : "boolean"
                      },
                      "write" : {
                        "type" : "boolean"
                      }
                    }
                  },
                  "createDirectories" : {
                    "type" : "boolean"
                  },
                  "createdBy" : {
                    "type" : "text",
                    "fields" : {
                      "keyword" : {
                        "type" : "keyword",
                        "ignore_above" : 256
                      }
                    }
                  },
                  "createdOn" : {
                    "type" : "date"
                  },
                  "delete" : {
                    "type" : "boolean"
                  },
                  "download" : {
                    "type" : "boolean"
                  },
                  "enforce" : {
                    "type" : "boolean"
                  },
                  "id" : {
                    "type" : "long"
                  },
                  "inheritanceBehavior" : {
                    "type" : "long"
                  },
                  "name" : {
                    "type" : "text",
                    "fields" : {
                      "keyword" : {
                        "type" : "keyword",
                        "ignore_above" : 256
                      }
                    }
                  },
                  "nodeID" : {
                    "type" : "long"
                  },
                  "nonInheritable" : {
                    "type" : "boolean"
                  },
                  "preview" : {
                    "type" : "boolean"
                  },
                  "read" : {
                    "type" : "boolean"
                  },
                  "remove" : {
                    "type" : "boolean"
                  },
                  "restrict" : {
                    "type" : "boolean"
                  },
                  "roleData" : {
                    "properties" : {
                      "accountID" : {
                        "type" : "integer"
                      },
                      "anonymous" : {
                        "type" : "boolean"
                      },
                      "hasLicense" : {
                        "type" : "boolean"
                      },
                      "id" : {
                        "type" : "long"
                      },
                      "includeInSalesforceMapping" : {
                        "type" : "boolean"
                      },
                      "memberOfRoles" : {
                        "type" : "object"
                      },
                      "name" : {
                        "type" : "text",
                        "fields" : {
                          "keyword" : {
                            "type" : "keyword",
                            "ignore_above" : 256
                          }
                        }
                      },
                      "password" : {
                        "type" : "text",
                        "fields" : {
                          "keyword" : {
                            "type" : "keyword",
                            "ignore_above" : 256
                          }
                        }
                      },
                      "profileID" : {
                        "type" : "integer"
                      },
                      "profileItems" : {
                        "properties" : {
                          "accountID" : {
                            "type" : "integer"
                          },
                          "id" : {
                            "type" : "integer"
                          },
                          "include" : {
                            "type" : "boolean"
                          },
                          "isDeleted" : {
                            "type" : "boolean"
                          },
                          "joinID" : {
                            "type" : "integer"
                          },
                          "name" : {
                            "type" : "text",
                            "fields" : {
                              "keyword" : {
                                "type" : "keyword",
                                "ignore_above" : 256
                              }
                            }
                          },
                          "position" : {
                            "type" : "integer"
                          },
                          "presetValueID" : {
                            "type" : "integer"
                          },
                          "presetValues" : {
                            "properties" : {
                              "id" : {
                                "type" : "integer"
                              },
                              "value" : {
                                "type" : "text",
                                "fields" : {
                                  "keyword" : {
                                    "type" : "keyword",
                                    "ignore_above" : 256
                                  }
                                }
                              }
                            }
                          },
                          "profileID" : {
                            "type" : "integer"
                          },
                          "required" : {
                            "type" : "boolean"
                          },
                          "type" : {
                            "type" : "integer"
                          },
                          "value" : {
                            "type" : "text",
                            "fields" : {
                              "keyword" : {
                                "type" : "keyword",
                                "ignore_above" : 256
                              }
                            }
                          },
                          "valueID" : {
                            "type" : "long"
                          }
                        }
                      },
                      "roleManagerID" : {
                        "type" : "long"
                      },
                      "roleMembers" : {
                        "type" : "object"
                      },
                      "roleType" : {
                        "type" : "integer"
                      },
                      "securityPolicyID" : {
                        "type" : "integer"
                      },
                      "systemPermissions" : {
                        "properties" : {
                          "accessLinksManagement" : {
                            "properties" : {
                              "description" : {
                                "type" : "text",
                                "fields" : {
                                  "keyword" : {
                                    "type" : "keyword",
                                    "ignore_above" : 256
                                  }
                                }
                              },
                              "enabled" : {
                                "type" : "boolean"
                              },
                              "name" : {
                                "type" : "text",
                                "fields" : {
                                  "keyword" : {
                                    "type" : "keyword",
                                    "ignore_above" : 256
                                  }
                                }
                              },
                              "requiredAccountFeature" : {
                                "type" : "integer"
                              }
                            }
                          },
                          "accessLinksUsage" : {
                            "properties" : {
                              "description" : {
                                "type" : "text",
                                "fields" : {
                                  "keyword" : {
                                    "type" : "keyword",
                                    "ignore_above" : 256
                                  }
                                }
                              },
                              "enabled" : {
                                "type" : "boolean"
                              },
                              "name" : {
                                "type" : "text",
                                "fields" : {
                                  "keyword" : {
                                    "type" : "keyword",
                                    "ignore_above" : 256
                                  }
                                }
                              },
                              "requiredAccountFeature" : {
                                "type" : "integer"
                              }
                            }
                          },
                          "auditLogManagement" : {
                            "properties" : {
                              "description" : {
                                "type" : "text",
                                "fields" : {
                                  "keyword" : {
                                    "type" : "keyword",
                                    "ignore_above" : 256
                                  }
                                }
                              },
                              "enabled" : {
                                "type" : "boolean"
                              },
                              "name" : {
                                "type" : "text",
                                "fields" : {
                                  "keyword" : {
                                    "type" : "keyword",
                                    "ignore_above" : 256
                                  }
                                }
                              },
                              "requiredAccountFeature" : {
                                "type" : "integer"
                              }
                            }
                          },
                          "eSignature" : {
                            "properties" : {
                              "description" : {
                                "type" : "text",
                                "fields" : {
                                  "keyword" : {
                                    "type" : "keyword",
                                    "ignore_above" : 256
                                  }
                                }
                              },
                              "enabled" : {
                                "type" : "boolean"
                              },
                              "name" : {
                                "type" : "text",
                                "fields" : {
                                  "keyword" : {
                                    "type" : "keyword",
                                    "ignore_above" : 256
                                  }
                                }
                              },
                              "requiredAccountFeature" : {
                                "type" : "integer"
                              }
                            }
                          },
                          "eSignatureManagement" : {
                            "properties" : {
                              "description" : {
                                "type" : "text",
                                "fields" : {
                                  "keyword" : {
                                    "type" : "keyword",
                                    "ignore_above" : 256
                                  }
                                }
                              },
                              "enabled" : {
                                "type" : "boolean"
                              },
                              "name" : {
                                "type" : "text",
                                "fields" : {
                                  "keyword" : {
                                    "type" : "keyword",
                                    "ignore_above" : 256
                                  }
                                }
                              },
                              "requiredAccountFeature" : {
                                "type" : "integer"
                              }
                            }
                          },
                          "groups" : {
                            "properties" : {
                              "description" : {
                                "type" : "text",
                                "fields" : {
                                  "keyword" : {
                                    "type" : "keyword",
                                    "ignore_above" : 256
                                  }
                                }
                              },
                              "enabled" : {
                                "type" : "boolean"
                              },
                              "name" : {
                                "type" : "text",
                                "fields" : {
                                  "keyword" : {
                                    "type" : "keyword",
                                    "ignore_above" : 256
                                  }
                                }
                              },
                              "requiredAccountFeature" : {
                                "type" : "integer"
                              }
                            }
                          },
                          "guests" : {
                            "properties" : {
                              "description" : {
                                "type" : "text",
                                "fields" : {
                                  "keyword" : {
                                    "type" : "keyword",
                                    "ignore_above" : 256
                                  }
                                }
                              },
                              "enabled" : {
                                "type" : "boolean"
                              },
                              "name" : {
                                "type" : "text",
                                "fields" : {
                                  "keyword" : {
                                    "type" : "keyword",
                                    "ignore_above" : 256
                                  }
                                }
                              },
                              "requiredAccountFeature" : {
                                "type" : "integer"
                              }
                            }
                          },
                          "licenseManagement" : {
                            "properties" : {
                              "description" : {
                                "type" : "text",
                                "fields" : {
                                  "keyword" : {
                                    "type" : "keyword",
                                    "ignore_above" : 256
                                  }
                                }
                              },
                              "enabled" : {
                                "type" : "boolean"
                              },
                              "name" : {
                                "type" : "text",
                                "fields" : {
                                  "keyword" : {
                                    "type" : "keyword",
                                    "ignore_above" : 256
                                  }
                                }
                              },
                              "requiredAccountFeature" : {
                                "type" : "integer"
                              }
                            }
                          },
                          "nodeExchange" : {
                            "properties" : {
                              "description" : {
                                "type" : "text",
                                "fields" : {
                                  "keyword" : {
                                    "type" : "keyword",
                                    "ignore_above" : 256
                                  }
                                }
                              },
                              "enabled" : {
                                "type" : "boolean"
                              },
                              "name" : {
                                "type" : "text",
                                "fields" : {
                                  "keyword" : {
                                    "type" : "keyword",
                                    "ignore_above" : 256
                                  }
                                }
                              },
                              "requiredAccountFeature" : {
                                "type" : "integer"
                              }
                            }
                          },
                          "nodeExchangeManagement" : {
                            "properties" : {
                              "description" : {
                                "type" : "text",
                                "fields" : {
                                  "keyword" : {
                                    "type" : "keyword",
                                    "ignore_above" : 256
                                  }
                                }
                              },
                              "enabled" : {
                                "type" : "boolean"
                              },
                              "name" : {
                                "type" : "text",
                                "fields" : {
                                  "keyword" : {
                                    "type" : "keyword",
                                    "ignore_above" : 256
                                  }
                                }
                              },
                              "requiredAccountFeature" : {
                                "type" : "integer"
                              }
                            }
                          },
                          "nodeManagement" : {
                            "properties" : {
                              "description" : {
                                "type" : "text",
                                "fields" : {
                                  "keyword" : {
                                    "type" : "keyword",
                                    "ignore_above" : 256
                                  }
                                }
                              },
                              "enabled" : {
                                "type" : "boolean"
                              },
                              "name" : {
                                "type" : "text",
                                "fields" : {
                                  "keyword" : {
                                    "type" : "keyword",
                                    "ignore_above" : 256
                                  }
                                }
                              },
                              "requiredAccountFeature" : {
                                "type" : "integer"
                              }
                            }
                          },
                          "nodePermissionOverride" : {
                            "properties" : {
                              "description" : {
                                "type" : "text",
                                "fields" : {
                                  "keyword" : {
                                    "type" : "keyword",
                                    "ignore_above" : 256
                                  }
                                }
                              },
                              "enabled" : {
                                "type" : "boolean"
                              },
                              "name" : {
                                "type" : "text",
                                "fields" : {
                                  "keyword" : {
                                    "type" : "keyword",
                                    "ignore_above" : 256
                                  }
                                }
                              },
                              "requiredAccountFeature" : {
                                "type" : "integer"
                              }
                            }
                          },
                          "profiles" : {
                            "properties" : {
                              "description" : {
                                "type" : "text",
                                "fields" : {
                                  "keyword" : {
                                    "type" : "keyword",
                                    "ignore_above" : 256
                                  }
                                }
                              },
                              "enabled" : {
                                "type" : "boolean"
                              },
                              "name" : {
                                "type" : "text",
                                "fields" : {
                                  "keyword" : {
                                    "type" : "keyword",
                                    "ignore_above" : 256
                                  }
                                }
                              },
                              "requiredAccountFeature" : {
                                "type" : "integer"
                              }
                            }
                          },
                          "reporting" : {
                            "properties" : {
                              "description" : {
                                "type" : "text",
                                "fields" : {
                                  "keyword" : {
                                    "type" : "keyword",
                                    "ignore_above" : 256
                                  }
                                }
                              },
                              "enabled" : {
                                "type" : "boolean"
                              },
                              "name" : {
                                "type" : "text",
                                "fields" : {
                                  "keyword" : {
                                    "type" : "keyword",
                                    "ignore_above" : 256
                                  }
                                }
                              },
                              "requiredAccountFeature" : {
                                "type" : "integer"
                              }
                            }
                          },
                          "retentionAdmin" : {
                            "properties" : {
                              "description" : {
                                "type" : "text",
                                "fields" : {
                                  "keyword" : {
                                    "type" : "keyword",
                                    "ignore_above" : 256
                                  }
                                }
                              },
                              "enabled" : {
                                "type" : "boolean"
                              },
                              "name" : {
                                "type" : "text",
                                "fields" : {
                                  "keyword" : {
                                    "type" : "keyword",
                                    "ignore_above" : 256
                                  }
                                }
                              },
                              "requiredAccountFeature" : {
                                "type" : "integer"
                              }
                            }
                          },
                          "retentionUnlock" : {
                            "properties" : {
                              "description" : {
                                "type" : "text",
                                "fields" : {
                                  "keyword" : {
                                    "type" : "keyword",
                                    "ignore_above" : 256
                                  }
                                }
                              },
                              "enabled" : {
                                "type" : "boolean"
                              },
                              "name" : {
                                "type" : "text",
                                "fields" : {
                                  "keyword" : {
                                    "type" : "keyword",
                                    "ignore_above" : 256
                                  }
                                }
                              },
                              "requiredAccountFeature" : {
                                "type" : "integer"
                              }
                            }
                          },
                          "salesForceManagement" : {
                            "properties" : {
                              "description" : {
                                "type" : "text",
                                "fields" : {
                                  "keyword" : {
                                    "type" : "keyword",
                                    "ignore_above" : 256
                                  }
                                }
                              },
                              "enabled" : {
                                "type" : "boolean"
                              },
                              "name" : {
                                "type" : "text",
                                "fields" : {
                                  "keyword" : {
                                    "type" : "keyword",
                                    "ignore_above" : 256
                                  }
                                }
                              },
                              "requiredAccountFeature" : {
                                "type" : "integer"
                              }
                            }
                          },
                          "systemSettings" : {
                            "properties" : {
                              "description" : {
                                "type" : "text",
                                "fields" : {
                                  "keyword" : {
                                    "type" : "keyword",
                                    "ignore_above" : 256
                                  }
                                }
                              },
                              "enabled" : {
                                "type" : "boolean"
                              },
                              "name" : {
                                "type" : "text",
                                "fields" : {
                                  "keyword" : {
                                    "type" : "keyword",
                                    "ignore_above" : 256
                                  }
                                }
                              },
                              "requiredAccountFeature" : {
                                "type" : "integer"
                              }
                            }
                          },
                          "templates" : {
                            "properties" : {
                              "description" : {
                                "type" : "text",
                                "fields" : {
                                  "keyword" : {
                                    "type" : "keyword",
                                    "ignore_above" : 256
                                  }
                                }
                              },
                              "enabled" : {
                                "type" : "boolean"
                              },
                              "name" : {
                                "type" : "text",
                                "fields" : {
                                  "keyword" : {
                                    "type" : "keyword",
                                    "ignore_above" : 256
                                  }
                                }
                              },
                              "requiredAccountFeature" : {
                                "type" : "integer"
                              }
                            }
                          },
                          "users" : {
                            "properties" : {
                              "description" : {
                                "type" : "text",
                                "fields" : {
                                  "keyword" : {
                                    "type" : "keyword",
                                    "ignore_above" : 256
                                  }
                                }
                              },
                              "enabled" : {
                                "type" : "boolean"
                              },
                              "name" : {
                                "type" : "text",
                                "fields" : {
                                  "keyword" : {
                                    "type" : "keyword",
                                    "ignore_above" : 256
                                  }
                                }
                              },
                              "requiredAccountFeature" : {
                                "type" : "integer"
                              }
                            }
                          },
                          "workflowManagement" : {
                            "properties" : {
                              "description" : {
                                "type" : "text",
                                "fields" : {
                                  "keyword" : {
                                    "type" : "keyword",
                                    "ignore_above" : 256
                                  }
                                }
                              },
                              "enabled" : {
                                "type" : "boolean"
                              },
                              "name" : {
                                "type" : "text",
                                "fields" : {
                                  "keyword" : {
                                    "type" : "keyword",
                                    "ignore_above" : 256
                                  }
                                }
                              },
                              "requiredAccountFeature" : {
                                "type" : "integer"
                              }
                            }
                          }
                        }
                      },
                      "userID" : {
                        "type" : "long"
                      },
                      "userName" : {
                        "type" : "text",
                        "fields" : {
                          "keyword" : {
                            "type" : "keyword",
                            "ignore_above" : 256
                          }
                        }
                      }
                    }
                  },
                  "roleID" : {
                    "type" : "long"
                  },
                  "roleName" : {
                    "type" : "text",
                    "fields" : {
                      "keyword" : {
                        "type" : "keyword",
                        "ignore_above" : 256
                      }
                    }
                  },
                  "systemType" : {
                    "type" : "integer"
                  },
                  "uploadFiles" : {
                    "type" : "boolean"
                  },
                  "view" : {
                    "type" : "boolean"
                  },
                  "write" : {
                    "type" : "boolean"
                  }
                }
              },
              "size" : {
                "type" : "long"
              },
              "systemType" : {
                "type" : "integer"
              }
            }
          },
          "nodeComment" : {
            "properties" : {
              "accountID" : {
                "type" : "integer"
              },
              "createdBy" : {
                "type" : "text",
                "fields" : {
                  "keyword" : {
                    "type" : "keyword",
                    "ignore_above" : 256
                  }
                }
              },
              "createdByUserID" : {
                "type" : "long"
              },
              "createdOn" : {
                "type" : "date"
              },
              "id" : {
                "type" : "integer"
              },
              "lastModifiedByUserID" : {
                "type" : "long"
              },
              "lastModifiedOn" : {
                "type" : "date"
              },
              "nodeID" : {
                "type" : "long"
              },
              "text" : {
                "type" : "text",
                "fields" : {
                  "keyword" : {
                    "type" : "keyword",
                    "ignore_above" : 256
                  },
                  "lowercase" : {
                    "type" : "keyword",
                    "ignore_above" : 32000,
                    "normalizer" : "lowercase"
                  }
                }
              }
            }
          },
          "nodeID" : {
            "type" : "text",
            "fields" : {
              "keyword" : {
                "type" : "keyword",
                "ignore_above" : 256
              }
            }
          },
          "profileID" : {
            "type" : "integer"
          },
          "profileItems" : {
            "type" : "nested",
            "properties" : {
              "boolValue" : {
                "type" : "boolean"
              },
              "dateTimeValue" : {
                "type" : "date"
              },
              "doubleValue" : {
                "type" : "float"
              },
              "id" : {
                "type" : "long"
              },
              "longValue" : {
                "type" : "long"
              },
              "presetValueID" : {
                "type" : "long"
              },
              "type" : {
                "type" : "long"
              },
              "value" : {
                "type" : "text",
                "fields" : {
                  "lowercase" : {
                    "type" : "keyword",
                    "ignore_above" : 32000,
                    "normalizer" : "lowercase"
                  }
                }
              }
            }
          }
        }
}
Postman Queries (pulled from reshard testing)

wait for completion

Post: https://vpc-rubex-elasticsearch-prod-8-6-soqlodwed3jcm7gcbrpwhguh7a.us-east-1.es.amazonaws.com/_snapshot/s3_repository/prod-snapshot-10-14-2020?wait_for_completion=true

Authorization:

image.png

Body:

{
"type": "s3",
"indicies":"fileindexitemindex",
"settings": {
"bucket": "efc-elasticsearch-prod-export",
"role_arn": "arn:aws:iam::748883581865:role/es-to-s3-repository-staging-role"
}
}

 

Postman Queries (pulled from reshard testing)

nodes stats

Get: https://vpc-rubex-elasticsearch-prod-8-6-soqlodwed3jcm7gcbrpwhguh7a.us-east-1.es.amazonaws.com/_nodes/stats?pretty

 

 

Postman Queries (pulled from reshard testing)

Kibana

https://vpc-rubex-elasticsearch-prod-8-6-soqlodwed3jcm7gcbrpwhguh7a.us-east-1.es.amazonaws.com/_plugin/kibana/app/kibana#/dev_tools/console?_g=()

 

Console (in Dev Tools):

GET _cat/indices?v
GET nodebaseindexitemindex/_settings
GET _snapshot?pretty

PUT rubex_usprod_indextesting

GET /_cluster/state

GET nodebaseindexitemindex/_settings
POST _reindex

GET _tasks?detailed=true&actions=*reindex

GET  rubex-usprod-esclusteridx?pretty

GET _tasks?detailed=true&actions=*reindex

GET rubex_usprod_newindex2022/_settings

GET rubex-usprod-esclusteridx/_mapping
GET rubex_usprod_newindex2022/_mapping?pretty=true

GET rubex_foo/_mapping/_nodebaseindexitem
GET _cat/indices?v


GET _cat/shards/nodebaseindexitemindex?v
GET _cat/pending_tasks
GET nodebaseindexitemindex

ElasticSearch to s3 snapshot

ElasticSearch to s3 snapshot

Steps to link ES cluster to s3 and create/restore snapshots

In the Account that the S3 bucket is going to live, create a new IAM policy with the following permissions:

{
    "Version": "2012-10-17",
    "Statement": [
        {
            "Sid": "VisualEditor0",
            "Effect": "Allow",
            "Action": "iam:PassRole",
            "Resource": [
                "arn:aws:s3:::S3-BUCKET-NAME/*",
                "arn:aws:iam::ACCOUNT-ID:role/*"
            ]
        },
        {
            "Sid": "VisualEditor1",
            "Effect": "Allow",
            "Action": "s3:ListBucket",
            "Resource": "arn:aws:s3:::S3-BUCKET-NAME"
        },
        {
            "Sid": "VisualEditor2",
            "Effect": "Allow",
            "Action": [
                "s3:PutObject",
                "s3:GetObject",
                "s3:DeleteObject"
            ],
            "Resource": "arn:aws:s3:::S3-BUCKET-NAME/*"
        }
    ]
}


Create a new Role in that AWS account with the above policy, and also create a Trust permission with the following details:

{
    "Version": "2012-10-17",
    "Statement": [
        {
            "Sid": "Statement1",
            "Effect": "Allow",
            "Principal": {
                "Service": "es.amazonaws.com"
            },
            "Action": "sts:AssumeRole"
        }
    ]
}


Create a new user in the account and give it the the policy created earlier


---------Create connection to repository
    
PUT: https://SOURCE-CLUSTER-ENDPOINT/_snapshot/snapshot-respository

Body: as JSON
    {   "type": "s3",
    "settings": {
        "bucket": "S3-BUCKET-NAME",
        "region": "us-east-1",
        "role_arn": "ARN FOR THE NEWLY CREATED ROLE"
    }
 }


--------Create backup

PUT: https://vpc-rbx-stg-es-6-8-f7kozzmqn3r2ygnqsqicjlrism.us-east-1.es.amazonaws.com/_snapshot/snapshot-respository/2023-01-05

--------Restore Status
GET: https://vpc-rbx-stg-es-6-8-f7kozzmqn3r2ygnqsqicjlrism.us-east-1.es.amazonaws.com/_snapshot/snapshot-respository/2023-01-05/_status


------Restore
POST: https://vpc-rbx-stg-es-6-8-shardings-ma7dgqmnnngrd6wthxwfgkot5u.us-east-1.es.amazonaws.com/_snapshot/snapshot-respository/2023-01-05/_restore

------Restore status
GET: https://vpc-rbx-stg-es-6-8-shardings-ma7dgqmnnngrd6wthxwfgkot5u.us-east-1.es.amazonaws.com/_cat/recovery