DARK MODE! Yes!

The $$ROLLUP function will give you multiple group levels as well. https://mrc.my.workfront.com/attask/api/v10.0/project/report?hours:hours_AggFunc=sum_hours:timesheet:endDate=2019-02-09&company:name_2_GroupBy=true&owner:name_1_GroupBy=true&$$ROLLUP=true&$$LIMIT=2000&apiKey=KRY Doug Patton": { "MRC ...

https://mrc.my.workfront.com/attask/api/v10.0/project/report?hours:hours_AggFunc=sum_hours:timesheet:endDate=2019-02-09&company:name_2_GroupBy=true&owner:name_1_GroupBy=true&$$LIMIT=2000&apiKey=KEY Looks like this works fine now. it seems it was the & between sum and hours throwing your request stri...

/attask/api/v10.0/proj/report?apiKey=YOURKEY&hours:hours_AggFunc=sum & hours:timesheet:endDate=2019-02-09 https://mrc.my.workfront.com/attask/api/v10.0/project/report?hours:hours_AggFunc=sum_hours:timesheet:endDate=2019-02-09 Try this one. Does it return the information you need? Nick Patel MRC Glob...

Also is "company" a custom field? Nick Patel MRC Global

what is the entire string you are wanting to use? Nick Patel MRC Global

I get a response with aggregated data and no errors with that string that you provided. https://mrc.my.workfront.com/attask/api/v9.0/hour/report?project:name_1_GroupBy=true&hours_AggFunc=sum&apiKey=KEY Nick Patel MRC Global

Brad, There is not an API string for only reporting. there is just the REST API that Workfront has available. You can use excel or Power Bi to draw te data down into a table after you get the string in the correct format. You can use filters and groups, but they are a bit different than the regular ...

Hi, yes I do use the GET API to pull a JSON response. You wont be able to use groups or filters as easily as drawing down the data and manipulating it yourself. you should be using: " https://mrc.my.workfront.com/attask/api/v10.0/issue/search?" then your filters, custom fields, projectID's etc. Then...

Kathy, thank you ! It Worked! You are a WorkFront ninja! Thank you, Nick Patel