Smartsheet 'Get Sheet' activity can't handle any 'Rows modified since' value

Feedback Activities
, ,
1

Hello,

We need to use ‘Rows modified since’ property for Smartsheet ‘Get Sheet’ activity but it doesn’t allow any value.

It fails using a DateTimeOffset variable
image

image
image843×104 9.44 KB

If fails using a date selected with the activity date picker
image

Same error for both cases

The image shows an error message indicating that the request to get a sheet has failed due to an invalid date value for the parameter 'rowsModifiedSince'. (Captioned by AI)
The image shows an error message indicating that the request to get a sheet has failed due to an invalid date value for the parameter 'rowsModifiedSince'. (Captioned by AI)762×218 6.1 KB

Documentation says it accepts DateTimeOffset or using the calendar widget to select a date.

UiPath.IntegrationService.Activitis 1.8.0
Studio 2023.10.4
Smartsheet activity Runtime (Available) version

2

Hi, @Juan_Felipe_Carvajal

Give date format like that,

FilterDate.ToString("yyyy-MM-ddTHH:mm:ssZ")

I hope it will be help to you. :slight_smile:

3

Hello @Kismet_Tosun

That property just accepts DateTimeOffset type as input.

The image shows an error message indicating that a string value cannot be implicitly converted to a 'DateTimeOffset' type in the 'Get Sheet' activity, where the 'FilterDate.ToString("yyyy-MM-ddTHH:mm:ssZ")' expression is being used. (Captioned by AI)
The image shows an error message indicating that a string value cannot be implicitly converted to a 'DateTimeOffset' type in the 'Get Sheet' activity, where the 'FilterDate.ToString("yyyy-MM-ddTHH:mm:ssZ")' expression is being used. (Captioned by AI)1499×260 17.3 KB

Thank you

4

Hİ, @Juan_Felipe_Carvajal

Change the Filter Date variable type by string. Give manuel date. Try it

:slight_smile:

5

Same error
The image shows an error message indicating that the value for "FilterDate" in UiPath cannot implicitly convert from 'String' to 'DateTimeOffset' due to Option Strict On. (Captioned by AI)

The activity has a bug.