Adobe Workfront Fusion

My company is exploring options for sharing information from Snowflake to Workfront, likely through Fusion. It doesn't look like Fusion has a Snowflake connection module, is there a way to connect directly or would we be forced to use an api?This question is similar but closed since it's 3 years old.https://experienceleaguecommunities.adobe.com/t5/workfront-fusion-2-0-questions/does-anyone-here-have-any-experience-integrating-with-snowflake/td-p/492280

Hi,Good day,searching for your brilliant ideas regarding my project,scenario goes like this, 1 email to case: If new message received by email it automatically creates an issue to WF (scenario working)2 reply to email then close the case: if the assignee replied to the email that the issue is resolved, it will auto close the issue.  here is my testing scenario. I dont know how to connect the WF module (record update) to WF module (create a record.)Maybe you have another way out. Thanks, 

We use Workfront as our Operational System of Record (no Marketing).    We are considering recording time in Workfront, but need a way to feed our payroll system ADP.   Does anyone have experience with an API either through App Developer or Fusion to feed hours and projects into ADP?

I am in the process of integrating Workfront Fusion to Azure Dev Ops.  I've successfully created multiple scenarios to create and retrieve tasks but am having issues with the "Watch For Work Items" function.  We need visibility of changes to the tasks in Azure DevOps on the fusion side.  When I creating a scenario with the Watch For Work Items function I get the following error.  I can see that in the connection definition there is an advanced setting to specify App ID and Client Secret but this hasn't been previously required and it's not clear if this is the solution.  If the advanced settings are needed I wonder why it's only this function and what is needed on the Azure DevOps side. The request failed due to failure of a previous request.Access Denied: XXXXXXXXXXXXXXXXXX needs the following permission(s) on the resource PublisherSecurity/YYYYYYYYYYYYYYY to perform this action: Edit Subscription

Hi Fusion Community! Wondering if anyone can help with the following challenge? Issue: I'm building a Fusion scenario to calculate a program-level metric that requires aggregating data across multiple nested iterators: Program → Projects → Tasks → Assignments. Current Flow:Get Program detailsIterator: Loop through all Projects under ProgramIterator: Loop through all Tasks per ProjectIterator: Loop through all Assignments per TaskCalculate cost per assignment: (User Cost Rate * Planned Hours) / 60PROBLEM: Need to sum ALL assignment costs into ONE program-level valueExpected Result: One bundle with total cost = sum of all assignments across all tasks across all projects Actual Result: Multiple bundles/operations, each with a subset of the total Question: How do I aggregate across multiple nested iterators to produce a single output value at the program level? Is there a specific aggregator configuration or module placement that works for this nested scenario?&nbs

Is there a way to access the Task / Hours / Log Time panel via Fusion? We are trying to add Freelancer Task Hours off invoices via Fusion.

Is it possible to update task predecessors through Fusion?  I just kick-started a group of 30+ projects, and I need to add cross-project predecessors to a specific task in each project.   When assigning predecessors last year (prior to us having Fusion access), I created a task report and pasted in the predecessor values using the project reference and task numbers (e.g., '1988778:24,1988827:24,1988974:24').   I'm pretty new to Fusion.  I've been able to download/parse CSV files and update tasks for basic info (assignees; planned start dates; etc.), but Predecessors is not one of the available options in the field list for the Task object.  Can the predecessors be mapped through the mapping panel?  If so, what would that expression be?  I'm not advanced enough at this point to go the API route (and I'm not even sure our IT department has obtained the API package in Fusion).   Thanks.  

Is it possible to connect Workfront to Notion via Fusion.  It doesn't look like there are any native connectors, has anyone attempted to build their own connections?  If so, how successful was your process.

Is there a way to capture a scenario's run id in a notification updated?  Trying to figure out a way to identify the exact run in a fusion scenario that errored out.

We are trying to set up a watch event using the Azure DevOps module. This is intended to notify us when a comment is entered on an Azure DevOps Product Backlog Item, Task, or Feature, and then sync that comment to the related task Comments(Updates or Note) in Workfront. However, we are facing an issue in our Fusion scenario, which is configured to watch for “New and Updated Records” (Work Item Commented). It creates two event subscriptions—one for new records and one for updated records—pointing to the same webhook address. This can lead to duplicate triggers if a single action in Workfront is interpreted as both a new record and an update, or if an update is registered immediately after creation. How can we address this issue?

How can i read the approval process of an object using fusion? approval id not approval process id . What should be the url used in the custom api call?

I'm attempting to update the "Project Sponsor" field that is in the Overview Stakeholders section.  I'd assumed updating the Sponsor ID through my update module would do it but it's not.Any ideas what could be wrong?  I don't see a property directly called "Project Sponsor" in the fields to map.   

I have created a Fusion scenario to add a new item to a list in sharepoint.  All fields populate as expected except Requestor which is a Person or Group Type.   If I subsequently edit the item directly in the sharepoint list, I can enter the same name I pass from Fusion, the name is found and after I select it the field is populated.   My feeling is that sharepoint is expecting a specific format for the name but I'm unable to determine what is expected.   Fusion ModuleMicrosoft Share Point Online - Create An Item Fusion Module item Key format Sharepoint List Field 

We have 100's of old document (not proof) approval requests in Workfront that are either no longer needed. Ideally, I'd like to cancel them all, but I'd especially like to start with cancelling the document approval requests that are between users that are no longer with our company (so both the requestor and the approver are no longer active in Workfront) because at least in that scenario, no one would get an email notification that their document approval request has been canceled. I would then follow-up with a scenario that I could use to capture stale requests between active users (or a mix of active users and inactive users, depending on which side of the approval they are on), and I would temporarily turn off the "document approval request has been cancelled" notification emails for active users. Would anyone be able to explain to a Fusion newbie (and I mean newbie, I have only had Fusion for 1 month) what scenario I could write to attempt this?

I have requirement to replace comma with semicolon. I tried String replace function, but it didn't work i think it is not considering semicolon. If I use other characters instead of semi colon it is getting replaced properly. Is there any way to escape semicolon. 

Hello!  I'm working on a scenario that will automate our project closure process, we have a Project Summary Details form on all of our projects that needs to the data mapped before we can close the project.  Im currently in the mapping stage of the scenario and keep running into this issue:my first module is a Watch Record module that watches for projects that are marked 100% complete, followed by a read record module to get the information from that project, and then a search Task module to search for a certain task within the results of the watch module and keep getting an error result: Missing value of required parameter 'ID'.  I've tested this two ways, 1 targeting the watch record module and second targeting the read a record module, as they both output an IDand neither of them work when tested. Any assistance is appreciated, thank you!     

Hello, I am attempting to run a scenario that will export a report and send it to a destination on my desktop. Is this possible and if so what is the best method to go about it?

Hello, I have a .csv file that feeds into my scenario and creates several new records in Salesforce. The output of the "Create new record in SF" is the ID for each newly created record.When I am testing this out:1 .csv file with 3 rows of data goes in.3 new records with ID numbers are created in Salesforce.I want the next step to be simply to create a new .csv, again with 3 rows, one for each contact and also showing the new ID number for each record. I cannot figure out where I am going wrong! The best I can get is creating 3 x csv files but I can't seem to combine them all into one place. Any help is much appreciated. Thanks CSV is parsed producing 3 bundles from the 3 rows in the file. 3 x SF records are created based on the data. Trying Array aggregator but 3 operations are still produced  I want to aggreagate the 3 operations and include some data (first name, last name) from the original csv file but additionally have the ID number from the SF module

Hello, I have a PUT Custom API module that shares a project with a user's manager once an issue is converted in the scenario.  However, I'm having trouble preserving the original, preset list of teams/users a project was shared with (from Project Template Sharing). Is there a way to preserve the existing information and simply add the manager to the 'shared with' list? Modules used:  Thank you for your insight! 

I have a situation where I have to concatenate values from a multi-select (where I use the join() function), but if only 1 selection is made my join() returns a null.I need to find a way to determine if this field is coming in as an array or single text field.Ideas?

Hi! I'm currently looking at setting up a service account to "own" our Fusion scenarios, but I was wondering does that service account also need to be an admin in our Workfront space? Appreciate any assistance!

If I have an array of collections with key-value pairs, what's the easiest way to transform this array so that only certain keys (and their values) are preserved in the array?For example, if this is the output of a HTTP request module:how can I transform this data so that within each collection I have only the value and label keys?I'd like to store the transformed array in a variable so that I can later "search" within that with the map function.Thank you! 

I am newer to creating and supporting various fusion scripts and ran into a challenge and wondering if there is a solution.  Scenario:    I have a CSV file that we are reading with fusion that includes a "problem" text (just a string of text) that we are looking to insert the text into a new "Request Description" field which is a text field with formatting. Issue:  When running a fusion scenario that is creating a record, I receive the following message:   "The following parameter value is invalid....".     From what I found, this appears to be a formatting issue.   Doing some digging, I found this article that refers to the need for a JSON file to upload into this field, but I feel I am missing something from a fusion standpoint on how to create this:  Rich text fields in the Adobe Workfront API | Adobe Workfront Ideas?    Is there an easy solution to convert this to allow for applying to the new

Has anyone used the Jira Create Record to create an Epic Feature assigned to a Capability? I have the Epic Feature creating part working, but not sure how to assigned that to a Capability. 

Hello all,I am very new to Fusion.  Does anybody know how to add a dash if there is a space between two text.  For example, I have a string called "Workfront Fusion", but I want the string to be "Workfront-Fusion".  I have tried using replace and " " (as blank space), and "-" (as the replacement string dash).  However, this still returns without the dash.  I also have lower to bring all the string to lower case.