Error 5262: "Unable to create the requested cell link(s). The source data is no longer accessible."

tkaczoro

Hi,

I'm getting this error message when attempting to create a link from a cell in another sheet (through creating a cell, a row, and then update_rows method). Has anyone seen this error? I'm reading a discussion on another thread that this error is related to some issue with profile data (?), but I can create this link manually, i.e. with Smartsheet interface...

Many thanks in advance for any help!

Tomasz

Genevieve P.

Hi @tkaczoro

If you're able to take the action in the UI, you should be able to take that action using the API, you're correct.

Is it possible that the row you're referencing to update no longer exists? (e.g. the row ID is incorrect). Can you confirm the SDK version that you're using?

This may be best to troubleshoot with Support directly so you can share private information (such as screen captures and code examples).

Cheers,

Genevieve

tkaczoro

Hi @Genevieve P. ,

Thank you for responding. No, it is not possible that the rows referenced (from both sheet A and sheet B) do not exist. I can print to console contents of those rows during execution of the code. Python SDK version is 2.177.1.

I reached out to Support yesterday, currently awaiting their response...

Best regards,

Tomasz

Genevieve P.

Hi @tkaczoro

Thanks for clarifying! Would you be able to test using the current Python SDK version 3.0.0 to see if this resolves the error?

Cheers,

Genevieve

tkaczoro

Hi @Genevieve P.,

I tested using the current  Python SDK version 3.0.0 and unfortunately it did not resolve the problem.

Here is the essential part of the code , maybe it can help in troubleshooting:

row = Row()
row._id_ = Number(sheetA_row_id)
cells = TypedList(Cell)
cell = Cell()
explicitnull = ExplicitNull()
cell._value = explicitnull
cell._column_id = Number(A_column_id)
celllink = CellLink()
celllink._column_id = Number(B_column_id)
celllink._row_id = Number(sheetB_row_id)
celllink._sheet_id = Number(sheetB_id)
_celllink = TypedObject(CellLink)
_celllink.value = celllink
cell._link_in_from_cell = _celllink
cells.insert(0, cell)
row._cells = cells

row_update = smartsheet.sheets.Sheets.update_rows(sheets, sheetA_id, row)

Thank you,

Tomasz

Genevieve P.

Hi @tkaczoro

Thanks for testing! Can you clarify a little more in regards to the sheet you're updating?

What is the column type that you're adding the cell-link into, and are you the owner of both sheets?

Are you able to use the same code (but on a different sheet) successfully?

Are you using Project Settings on this sheet at all?

It would be helpful to see a screen capture of your sheet; I'd like to recreate your set-up.

Thanks!

Genevieve

tkaczoro

Hi @Genevieve P.,

Please see attached screenshots of the sheets. Also, here is the full code (I re-wrote it for clarity and to align with popular style/format):

import smartsheet.sheets
from smartsheet.models import Row, Cell, CellLink, ExplicitNull

smart = smartsheet.Smartsheet(access_token='xxxxxxxxxxxxxxxxxxxxxxxxxxxx')
sheets = smartsheet.sheets.Sheets(smart)

sheetA_id = 4349218560206724
sheetA_row_id = 1839828046440324
sheetA_column_id = 7140800557016964

sheetB_id = 412818613790596
sheetB_row_id = 3312344608925572
sheetB_column_id = 360134934849412

row = Row()
row.id = sheetA_row_id
cell = Cell()
cell.value = ExplicitNull()
cell.column_id = sheetA_column_id
celllink = CellLink()
celllink.column_id = sheetB_column_id
celllink.row_id = sheetB_row_id
celllink.sheet_id = sheetB_id
cell.link_in_from_cell = celllink
row.cells.append(cell)

row_update = smartsheet.sheets.Sheets.update_rows(sheets, sheetA_id, row)

I'm currently the owner of both sheets. The columns are Text/Number type (I also tested Date columns), the cells that are to be linked are selected in the screenshots.

I have not tried the code on completely different sheets, but I also tried admin(sheetA)/owner(sheetB) and when both sheets are in the same workspace.

I have not tried changing anything in Project Settings. Is there anything to try there?

Thank you!

sheetA.png

sheetB.png

Genevieve P.

Hi @tkaczoro

This is all really helpful information - I can't replicate the error you're getting. The Project Settings question would be in relation to what column you're putting the link into, but from your images I can see you're using the Comments column, which should be fine.

The last thing to test is to use two completely new, different sheets (changing the Sheet Ids, the Column Ids, and the Row Ids). This will determine if it's an issue with theses two specific sheets or with the API.

If performing this action works fine on new sheets, please follow-up with Support letting them know of your tests along with the two sheet IDs of the ones that aren't working for you.

I hope you have a good weekend!

Genevieve

tkaczoro

Hi @Genevieve P. ,

Great suggestion. I made this test - created two new sheets A and B and attempted to link some cells with my code. It worked!

So it looks like the problem is specific to my sheets I'm trying to link. I will let Support know about this finding.

Thank you very much for all your help! Wish you a nice weekend too!

Tomasz

Genevieve P.

I'm glad you were able to get it working on new sheets! Thanks for following up. 🙂

tkaczoro

Hi @Genevieve P.,

After a long time testing different scenarios I was finally able to find the root cause. It was a typo in my code that gave row id of sheet A when it was supposed to be the value from sheet B.

Thank you very much for your help with this. I will make sure next time to check the code multiple times before posting the issue.

Best regards,

Tomasz

Genevieve P.

Hi @tkaczoro

I'm so glad to hear that you were able to identify the issue and get this working again!