Collection Text Mode Reporting | Community
Skip to main content
K
Kellie_sphere
Level 2
February 20, 2026
Solved

Collection Text Mode Reporting

  • February 20, 2026
  • 2 replies
  • 63 views

I’m running an access level report in Workfront and I’m trying to get collection data to appear on the report. Based on the API explorer I’d like to get the following fields

Access Level Permissions

  • coreAction
  • forbiddenActions
  • secondaryActions

I set up the collection text mode column and was able to successfully get values for “coreAction”. However, it’s not returning the proper values for forbidden or secondary and instead returns a string of code. 

 

I’ve noticed that the field types for coreAction is different than the other 2 field types

  • Field Type: string vs Field Type: string[]

 

Anyone able to help solve for this? 

 

      Best answer by Rafal_Bainie

      I would say this isn’t possible, field type seems to indicate that you’re trying to pull collection of collections and WF report probably is not supporting this.

      2 replies

      kautuk_sahni
      Community Manager
      kautuk_sahniCommunity Manager
      Community Manager
      February 24, 2026

      ​@Gokul_Agiwal ​@Daniel_Clarke ​@anupampat ​@Rafal_Bainie Wanted to loop you in and see if you have any perspective or lessons learned that could help us here. Your insight would be helpful, thank you!

      Kautuk Sahni
      Rafal_Bainie
      Community Advisor
      Rafal_BainieCommunity AdvisorAccepted solution
      Community Advisor
      February 24, 2026

      I would say this isn’t possible, field type seems to indicate that you’re trying to pull collection of collections and WF report probably is not supporting this.

        KellieGardner
        Community Advisor and Adobe Champion
        KellieGardnerCommunity Advisor and Adobe Champion
        Community Advisor and Adobe Champion
        February 24, 2026

        ​@Rafal_Bainie - out of curiosity, are you saying the “Field Type: string[]” indicates it’s a collection, and Field Type: string is not a collection?

         

        I’m curious because I can get the value of Field Type: string to return to just fine, and the Field Type: string[] is returning values, just not the values it has listed in the API explorer.

        Rafal_Bainie
        Community Advisor
        Rafal_BainieCommunity Advisor
        Community Advisor
        February 25, 2026

        I think so, although I’m not 100% sure.
        when I query for access levels with access level permission details in fusion I get following result [sample]:

         {
                            "ID": "665816e701d739da35220b3c73533bf6",
                            "name": "Standard",
                            "objCode": "ACSLVL",
                            "accessLevelPermissions": [
                                ...
                                {
                                    "ID": "665816e701d73a04f877843de9b6d8af",
                                    "objCode": "ALVPER",
                                    "secondaryActions": [
                                        "EDIT_ROLE_GROUP",
                                        "EDIT_ACCESSLEVEL"
                                    ],
                                    "coreAction": "DELETE",
                                    "forbiddenActions": [
                                        "EDIT_FINANCE"
                                    ]
                                },
                                {
                                    "ID": "665816e701d73a138e92fd65b22c62ac",
                                    "objCode": "ALVPER",
                                    "secondaryActions": [],
                                    "coreAction": "DELETE",
                                    "forbiddenActions": []
                                },
                                {
                                    "ID": "665816e701d73a018ee887ee6c169555",
                                    "objCode": "ALVPER",
                                    "secondaryActions": [],
                                    "coreAction": "DELETE",
                                    "forbiddenActions": []
                                },
                                {
                                    "ID": "665816e701d739e8ed5dec95a257e0e5",
                                    "objCode": "ALVPER",
                                    "secondaryActions": [],
                                    "coreAction": "DELETE",
                                    "forbiddenActions": []
                                }
                            ]
                        }

        first permission has some secondary actions and indeed it’s a collection. So I think it does confirm my point to some extent

          Terms & ConditionsAccessibility statement

          Loading footer...