Is it possible to update a shared with sheet, by the shared with user via the APIs?

I'm updating sheets via the API, I have a sheet that was shared with me, where I have admin level access. Doing a SheetResources.UpdateSheet(sheetObject) returns an unauthorized error on the shared with sheet. Only the sheets that I own seem to be updatable via the API, any sheets that were shared with me, I am not authorize to update. Is there a way I can use the API to update sheets that was shared with a user, by that user and not necessarily the owner.

Thanks for your help with this.

Best Answer

Answers

  • Genevieve P.
    Genevieve P. Employee Admin

    Hey @sbryon

    The ability to make changes to a Smartsheet item will depend on your permission levels and the action that you're looking to take.

    Can you clarify what you're looking to update with Update Sheet? Are you changing the Project Settings or User Settings? Is it possible that Update Rows is the action you're looking for? See:

    One way to test this is to see if you can take that action within the UI directly. If you're unable to make that change in the UI, you won't be able to make that change with the API, either.

    Cheers,

    Genevieve

  • sbryon
    sbryon ✭✭

    Thank you Genevieve. My code was attempting to change the Sheet name, which works as long as it is not a shared sheet. You are right, this is the same in the UI, I am not able to update the name of the sheet even with Admin level access to that Sheet. Thank you for the info.

  • Genevieve P.
    Genevieve P. Employee Admin
    Answer ✓

    @sbryon

    Thanks for confirming! Yes you're correct, only the owner of a sheet can rename it, unless the Admin has been shared to the entire workspace where the sheet resides.

    This chart has more information on permission levels and actions you can take:

    Cheers,

    Genevieve