Expand my Community achievements bar.

NickPa
NickPa
Offline
Type
  • All
  • Questions
  • Discussions
  • Ideas
  • Blogs
Filter by user contributions
  • 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 ...

    Type

    Questions

    Views

    2.2K

    Likes

    0

    Replies

    0
  • 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...

    Type

    Questions

    Views

    2.2K

    Likes

    0

    Replies

    0
  • /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...

    Type

    Questions

    Views

    2.2K

    Likes

    0

    Replies

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

    Type

    Questions

    Views

    2.2K

    Likes

    0

    Replies

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

    Type

    Questions

    Views

    2.2K

    Likes

    0

    Replies

    0
  • 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

    Type

    Questions

    Views

    2.2K

    Likes

    0

    Replies

    0
  • 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 ...

    Type

    Questions

    Views

    2.2K

    Likes

    0

    Replies

    0
  • 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...

    Type

    Questions

    Views

    2.2K

    Likes

    0

    Replies

    0
Top badges earned by NickPa
Customize the badges you want to showcase on your profile