Smartsheet connection load bot ability to get single row

[TCMMatthiasFankhauser]

The current implementation of the smartsheet connection load bot is simply returning the entire sheet.

For our usecase with Amazon ATS, we hould be able to query for a single row in the smartsheet. This would allow us to more easily load all corresponding salesforce data & sync without the risk of interfering with unrelated rows just because they are also loaded.

The smartsheet docs ( https://smartsheet.redoc.ly/#section/API-Basics/Formatting ) lists a GET command that looks like its able to handle a rowid param ( *GET sheets/{sheetId}/rows/{rowId} *)

But i could not get it to work on the fly. Is it possible to get a variation on the smartsheet connector bot that would work for a single row only?

Currently our workaround is to load all rows in the Sheet and discarding all but one. Not ideal from a scalability point of view. And as mentioned, having more than one smartsheet row loaded in this case can contribute to faulty syncs.

┆Issue is synchronized with this Clickup task by Unito

[zachelrath]

I added this feature here in this PR: ues-io/integrations#32

[TCMMatthiasFankhauser]

@zachelrath tested it with the help of @abelcloudmasters . Works well