API PUT and Body help for Cell link from a cell in sheet "a" to sheet "b"

Carlo Rodriguez

I am having trouble linking a cell from sheet a to b.

I am new to using API and possibly just getting the call wrong? or the body. Any help would be appreciated.

PUT: https://api.smartsheet.com/2.0/sheets/4098048888098692/rows/1370574824361860/cells/259016080

Body:

{

  "cells": [

    {

      "linkinFromCell": {

          "columnId": "7321839030194052",

          "rowId": "2229989274242948",

          "sheetId": "7094494025437060"

      }

    }

  ]

}

Error:

{

    "errorCode": 1006,

    "message": "Not Found",

    "refId": "3uq62l"

}

Genevieve P.

Hey @Carlo Rodriguez

This is how I've successfully added a cell-link using the API:

PUT (with the destination sheet data):

https://api.smartsheet.com/2.0/sheets/XXXX/rows/XXXX

Body (with the source sheet data, but the initial ColumnID from the destination sheet to show where to put the link):

{
  "cells": [
    {
      "columnId": 11111,
            "value": null,
            "linkInFromCell": {
                "sheetId": 22222,
                "rowId": 33333,
                "columnId": 44444
            }
    }
     ]
}

Let me know if this works for you!

Cheers,

Genevieve

Genevieve P.

Hey @Carlo Rodriguez

This is how I've successfully added a cell-link using the API:

PUT (with the destination sheet data):

https://api.smartsheet.com/2.0/sheets/XXXX/rows/XXXX

Body (with the source sheet data, but the initial ColumnID from the destination sheet to show where to put the link):

{
  "cells": [
    {
      "columnId": 11111,
            "value": null,
            "linkInFromCell": {
                "sheetId": 22222,
                "rowId": 33333,
                "columnId": 44444
            }
    }
     ]
}

Let me know if this works for you!

Cheers,

Genevieve

Carlo Rodriguez

Thanks! I finally figured it out after going through the documentation again and again :)

My PUT request was missing the row ID and i didn't need the column ID.