Pull Collection Data into Blog/RSS Feed

Forgive me as I am not advanced as a developer. I can google my way through most things. This is what I am trying to accomplish.

I have an MB Collection called “Album of the Week”. I add a new album each week for my family to listen to. I am trying to find a way to pull Artist, Release Name, Release Date and Album Art into a blog post each week. From there my family can access it and I can use the RSS feed to pull it into a HomeAssistant dashboard (the ultimate goal).

If anyone is able to offer some assistance, I would be grateful.

The first thing you want to do is get your collection into json (or xml)
Try something like the below with your collection id:


See the api document for other parameters:

You then need something to parse this and convert this to a format you want.
As you are using home assistant do you also have node red?
I have not looked but that may be able to run the above query and add this to a list inside home assistant.

There may be other tools that you can use to convert between json and rss.
I have wondered about using microsoft flows.