Aggregation count for email Body


I've an Aggregation Response in the below format, and would like to report on {{ctx.payload.aggregations.errors.buckets.COM.errorDetails.errorDetails.doc_count}}.

Aggregation Response:

aggregations": {
"errors": {
"buckets": {
"COM": {
"doc_count": 64,
"errorDetails.errorDetails": {
"doc_count": 104,
"by_code": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
"key": "1001",
"doc_count": 64
"key": "1002",
"doc_count": 40

The goal is to have the count information in the email Body.
I don't see any output for {{ctx.payload.aggregations.errors.buckets.COM.errorDetails.errorDetails.doc_count}} in the Body of the send_Email action (expected is 104).

Please advice. Thanks!


please take the time to properly format your messages, this makes it much easier to read, and also to copy/paste.

Try to remove the . form your bucket name. Use errorDetails instead of errorDetails.errorDetails.


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