Formatting error on OData query

Help Studio
, , , ,
1

Good morning UiPath Forum,

I am having a problem with an OData filter. I am simply trying to query the ID on a SharePoint list and return the one list item with that ID number. I have tried all of the following but continue to get the error shown in the image. I’d greatly appreciate your assistance on formatting the OData query properly. Many thanks,

“ID=‘21’”
“ID=21”
“fields/ID=‘21’”
“fields/ID=21”

This image is a screenshot of a debugging session in UiPath Studio showing an error in a workflow for updating a SharePoint list item, with details of the error and variables displayed in the panels. (Captioned by AI)
This image is a screenshot of a debugging session in UiPath Studio showing an error in a workflow for updating a SharePoint list item, with details of the error and variables displayed in the panels. (Captioned by AI)1035×655 80.1 KB

2

Hi @jamiejam
i think the id should be numeric value so if this assumption is correct you need to avoid adding single or double quotes around numeric values for ID

Update your filter expression in the For Each List Item activity to:

ID eq 21

If fields/ is required (depending on your SharePoint list structure):

fields/ID eq 21

if above not working please make sure that the ID field exists and matches your SharePoint list’s schema. please try and update us if you still face issue :slight_smile:

3

Thanks VERY much @mahmoud.zaky . “fields/ID eq 21” worked.