Smartsheet application on Connect iPaaS uses OAuth authorization and API Key authorization. By linking your Smartsheet account with Connect iPaaS using OAuth, you can authorize RoboMQ to have a delegated access on your behalf. RoboMQ needs the following permissions on your account to provide a seamless integration experience:
|Sheet Row Object||Read and Write Permission on sheets (READ_SHEETS, WRITE_SHEETS)|
|Sheet Object||Permission to create sheet (CREATE_SHEETS)|
|Webhooks||Admin Permission on managing Webhooks (ADMIN_WEBHOOKS)|
|Users||Permission to read users (READ_USERS)|
Please refer here to learn more about Smartsheet OAuth permissions used by Connect iPaaS.
Using the API Key connection mechanism, you can authorize Connect iPaaS to have the same level of access as the user principal of the account that generated the API key. These permissions may be more permissive than what could be achieved by using OAuth. For security considerations, we recommend using OAuth wherever available.
Create an OAuth 2.0 Connection¶
To link your Smartsheet account using
OAuth, you just have to click on the
link account button.
When you click on the
Link Account button, you will be redirected to the Smartsheet Authentication screen and then to the application page where you can check
allow RoboMQ to access your account.
By allowing access, you are authorizing RoboMQ to access your Smartsheet account.
Create an API Key Connection¶
You need to generate API Key to authenticate your Smartsheet account on Connect iPaaS.
How to get API Key in Smartsheet?¶
Login to your Smartsheet account.
Click on the
Accountbutton in the upper-right corner of the Smartsheet screen, and then click
Personal Settings.Figure 1: Smartsheet API Key Generation
API Accesstab.Figure 2: Smartsheet API Key Generation
Generate new access tokenbutton to obtain an access token. And then choose API Access Token Name on the create an API key screen.Figure 3: Smartsheet API Key Generation
How to create a Smartsheet connection on Connect iPaaS using API Key?¶
Now you have your API key, you can now use your account in Connect iPaaS. Choose the connection type
APIKey and paste the API Key value you saved earlier.