Through this blog, I will sharing script which can help to get complete information about all the email alerts configured in Salesforce using workflow rules for any sObject.
Imagine a scenario in which you need to extract all email alert configured or created for different workflow rules for specific object so that it can be reviewed or analyzed. If you do this activity manually then you have to open each workflow email alert and note down details like recipient, ccEmails, senderAddress, email template etc. This will be very hectic if you have lots of email configured.
In order to solve this scenario, I am using Tooling API through which we can get complete details about workflow email alert. Through apex script, we can generate these details and send email (with csv file as attachment) to user with all details.
First of all, inorder to parser JSON response, we need to create apex class (SK_EmailAlertJSONParser) which will act as parser for JSON. After this we can run the script in developer console and user will get email with all information regarding email alert.
Below is snapshot of csv file that we will receive after running above script in developer console.
I have specified objectId as "Contact". For custom object, specify 15 digit or 18 digit id.
Imagine a scenario in which you need to extract all email alert configured or created for different workflow rules for specific object so that it can be reviewed or analyzed. If you do this activity manually then you have to open each workflow email alert and note down details like recipient, ccEmails, senderAddress, email template etc. This will be very hectic if you have lots of email configured.
In order to solve this scenario, I am using Tooling API through which we can get complete details about workflow email alert. Through apex script, we can generate these details and send email (with csv file as attachment) to user with all details.
First of all, inorder to parser JSON response, we need to create apex class (SK_EmailAlertJSONParser) which will act as parser for JSON. After this we can run the script in developer console and user will get email with all information regarding email alert.
Below is snapshot of csv file that we will receive after running above script in developer console.
I have specified objectId as "Contact". For custom object, specify 15 digit or 18 digit id.
This script can be used to fetch information from other salesforce org also. Suppose you don't want to deploy this script in production, then save SK_EmailAlertJSOnParser class in sandbox and in developer console (using execute anonymous window) just specify the domainUrl for production and sessiond id production for admin user.
Don't forget to add domainUrl in remote site settings before running this script in execute anonymous window in developer console.
Hope this will help!!1
Thanks for sharing this useful information, really helped me a lot. In the recent announcement from Salesforce, I heard they have launched LWC Local Development Beta program. Can you please tell me more about that. As a Salesforce consulting partner, It's a great news for us.
ReplyDeleteHi there, I read your blogs on a regular basis. Your humoristic style is witty, keep it up! Thank You for Providing Such a Unique and valuable information, If you are looking for the best Serp Api, then visit SERP House. I enjoyed this blog post.
ReplyDeleteThis is a wonderful article, Given so much info in it, These type of articles keeps the users interest in the website, and keep on sharing more ... good luck. active response training
ReplyDeleteHi Please help why is it returing only one row ..I ran this is anonymous window. and getting only 1 row ..
ReplyDeletestring sessionId= UserInfo.getSessionID();
string domainUrl=URL.getSalesforceBaseUrl().toExternalForm();
system.debug('********domainUrl:'+domainUrl);
string objectId ='Email Alerts'; //for custom objects, provide 15 digit or 18 digit object id
HttpRequest req = new HttpRequest();
req.setHeader('Authorization', 'Bearer ' + sessionId);
req.setHeader('Content-Type', 'application/json');
req.setEndpoint(domainUrl+'/services/data/v47.0/tooling/query/?q=select+id,SenderType,templateId+from+WorkflowAlert');
req.setMethod('GET');
Http h = new Http();
HttpResponse res = h.send(req);
system.debug(JSON.serializePretty(res.getBody()));
I need to get all the email Additional Email field how to do that .. Also kindly help is this class needs to execute only in anonymous window.. my require is to fetch all the workflowemailalert additional email field and update it with .invalid suffix in lower sandbox.. how to achive the whole flow please help
Hi,
DeleteDid you got any solution for this. If yes can you please send the script here.
This is a wonderful article, Given so much info in it, These type of articles keeps the users interest in the website, and keep on sharing more ... good luck. g licensing
ReplyDeleteCan you please help me to update ccEmail field with the code please this is very urgent
ReplyDeleteHey what a brilliant post I have come across and believe me I have been searching out for this similar kind of post for past a week and hardly came across this. Thank you very much and will look for more postings from you. hotmail
ReplyDeleteWith an email scraping spider collecting programming you will have the option to manufacture your rundown a lot faster as it will insect its way through different web indexes and assemble URL's that meet the inquiry dependent on catchphrases.
ReplyDeleteHe ordinarily doesn't get a high level of deals, on the grounds that a great many people quickly erase emails that they think are spam. Bulk Email Sender
ReplyDeleteHi, not a developer in the least. I tested this in our sandbox with success, but I need it in production. The only way I know to do that is to push a deployment of the SK_EmailAlertJSONParser.cls apex class to production, then run the script in the Dev Console. However, I cannot deploy this to prod without a test class. Do you have a test class framework to go along with the SK_EmailAlertJSONParser.cls class?
ReplyDeleteThis is such a great resource that you are providing and you give it away for free. I love seeing blog that understand the value of providing a quality resource for free. freeware bulk email extractor
ReplyDeletePretty good post. I have just stumbled upon your blog and enjoyed reading your blog posts very much. I am looking for new posts to get more precious info. Big thanks for the useful info. gmass account login
ReplyDeleteI am jovial you take pride in what you write. It makes you stand way out from many other writers that can not push high-quality content like you. how to send thousands of emails
ReplyDeleteHi there! Nice material, do keep me posted when you post something like this again! I will visit this blog leaps and bounds for more quality posts like it. Thanks... one funnel away challenge
ReplyDeletebuy online ambien 10mg
ReplyDeletebuy online xanax 1mg
ReplyDeletebuy online CIALIS 10MG
ReplyDeleteI've proper selected to build a blog, which I hold been deficient to do for a during. Acknowledges for this inform, it's really serviceable! Email Harvester
ReplyDeleteI have read all the comments and suggestions posted by the visitors for this article are very fine,We will wait for your next article so only.Thanks! Zendable
ReplyDeletewhich you need to extract all email alert configured or created for different workflow rules for specific object so that it can be reviewed or analyzed. If you do this activity manually.Sony Vegas Pro crack
ReplyDeleteThis script can be used to fetch information from other salesforce org also. Suppose you don't want to deploy this script in production, then save SK_EmailAlertJSOnParser class in sandbox and in developer console (using execute anonymous window) just specify the domainUrl for production and sessiond id production for admin user uTorrent Pro Crack with Activation Code
ReplyDeleteI've proper selected to build a blog, which I hold been deficient to do for a during. Acknowledges for this inform, it's really serviceable.Activators for Windows
ReplyDeleteThanks for sharing this useful information, really helped me a lot. In the recent announcement from Salesforce, I heard they have launched LWC Local Development Beta program. Can you please tell me more about that. As a Salesforce consulting partner, It's a great news for us. I have read all the comments and suggestions posted by the visitors for this article are very fine, We will wait for your next article so I can increase my knowledge
ReplyDeleteZentimo xStorage Keygen
I've proper selected to build a blog, which I hold been deficient to do for a during. Acknowledges for this inform, it's really serviceable.FileZilla Pro Crack
ReplyDeleteGreat work with hard work you have done I appreciate your work thanks for sharing it.
ReplyDeleteZentimo xStorage Manager Crack
What sorts of emails to anticipate from you later on
ReplyDeleteWhy you're really amazing specialist to assist them with purchasing or sell their home. GMX Mail Login
buy twitch followers Battlefield 3 was released at the same time at Modern Warfare 3. With two huge First person shooter games being released just a few days apart, the competition for #1 console FPS game began. Did Battlefield 3 come out on top? Is Battlefield 3 the better shooter? Check out this review to find out!
ReplyDeletehttps://www.visualaidscentre.com/service/eyes-specialist-delhi/ A home improvement loan is actually one of the simplest ways in which you can live in your dream home. This is because it is the prime option for someone wanting to enhance the appearance of their home and also add to the value. In other words, a home improvement loan pays off in many ways.
ReplyDeletePositive site, where did u come up with the information on this posting? I'm pleased I discovered it though, ill be checking back soon to find out what additional posts you include. download ExpressVPN
ReplyDeletehttps://www.visualaidscentre.com/lasik-eye-surgery-in-delhi/ State-of-the-art coolness and state-of-the-art game design just got ratcheted up to a new level. There are funny games and apps galore to be found on dynamic new web portals. You can find reliable web portals on the internet.
ReplyDelete
ReplyDeleteUp until this point, the crypto cash market has kept away from numerous administration and customary bank monetary issues and traps, and B lockchain innovation can possibly take care of a lot more issues. NFT Mint Calenda