Programatic Communication

[smpa01]

I need to progrmatically send data from notebook and my research shows possible techs are

1. Graph API

2. Azure Logic App

3. Azure Communication Services

4. outlook smtp through python - does not seem to be supported by outlook anymore.

5. Outlook Activity in data pipeline has no attachment option

6. Power Automate - When a HTTP request is recieved (POST to a listener)- has no attachment option for Sending Email

7. Are there any other options?

It seems enabling graph for sending email (outlook mail rest api) requires a lot of risk assesment by IT for application permission . I am guessing delegated permission will not be useful to send dynamic emails.

Can anyone shed some light on achieving this task using Azure Comm Services if they have used it for a similar need?

@zenisekd @jwinchell40 @FabianSchut @AndreyBear @AlexisOlson 

similar post 

Thank you in advance

[v-veshwara-msft]

Hi @smpa01 ,

Just checking in to see if you query is resolved and if any responses were helpful. If so, kindly consider marking the helpful reply as 'Accepted Solution' to help others with similar queries. 

Otherwise, feel free to reach out for further assistance.

Thank you.

[jwinchell40 · Accepted solution]

@smpa01 - I haven't done this from a notebook yet in Fabric but in a prior role we used SendGrid from WebApps and Databricks.  We didn't have to send a lot per day so the Free plan covered us. 

https://azuremarketplace.microsoft.com/en-us/marketplace/apps/sendgrid.tsg-saas-offer?tab=PlansAndPr... 

[smpa01]

@jwinchell40 this is great. So SendGrid has an Api I guess, since you used it from databricks notebook. If yes, do you mind passing on the the documentation please. I will give this a spin. I am not entirely sure if I can limit ourselves to the daily threshold ( 20 reports x unknown dynamic daily offenders ) but I am willing to give this a try. Thanks for sharing.

[jwinchell40]

@smpa01 - I no longer work for that company so I do not have access to the code.  However, the documentation is pretty good and they have a Python example here:  

https://www.twilio.com/docs/sendgrid/for-developers/sending-email/quickstart-python

We will also be starting to integrate this into a Web App we've built so I should have another working example soon-ish.

[LillyBeast]

Just to make sure I can suggest an appropriate solution, can you describe your whole pipeline?

We currently hit graph api send email from fabric notebooks, as this was the only way to directly inject very large payloads into delegated dynamic emails - large enough to exceed fabric pipeline notebook activity output buffer, which is why we figured out a way to keep the entire process in a notebook.
This is, theoretically, the fastest and most capable way of doing anything involving graph api out of a fabric notebook - anything you can delegate consent for! However, that process requires setting up an azure app registration + azure key vault to handle caching for graph api tokens.
So, maybe there is a smaller/easier solve for your specific case. 🙂

[nilendraFabric]

Hello @smpa01 

We had a good discussion here on the same topic, see if this helps 

https://community.fabric.microsoft.com/t5/Data-Engineering/How-to-send-an-email-with-an-attached-fil...