I was trying to create a rest api point for aggregation in elasticsearch using spring data elasticsearch. I am able to get the data in service layer but when controller (i.e. @RestController) is trying to return it to postman i am getting this error.
Could not write JSON: For input string:
"bHRMZzc5aHdodDF5a0hOck15Lzl1UT09"; nested exception is
com.fasterxml.jackson.databind.JsonMappingException: For input string:
"bHRMZzc5aHdodDF5a0hOck15Lzl1UT09" (through reference chain:
org.springframework.data.elasticsearch.core.aggregation.impl.AggregatedPageImpl["aggregations"]->org.elasticsearch.search.aggregations.InternalAggregations["asMap"]->java.util.Collections$UnmodifiableMap["memberNumberToken"]->org.elasticsearch.search.aggregations.bucket.terms.StringTerms["buckets"]->java.util.ArrayList[0]->org.elasticsearch.search.aggregations.bucket.terms.StringTerms$Bucket["keyAsNumber"])
My Mapping file is this
{
"transactions" : {
"properties" : {
"refernceId" : {
"type" :"text",
"index": true,
"store": true
},
"postingDate" : {
"type" : "date",
"index": true,
"store": true,
"format" : "yyyy-MM-dd'T'HH:mm:ss'Z'"
},
"effectiveDate" : {
"type" : "date",
"index": true,
"store": true,
"format" : "yyyy-MM-dd'T'HH:mm:ss'Z'"
},
"effectiveTime" : {
"type" : "text",
"index": true,
"store": true
},
"effectiveEpochTime" : {
"type" : "long",
"index": true,
"store": true
},
"transactionAmount" : {
"type" : "double",
"index": true,
"store": true
},
"transactionType" : {
"type" : "keyword",
"index": true,
"store": true
},
"transactionDesc" : {
"type" : "text",
"index": true,
"store": true
},
"transactionMemo" : {
"type" : "text",
"index": true,
"store": true
},
"transactionNumber" : {
"type" : "text",
"index": true,
"store": true
},
"transactionTypeCode" : {
"type" : "text",
"index": true,
"store": true
},
"transactionStatus" : {
"type" : "keyword",
"index": true,
"store": true
},
"principalAmount" : {
"type" : "double",
"index": true,
"store": true
},
"interest" : {
"type" : "text",
"index": true,
"store": true
},
"accountNumberToken" : {
"type" : "keyword",
"index": true,
"store": true
},
"memberNumberToken" : {
"type" : "keyword",
"index": true,
"store": true
},
"accountType" : {
"type" : "keyword",
"index": true,
"store": true
},
"userSub" : {
"type" : "keyword",
"index": true,
"store": true
},
"tenant" : {
"type" : "keyword",
"index": true,
"store": true
}
}
}
}