The Smartsheet API gives developers access to Smartsheet platform features and data, enabling you to build custom applications and integrations that extend the functionality of Smartsheet. With the Smartsheet API, you can create powerful integrations that are tailored to your specific business needs.
Using the Smartsheet API, you can:
import { axios } from "@pipedream/platform"
export default defineComponent({
props: {
smartsheet: {
type: "app",
app: "smartsheet",
}
},
async run({steps, $}) {
return await axios($, {
url: `https://api.smartsheet.com/2.0/users/me`,
headers: {
Authorization: `Bearer ${this.smartsheet.$auth.oauth_access_token}`,
},
})
},
})
Smartsheet uses OAuth authentication. When you connect your Smartsheet account, Pipedream will open a popup window where you can sign into Smartsheet and grant Pipedream permission to connect to your account. Pipedream securely stores and automatically refreshes the OAuth tokens so you can easily authenticate any Smartsheet API.
Pipedream requests the following authorization scopes when you connect your account:
ADMIN_SHEETS
ADMIN_SIGHTS
ADMIN_USERS
ADMIN_WEBHOOKS
ADMIN_WORKSPACES
CREATE_SHEETS
CREATE_SIGHTS
DELETE_SHEETS
DELETE_SIGHTS
READ_CONTACTS
READ_SHEETS
READ_SIGHTS
READ_USERS
SHARE_SHEETS
SHARE_SIGHTS
WRITE_SHEETS
GET
https://app.smartsheet.com/b/authorize
?
client_id={{oauth.client_id}}
&
redirect_uri={{oauth.redirect_uri}}
&
state={{oauth.state}}
&
response_type=code
&
scope={{oauth.space_separated_scopes}}
POST
https://api.smartsheet.com/2.0/token
content-type: application/x-www-form-urlencoded
accept: application/json
client_id={{oauth.client_id}}
&
client_secret={{oauth.client_secret}}
&
redirect_uri={{oauth.redirect_uri}}
&
grant_type=authorization_code
&
code={{oauth.code}}
POST
https://api.smartsheet.com/2.0/token
content-type: application/x-www-form-urlencoded
accept: application/json
client_id={{oauth.client_id}}
&
client_secret={{oauth.client_secret}}
&
grant_type=refresh_token
&
refresh_token={{oauth.refresh_token}}