Smartsheet connectors

Smartsheet connectors DEFAULT

Smartsheet

Smartsheet is a powerful work management and collaboration tool that lets you easily track and manage your work so you and your team can be more productive than ever. Use it to collaborate with others, track progress on any project, automate processes, and better structure your work.

This connector is available in the following products and regions:

ServiceClassRegions
Logic AppsStandardAll Logic Apps regions except the following:
     -   Azure China regions
     -   US Department of Defense (DoD)
Power AutomateStandardAll Power Automate regions except the following:
     -   US Government (GCC High)
     -   China Cloud operated by 21Vianet
     -   US Department of Defense (DoD)
Power AppsStandardAll Power Apps regions except the following:
     -   US Government (GCC High)
     -   China Cloud operated by 21Vianet
     -   US Department of Defense (DoD)

To use this integration, you will need access to a Smartsheet account. To make a connection, select Sign In. You will be prompted to provide your Smartsheet account information, follow the remainder of the screens to create a connection.

You're now ready to start using this integration.

Throttling Limits

NameCallsRenewal Period
Frequency of trigger polls115 seconds

Actions

Add a comment to an existing discussion.

Parameters

NameKeyRequiredTypeDescription

Sheet Id

sheetId True string

The unique id of the sheet.

Discussion

discussionId True string

The discussion to add the comment to.

Text

text string

The text of the comment.

Returns

Response object for Creating a Comment.

Add a discussion to a row

Add a discussion to a specific row in a sheet.

Parameters

NameKeyRequiredTypeDescription

Sheet

sheetId True string

The unique id of the sheet.

Row Id

rowId True string

The unique id of the row.

Title

title string

The title for the discussion.

Text

text string

The text of the comment.

Returns

Response object for Create Discussion.

Add a discussion to a sheet

Add a discussion to a sheet

Parameters

NameKeyRequiredTypeDescription

Sheet Id

sheetId True string

Sheet to add a discussion to

Title

title string

The title for the discussion.

Text

text string

The text of the comment.

Returns

Response object for Create Discussion.

Get a discussion

Get a specific discussion.

Parameters

NameKeyRequiredTypeDescription

Sheet Id

sheetId True string

The unique id of the sheet.

Discussion Id

discussionId True string

The unique id of the discussion on the specified sheet.

Returns

Data relevant to the discussion created.

Get a sheet

Get a specific sheet.

Parameters

NameKeyRequiredTypeDescription

Sheet Id

sheetId True string

The unique id of the sheet.

Comma separated columns to return

columns string

The list of columns to return

Returns

A Smartsheet sheet with rows.

Get a sheet data (dynamic schema)

Get a specific sheet data.

Parameters

NameKeyRequiredTypeDescription

Sheet Id

sheetId True string

The unique id of the sheet.

Comma separated columns to return

columns string

The list of columns to return

Returns

The outputs of this operation are dynamic.

Get discussions for a sheet

Get the discussions for a specific sheet.

Parameters

NameKeyRequiredTypeDescription

Sheet Id

sheetId True string

The unique id of the sheet.

Returns

A common pattern for requesting collections from Smartsheet.

Get subfolders of a folder

Get subfolders of a specific folder.

Parameters

NameKeyRequiredTypeDescription

Folder Id

id True string

The id of the folder.

Returns

A common pattern for requesting collections from Smartsheet.

Get the columns of a sheet

Get the columns of a specific sheet.

Parameters

NameKeyRequiredTypeDescription

Sheet Id

sheetId True string

The unique id of the sheet.

Returns

A common pattern for requesting collections from Smartsheet.

Get the columns of a sheet (dynamic schema)

Get the columns of a specific sheet in dynamic schema format.

Parameters

NameKeyRequiredTypeDescription

Sheet Id

sheetId True string

The unique id of the sheet.

Returns

Insert row

Insert a row into a specific sheet.

Parameters

NameKeyRequiredTypeDescription

Sheet Id

sheetId True string

The unique id of the sheet.

Row

row True dynamic

The row to insert.

Returns

Response to InsertRow operation.

List the sheets

Get a list of the sheets.

Parameters

NameKeyRequiredTypeDescription

Folder Id (defaults to all)

optionalFolderId string

The unique id of the folder containing the sheets. If not specified, will default to all.

Returns

A common pattern for requesting collections from Smartsheet.

Triggers

Triggers when a comment is added to a specific discussion.

Parameters

NameKeyRequiredTypeDescription

Sheet Id

sheetId True string

The unique id of the sheet.

Discussion Id

discussionId True string

The unique id of the discussion.

Returns

Response object for Comment.

Triggers when a comment is added to a specific sheet.

Parameters

NameKeyRequiredTypeDescription

Sheet Id

sheetId True string

The unique id of the sheet.

Returns

A common pattern for requesting collections from Smartsheet.

When a discussion is added to a sheet

Triggers when a discussion is added to a sheet.

Parameters

NameKeyRequiredTypeDescription

Sheet Id

sheetId True string

The unique id of the sheet.

Returns

A common pattern for requesting collections from Smartsheet.

When a new row is created

Triggers when a new row is created in a specific sheet.

Parameters

NameKeyRequiredTypeDescription

Sheet Id

sheetId True string

The unique id of the sheet.

Columns

columns string

The comma separated list of columns.

Returns

Response object for OnRowCreated.

When a new sheet is created

Triggers when a new sheet is created.

Parameters

NameKeyRequiredTypeDescription

Folder Id (defaults to all)

optionalFolderId string

The unique id of the folder containing the sheets. If not specified, will default to all.

Returns

A common pattern for requesting collections from Smartsheet.

When a sheet is updated

Triggers when a specific sheet is updated.

Parameters

NameKeyRequiredTypeDescription

Sheet Id

sheetId True string

The unique id of the sheet.

Columns to Return

columns string

The comma separateed list of columns to return.

Returns

A common pattern for requesting collections from Smartsheet.

When any sheet is updated

Triggers when any sheet is updated.

Parameters

NameKeyRequiredTypeDescription

Folder (defaults to all)

optionalFolderId string

The unique id of the folder containing the sheets. If not specified, will default to all.

Returns

A common pattern for requesting collections from Smartsheet.

Definitions

SmartsheetCollection[Sheet]

A common pattern for requesting collections from Smartsheet.

NamePathTypeDescription

Data

data array of Sheet

Collection of Smartsheet models.

Sheet

A Smartsheet sheet.

NamePathTypeDescription

Access Level

accessLevel string

The access level of the sheet.

Id

id integer

The unique identifier for the sheet.

Name

name string

The name of the sheet.

Url

permalink string

The url for the sheet.

Created At

createdAt date-time

The datetime when the sheet was created.

Modified At

modifiedAt date-time

The datetime the sheet was modified.

A common pattern for requesting collections from Smartsheet.

NamePathTypeDescription

Data

data array of DiscussionComment

Collection of Smartsheet models.

A comment on a discussion.

NamePathTypeDescription

Comment Text

text string

The text of the comment.

Comment Id

id integer

The id for the comment.

createdBy

createdBy DiscussionCommentUser

The user who created the comment.

Created At

createdAt date-time

The datetime the comment was created.

Modified At

modifiedAt date-time

The datetime the comment was modified.

The user who created the comment.

NamePathTypeDescription

Created By (Name)

name string

The name of the user who created a comment.

Created By (Email)

email string

The email of the user who created a comment.

SheetWithRows

A Smartsheet sheet with rows.

NamePathTypeDescription

Sheet HTML

rowHTML string

An HTML table representation of the sheet.

Access Level

accessLevel string

The access level of the sheet.

Id

id integer

The unique identifier for the sheet.

Name

name string

The name of the sheet.

Url

permalink string

The url for the sheet.

Created At

createdAt date-time

The datetime the sheet was created.

Modified At

modifiedAt date-time

The datetime the sheet was modified.

Columns

columns array of Column

Array of columns.

Rows

rows array of RowData

Array of rows.

SmartsheetCollection[Column]

A common pattern for requesting collections from Smartsheet.

NamePathTypeDescription

Data

data array of Column

Collection of Smartsheet models

Column

A Smartsheet column.

NamePathTypeDescription

Column Id

id integer

The unique id of the column.

Column Index

index integer

The ordinal position of the column.

Title

title string

The title of the column.

Data Type

type string

The data type of the column (such as text_number or datetime).

Is Primary

primary boolean

A boolean value (true, false) determining whether or not the column is the primary column.

Width

width integer

The width in pixels of the column,

InsertRowResponse

Response to InsertRow operation.

NamePathTypeDescription

result

result InsertRowResponseResult

InsertRowResponseResult

NamePathTypeDescription

Sheet Id

sheetId integer

The Id of the sheet that was modified.

Row Number

rowNumber integer

The row number of the newly inserted row.

Created At

createdAt date-time

The datetime the sheet was created.

Modified At

modifiedAt date-time

The datetime the sheet was modified.

SmartsheetCollection[SheetWithRows]

A common pattern for requesting collections from Smartsheet.

NamePathTypeDescription

Data

data array of SheetWithRows

Collection of Smartsheet models.

SmartsheetCollection[Folder]

A common pattern for requesting collections from Smartsheet.

NamePathTypeDescription

Data

data array of Folder

Collection of Smartsheet models.

Folder

A Smartsheet folder.

NamePathTypeDescription

Id

id integer

The unique id of the folder.

Name

name string

The name of the folder.

Url

permalink string

The url for the folder.

DiscussionResponse

Response object for Create Discussion.

NamePathTypeDescription

result

result DiscussionData

Data relevant to the discussion created.

DiscussionData

Data relevant to the discussion created.

NamePathTypeDescription

Id of Discussion

id integer

The id for the discussion.

Discussion title

title string

The title for the discussion.

Comments

comments array of DiscussionComment

The comments in the discussion.

createdBy

createdBy DiscussionUser

The user who created the discussion.

DiscussionUser

The user who created the discussion.

NamePathTypeDescription

Created By (Name)

name string

The name of the user who created the discussion.

Created By (Email)

email string

The email of the user who created the discussion.

SmartsheetCollection[GetDiscussionResponse]

A common pattern for requesting collections from Smartsheet.

NamePathTypeDescription

Data

data array of GetDiscussionResponse

Collection of Smartsheet models.

GetDiscussionResponse

Response object for Get Discussions.

NamePathTypeDescription

Discussion Id

id integer

The unique id of the discussion.

Discussion Title

title string

The title for the discussion.

createdBy

createdBy DiscussionUser

The user who created the discussion.

Access Level

accessLevel string

The access Level for the discussion.

Parent Type

parentType string

The parent type for the discussion.

Is Read-Only

readOnly boolean

A boolean value (true, false) determining whether or not this discussion is read-only.

Last Commented At

lastCommentedAt date-time

The datetime of the most recent comment

RowResponse

Response object for OnRowCreated.

NamePathTypeDescription

Rows

rows array of RowData

The content of the row that was created.

RowData

A row

NamePathTypeDescription

Row Id

id integer

The unique id for the row.

Sheet Id

sheetId integer

The id of the sheet the row was added to.

Url

permalink string

The url for the sheet the row was added to.

Created At

createdAt date-time

The datetime the row was created.

Modified At

modifiedAt date-time

The datetime the row was modified.

Row Number

rowNumber integer

The number of the row.

Cells

cells array of RowCell

The cell detail in the row.

Row HTML

rowHTML string

An HTML table representation of the new row.

RowCell

A cell in a row

NamePathTypeDescription

Column Id

columnId integer

The id of column for this cell.

Cell Value

value

The value of the cell.

Cell Display Value

displayValue string

The display value of the cell.

Response object for Creating a Comment.

NamePathTypeDescription

result

result DiscussionComment

A comment on a discussion.

Response object for Comment.

NamePathTypeDescription

Comments

comments array of DiscussionComment

Comments in this discussion.

Sours: https://docs.microsoft.com/en-us/connectors/smartsheet/

Smartsheet Connector for MuleSoft

SQL-Centric MuleSoft Connectivity to Smartsheet

Leverage the power of SQL to simplify integration with Smartsheet. Our Smartsheet Connector for MuleSoft includes a robust SQL engine that simplifies data connectivity and allows users to accomplish complex data manipulation without extensive transformation workflow.

  • Write SQL, get Smartsheet data. Similar to the MuleSoft Database Connector, but for Smartsheet.
  • Powerful SQL Engine with support for dynamic queries, streaming, bulk operations, metadata discovery, query folding, and more.

  buy now
Smartsheet MuleSoft Anypoint Connector



SQL Access to Smartsheet From MuleSoft

Connecting to Smartsheet is as easy as connecting to a database




The Smartsheet MuleSoft Connector provides the easiest way to connect with Smartsheet data from MuleSoft workflow. The Connectors leverage a straightforward design, similar to the MuleSoft Database Connector, that makes it easy to import, export, backup, analyze, transform, & connect-to your Smartsheet data.


Standard MuleSoft Connectors



The Smartsheet Connector for MuleSoft is a fully-integrated standard Connector featuring seamless integration with the Anypoint designer, dynamic input and operation through DataSense, support for complex projections, streaming, bulk operations, and more!

Type SQL, Get Smartsheet



Write standard SQL queries to interact with Smartsheet, just like working with any RDBMS. Supports joins, updates, aggregation, etc.

SELECT WITH INNER JOIN

AGGREGATE FUNCTIONS

CRUD OPERATIONS


Key Features

  • Data-Centric Operations (SQL Access to Data)

    CData Connectors for MuleSoft function in a similar way to the Mule 4 Anypoint Connector for Database. They interoperate with MuleSoft DataWeave to offer dynamic data access from MuleSoft workflow.

  • Fully-Dynamic Queries

    Users can parameterize all parts of the Query passed to the Connector. This capability includes the WHERE clause as well as the ability to parameterize parts of the query itself.

  • Streaming & Bulk Operations

    Connectors support data streaming and bulk operations by default, making operations over large datasets fast and efficient. The connectors include integrated paging that streamlines data access, and support bulk and batch operations for reading and writing.

  • Intelligent Query Folding

    Improved performance through intelligent query folding. Connectors push data operations server-side wherever possible to improve execution performance. Operations that cannot be executed server side are handled client-side by the robust embedded SQL Engine.

  • Metadata Discovery

    Extensive schema discovery capabilities. Explore tables, columns, keys, and other data constructs based on user identity.

  • Replication and Caching

    Our replication and caching commands make it easy to copy data to local and cloud data stores such as Oracle, SQL Server, Google Cloud SQL, etc. The replication commands include many features that allow for intelligent incremental updates to cached data.

  • String, Date, & Numeric Function

    Includes a library of 50 plus functions that can manipulate column values into the desired result. Popular examples include Regex, JSON, and XML processing functions.

  • Collaborative Query Processing

    Connectors enhance the data source's capabilities with additional client-side processing, when needed, to enable analytic summaries of data such as SUM, AVG, MAX, MIN, etc.

  • Customizable and Configurable

    Data models can easily be customized to add or remove tables/columns, change data types, etc. without requiring a new build. Customizations are supported at runtime using human-readable schema files that are easy to edit.

  • All-in-One Deployment

    Standard MuleSoft Connectors that can be easily deployed to any supported MuleSoft platform.



Fast-track your next MuleSoft integration to Smartsheet. Standard SQL interfaces provide a familiar interface to Smartsheet, and shield systems integrators from the complexities of data access.


  download

Popular MuleSoft Articles:

Take a look at some of our most popular articles from our knowledge base:


For more articles and technical content related to Smartsheet MuleSoft Connector, please visit our online knowledge base.



This website stores cookies on your computer. These cookies are used to collect information about how you interact with our website and allow us to remember you. We use this information in order to improve and customize your browsing experience and for analytics and metrics about our visitors both on this website and other media. To find out more about the cookies we use, see our Privacy Policy.

AcceptDecline

Sours: https://www.cdata.com/drivers/smartsheet/mule/
  1. Biblical dress up ideas
  2. Albertsons 25
  3. Kidz bop youtube
  4. Powershell and command
  5. App annie review

Connectors

How to Use "Filtered Out by Connector—Not Synced"

When you're working with a sheet that is used with a Smartsheet connector, you may see a row that is labeled "Filtered out by Connector—not synced." U...

Gain Valuable Insight with the Smartsheet for Tableau Integration

Import Smartsheet data into Tableau and combine data from other business-critical systems to help your whole team gain valuable analytics insights....

Smartsheet for Jira Connector

Smartsheet for Jira Connector: Overview

Use Smartsheet for Jira to track and manage Jira issues in Smartsheet....

Smartsheet for Jira Connector: Admin Setup (Cloud and Self-Hosted)

Use the Smartsheet for Jira Connector to create workflows to sync information between Smartsheet and one or more Jira instances....

Smartsheet for Jira: Creating and Editing Synchronization Workflows

You can use Smartsheet for Jira to track and manage Jira issues in Smartsheet....

Keep Related Jira Issues Together with Smartsheet Hierarchy

Keep synched Jira issues organized and sorted to maintain consistency and readability in your sheet....

Link Jira Issues together from Smartsheet with Issue Links

Use Issue Links in Jira to get a broader view of your Jira issues....

Streamline Jira Issue Creation From Smartsheet

Using the Smartsheet for Jira Connector, you can create new issues in Jira without having to leave Smartsheet....

Jira Connector Firewall FAQ (Self-Hosted Server)

This article provides server and firewall requirements that will need to be in place, prior to configuring a self-hosted server on the Smartsheet for ...

Salesforce and Service Cloud Connectors

Salesforce and Service Cloud Connectors

The Salesforce and Service Cloud Connectors are available as a premium offering....

Salesforce and Service Cloud Connectors: Admin Setup

Use the Salesforce Connector to gain valuable insights from your sales data and drive the execution of work across teams....

Connectors: Sync Smartsheet with Salesforce or Service Cloud

Use the Salesforce Connector to have opportunities, contacts, and other Salesforce records automatically update to and from Smartsheet in real time....

Salesforce Connector FAQ

You can use the Smartsheet for Salesforce and Service Cloud Connectors to synchronize data between Salesforce or Service Cloud objects and sheets in S...

Smartsheet for Microsoft Dynamics 365 Connector

Smartsheet for Microsoft Dynamics 365 Connector

Use the Smartsheet for Microsoft Dynamics 365 Connector to automatically synchronize data bi-directionally between Smartsheet and Dynamics 365....

Sync Smartsheet with Microsoft Dynamics 365

Use the Microsoft Dynamics 365 Connector to have Leads, Opportunities, Accounts, Contacts and other Dynamics 365 entities sync between Smartsheet and ...

Smartsheet for Microsoft Dynamics 365 Connector: Admin Setup

Use the Smartsheet for Microsoft Dynamics 365 Connector to create workflows that sync information between Smartsheet and your Microsoft Dynamics 365 i...

Subscribe to Connectors

Sours: https://help.smartsheet.com/topics/Connectors
Introduction to Smartsheet

reshuffle-smartsheet-connector

Code | npm | Code sample

Reshuffle Smartsheet Connector

This package contains a Reshuffle connector to access to online spreadsheets at smartsheet.com.

The following example tracks changes to an online spreadtsheet. Changes are reported at the sheet level, row level and cell level:

const{ Reshuffle }=require('reshuffle')const{ SmartsheetConnector }=require('reshuffle-smartsheet-connector')constapp=newReshuffle()constssh=newSmartsheetConnector(app,{apiKey: process.env.SMARTSHEET_API_KEY,baseURL: process.env.RESHUFFLE_RUNTIME_BASE_URL,})ssh.on({sheetId: sheet.sheetId},async(event)=>{console.log('Smartsheet event:',event)})asyncfunctionmain(){constsheet=awaitssh.findOrCreateSheet('Reshuffle Events Example',[{title: 'Name',type: 'TEXT_NUMBER',primary: true},{title: 'Quest',type: 'TEXT_NUMBER'},{title: 'Color',type: 'TEXT_NUMBER'},])if(sheet.created){awaitssh.addRowToBottom(sheet.sheetId,[{columnId: sheet.columns[0].id,value: 'Arthur'},{columnId: sheet.columns[1].id,value: 'Find the Holy Grail'},{columnId: sheet.columns[2].id,value: 'Blue'},])}console.log(`Please visit ${sheet.permalink} and make some changes`)}app.start()main().catch(console.error)

Table of Contents

Configuration Configuration options

Connector events

sheetChanged Sheet changed

Connector actions

addRows Add rows to a sheet

addRowToBottom Add one row at the bottom of a sheet

addRowToTop Add one row at the top of a sheet

createSheet Create a new sheet

deleteRow Delete one row

findOrCreateSheet Find or create a sheet

getImage Get image from a sheet cell

getSheetById Get sheet data by sheet id

getSheetIdByName Find sheet id by its name

getSheetByName Get sheet data by sheet name

getSimpleSheetById Get a simple sheet object by ID

getSimpleSheetByName Get a simple sheet object by name

getRow Get row information

listSheets List all sheets

listRows List rows in a sheet

update Update a sheet

sdk Get direct SDK access

Configuration options

constapp=newReshuffle()constsmartsheetConnector=newSmaetsheetConnector(app,{apiKey: process.env.SMARTSHEET_API_KEY,baseURL: process.env.RESHUFFLE_RUNTIME_BASE_URL,// optional but required// for events})

Connector events

Sheet Changed event

Example:

async(event)=>{console.log('Smartsheet event:',event)})

This event is fired when a Smartsheet webhook is triggered. Triggers include sheet update, row update, cell update and more.

See event.js for an example of defining and handling sheet events.

Connector actions

Add Rows action

Add rows to a sheet.

Definition:

(sheetId: number|string,rows: object,)=>void

Usage:

awaitsmartsheetConnector.addRows(4583173393803140,[{toTop: true,cells: [{columnId: 7960873114331012,value: true,},{columnId: 642523719853956,value: 'New status',strict: false,},],},{toBottom: true,cells: [{columnId: 7960873114331012,value: true,},{columnId: 642523719853956,value: 'New status',strict: false,},],},])

Add Row To Bottom action

Add one row after the last row of a sheet.

Definition:

(sheetId: number|string,cells: object[],)=>void

Usage:

awaitsmartsheetConnector.addRowToBottom(4583173393803140,{{columnId: 7960873114331012,value: true},{columnId: 642523719853956,value: 'New status'}})

Add Row To Top action

Add one row before the first row of a sheet.

Definition:

(sheetId: number|string,cells: object[],)=>void

Usage:

awaitsmartsheetConnector.addRowToTop(4583173393803140,{{columnId: 7960873114331012,value: true},{columnId: 642523719853956,value: 'New status'}})

Create Sheet action

Create a new sheet.

Definition:

(name: string,columns: object[])=>object

Usage:

awaitsmartsheetConnector.createSheet('My Sheet',[{title: 'Name',type: 'TEXT_NUMBER',primary: true},{title: 'City',type: 'TEXT_NUMBER'},])

Delete Row action

Delete a single row from the specified sheet.

Definition:

(sheetId: number|string,rowId: number|string,)=>void

Usage:

awaitsmartsheetConnector.deleteRow(4583173393803140,1234567890123456)

Find Or Create Sheet action

This action offers the same interface as createSheet above, but checks first whether a sheet with the specified exists. If so, that sheet is returned. Otherwise, a new one is created.

The action returns an object with the following fields:

accessLevel: string columns: object[] created: boolean name: string permalink: string sheetId: number

Definition:

(sheetId: number|string,rowId: number|string,)=>object

Usage:

awaitsmartsheetConnector.findOrCreateSheet('My Sheet',[{title: 'Name',type: 'TEXT_NUMBER',primary: true},{title: 'City',type: 'TEXT_NUMBER'},])

Get Image action

Get an image stored in a sheet cell. and specify the specific row to query. is treated as an index if it is a number smaller than 1024, otherwise it is treated as a column id.

The returned image data includes a unique ID, the alternative text (usually the original file name) and a download URL. The URL is valid for half an hour.

Use the optional and arguments to get a link to a resized image.

Definition:

(sheetId: number|string,rowId: number|string,columnIdOrIndex: number|string,width?: number,height?: number,)=>object

Usage:

constimg=awaitsmartsheetConnector.getImage(4583173393803140,000000000000000,3,)console.log(img.id,img.text,img.url)

Get Sheet By ID action

Get full sheet data for the sheet with the specified .

Definition:

(sheetId: number|string,)=>object

Usage:

constsheetData=awaitsmartsheetConnector.getSheetById(4583173393803140)

Get Sheet ID By Name action

Lookup the sheet ID for the sheet with the specified name. If a sheet with that name is not found then an Error is thrown.

Definition:

(name: string,)=>number

Usage:

constsheetId=awaitsmartsheetConnector.getSheetIdByName('My Sheet')

Get Sheet By Name action

Get full sheet data for the sheet with the specified . If a sheet with that name is not found then an Error is thrown.

Definition:

(name: string,)=>object

Usage:

constsheetData=awaitsmartsheetConnector.getSheetByName('My Sheet')

Get Simple Sheet By ID action

Get a object representing the sheet with the specified . This object provides the following methods:

getColumnIdByTitle(columnTitle: string,): number// Get column ID by column titlegetUpdater(): object// Create an updater objectpivot(pivotColumn: string,property: string,matchColumns: string[],includeRowIDs?: boolean,): object// Build a pivot tabletoSCV(): string// Create a CSV representation

An updater object provides the following methods:

addUpdate(columnTitle: string,rowId: number|string,value: string,)// Add a cell value to be updatedgetSheetId(): number// Get the sheet IDgetUpdates(): object// Get the updates for using with the update action

Definition:

(sheetId: number|string,)=>object

Usage:

constsheet=awaitsmartsheetConnector.getSimpleSheetById(4583173393803140)constupdater=sheet.getUpdater()updater.addUpdate('My Column',000000000000000,'New Value')awaitsmartsheetConnector.update(updater.getSheetId(),updater.getUpdates())

Get Simple Sheet By Name action

Get a object representing the sheet with the specified . See getSimpleSheetById for details.

Definition:

(name: string,)=>object

Get Row action

Get information about the specified row in the specified sheet. Row information is detailed here.

Definition:

(sheetId: number|string,rowId: number|string,)=>object

Usage:

constrow=awaitsmartsheetConnector.getRow(4583173393803140,1234567890123456,)

List Rows action

Get a list of row Ids in the specified sheet.

Definition:

(sheetId: number|string,)=>number[]

Usage:

constrowIds=awaitsmartsheetConnector.listRows(4583173393803140)

List Sheets action

Get a list of all sheets in the connected Smartsheet account. For each sheet, the following information is returned:

  • id - Sheet ID
  • name - Sheet name
  • accessLevel - Usually 'OWNER'
  • permalink - Link to the sheet's online page
  • createdAt - Creation time stamp
  • modifiedAt - Modification time stamp

Definition:

Usage:

constsheets=awaitsmartsheetConnector.listSheets()

Update action

Update the data in a sheet. The update object uses the format defined here. You can use the Simple Sheet object to create an updater object that will construct the rows array.

Definition:

(sheetId: number|string,rows: object[],)=>void

Usage:

awaitsmartsheetConnector.update(4583173393803140,[{id: '0000000000000000',cells: [{columnId: '0000000000000000',value: 'My Value',},],},],)

sdk action

Get the underlying SDK object.

Definition:

Usage:

constclient=awaitsmartsheetConnector.sdk()
Sours: https://github.com/reshufflehq/reshuffle-smartsheet-connector

Connectors smartsheet

.

How to Integrate Smartsheet with Jira

.

You will also be interested:

.



746 747 748 749 750