How Insert or Update document in ElasticSearch NEST 6

Asked Sep 23 '18 at 05:57

Active Sep 23 '18 at 06:26

Viewed 954 times

How to Insert or Update document in ElasticSearch NEST 6

I want to store web page view event per user to elastic index. if ViewEvent for the specific user exists then Insert, else plus 1 count of existing ViewEvent.

The elastic document type is Post

public class ViewEvent
{
    public int UserId {get; set;}
    public int Count {get; set;}
}

I can do this by following the REST request:

http://192.168.20.80:9200/db/ViewEvent/2/_update

{
    "script": {
        "lang": "painless",
        "source": "ctx._source.count += 1;"
    },
    "upsert" : {
        "userId": 2,
        "count": 1
    }
}

Problem is when I try to do this by NEST client. Update part through the following code done.

var response1 = await _vastContext.Client(indexName)
    .UpdateByQueryAsync<VastEvent>(u => u.Query(query => 
                query.Terms(term => term.Field(f => f.UserId).Terms(2)))
    .Script(script => script.Source($"ctx._source.count += 1;")
            .Lang(ScriptLang.Painless)));

I cannot add upsert part to the request!

edited Sep 23 '18 at 06:26

asked Sep 23 '18 at 05:57

Mohammad Akbari

4,486
6
43
74

I believe this post can come in handy https://stackoverflow.com/questions/39025484/elasticsearch-nest-insert-update – Green Sep 23 '18 at 10:21
You're using `.UpdateByQuery(...)`. You should use `.Update(...)` instead – Russ Cam Sep 24 '18 at 00:01
@Green, I need script part but the post that you mentioned not have script part – Mohammad Akbari Oct 08 '18 at 06:03
@Russ Cam, by Update how add query part – Mohammad Akbari Oct 08 '18 at 06:03

How Insert or Update document in ElasticSearch NEST 6

0 Answers0