Creating a Fusion Scenario that looks for Duplicate Projects

[OmahaOmaha]

Hi All,  I've been attempting to create a Fusion scenario that looks for potential duplicate projects in our instance.  The parameters I would like to use is if the duplicate project was created within the last three weeks, and if the project titles are  80% identical if possible.  If there's a match, I would want to leave an update on the duplicate project, explaining that it is a potential duplicate project and provide the name and link to the original.  Not sure where to start on this one.  Any guidance would be greatly appreciated.

[patrickheinzelm]

HI @OmahaOmaha,

You have two Options:

1. You listen to creation of new projects using Fusion and search for a projects with a similar title
2. You create schedule process which periodically search for last created projects and compares them against similar projects.

In both cases you need to do custom API call using the Workfront Module and create a search using the REST API. See https://developer.workfront.com/projects.html#get-/proj/search and https://experienceleague.adobe.com/en/docs/workfront/using/adobe-workfront-api/api-general-informati...

Patrick

[patrickheinzelm]

PS: Instead of "Custom API Call" of the Workfront Module, you could also use the "Search" of the Workfront Module, when your filter is simple enough. It really depends on the complexity of your filter criteria.

[Sven-iX]

Hi @OmahaOmaha 
your requirement "80% identical title" needs to be refined. I would recommend not using a mutable string such as the title, but look at the project's fields (group, program, portfolio, enteredBy, status, priority, and any key custom fields) to ascertain whether the project is a duplicate.

As @patrickheinzelm states - once you have the search, bolt that onto the scenario that listens to projects being created and if you find a match (or matches) add the update.