Need the hyperlink column to be included in the Smartsheet API response.

Kiran Rathod

Need Smartsheet technical expert suggestion or approach to retrieve hyperlink from Smartsheet API

1. The recommended approach to retrieve hyperlink data structure from columns via the API
2. Any specific column type configurations or API parameters that might be required
3. Best practices for handling hyperlink data in API responses

Requirement:  Requires the 'Program Name' column data to be retrieved as hyperlink objects through the Smartsheet API. Currently, we are receiving this data as text format in our API responses

API Parameter tried:

1. Implemented the include=hyperlinks parameter in our API queries
2. Tested with GET /sheets/{sheetId}/rows?include=hyperlinks
3. Tried to update the project name column as hyperlink through postman

Documentation :- We are refereeing the documentation available on google

Smartsheet API introduction

After using above options, our API calls are functioning correctly and returning data, we are receiving the column information as text format rather than the structured hyperlink objects that would allow us to access both display text and URL components separately.

Current Response :-

Expected Response :-

jmyzk_cloudsmart_jp

Hi @Kiran Rathod

I'm not sure what you meant by 'hyperlink column', but your expected response looks like a cell object.

If so, for example, if you want to get the hyperlink of the cell at the first row on the 'Program name' column, you just have to use the 'Get Sheet' method.

https://app.smartsheet.com/b/publish?EQBCT=5e252645df4248d5928a14527de9f577

The following uses the Smartsheet Python SDK, but as you can see, the get_sheet method has no particular parameters.

Your 'Current Response' does not appear to include a hyperlink, so nothing is displayed in the response.