Exporting A Report Via Fusion

[Eric_D_Miller]

Hello,

I am attempting to run a scenario that will export a report and send it to a destination on my desktop. Is this possible and if so what is the best method to go about it?

[Sven-iX]

Hi @Eric_D_Miller can you clarify your requirements

• you can export any report with a call to /attask/api-internal/report/export and setting the form data 
  

  exportOptions = {"exportFormat":"XLSX","exportTitle":"sven test assignments","exportType":"LIST","properties":{"detailObjCode":"PTLSEC","detailObjID":"685c24f300008535fbe3219a261d8cff"}}
  listOptions = {"viewID":"685c24f300008533d307b9ea023f0cb5","groupID":"0","filterID":"685d6e530005a5b241a4a46c07fffa43","reportID":"685c24f300008535fbe3219a261d8cff","isDrillDown":false,"listObjCode":"ASSGN","currency":null}
  filters = {}
  method = get​

• Fusion doesn't send anything to your desktop. You can 
  • use WF modules to upload to WF
  • use Sharepoint/Offic modules to upload to Sharepoint or Office 365
  • use email modules (Office 365 or Email) to send email and attach a file (size limitations apply)

[Eric_D_Miller]

Sven,

My requirements are that a report be exported once a day. I would then like the file to replace a file. We may be able to move that file to a Sharepoint location to make this easier on us.

Can you explain where the call to the API is entered? Am I using the Custom API Call module?

[Sven-iX]

Eric,

Yes you'll need the customAPI module. 
You could upload to Workfront (as well as a new version if you want history)

[viovi]

Hi @Sven-iX,

I'm trying to recreate Report export via Custom API call, but I'm not sure about some fields.

Is "detailObjID" / "reportID" the actual report ID that we need to export?

And what are "viewID" and "filterID"? I do not see such values in our report. Where can I find them?

Update:

I was able to get veiewID and filterID from report, but I guess I'm missing something.

My query:

and I get an error: 

The operation failed with an error. [422] Invalid Parameter: listOptions value "{"viewID":"6047a6ce003f42586dc19dea1904a608","groupID":"0","filterID":"6047a6ce003f425ccdd376d63f4fc548","reportID":"6047a6ce003f425e8ec64e347a564d9f","isDrillDown":false,"listObjCode":"ASSGN","currency":},JSON parsing error at line 1, column 206"

[viovi]

I tried to replicate the request by using the value from Workfront report export operation, but now I get 

RuntimeError

[422] null objCode

I tried adding objCode:PTLSEC, but get the same error.

What am I missing?

[kautuk_sahni]

@Eric_D_Miller Just checking in — were you able to resolve your issue? We’d love to hear how things worked out. If the suggestions above helped, marking a response as correct can guide others with similar questions. And if you found another solution, feel free to share it — your insights could really benefit the community. Thanks again for being part of the conversation!