Export Execution History from Fusion

[#1]

Description - We want to be able to export info from fusion, specifically the scenario history tab.

Why is this feature important to you - We want to use this info to calculate time saved via fusion automations.

How would you like the feature to work - There would be an "export" button that would let you export the history into an excel sheet, similarly to other reports in Workfront.

Current Behaviour - No reporting options exist.

[#2]

Yes! we need this badly!

[#3]

Hi,

You could achieve this using the following workaround by utilizing the API of Fusion: 

• Find out your teamID (should be visible when opening your team dashboard https://app.workfrontfusion.com/<teamId>/team/dashboard)
  or your organizationId
• Click on your Username in the left bottom and chose the tab API
• Add a new token (concerning the permissions you have to try out, but at least scenarios:read is necessary
• Copy your new API token
• Create a new scenario containing the module HTTP -> Make a request and set it up as follows:
  • To get all scenarios: 
    • URL:https://app.workfrontfusion.com/api/v2/scenarios?teamId=<teamId>
    • Headers: Authorization: Token <copied token>
    • Method: GET
      
  • To get executions of specific scenario:
    • URL:https://app.workfrontfusion.com/api/v2/scenarios/<scenarioId>/logs
    • Headers: Authorization: Token <copied token>
    • Method: GET
      
  • To get execution details
    • URL:https://app.workfrontfusion.com/api/v2/scenarios/<scenarioId>/logs/<executionId>
    • Headers: Authorization: Token <copied token>
    • Method: GET

From there you could process the data to a CSV, textfile, Google / Excel Sheet, ....

I hope this helps.

Regards

Lars

[#4]

Lars, 

Thank you! This is incredibly helpful!

A couple questions: Are there two headers? And do those headers need values? Like this:

1. Header: Authorization
   Value: <blank>
2. Header: Token
   Value: (copied token)

Also, could you walk me through the data process module? I'd love to export it as an excel document. 

Thanks,

Christine

[#5]

Hello Christine,

I went through it and for the authorization only one header is mandatory:

Don't be surprised about the URL (app-eu.workfrontfusion...). Our instance runs on a European server.

Concerning the data processing you will need to parse the JSON coming from the HTTP request and fill your Excel sheet. Unfortunately we don't have a connector to Excel set up, but I propably can have a look on how to do that using the CSV module later.


Regards
Lars