Remove/Delete existing hyperlink using API

GarrettSever

Per the problem outlined in the below community post, it appears the API is unable to remove existing hyperlinks from cells. It is possible to add or update hyperlinks, but not delete/remove them.

Please add the ability to either completely clear cells (including hyperlinks) or remove just existing hyperlinks using the API. If this capability already exists, please update the online documentation to clearly demonstrate how to clear hyperlinks - my efforts (outlined in the community post) were all unsuccessful in accomplishing this task.

Delete/Remove/Clear Hyperlink using API

GarrettSever

May 6, 2024

While there are a wealth of articles, discussions, and examples of adding and updating hyperlinks in cells using the Smartsheet API, I struggled to find any concrete guidance on how to remove a hyperlink or clear a cell that contains one via the API. I need the equivalent of going into the sheet, hitting "Delete" in the cell, and then saving, but this does not seem possible via the API.

I have tried:

• Passing both empty strings and Null values to the cell's "value" and "displayValue" fields.
• Passing a "hyperlink" property value of Null as well as a "blank" hyperlink
• Passing a "hyperlink" object with an empty string and Null value for the "url"
• Passing a "hyperlink" object with a 0 and Null value for a "sightId"
• Various combinations of the above.

Some of these return "Success," but the hyperlink remains, and some throw various 11## errors stating the hyperlink url, sheetId, or reportId values must be specified.

I'm perplexed by the apparent lack of a method in the API to remove or delete a hyperlink. If my approaches are incorrect, I'm eager to learn what specific values I need to pass through the API for the hyperlinks to be removed. Could someone shed some light on this?

---

View Post