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

Lol MAP!! Brilliant - I guess it was too late for me last night  My only thought is that if you modify the object like I described, you do it once, and then reference any property downstream.But if your solution works - awesome. Much more elegant than my ugliness. 

Hi @Nevalee_Hedges That does sound klunky.  I'm curious: If the Ops team assigns their desired resources - why wouldn't the team lead just use the Workload Balancer to reshuffle work?  

Hi @FranciscoRuiz It's doable but it's ugly. In short: Don't use field names that contain periods....Due to the limited tools available in Fusion, if you want to access a property on an object you'll need to convert the collection to a JSON stringreplace the keys so they don't contain a periodconver...

Hi @LukaszMatyszewski I can replicate that - apparently external lookups cannot be bulk-edited  without Fusion.I would raise a ticket for that. 

One thought: You can do one search instead of first parent task and then children: search for tasks where DE:PSRA_Mod=notblank and parent:name=CPS But my question remains - how do you define "the most recent projects that user/contact has worked on"?the projects user/contact has worked on - that are...

Hi @LauraCr  So there are cases where a task may be assigned to multiple people, e.g. "do prep for presentation". You do this to let anyone who contributes log their time. When they say "Work on it" it doesn't affect other assignee's Work Lists. On the other hand a Team assignment is used when you h...