Expand my Community achievements bar.

Latest Community Ideas Review is Out: Discover What’s New and What to Expect!
SOLVED

Bulk delete reports

Avatar

Level 10

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

1 Accepted Solution

Avatar

Correct answer by
Level 7

@NickVa1 - 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]

_Manish_Singh_1-1690515615371.png

View solution in original post

5 Replies

Avatar

Correct answer by
Level 7

@NickVa1 - 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]

_Manish_Singh_1-1690515615371.png

Avatar

Level 10

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?

Avatar

Level 7

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.

_Manish_Singh_0-1691556483435.png

Avatar

Community Advisor

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.

William_0-1691248402329.png

 

If you like my content, please take a moment to view and vote on my Idea Requests: https://tinyurl.com/4rbpr7hf

Avatar

Level 10

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