Bulk delete reports | Community
Skip to main content
N
NickVa7
Level 9
July 28, 2023
Solved

Bulk delete reports

  • July 28, 2023
  • 2 replies
  • 1204 views

Hi Fusion Community,

I was given a list of report ID's that need to be deleted - 658 of them to be precise.  

I went to delete these using a Delete module, but the report object is not an option to choose from.  

 

Since someone poured over this list to manually determine which ones can be deleted, there's no simple filtering I can do on the front end of a WF report list in order to do the bulk delete there.

Does anyone have any ideas with regard to Fusion?
Thanks,
Nick

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by _Manish_Singh

@nickva7 - If you have report IDs available, you'll have to use custom API call.

Method: DELETE
URL: https://yourdomain.my.workfront.com/attask/api/v15.0/PTLSEC?ID=[insert reportID here]

2 replies

_Manish_Singh
_Manish_SinghAccepted solution
Level 9
July 28, 2023

@nickva7 - If you have report IDs available, you'll have to use custom API call.

Method: DELETE
URL: https://yourdomain.my.workfront.com/attask/api/v15.0/PTLSEC?ID=[insert reportID here]

N
NickVa7Author
Level 9
August 8, 2023

Perfect, this worked, Manish.  Thanks!
Question - how did you know to put PTLSEC?ID=[insert reportID here] at the end?  If I was searching Fusion knowledge articles in Experience League, would I have found that?

_Manish_Singh
_Manish_Singh
Level 9
August 9, 2023

I found PTLSEC in the API Explorer document. It is a way to directly access a specific report using its ID. It might not be available in the knowledge articles as it is more specific to the API calls.

    William--
    Community Advisor
    William--Community Advisor
    Community Advisor
    August 5, 2023

    The answer provided by Manish is correct - that's how you would delete report objects in Fusion. 

    I'm only chiming in to say that you can also do this in the WF UI if you have only a list of IDs. Create a text mode filter that looks like the below example. There are lots of tools that can transform your list of 658 report IDs into a tab separated list, but the easiest to use is probably ChatGPT. Just plop your long list in and tell it that you want to replace line breaks with tab characters, then you can copy/paste its output into your report filter. 

    That said, I don't know what limits apply to filter rules in Workfront. I've never hard-coded that many IDs into a single filter rule. If Workfront rejects the filter, you could do 100 at a time by just pasting 100 values at a time.

     

    If you like my content, please take a moment to view and vote on my Idea Requests: https://tinyurl.com/4rbpr7hf
      N
      NickVa7Author
      Level 9
      August 8, 2023

      Nice idea, William.  Thanks for this tip for the future. 

      Terms & ConditionsAccessibility statement

      Loading footer...