Hello,
I’m using the Smartsheet connector and I’m trying to find a specific sheet in my account.
I’m struggling with what to put in the “Where” field.
The sheet I care about is named “Scorecard”. I’m able to use the activity as you see it to get a list of all of the sheets and then loop through it until I find the sheet I need, but it seems like I should be able to filter the results before I get them through the Where field.
The tooltip seems to contradict itself by stating the “Where clause without the WHERE keyword”, but then it goes on to show the WHERE keyword in the example.
I have tried the following to no avail:
“Name=Scorecard”
I even asked ChatGPT for a CEQL statement and I tried
“Name equals ““Scorecard”””
Thanks in advance!
Anil_G
October 21, 2023, 5:16am
2
Hi @Anil_G
Thank you so much for the link! I did read the content at that link but sadly it doesn’t get me closer to a solution.
I’m struggling with the syntax of what a valid CEQL query should look like and there are no examples in that document.
I’ll refer to Google, but would appreciate examples in UiPath if anyone has some to share.
Anil_G
October 23, 2023, 2:31pm
4
Thank you so much for your willingness to help! This is one of the great things about the UiPath community!
Using that CEQL statement didn’t throw an error, so that’s a positive, but it returned an unfiltered list of results.
Anil_G
October 23, 2023, 3:10pm
6
@kevin.scott
Just to make sure can you see if the sheet scorecard is present
Also …is name a valid identifier?
Open the list of sheets and check the key
Cheers
It’s definitely present because if I loop through that list of files I do find “Scorecard” eventually.
Here’s what the identifiers are:
Sheets { AccessLevel=“ADMIN”, AdditionalProperties=Dictionary<string, object>(0) { }, Attachments=null, Columns=null, CreatedAt=[08/04/2021 22:37:05 +00:00], CrossSheetReferences=null, DependenciesEnabled=null, Discussions=null, EffectiveAttachmentOptions=null, Favorite=null, FromId=null, GanttEnabled=null, HasSummaryFields=null, Id=REDACTED BY KEVIN, ModifiedAt=[08/04/2021 22:39:29 +00:00], Name=“REDACTED BY KEVIN”, Owner=null, OwnerId=null, Permalink=“REDACTED BY KEVIN”, ProjectSettings=null, ReadOnly=null, ResourceManagementEnabled=null, Rows=null, ShowParentRowsForFilters=null, Source=null, Summary=null, TotalRowCount=null, UserPermissions=null, UserSettings=null, Version=null, Workspace=null },
Anil_G
October 24, 2023, 5:02am
8
@kevin.scott
To check can you use "Name = 'REDACTED BY KEVIN'" and see if it works
Cheers
It wouldn’t be of any diagnostic value.
I changed those fields before posting the data because I didn’t want to broadcast the file name, ID, or permalink to the internet.
Anil_G
October 24, 2023, 12:51pm
10
@kevin.scott
The filters works on those keys only…so in which ever key you have the required value …only that works
The other way would be after retreiving all data to use a filter query
Cheers
I’ll just download them all and loop through them. It takes longer than it should but it works.
I appreciate your attempt to help!
Anil_G
October 24, 2023, 6:12pm
12
@kevin.scott
Instead of looping you can wuery like this
Listsheets.Where(function(x) x.Name.Equals("Nameyouneed")).ToList
Cheers
Woop! That worked great for me!
I put what you wrote into an assign activity to an array variable and then fed that array into my already written loop, which of course looped just once.
Cheers!
1 Like
system
October 27, 2023, 8:06pm
14
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.
