Best Of

Hi @Manik Salaria,

Can you confirm if you have entered a sheet ID into your API request? This should be entered in the section at the top. 

For example, if you’re wanting to get a specific comment, you’ll need to enter the sheet ID and the comment ID in the bolded sections here:  https://api.smartsheet.com/2.0/sheets/{sheetId}/comments/{commentId}

If you’re wanting to retrieve all discussions & comments for an entire sheet, you’ll need to use https://api.smartsheet.com/2.0/sheets/{sheetId}/discussions?include=comments.

Lastly, if you’re wanting to list all comments for a specific row, you can use https://api.smartsheet.com/2.0/sheets/{sheetId}/rows/{rowId}/discussions.

Take a look at the relevant sections of the Smartsheet API documentation here:

• Get a comment
• List Discussions
• List Discussions with a Row

Hope that helps!

Georgie

@Genevieve P. Thank you for that! After some trial and error, we were finally able to get a solution! We were able to do it fairly similarly to what you have, but with a bit of additional javascript which allows it to be dynamic when we have multiple employees in this workspace.

1. Use Bridge to trigger off of a row being added to the summary sheet from a control center project.
2. New State: Get Row
   1. Use Bridge to get row
      1. The row contains the project name and employee name.
3. New State: Get Project Folder
   1. Use the API with the workspace ID that we are pushing the projects to and list out the folders in that workspace.
   2. Use JS to see which of the folder names contains the project name that we got from step 2a.
4. New State: Get Project Sheet/Employee Folder
   1. Use the API to get the sheet ID from the sheet in the folder from step 3b.
   2. Use JS to see which of the folder names (step 3a) contains the employee name that we got from step 2a.
5. New State: Get Destination Folder
   1. Use the API to list the folders under the folder from step 4b.
   2. Use JS to see which of the folder names is equal to "Group Sheets".
6. New State: Move Sheet
   1. Use the API to move the sheet (step 4a) to the "Group Sheets" folder (step 5b).
7. New State: Delete Project Folder
   1. Use the API to delete the project folder (step 3b).

We used the https://api.smartsheet.com/2.0/ for the base URL and then the documentation from https://smartsheet.redoc.ly/?_gl=1*1kk6t8a*_ga*MjUzODA3NTQ1LjE3MDgzODQzMDk.*_ga_ZYH7XNXMZK*MTcxMzgwMzU4OS45NC4xLjE3MTM4MDQwNTMuNTkuMC4w&_ga=2.255678600.1272401998.1713800142-253807545.1708384309#section/Introduction to do the endpoints.

We were then able to use the below JavaScript through each step to determine which folders we were wanting to use.
function getFolderIdByName(folders, searchName) {
const folder = folders.find(folder => folder.name.includes(searchName));
if (folder) {
return folder.id;
} else {
return 'Folder not found';
}
}

const folders = folderArray;
const folderId = getFolderIdByName(folders, searchName);
return folderId;
The folderArray and searchName were set in the Bridge JavaScript Script Parameters. The folderArray was set to the folder arrays that we were getting from the API calls and the searchName was set to the folders that we were trying to find (Project Name(Step 2a), Employee Name (Step 2a), or Group Sheets (Hard Coded)).
The folder.name.includes() allowed us to not have to specify the whole name for the folder and instead just include the specific part that we were capturing in the summary sheet.

Now onto step 2 (or would it be 8?) for when the project is complete, we are going to make a copy of the sheet, save the copy to a historical folder, then wipe the original so that it can be used again. My use-case is a project sheet that is refreshed annually. No need to archive the projects in Control Center, especially since Control Center has issues with creating projects with the same name a second time, and not being able to effectively archive the actual project sheet if it is moved from the original project folder!