How to retrieve all Conversation comments for a row through ODBC?

cbsarge

Hello. I am writing reports in SQL Server Report Server. I have successfully added one of our Smartsheet sheets as an ODBC data source and am able to retrieve all rows and columns. I'm trying to use a lookup or lookupset to retrieve all the entries for a Conversation of a row so that it can be displayed as "Help" text when hovering over one of the items in the SSRS report. This works except it's only showing the latest comment. I was hoping to use a custom Function for LookupSet to grab the entire Comments for the row. I'm not sure what to provide here to help describe this in more detail but, am willing to given some guidance.

Gia Thinh

Hi cbsarge,

Just a reminder in case you missed it: you can add the query parameter include=comments to retrieve all discussions and comments associated with a row, as shown in the screenshot below.

cbsarge

Thanks Gia but how would this be applied to use of the Smartsheet Live Data Connector?