Smartsheet API linkInFromCell

Yueying Cui

Hi,

 

I am trying to use the Smartsheet API to insert a new row which contains regular cells and 'link cells from another Smartsheet'. Currently, I can only do this in two steps:

1. create new row only with regular cells

2. add 'link cells from another Smartsheet' to this new row

 

API call: "https://api/smartsheet.com/1.1/sheet/sheetId/rows"

 

row data object: 

[{

  columnId: columnId1,

  value: null,

  linkInFromCell: {

    columnId: columnId,

    rowId: rowId,

    sheetId: sheetId,

   sheetName: sheetName

  }

},

{

  columnId: columnId2,

  value: null,

  linkInFromCell: {

    columnId: columnId,

    rowId: rowId,

    sheetId: sheetId,

    sheetName: sheetName

 }

 

}]

 

If I do them together in a single step, I always reveive this error: "The attribute(s) cell.linkInFromCell are not allowed for this operation."

 

Is there a way that I can do it in a single step? Thanks for any suggestion or idea.

 

Best,

Yueying

 

 

 

Kim Brandl

Unfortunately it's not currently possible to add cell links when POSTing a new row to a sheet.  A cell link can only be added to an existing cell -- so the two step process that you describe (1-add new row, 2-update row to add cell links to some cells) is the only way to add cell links via the API.

 

 

Brett Evans

Kim,

where would you recommend going for API tips.  GitHub, stackoverfow.  I am trying to parlay my google sheets javascript API experience to SmartSheet, but I am not sure where to start.

 

Thanks,

Brett

Yueying Cui

Thanks for replying, Kim.

Kim Brandl

@Yeuying Cui -- happy to help.

 

@Brett -- great question.  I'd recommend that you post API-related questions to Stack Overflow (using the smartsheet-api tag).  That way, you'll get answers to your questions AND others may also benefit from the information in the future.  Additionally, I'd definitely suggest that you review the API documentation and checking out the other Developer resources linked to from our Developer Portal.