our team has recently acquired Sitecore XM Cloud, and I am completely new to the Sitecore. We need to implement a feature where a button in the Content Editor allows marketers or developers to synchronize data with a remote Dynamics 365 database when clicked. I did some research and looks like I need to write a sync function in Powershell and attach it as command for that ribbon? Please correct me if I'm wrong
Additionally, we need to establish a nightly task that automatically syncs data with the Dynamics 365 database (so the items under that data folder in content tree will be updated) . Can we set up such a scheduled task in XM Cloud from backend to achieve this requirement? I would greatly appreciate any assistance in this matter.