User time off + designated holidays (based on the schedule)

[SerbanNitu]

Helloes,

I am trying to create some kind of report or anything that could be exported that includes PTO's and the designated holidays for different users. 

I can easily get the PTO via search + read related records modules, but I am having a hard time getting the dates of the designated holidays that are coming from the schedule. I have tried using the Custom API Call module to GET those and I have also tried using the HTTP module to GET the schedule exceptions but most likely due to my lack of experience it didnt go too well.

Would there be any suggestions on how to achieve such thing?

Thank you for your time and looking forward to hearing your suggestions.

Also, I understood that the calendar view can help with at least viewing it visually in case it cannot be done.

[Sven-iX]

Hello @SerbanNitu 
From your description I can't tell if you've tried getting the non-working days from the schedule? 

It's a collection that gives you the date of the holiday.

From API explorer

[SerbanNitu]

hi @Sven-iX - thank you for taking your time and looking into it.

I have not tried it, but I ve been trying to do so this morning and all I could get is the ID of the NONWKD and the objCode.

Any suggestions how to continue from here? (I have also tried getting the startDate,etc in the GET customapi module but to no avail. (either objcode errors/api not supporting)

[Sven-iX · Accepted solution]

you'll need to specify the desired fields - otherwise you just get name, ID and objCode. 

https://developersupport.workfront.com/page-api-explorer.html

in my example below I just grabbed all fields 

[SerbanNitu]

Hi @Sven-iX , that worked wonders, thank you sooo much!