Hi @ArtieBertie this is probably better for your usecase: Do a search for "timeOff" for the user and today's date. If there are no results, the user is available. If there's ANY result - the user has the day blockedYou may need to test with partial (eg half-day) time off records. 

HI @ArtieBertie you can see if the MiscAction module might help: It has the action "getUsersAvailableTime"   

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.