Skip to content

Example Formatting-Templates

RDA uses Jinja2 Templating Engine to format data to make it suitable for REST Endpoints, HTML Reports sent via email, and many other formats as needed by various integration endpoints.

This page contains formatting templates that are used by some of the example pipelines.

Formatting templates are consumed by Bots @dm:apply-template-by-row and @dm:apply-template-all-rows

Formatting-Template: Email HTML Template

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
<html>
<body>

<table cellspacing="2" width='90%'>
<tr bgcolor='#00CCFF'>
    <td>Incident</td><td><b>{{ number }}</b></td>
</tr>
<tr>
     <td>Priority</td><td><b>{{ priority }}</b></td>
</tr>
<tr>
     <td>State</td><td><b>{{ state }}</b></td>
</tr>
<tr>
     <td>Title</td><td><b>{{ short_description }}</b></td>
</tr>
<tr>
     <td>Description</td><td><pre>{{ description }}</td>
</tr>
</table>

</body>
</html>

You may run following pipeline snippet to load the formatting template into your environment:

1
2
3
4
@dm:add-template
    url = 'https://bot-docs.cloudfabrix.io/data/ft/ft-f9f-Email-HTML-Template' &
    name = 'Email HTML Template' &
    description = ''

Playground

Try this in RDA Playground

Pipelines using this Formatting-Template



Formatting-Template: Incident Slack Template

1
2
3
4
5
6
7
8
9
Incident: *{{number}}*
Title: *{{short_description}}*
Priority: *{{priority}}*
State: *{{state}}*
Create: *{{sys_created_on}}*
Description:
====================================================
{{description}}
====================================================

You may run following pipeline snippet to load the formatting template into your environment:

1
2
3
4
@dm:add-template
    url = 'https://bot-docs.cloudfabrix.io/data/ft/ft-360-Incident-Slack-Template' &
    name = 'Incident Slack Template' &
    description = ''

Playground

Try this in RDA Playground

Pipelines using this Formatting-Template



Formatting-Template: News Template HTML

1
<p><h3>News that doesn't make you Snooze. <i>Generated by CloudFabrix RDA Bots</i></h3><ul>{%for row in rows%}<li><a href='{{ row.link }}'>{{ row.title }}</a></li>{% endfor %}</li></ul></p>

You may run following pipeline snippet to load the formatting template into your environment:

1
2
3
4
@dm:add-template
    url = 'https://bot-docs.cloudfabrix.io/data/ft/ft-a04-News-Template-HTML' &
    name = 'News Template HTML' &
    description = ''

Playground

Try this in RDA Playground



Formatting-Template: PagerDuty Create Incident Template

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
{
    "incident": {
        "type": "incident",
        "title": "{{ incident_key }}: {{ incident_title }}",
                "service": {
                   "id": "{{service_id}}",
                   "type": "service_reference"
                },
            "priority": {
            "id": "{{priority_id}}",
            "type": "priority_reference"
        },
        "urgency": "{{ urgency_id }}",
        "body": {
            "type": "incident_body",
            "details": "{{ body_details }}"
        }
    }
}

You may run following pipeline snippet to load the formatting template into your environment:

1
2
3
4
5
@dm:add-template
    url = 'https://bot-docs.cloudfabrix.io/data/ft/ft-35a-PagerDuty-Create-Incident-Template' &
    name = 'PagerDuty Create Incident Template' &
    description = '## This is a template to capture Payload for PagerDuty Incident Creation.
'

Playground

Try this in RDA Playground

Pipelines using this Formatting-Template



Formatting-Template: Sendgrid Email Payload

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
{
  "personalizations": [
    {
      "to": [
        {
          "email": "{{recipient}}"
        }
      ]
    }
  ],
  "from": {
    "email": "tejo.prayaga@roboticdata.ai",
    "name": "{{bot_name}}"
  },
  "reply_to": {
    "email": "no-reply@roboticdata.ai",
    "name": "{{bot_name}}"
  },
  "subject": "{{subject}}",
  "content": [
    {
      "type": "text/html",
      "value": "{{message}}"
    }
  ]
}

You may run following pipeline snippet to load the formatting template into your environment:

1
2
3
4
@dm:add-template
    url = 'https://bot-docs.cloudfabrix.io/data/ft/ft-bc9-Sendgrid-Email-Payload' &
    name = 'Sendgrid Email Payload' &
    description = ''

Playground

Try this in RDA Playground



Formatting-Template: Splunk-Template

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
{
    "index": "{{index}}",
    "source" : "{{source}}",
    "sourcetype" : "{{sourcetype}}",
    "server" : "{{splunk_server}}",
    "host" : "{{host}}",
    "cfx_received_time": "{{cfx_received_time}}",
    "_bkt":"{{_bkt}}",
    "_raw":"{{_raw}}",
    "_time":"{{_time}}",
    "splunk_server":"{{splunk_server}}",
    "message":"{{message}}",
    "enrich_cols": "{{enrich_cols}}"
}

You may run following pipeline snippet to load the formatting template into your environment:

1
2
3
4
@dm:add-template
    url = 'https://bot-docs.cloudfabrix.io/data/ft/ft-048-Splunk-Template' &
    name = 'Splunk-Template' &
    description = 'Splunk to Webhook'

Playground

Try this in RDA Playground



Formatting-Template: appd-event-notification-to-webex-template

  1
  2
  3
  4
  5
  6
  7
  8
  9
 10
 11
 12
 13
 14
 15
 16
 17
 18
 19
 20
 21
 22
 23
 24
 25
 26
 27
 28
 29
 30
 31
 32
 33
 34
 35
 36
 37
 38
 39
 40
 41
 42
 43
 44
 45
 46
 47
 48
 49
 50
 51
 52
 53
 54
 55
 56
 57
 58
 59
 60
 61
 62
 63
 64
 65
 66
 67
 68
 69
 70
 71
 72
 73
 74
 75
 76
 77
 78
 79
 80
 81
 82
 83
 84
 85
 86
 87
 88
 89
 90
 91
 92
 93
 94
 95
 96
 97
 98
 99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
{
    "roomId": "{{roomId}}",
    "markdown": "AppDynamics Event Notification",
    "attachments": [{
        "contentType": "application/vnd.microsoft.card.adaptive",
        "content": {
            "type": "AdaptiveCard",
            "body": [{
                    "type": "ColumnSet",
                    "columns": [{
                            "type": "Column",
                            "items": [{
                                "type": "Image",
                                "style": "Person",
                                "url": "https://cloudfabrix.com/blog/wp-content/uploads/2022/05/rdabot.png",
                                "size": "Medium",
                                "height": "40px"
                            }],
                            "width": "auto"
                        },
                        {
                            "type": "Column",
                            "items": [{
                                    "type": "TextBlock",
                                        "horizontalAlignment": "Left",
                                    "text": "CloudFabrix Databot",
                                    "weight": "Lighter",
                                    "color": "Accent"
                                },
                                {
                                    "type": "TextBlock",
                                    "weight": "Bolder",
                                    "text": "AppDynamics Event: {{ id }}",
                                    "verticalAlignment": "Left",
                                    "wrap": true,
                                    "color": "Light",
                                    "size": "Large",
                                    "spacing": "Small"
                                }
                            ],
                            "width": "stretch"
                        }
                    ]
                },
                {
                    "type": "ColumnSet",
                    "columns": [{
                            "type": "Column",
                            "width": 35,
                            "items": [{
                                    "type": "TextBlock",
                                    "text": "App Name:",
                                    "color": "Light"
                                },
                                {
                                    "type": "TextBlock",
                                    "text": "Impacted Entity:",
                                    "weight": "Lighter",
                                    "color": "Light",
                                    "spacing": "Small"
                                },
                                {
                                    "type": "TextBlock",
                                    "text": "Created:",
                                    "weight": "Lighter",
                                    "color": "Light",
                                    "spacing": "Small"
                                },

                                {
                                    "type": "TextBlock",
                                    "text": "Severity:",
                                    "weight": "Lighter",
                                    "color": "Light",
                                    "spacing": "Small"
                                },

                                {
                                    "type": "TextBlock",
                                    "text": "Type:",
                                    "weight": "Lighter",
                                    "color": "Light",
                                    "spacing": "Small"
                                },

                                {
                                    "type": "TextBlock",
                                    "text": "Summary:",
                                    "weight": "Lighter",
                                    "color": "Light",
                                    "spacing": "Small"
                                }

                            ]
                        },
                        {
                            "type": "Column",
                            "width": 65,
                            "items": [{
                                    "type": "TextBlock",
                                    "text": "{{app_name}}",
                                    "color": "Light"
                                },
                                {
                                    "type": "TextBlock",
                                    "text": "{{ affectedEntities_name }}",
                                    "color": "Light",
                                    "weight": "Lighter",
                                    "spacing": "Small"
                                },
                                {
                                    "type": "TextBlock",
                                    "text": "{{ eventTime }}",
                                    "weight": "Lighter",
                                    "color": "Light",
                                    "spacing": "Small"
                                },

                                {
                                    "type": "TextBlock",
                                    "text": "{{ severity }}",
                                    "weight": "Lighter",
                                    "color": "Light",
                                    "spacing": "Small"
                                },

                                {
                                    "type": "TextBlock",
                                    "text": "{{ type }}",
                                    "weight": "Lighter",
                                    "color": "Light",
                                    "spacing": "Small"
                                },


                                {
                                    "type": "TextBlock",
                                    "text": "{{ summary }}",
                                    "weight": "Lighter",
                                    "color": "Light",
                                    "spacing": "Small"
                                }


                            ]
                        }
                    ],
                    "spacing": "Padding",
                    "horizontalAlignment": "Center"
                },
                {
                    "type": "TextBlock",
                    "text": "{{ description }}",
                    "wrap": true
                },
                {
                    "type": "TextBlock",
                    "text": "Resources:"
                },
                {
                    "type": "ColumnSet",
                    "columns": [{
                            "type": "Column",
                            "width": "auto",
                            "items": [{
                                "type": "Image",
                                "altText": "",
                                "url": "https://developer.webex.com/images/link-icon.png",
                                "size": "Small",
                                "width": "30px"
                            }],
                            "spacing": "Small"
                        },
                        {
                            "type": "Column",
                            "width": "stretch",
                            "items": [{
                                "type": "TextBlock",
                                "text": "[{{ id }}]({{deepLinkUrl}})",
                                "horizontalAlignment": "Left",
                                "size": "Medium"
                            }],
                            "verticalContentAlignment": "Left",
                            "horizontalAlignment": "Left",
                            "spacing": "Small"
                        }
                    ]
                }
            ],
            "$schema": "http://adaptivecards.io/schemas/adaptive-card.json",
            "version": "1.2"
        }
    }]
}

You may run following pipeline snippet to load the formatting template into your environment:

1
2
3
4
@dm:add-template
    url = 'https://bot-docs.cloudfabrix.io/data/ft/ft-ca6-appd-event-notification-to-webex-template' &
    name = 'appd-event-notification-to-webex-template' &
    description = ''

Playground

Try this in RDA Playground



Formatting-Template: cato-payload-template

  1
  2
  3
  4
  5
  6
  7
  8
  9
 10
 11
 12
 13
 14
 15
 16
 17
 18
 19
 20
 21
 22
 23
 24
 25
 26
 27
 28
 29
 30
 31
 32
 33
 34
 35
 36
 37
 38
 39
 40
 41
 42
 43
 44
 45
 46
 47
 48
 49
 50
 51
 52
 53
 54
 55
 56
 57
 58
 59
 60
 61
 62
 63
 64
 65
 66
 67
 68
 69
 70
 71
 72
 73
 74
 75
 76
 77
 78
 79
 80
 81
 82
 83
 84
 85
 86
 87
 88
 89
 90
 91
 92
 93
 94
 95
 96
 97
 98
 99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
{
  accountMetrics(
    accountID: {{accountID}}
    timeFrame: "{{timeFrame}}"
    groupInterfaces: {{groupInterfaces}}
    groupDevices: {{groupDevices}}
  ) {
    id
    from
    to
    granularity
    sites {
      id
      interfaces {
        metrics {
          duration
          granularity
          bytesDownstream
          bytesUpstream
          bytesTotal
          lostDownstream
          lostDownstreamPcnt
          lostUpstream
          lostUpstreamPcnt
          packetsDownstream
          packetsUpstream
          jitterUpstream
          jitterDownstream
          packetsDiscardedDownstream
          packetsDiscardedUpstream
          rtt
          hostCount
          hostLimit
          flowCount
        }
        name
        timeseries {
          data
          label
          sum
          units
          info
        }
        annotations {
          time
          label
          shortLabel
          type
        }
        periods {
          duration
          title
          type
        }
        remoteIPInfo {
          ip
          countryCode
          countryName
          city
          state
          provider
          latitude
          longitude
        }
        remoteIP
        socketInfo {
          id
          serial
          isPrimary
          platform
          version
          versionUpdateTime
        }
        ipsecInfo {
          isPrimary
          catoIP
          remoteIP
          ikeVersion
        }
        interfaceInfo {
          id
          name
          upstreamBandwidth
          downstreamBandwidth
        }
      }
      metrics {
        duration
        granularity
        bytesDownstream
        bytesUpstream
        bytesTotal
        lostDownstream
        lostDownstreamPcnt
        lostUpstream
        lostUpstreamPcnt
        packetsDownstream
        packetsUpstream
        jitterUpstream
        jitterDownstream
        packetsDiscardedDownstream
        packetsDiscardedUpstream
        rtt
        hostCount
        hostLimit
        flowCount
      }
      name
      info {
        name
        type
        description
        countryCode
        region
        countryName
        isHA
        connType
        creationTime
        sockets {
          id
          serial
          isPrimary
          platform
          version
          versionUpdateTime
        }
        ipsec {
          isPrimary
          catoIP
          remoteIP
          ikeVersion
        }
      }
      hostCount {
        data
        label
        sum
        units
        info
      }
      flowCount {
        data
        label
        sum
        units
        info
      }
      hostLimit {
        data
        label
        sum
        units
        info
      }
    }
    timeseries {
      label
    }
  }
}

You may run following pipeline snippet to load the formatting template into your environment:

1
2
3
4
@dm:add-template
    url = 'https://bot-docs.cloudfabrix.io/data/ft/ft-f91-cato-payload-template' &
    name = 'cato-payload-template' &
    description = ''

Playground

Try this in RDA Playground

Pipelines using this Formatting-Template



Formatting-Template: mondaydotcom-graphql-template

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
{ boards (limit:1) {
  name
  id
  description
  items {
    name
    column_values {
      title
      id
      type
      text
} } } }

You may run following pipeline snippet to load the formatting template into your environment:

1
2
3
4
@dm:add-template
    url = 'https://bot-docs.cloudfabrix.io/data/ft/ft-645-mondaydotcom-graphql-template' &
    name = 'mondaydotcom-graphql-template' &
    description = ''

Playground

Try this in RDA Playground

Pipelines using this Formatting-Template



Formatting-Template: webex-payload-with-card

  1
  2
  3
  4
  5
  6
  7
  8
  9
 10
 11
 12
 13
 14
 15
 16
 17
 18
 19
 20
 21
 22
 23
 24
 25
 26
 27
 28
 29
 30
 31
 32
 33
 34
 35
 36
 37
 38
 39
 40
 41
 42
 43
 44
 45
 46
 47
 48
 49
 50
 51
 52
 53
 54
 55
 56
 57
 58
 59
 60
 61
 62
 63
 64
 65
 66
 67
 68
 69
 70
 71
 72
 73
 74
 75
 76
 77
 78
 79
 80
 81
 82
 83
 84
 85
 86
 87
 88
 89
 90
 91
 92
 93
 94
 95
 96
 97
 98
 99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
{
    "roomId": "{{roomId}}",
    "markdown": "Incident Notification",
    "attachments": [{
        "contentType": "application/vnd.microsoft.card.adaptive",
        "content": {
            "type": "AdaptiveCard",
            "body": [{
                    "type": "ColumnSet",
                    "columns": [{
                            "type": "Column",
                            "items": [{
                                "type": "Image",
                                "style": "Person",
                                "url": "https://cloudfabrix.com/blog/wp-content/uploads/2022/05/rdabot.png",
                                "size": "Medium",
                                "height": "40px"
                            }],
                            "width": "auto"
                        },
                        {
                            "type": "Column",
                            "items": [{
                                    "type": "TextBlock",
                                        "horizontalAlignment": "Left",
                                    "text": "CloudFabrix Databot",
                                    "weight": "Lighter",
                                    "color": "Accent"
                                },
                                {
                                    "type": "TextBlock",
                                    "weight": "Bolder",
                                    "text": "ServiceNow Incident: {{ number }}",
                                    "verticalAlignment": "Left",
                                    "wrap": true,
                                    "color": "Light",
                                    "size": "Large",
                                    "spacing": "Small"
                                }
                            ],
                            "width": "stretch"
                        }
                    ]
                },
                {
                    "type": "ColumnSet",
                    "columns": [{
                            "type": "Column",
                            "width": 35,
                            "items": [{
                                    "type": "TextBlock",
                                    "text": "Created:",
                                    "color": "Light"
                                },
                                {
                                    "type": "TextBlock",
                                    "text": "Priority:",
                                    "weight": "Lighter",
                                    "color": "Light",
                                    "spacing": "Small"
                                },
                                {
                                    "type": "TextBlock",
                                    "text": "State:",
                                    "weight": "Lighter",
                                    "color": "Light",
                                    "spacing": "Small"
                                },

                                {
                                    "type": "TextBlock",
                                    "text": "Category:",
                                    "weight": "Lighter",
                                    "color": "Light",
                                    "spacing": "Small"
                                },

                                {
                                    "type": "TextBlock",
                                    "text": "Subcategory:",
                                    "weight": "Lighter",
                                    "color": "Light",
                                    "spacing": "Small"
                                },

                                {
                                    "type": "TextBlock",
                                    "text": "Configuration Item:",
                                    "weight": "Lighter",
                                    "color": "Light",
                                    "spacing": "Small"
                                },



                                {
                                    "type": "TextBlock",
                                    "text": "Caller:",
                                    "weight": "Lighter",
                                    "color": "Light",
                                    "spacing": "Small"
                                },
                                {
                                    "type": "TextBlock",
                                    "text": "Age:",
                                    "weight": "Lighter",
                                    "color": "Light",
                                    "spacing": "Small"
                                },

                                {
                                    "type": "TextBlock",
                                    "text": "Title:",
                                    "weight": "Lighter",
                                    "color": "Light",
                                    "spacing": "Small"
                                }
                            ]
                        },
                        {
                            "type": "Column",
                            "width": 65,
                            "items": [{
                                    "type": "TextBlock",
                                    "text": "{{ sys_created_on}}",
                                    "color": "Light"
                                },
                                {
                                    "type": "TextBlock",
                                    "text": "{{ priority }}",
                                    "color": "Light",
                                    "weight": "Lighter",
                                    "spacing": "Small"
                                },
                                {
                                    "type": "TextBlock",
                                    "text": "{{ state }}",
                                    "weight": "Lighter",
                                    "color": "Light",
                                    "spacing": "Small"
                                },

                                {
                                    "type": "TextBlock",
                                    "text": "{{ category }}",
                                    "weight": "Lighter",
                                    "color": "Light",
                                    "spacing": "Small"
                                },

                                {
                                    "type": "TextBlock",
                                    "text": "{{ subcategory }}",
                                    "weight": "Lighter",
                                    "color": "Light",
                                    "spacing": "Small"
                                },


                                {
                                    "type": "TextBlock",
                                    "text": "{{ cmdb_ci }}",
                                    "weight": "Lighter",
                                    "color": "Light",
                                    "spacing": "Small"
                                },


                                {
                                    "type": "TextBlock",
                                    "text": "{{ caller_id }}",
                                    "weight": "Lighter",
                                    "color": "Light",
                                    "spacing": "Small"
                                },

                                {
                                    "type": "TextBlock",
                                    "text": "{{ calendar_duration }}",
                                    "weight": "Lighter",
                                    "color": "Light",
                                    "spacing": "Small"
                                },

                                {
                                    "type": "TextBlock",
                                    "text": "{{ short_description }}",
                                    "weight": "Lighter",
                                    "color": "Light",
                                    "spacing": "Small"
                                }

                            ]
                        }
                    ],
                    "spacing": "Padding",
                    "horizontalAlignment": "Center"
                },
                {
                    "type": "TextBlock",
                    "text": "{{ description }}",
                    "wrap": true
                },
                {
                    "type": "TextBlock",
                    "text": "Resources:"
                },
                {
                    "type": "ColumnSet",
                    "columns": [{
                            "type": "Column",
                            "width": "auto",
                            "items": [{
                                "type": "Image",
                                "altText": "",
                                "url": "https://developer.webex.com/images/link-icon.png",
                                "size": "Small",
                                "width": "30px"
                            }],
                            "spacing": "Small"
                        },
                        {
                            "type": "Column",
                            "width": "stretch",
                            "items": [{
                                "type": "TextBlock",
                                "text": "[{{ number }}](https://{{snowhostId}}.service-now.com/task.do?sys_id={{ number }})",
                                "horizontalAlignment": "Left",
                                "size": "Medium"
                            }],
                            "verticalContentAlignment": "Left",
                            "horizontalAlignment": "Left",
                            "spacing": "Small"
                        }
                    ]
                }
            ],
            "$schema": "http://adaptivecards.io/schemas/adaptive-card.json",
            "version": "1.2"
        }
    }]
}

You may run following pipeline snippet to load the formatting template into your environment:

1
2
3
4
@dm:add-template
    url = 'https://bot-docs.cloudfabrix.io/data/ft/ft-4b9-webex-payload-with-card' &
    name = 'webex-payload-with-card' &
    description = ''

Playground

Try this in RDA Playground