Workfront Fusion

Scenarios

• Scenarios will time out after 40 minutes.
• You can chain scenarios to break the work into smaller pieces.
• Technically the maximum size of a scenario blueprint is 5MB, however 3MG is the largest recommended size.
• Apps modules that create or update data with large amounts can get big.
• While there is no limit, it is recommended to keep scenarios under 150 modules.

Operations

• The default operation time out is 40 seconds.

Files

• The total file processing capacity is 1 GB.
• Note: if a 400MG file is both uploaded and downloaded, that is 800MB of file processing.

Server Memory

• Server memory usage for a single execution is limited to 1GB.

Webhooks

• Webhooks are limited to 100 requests per second.
• When the limit is reached, Fusion sends a 429 (too many requests) status.
• Payloads are stored for 30 days.
• Deactivated webhooks are deleted and unregistered automatically if they are not connected to any scenarios and have been deactivated for 30 days.

Execution history

• Execution logs are limited to 100 MB.
• If the history is bigger, only the first 100 MB are shown.
• Incomplete executions are limited to 100 MB per scenario.
• Incomplete execution are limited to a total size of 500 MB per team.
• Fusion allows up to 5 failures per minute.
• If a scenario fails consecutively 10 times within 2 minutes, it will automatically be deactivated.

Recursion

• If you create an infinite loop it is deactivated by the engineering team.

Map

• map(complexarray;key;[key for filtering];possible values for filtering])
• Examples:
• map(Emails[];email)
• Returns a primitive array with emails
• map(Emails[];email;label;work)
• Returns a primitive array with emails having a label equal to work

get (object or array; path)

• returns the value path of an object or array To access nested objects, use dot notation. The first time in an array is index 1.
• Examples:
• get( array ; 1 + 1 )
• get( array ; 5.raw_name )
• get( object ; raw_name )
• get( object ; raw_name.sub_raw_name

Example

1. Set Variable
2. Name: testArray
3. Value: {"testArray":[{"field1":"A","field2":"X","field3":[{"field3A":"first1","field3B":"second1","field3C":"third1"}]},{"field1":"B","field2":"Y","field3":[{"field3A":"first2","field3B":"second2","field3C":"third2"}]}]}

1. Parse JSON
2. Use the Generator, paste: {"testArrayStructure":[{"field1":"A","field2":"X","field3":[{"field3A":"first1","field3B":"second1","field3C":"third1"}]}]}
3. This will make an Array structure with 3 fields, 2 text and one array.

1. Set Multiple variables
2. Maptest
3. {{map(2.testArray; "field1")}}
4. returns array variable mapTest entry one is A, entry 2 is B.
5. getTest
6. {{get(2.testArray; 1)}}
7. returns collection with field1: A, field2: X, field3: Array with 3 items[field3A:first1, field3B:second1,field3C:third1]
8. getMapTest
9. {{get(map(2.testArray; "field2"; "field1"; "B"); 1)}}
10. returns Y
11. ngestedArray
12. {{get(map(2.testArray[].field3; "field3A"); 1)}}
13. returns first1

1. Start with a Set Variable to calculate and format the date.
2. Name:[use number of days]DaysAgo
3. value: formatDate( addDays(now;-[use number of days]);YYYY-MM-DD)
4. Custom API call.
5. URL: project/search?lastUpdateDate=[use date from previous module]&lastUpdateDate_Mod=gte&fields=ID,name,[any other fields you want to see from the project level]
6. Itterator
7. Arrray will be the body: data[] from the previous module.
8. Read Related Records
9. Record Type: Project
10. Parent Record ID: [ID field from the itterator array]
11. Collections: Tasks
12. Outputs: ID, Name, Template Task ID, [Anything else you need to find one task per template, we use the same task name for the first task everytime, so I'll be using that.]
13. Filter
14. use the field from the previous module that will identify one task per template.
15. Search
16. Record Type: template Task
17. Search criteria: ID = [template task ID field from previous module]
18. Output: TemplateID
19. Search
20. Record Type: Template
21. Search criteria: ID=[template ID from previous module]
22. Text Aggregator: Combine template names by Project
23. Source module: itterator
24. Seperator: other ,
25. Show advanced settings, Group by the ID from the itterator array
26. Text name from the previous module.

Best practice is not to use spaces or special characters in the field names. Using them in the label is fine. But, it happens. So, if you have fields that have these characters in the name, you will need to substitute the characters.

Space: %20

?: %3F

/ : %2F

(: %28

): %29

,: %2C

#: %23

.: %2E

For example a custom field named This is a question? would be called with DE:This%20is%20a%20question%3F

Reference

1. Custom API CALL
2. URL: [object type]/search?ID=[ID of object you want to update]&fields=ID,name,objectCategories.
3. Add and Itterator
4. body data [ ] from the API call
5. Add a Router
6. Before you attempt to update the custom field, add a router.
7. Add a Misc Action module
8. Between the router and Misc Action add a filter
9. filter to check the objectCategories[] from the API call does not contain the form ID.
10. Configure the Misc Action module
11. set Record Type for the object type you are updating
12. Action: assignCategories
13. objID use the ID from the itterator
14. objcCode: use the appropriate code for your object that you are updating
15. categoryIds: use the ID for the form you need to add

1. Download Document
2. Use the ID from the CSV loaded to Workfront
3. The values for the update should be in one field separated by something other than a comma, like an * or | symbol.
4. Parse CSV
5. delimiterType: Other, then enter ,
6. use the CSV from the first module in the CSV field
7. Array Aggregator
8. Source Module: CSV - Parse CSV
9. Traget structure type: Custom
10. Aggregated fields: the ID and whatever column has the field you are updating.
11. Itterator
12. Array is the array from the previous module
13. Set Variable
14. split([field name from CSV]; [delimiter from the CSV field)
15. Update a record
16. Use the ID from the CSV
17. Map the multi-select field and use the value from the Set Variable Module.