Can anyone provide an example of using Bridge HTTP Call Utility to Smartsheet Group?

molson

I have a column of email addresses in multiple sheets and I would like to have an automated way to add them to a Smartsheet Group. This is for the dynamic view links we created to update the sheets. I was directed to use Smartsheet Bridge but I'm not too familiar with JSON. How I can PUT or POST a sheet column value in the Smartsheet Group URL? How can this be done?

Genevieve P.

Hey @molson

If you're using the HTTP module, then you'll want to reference the API Documentation for how to set it up / what parameters are needed. Here's the documentation to Add Group Members using POST:

https://smartsheet.redoc.ly/tag/groupMembers#operation/add-group-members

The URL would be:

https://api.smartsheet.com/2.0/groups/{groupId}/members

You'd need to add the Authorization (bearer token) under the Header tab, then the Array of emails in the Body of the HTTP call.

I'm not a Group Admin so I haven't tested it, but hopefully this should point you in the right direction!

Cheers,

Genevieve

molson

Thanks Genevieve! This is very helpful. I will work on this and see how far I can manage to make it work!

molson

Hi Genevieve,

How do I request for a bearer token in the HTTP call to put in the Header tab? I cannot find the documentation for that, or I may be looking at the wrong place.

Thanks in advance!

Genevieve P.

Hey @molson

No problem, happy to help!

The HTTP module allows you to use the Smartsheet API. This means the Bearer Token is your API access Token. Here's the documentation: https://smartsheet.redoc.ly/#section/API-Basics/Authentication-and-Access-Tokens

In the Smartsheet application, go to your profile/account in the bottom left. Then go to the API Access tab:

Here's the Help Article that has steps on how to get it:

https://help.smartsheet.com/articles/2482389-generate-API-key

Cheers,

Genevieve

molson

Thank you Genevieve! These are all helpful, I think I'm ready to test my Bridge workflow.

Samuel Mueller

@molson I'm happy to help too if you are having trouble, I create a lot of these types of workflows in bridge to update Smartsheet groups.

molson

Hi Samuel - Thank you! Yes I definitely need help in testing the Bridge workflow. I'm not even sure how to properly test it as the trigger is a new added row in a sheet to a Smartsheet Group. Is there a way to show you the workflow I created via an online session instead of screenshots?

Samuel Mueller

@molson I'd be happy to connect through zoom or whatever. I have some free time tomorrow afternoon or Monday afternoon. I'm central

molson

@Samuel Mueller Thank you, I will setup sometime Monday afternoon via Webex.

molson

Thank you @Samuel Mueller for the help on the Smartsheet Bridge workflow last week! Your expertise and time were very much appreciated.