# How do I create a composite aggregate in c#

**URL:** https://discuss.elastic.co/t/how-do-i-create-a-composite-aggregate-in-c/355563
**Category:** Elasticsearch
**Created:** [March 17, 2024, 7:16pm UTC](https://discuss.elastic.co/t/how-do-i-create-a-composite-aggregate-in-c/355563 "2024-03-17T19:16:05Z")
**Posts on this page:** 3
**Page:** 1

<div class="post-metadata">

### Author: ![Eric\_Paul](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/eric_paul/32/47825_2.png) [@Eric\_Paul](https://discuss.elastic.co/u/Eric_Paul)
#### Post date: [March 17, 2024, 7:16pm UTC](https://discuss.elastic.co/t/how-do-i-create-a-composite-aggregate-in-c/355563/1 "2024-03-17T19:16:05Z")

</div>

I have been trying for days now to duplicate the following query in c#

```auto
POST /traces-apm*/_async_search
{
  "size": 0,
  "query": {
    "bool": {
      "must": [
        {
          "wildcard": {
            "url.original": "*.js"
          }
        },
        {
          "range": {
            "@timestamp": {
              "gte": "2024-03-11T00:00:00.000Z",
              "lte": "2024-03-11T23:59:59.999Z"
            }
          }
        }
      ]
    }
  },
  "aggs": {
    "unique_combinations": {
      "composite": {
        "sources": [
          {
            "site": {
              "terms": {
                "field": "labels.site"
              }
            }
          },
          {
            "url": {
              "terms": {
                "field": "url.original"
              }
            }
          }
        ],
        "size": 2 
      }
    }
  }
}

```

Nothing I have done seems to even come close. I'm pretty sure I want a composite aggregate but since there is very little documentation I'm playing a big guessing game. So far I have:

```auto
private static SearchRequestDescriptor<dynamic> GetSearchRequestDescriptorAggregateTransactions(string indexes,
    int size,
    string scrollTimeout, DateTime utcStartDate, DateTime utcEndDate)
{
    var searchRequestDescriptor = new SearchRequestDescriptor<dynamic>();
    searchRequestDescriptor.Index(indexes);
    searchRequestDescriptor.Size(size);
    searchRequestDescriptor.Scroll(scrollTimeout);
    searchRequestDescriptor.Query(q => q
        .Bool(b => b
            .Must(m => m
                .Range(r => r
                    .DateRange(d => d
                        .Field("@timestamp")
                        .Gt(utcStartDate)
                        .Lte(utcEndDate)
                    )
                )
                .Wildcard(w => w
                    .Field("url.original")
                    .Value("*.js"))
            )
        )
    );

    ICollection<IDictionary<string, CompositeAggregationSource>> sources =
        new List<IDictionary<string, CompositeAggregationSource>>();

    var siteSource = new CompositeAggregationSource
    {
        Terms = new TermsAggregation("labels.site")
    };

    var urlSource = new CompositeAggregationSource
    {
        Terms = new TermsAggregation("url.original")
    };

    sources.Add(new Dictionary<string, CompositeAggregationSource>
    {
        { "site", siteSource }
    });

    sources.Add(new Dictionary<string, CompositeAggregationSource>
    {
        { "url", urlSource }
    });

    var compAggDesc = new CompositeAggregationDescriptor<dynamic>();
    compAggDesc.Sources(sources);

    searchRequestDescriptor.Aggregations(a => a
        .Composite("composite", d => d.Sources(sources
            ).Size(2)
        )
    );

    searchRequestDescriptor.Aggregations(a => a
        .Composite("composite", d => d
            .Aggregations(aa => aa.Terms("unique", t => t
                .Field("labels.site")
                .Field("url.original")
                .Size(2)
                )
            )
            .Sources(sources)
        )
    );

    searchRequestDescriptor.Sort(s => s
        .Field("@timestamp")
    );

    return searchRequestDescriptor;
}

```

But this just produces the following error:  
[composite] failed to parse field [sources]" CausedBy: "Type: x\_content\_parse\_exception Reason: "[9:17] [terms] unknown field [terms]

As far as I can see I did not pass any filed named "terms"  
Anyone know how to use the elastic.clients.Elasticsearch library?

---

<div class="post-metadata">

### Author: ![Eric\_Paul](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/eric_paul/32/47825_2.png) [@Eric\_Paul](https://discuss.elastic.co/u/Eric_Paul)
#### Post date: [March 18, 2024, 11:47am UTC](https://discuss.elastic.co/t/how-do-i-create-a-composite-aggregate-in-c/355563/2 "2024-03-18T11:47:52Z")

</div>

So it looks like the real answer is to use the out-dated nest library. The lack of updates and and documentation to the elastic.clients.elasticsearch library seem to tell me that I need to start looking for something to replace elasticsearch in my tech stack. Elastic clearly doesn't see the .Net community as important to their long term strategies. If they did they'd be more aggressive in supporting .Net.

---

<div class="post-metadata">

### Author: ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)
#### Post date: [April 15, 2024, 11:48am UTC](https://discuss.elastic.co/t/how-do-i-create-a-composite-aggregate-in-c/355563/3 "2024-04-15T11:48:19Z")

</div>

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.