Correct.  Currently we have 4 Access queries for each report.The first query just includes project-based fields that can be aggregated:The second query includes the task-based fields that will form the heart of the crosstab; in it I created a custom field that includes both the task due date and com...

Yeah, I find both the matrix reporting and the built-in milestone view underwhelming.  We rely on milestone reporting to give us an at-a-glance view on how different project populations are tracking.Until WF can provide a better built-in solution, we've been exporting the raw WF milestone task data ...

Thanks, Sven!  I was missing "Token " in the header value.

Thanks, Lars.  This is is the base URL for our Fusion instance:I've tried both https://fusion.adobe.com/api/v5/ and https://app.workfrontfusion.com/api/v5/ with the same result (v2 gives a not logged in error, and the output specifies the API version as 5.38.1).  I just get a big block of HTML (the ...

Thanks, Rafal.  Just to be clear--this will allow me to access the Fusion API (to research scenario runs, incomplete executions, etc.)?  I'm not looking to access the Workfront API.  Thanks.

Could someone give me a little guidance for working with the the Fusion internal API?  I've created an API token (selecting all the 'read' options), and I've looked at the Make.com documentation.I've tried using an HTTP Make a Request module, using https://app.workfrontfusion.com/api/v5/ as a base U...

Happy to help!

Try passing the value to a Parse JSON module.  All 3 of the items in your string would be text types in the data structure.  Once parsed, you should be able select the items individually.    

Hmmm... I submitted an access request to create a connection for the Power BI modules; I got a confirmation email after my submission, but the request seems to have gone into a black hole after that.I was correct in assuming that my sessionID would expire (I think it took a day or two) and throw an ...

Hi All,I'm new to both Power BI and API calls (I've used the Custom API Call module in Fusion but nothing much beyond that), and I have a couple of questions for folks who have used both with Workfront.I started experimenting with WF API calls in Power BI. After reading Rick's reply in this post, I ...