How to use RSS Feeds - MS Flow - Microsoft Dynamics Business Central to get your blogs synchronized in Business Central

Introduction:
Today, as I was thinking about tracking blogs posted on to my blog post. There is a system in our company to check with the blogs submitted by a person by exporting MySQL database and then importing into PowerBI to generate the reports.
Recently, I got my blog published on dynamics community and it uses RSS Feeds to syndicate blogs from different websites.
So, this blog is about an experiment can I use the combination of both in Business Central and MS Flow to track the blogs posted on a Website/Blogspot.

Pre-requisites:
Microsoft Flow
Microsoft Dynamics Business Central / NAV
VS Code
AL Language Extension

Solution:
Creation of Flow:
In Microsoft Flow there is a default template for RSS Feeds, change the RSS Feed URL to your own Blog RSS Feeds URL. Also, add Email to Gmail with appropriate data from RSS feeds.

Adding your RSS Feed URL

Flow to send Email when a blog is published

You will need to publish a blog with relevant fields as you want.

Email received when a blog is published

Creation of Extension in Business Central (Refer https://github.com/olisterr/Blog-Integration-using-RSS-Feeds):
In VS Code create a sample project using AL Go!
Create a Table with auto-increment primary key and add all the fields needed.

Table to store details from RSS Feeds

Create a Page for the same

Page to view stored RSS Feed details and visit the link.

In Webservices, publish the page

Webservice to access RSS Feed Details.

Flow Setup to pass data from Flow to Business Central Web Service:
Call this page in MS Flow using HTTP POST Request
Passing the data from RSS fields to the newly created Webservice.

Testing the Flow and let's see if it work.
Output:

When Blog is Published!

Email is received for each category

Entries get created in Business Central

To visit the blog entry created in Business Central

Visiting the blog from Business Central

Conclusion:
Microsoft Flow is a pretty good tool to do small processings hassle-free such as this example. It can also use for integrations, processing data, and automation.
Hoping you guys like this trick.