Workfront Fusion

KristofferMi1 · 9/17/25

I am brand new to Fusion and am needing to develop a scenario that will find all the Programs that have an empty field. I am currently using "Search", but I get this error each time I run it, "The operation failed with an error. [422] APIModel V20_0 does not support field null (Project)". Any suggestions or tips are greaty appreciated! Thank you!

Kurt_Jones · 9/18/25

You're likely getting that error as you have the record set set to First Matching Record and it needs to be All Matching Records. You want the scenario to pull all program records that match your search criteria, since none have that field populated yet. Here's example below of how you can set up your search. Notice under collections I toggle the map and use projects:referenceNumber as you wanted to get all the reference numbers of projects underneath your program. You'll have some other things to think about in your scenario, such as, what if there are no projects yet under the program? what do you want your scenario to do in this case as it can't populate the custom field yet. You will also need to use the iterator function under the Flow module to help list all the projects under the program to get their IDs and reference numbers.

View solution in original post

Kurt_Jones · 9/17/25

KristofferMi1,

I'm assuming you're trying to find projects that don't have a program id (name) based on what I see. Your search module should look like below

1. Record type: Project

2. Search criteria: Program ID does not exist AND Status equal to CUR (assuming you only want current projects...remove if not needed)

3. Maximal set to 2000, that's the most you can pull at one time if there are that many records

4. Output: ID, Name (to get the ID and project name of the items that don't have a program ID

If I misunderstood, can you provide more context as to what field you're wanting to look at on Programs that might be empty?

KristofferMi1 · 9/18/25

Thank you for the response, Kurt! You're on the right track. We have a custom field, "Program Number" that we are wanting to use for helping our associates quickly search for programs by a number instead of by name or other ways. (We recently migrated from another system where campaign numbers were the only way we could track and search by.)

Our plan is to use the "Reference Number" from the 1st project created in each program. My thinking is to have the Fusion scenario find all the programs with this field empty, to then have go through each program and copy the 1st project reference number into this field.

I hope this makes sense and thank you for your help!

Kurt_Jones · 9/18/25

KristofferMi1,

So my response will change a bit now with the context. Using the Search module you should be able to:

1. Record type is program

2. Choose the Custom Form where the program number custom field is

3. Search criteria choose your program number custom field and use does not exist

4. Choose the output fields you need

This should look at every program and if the program number custom field is blank (or doesnt exist) you'll get those items back. I think this should get you what's needed.

KristofferMi1 · 9/18/25

Thank you Kurt! So I have my module set up like this, but I get this error. Is this an access error? "[422] APIModel V20_0 does not support field null (Program)"

Kurt_Jones · 9/18/25

You're likely getting that error as you have the record set set to First Matching Record and it needs to be All Matching Records. You want the scenario to pull all program records that match your search criteria, since none have that field populated yet. Here's example below of how you can set up your search. Notice under collections I toggle the map and use projects:referenceNumber as you wanted to get all the reference numbers of projects underneath your program. You'll have some other things to think about in your scenario, such as, what if there are no projects yet under the program? what do you want your scenario to do in this case as it can't populate the custom field yet. You will also need to use the iterator function under the Flow module to help list all the projects under the program to get their IDs and reference numbers.