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:

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:

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"
}
}
Body:
{
"source": {
"index": "nodebaseindexitemindex"
},
"dest": {
"index":
}
}
Body:
{
"source": {
"index": "nodebaseindexitemindex"
},
"dest": {
"index": "rubex_usprod_idx_012022"
}
}
Body:
{
"conflicts": "proceed",
"source": {
"index": "nodebaseindexitemindex"
},
"dest": {
"index": "rubex_usprod_idx_012022",
"op_type": "create",
"version_type": "internal"
}
}
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”
}
}
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:

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