Forum Discussion
Wei-Painter
Nov 23, 2023Copper Contributor
Regarding the $filter/ $search query parameter
Hi Experts,
I try to use the Graph API to extract some information or documentations from my Document Library in SharePoint Online, for instance:
GET https://graph.microsoft.com/v1.0/sites/{site-id}/drive/root/children?$filter=name eq 'AS-BUILT' > Works well - no problem
My question is:
- How should I define my filter parameters for searching the <lastModifiedBy: user: id>, because I hope there are two parameters will be leveraged in the Graph API, one is name eq 'AS-BUILT' another is <lastModifiedBy: user: id> eq 0022808b-....*** <lastModifiedBy: user: id>: Please refer to the following image ***
- Another question is when I have more than 2 Columns/ Fields (Such as: Name and ID) as a search conditions, Which one is better for this situations between $filter and $search. My totally amount of documentations is more or less 800,000
Thanks
Here is my JSON file about a documentation.
"lastModifiedBy": {
"user": {
"email": "email address removed for privacy reasons",
"id": "0022808b-1582-4c71-b423-b8cf712416df",
"displayName": "Wei-OOOOOO"
}
No RepliesBe the first to reply