aadhawan
Scholar

Smartsheet Add a Row Function

Jump to solution

Hello All,

 

Looking at the Smartsheet API connection, we only have:

aadhawan_0-1628179768902.png

Ability to get certain variables from Smartsheet, hoping we can add another to Add Rows. 

We are trying to use the Nintex Forms and store list data in Smartsheet for Auditing purposes. Looking at Smartsheet API 2.0 capabilities they show the ability to Add Rows: https://smartsheet-platform.github.io/api-docs/#add-rows

 

If this can be added, we will greatly appreciate the help. If not an alternative solution will help too. 

 

Thank You

Labels: (1)
0 Kudos
Reply
4 Replies
butlerj
Community Manager Community Manager
Community Manager

Re: Smartsheet Add a Row Function

Jump to solution

@_Ruben for your visibility around the Smartsheet connector. 

 

@aadhawan currently while the Smartsheet API support add a row, that capability has not yet been added to the NWC connector. As we're evaluating updates to the Smartsheet connector, would be very interested to get more information about the use case where you're capturing data via the NWC form. Are you able to share that?

0 Kudos
Reply
aadhawan
Scholar

Re: Smartsheet Add a Row Function

Jump to solution

Hello @_Ruben,

 

Thanks for your quick reply.

 

We are currently using a generic New Hire Form: 

aadhawan_0-1628527512670.png

 

To import users' data into variables which we will like to add to our Smartsheet for the record, auditing, and tracking. 

We do a lot of record-keeping in smartsheet currently, and we will like to build more features with the add-on capability for Smartsheet API - to enable us future integrations with other programs. 

 

The key ideas will be to enter the data from the variables in the Smartsheet (hoping this will be available) and then look up the row and attach the signed Adobe forms in Smartsheet (which seems possible with current options):

aadhawan_1-1628527988377.png

For the Smartsheet, this is how it will look like:

aadhawan_3-1628528115624.png

Thank you, and let me know if this is good, or would you like another example.

0 Kudos
Reply
bsikes
Scholar

Re: Smartsheet Add a Row Function

Jump to solution

We would also find more functionality in the Smartsheet connector helpful. 

 

At the moment, here's what we're doing to add a new row:

  1. Get Sheets action, then find the sheet ID of the desired sheet from what's returned.
  2. Using a Web Request action with the GetSheet API and the sheet ID to get the data for the actual sheet.
  3. Query JSON action to create a collection of Column IDs and Column Names
  4. Loop through a collection of NWC variables that should be in the new row doing the following to form the body of the Add Row API call:
    1. Match the variable name with the column name to identify the column ID.
    2. Format and Add the NWC variable value and the column ID to a String variable representing the body of the Add Row request. 
  5. Do some final formatting of the variable to ensure it's formatted as Smartsheet expects.
  6. Use a Web Request actions with the AddRow API and formatted string variable to add the row.

I've got this in it's own Component Workflow so that it can be used in multiple workflows... would be much easier if there was a connector action to do it! 

0 Kudos
Reply
_Ruben
Nintex Employee
Nintex Employee

Re: Smartsheet Add a Row Function

Jump to solution

Thanks for the feedback about the SmartSheet connector.

 

As @butlerj indicated, we're evaluating this at the moment and 'Add Row' is high on the list. At the moment we're at a stage where we're technically evaluating this as there are some technical items to consider on our side.

Once we know more, we'll post an update here.

View solution in original post

0 Kudos
Reply