Resource Management - API Error [Code:500] - [Message: Internal Error]

Tamer Moustafa

Hello,

I am trying to make an API call on Resource Management Reports API, it works fine until I pass the group_by parameter then i receive the subject error (500: Internal error) although the group_by is one of the parameters that we can pass according to the API documentation and by default if not passed its (group_by: 'project_id').

any idea how to solve this issue ?

Before passing group by parameter:

After passing group by parameter:

Genevieve P.

Hey @Tamer Moustafa

The correct format for group_by is an array indicated by a square bracket (like in the output you screen captured above). If you want to group just by the discipline, you would need to still set that as a one-item array with the string 'discipline' in your tools/script, e.g. ['discipline'].

Here's more information:

Resource Management by Smartsheet API

https://10kft.github.io/10kft-api/#time_frame

The Resource Management by Smartsheet API provides programmatic access to projects, users and time entries in your account, commonly referred to as resources in the rest of this API documentation. The API implements a standard HTTP REST pattern and allows callers with appropriate authentication and authorization to programmatically create, read, update and delete these resources.

Cheers,

Genevieve

Tamer Moustafa

Thanks @Genevieve P. for your answer, I have tried this as well, it's not working after passing the group_by Parameter, kindly see the below screenshots with and without group_by.

Without group_by (working fine)

After adding group_by (Internal Error):

Genevieve P.

Hey @Tamer Moustafa

Would you mind testing an array, just to make sure the rest of the structure is set up properly? (Grouping by more than one element)

Tamer Moustafa

Hi @Genevieve P. , I got the same result, below is the screenshot

Genevieve P.

Hey @Tamer Moustafa

Thanks for testing and confirming! At this point I would recommend opening a Support Ticket so we can continue to troubleshoot in a private channel where you can share more information. Please include all of these screen captures and the steps you have tried.

Thank you,

Genevieve

Tamer Moustafa

Thanks @Genevieve P. for trying .. I have already raised a ticket, shall I share the ticket number ?

Genevieve P.

Thanks for contacting Support!

The only other thing I can think of testing while you wait to hear back is to ensure that this Group value is a valid value to group by - you can test this by doing the same action in the Resource Management UI and make sure the Grouping works when you add these parameters.

Tamer Moustafa

Hi @Genevieve P. .. That's good idea .. it's working, please see the below screenshot

Tamer Moustafa

In reference to the above, So definitely we need support team assistance @Genevieve P. 😊

Tamer Moustafa

Hi @Genevieve P. , I have solved the problem, it seems i have to pass the array it self as a string as shown in the below screenshot, its now working fine

Tamer Moustafa

I have a problem now passing the time frame, I am passing it as an object but I am getting error.