How to add multiple rows to Smartsheet

Question

Hello,

I'm having issues trying to figure out how to add multiple rows to Smartsheet. I'm using workflows from @ivoller from this post about connecting to and pushing data into Smartsheet.  Using the "Write new Smartsheet Record" workflow, I'm successfully able to push one record into Smartsheet, but when I try to alter the inputs to have more than one row to add, it concatenates all of them into one row.

I then get error 1037 back from Smartsheet saying that I have the same column ID in the row more than once.

This won't work for me because I'm trying to push records from one database into Smartsheet using Alteryx, and there will be thousands of records passed through.

How can I form the JSON to match Smartsheet's requirements so that I can add multiple rows programmatically?

THANK YOU!

Write new Smartsheet record.yxmd

BonusCup · Answer

@rdlalli

Here's a cleaned up version of the macro.  Let me know if you have any questions with it.  You just need to add a text input like the below.

Smartsheet Input.yxzp

BonusCup · Answer

@rdlalli 
For your #2, I created a macro that provides:

* Workbook Name
* Raw data
* Row and Column IDs

The only requirements needed are the sheetId and the Bearer access token.

rdlalli · Answer

There are a couple of community posts on this topic.  I just wanted to add a couple of notes:

* You can't post or "write" to cells in a Smartsheet column if that column is using a "column formula".  You'll need to do a work-around or convert it to "cell formula".  Every column in the row will fail.  At first, I thought it would just fail on that one column, but it actually gives a Bad Response for the whole row.
* For those not having access to Postman to return Column ID values, you can convert that column to a 'dropdown select' column type, switch to card view, change the view to the column you just edited, and grab the Column ID from the end of the URL.