Send a json file via email using workflows

[elenaperez]

Hi team 😊

I have a workflow with a variable that contains a lot of information I want to send via email.

The information is too large to be sent via email directly so I need a json file to be sent. I don't see a way to attach files though.

What is the best way to do this? I've tried with Power Automate and Microsoft Entra but don't have enough permissions.

Maybe via FTP? But how?

Thanks in advance!

[sujit_k_singh]

Hi @elenaperez 

The built-in Send Email action in Dynatrace Workflows does not support file attachments  it only supports sending text/Markdown content in the email body, this is a known limitation.

The most reliable workaround: use the built-in HTTP Request action to call an external email API that supports attachments , encoding your JSON variable into the payload. Store the API key in the Credential Vault. This sidesteps the Power Automate/Entra permissions issue since you're not going through Microsoft at all.

Or 2nd approach could be, use HTTP Request to upload the JSON somewhere accessible (S3, Blob Storage or a file server.) then use the Send Email action to send a link to the file rather than the file itself.

Thanks,

Sujit

[elenaperez]

I don't think I understand the solution. Where do I get the external email API from?
Could you provide an example of how you would do this, please?

[sujit_k_singh]

Hi @elenaperez 

Sure, this is absolutely possible using Dynatrace Workflows. Here's how I've done it:

I have used here HTTP Request action with SendGrid API

Step 1: Generate JSON data (JavaScript action) sample example 

Step 2: Send email with attachment (HTTP Request action)
Method: POST
URL: https://api.sendgrid.com/v3/mail/send
Authentication: Bearer token (store your SendGrid API key in Credential Vault)
Payload:

Store your API key in Dynatrace Credential Vault

now run the flow

This approach works for any JSON data — problem notifications, metric exports, custom reports, etc.

Now i got this email with attachment

Thanks,

Sujit

[elenaperez]

This won't be possible for them because their email blocks anything coming from SendGrid.
Would it be possible to send the json to an Ubuntu machine somehow? Maybe with EdgeConnect?

[sujit_k_singh · Accepted solution]

Hi @elenaperez 

Yes, its possible.

I tested this on my end — it works! Here's what I did:

• Dynatrace tenant with EdgeConnect configured to reach my Ubuntu machine
• Simple Flask webhook listener on the Ubuntu box (port 5000)
• Dynatrace Workflow: On demand trigger → Run JavaScript (generate JSON) → HTTP Request (POST to webhook via EdgeConnect)

Thanks,

Sujit

[AntonPineiro]

Hi,

Maybe this can be a product idea.

Best regards

[sujit_k_singh]

Hello,

Yes, this is right use case for product idea.

Thanks,

Sujit