Hi Marc, thank you for taking the time to share your knowledge with us.

I have been trying to follow your example to create a site workflow to iterates through multiple sites but I run into some issues.

I need some help to create a workflow using REST call to iterate through three different subsites.

I was able to create a site workflow using the REST API call to iterate through one site and query all item within one list and send the email. However, Im not been able to figure out a way to make it work for multiple sites/subsites.

This is what Im trying to accomplish:
Lets say I have a site (Root site) which has: Subsite A Subsite B Subsite C.
On those subsites, I have a list call (weekly report) where user enter their work and status update on a daily bases.

Im trying to create a site workflow that can query all three subsites and get all new status update from the list and send out an email to a user.

any help would greatly appreciated.