Yeah I had a feeling  Are you able to modify the approval paths to include a team so you don't have to keep adding userIDs to the report? 

Oh - yes of course: I put the role into the stage approver field - I thought that's what you were doing! you could TRY stepApprover:user:roleID but that may be one hop too far.  I'd recommend to create a team for these approvers and use that in the approval step, or use the role in the step. 

Hi @AndrewGr1 a task has a collection "approvalStatuses" you can use. Try an EXISTS filter like this and replace "###" with the roleID you need. EXISTS:a:$$EXISTSMOD=EXISTS EXISTS:a:$$OBJCODE=ARVSTS EXISTS:a:stepApprover:roleID=################ EXISTS:a:taskID=FIELD:ID   

Thanks for following up! Sorry - Rafal's code is 100% fine. And I just retried - now I do see docs attached to a project in Program/projects view... Same code. So I must have fatfingered something. BTW the interspersed <p>s - I think that's a bug in the iterator: the link/href around the <p> is a co...

@A_EN instead of thinking "export" think of pulling the data using a Search module. You can use the same text-mode filters.

@skyehansen it works if you have documents at the program. Any project documents (as OP described) will not get listed. The OP is on a page that lists projects (eg projects view in program detail) and wants to iterate over each of the listed projects' documents. I'm not aware of a method to do a dou...

I would raise a ticket nonetheless with support so they see their CORS block for API calls is a bit (in my eyes) misguided

If you run an endpoint using Python, you can hit that endpoint from Excel, and then use Python to call the API. 

@Hu_Li-_-  most likely a CORS issuehttps://stackoverflow.com/questions/77279755/office-script-in-excel-365-failed-to-fetch-for-some-urls While hitting the API with a browser works, it does not when you e.g. use javascript to make the API call...  Best I got is to use Fusion as your endpoint for Offi...

You could use the user collection workitems and sort them by task:actualCompletionDate