Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn more

View all

Sign in to view all badges

How can i create a file and send it via email using JS Code activity when you don't have permissions to attach a file in an email from the server

akashaj7696
Level 3
Level 3

Hi Everyone,

I have a use case where I need some help-

 

I want to know all the deliveries which are deployed on a given day and send it to myself in an email as a file attachment.

All the deliveries deployed can be found using a query and a temp schema with all required fields can be prepared. But how can i transfer the content of the temp schema into a csv file and then send as an email attachment. Is it possible?

OR

I can write a JS Code to get all the information of deployed deliveries if from there we can do something for this use case.

Please let me know if you have any solutions.

Thank You!

Akash

@Sukrity_Wadhwa 

2 Replies
Manoj_Kumar_
Community Advisor
Community Advisor

Hello @akashaj7696 

 

Since you don't have permission to attach a CSV file. Why don't you print the data in the email body itself?

 

Query the data with javascript and then store the data in a variable and then do a for each loop in the email body and print the data.

 

 

akashaj7696
Level 3
Level 3
Hi Manoj, Thanks, but could you please elaborate the solution?