Workfront Custom API usng status_Mod=in not working for me

Question

Hoping someone can help. I have loaded an array with the statuses of PLN and CUR and set the rest of the parameters. I end up with the query string of

"PROJECT/search?DE:Project Release Date=2024-09-04T12:41:18.100Z&fields=ID,ownerID,sponsorID,DE:Project 
Release Date&status=CUR, PLN&status_Mod=in"

Which looks correct, but is still returning projects in other statuses. I am using the &status={{add(emptyarray; "CUR"; "PLN")}}&status_Mod=in to set up the status portion of the query in order to load multiple statuses into the array - no dice. Any ideas? thanks.

Rafal_Bainie · Accepted Answer

I would try this:PROJECT/search?DE:Project Release Date=2024-09-04T12:41:18.100Z&fields=ID,ownerID,sponsorID,DE:Project Release Date&status=CUR&status_Mod=in&OR:1:DE:Project Release Date=2024-09-04T12:41:18.100Z&OR:1:status=PLN&OR:1:status_Mod=in the key difference is listing second status using OR:1:cheers

Sven-iX · Answer

Hi @marty_gawry

after checking with Support here is another way: using a filter JSON object

/attask/api/v18.0/proj/search?filters={"status":["PLN","CUR"]}

I like this over OR: because it's concise.

in Fusion (eg Search) the IN modifier will work if you pass an actual array of choices like add({{emptyarray}};CUR;PLN)

per support, IN in the API equates to "equals" ...

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded