How to get blob file data content using ADF

Arundhati Sen 151 Reputation points
2023-08-17T14:32:17.9766667+00:00

In Logic Apps we have an option to get blob content and use that content further (as an attachment to send in mail)

User's image

User's image

From ADF is there any similar way to get the blob content and send that as an attachment.

In ADF using webactivity and passing sendGrid API, I am able to send mail
User's image

Using sendGrid API in body section we can send attachments also by sending the content.
https://docs.sendgrid.com/api-reference/mail-send/mail-send

Please let me know is there any way to get the blob data content directly in ADF. As we don't want dependency on LogicApp

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
11,623 questions
{count} votes

2 answers

Sort by: Most helpful
  1. ShaikMaheer-MSFT 38,546 Reputation points Microsoft Employee Moderator
    2023-08-18T17:04:46.3366667+00:00

    Hi Arundhati Sen,

    Thank you for posting query in Microsoft Q&A Platform.

    From the ADF side you can make API calls to any service. So, in this case to your Send Grid also it can be possible to do. Coming to having attachment in send grid, if any API provides such functionality, then use you can make that API call using web activity. If no such Api in send grid and configuration of attachment needs to be done in that Send Grid, then consider doing so and making API call to it from ADF web activity.

    Hope this helps. Please let me know how it goes.

    0 comments No comments

  2. ShaikMaheer-MSFT 38,546 Reputation points Microsoft Employee Moderator
    2023-08-21T06:08:21.0466667+00:00

    Hi Arundhati Sen, Glad to know that your issue resolved. So I hope you are using Http connector to resolve this issue. Please confirm and if yes, please make this as accepted answer. Marking answers as accepted helps community to resolve their issues as well. Thank you.


Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.