admin管理员组文章数量:1023794
I have a list that is a parent folder (Folder_A). It has multiple subfolders as list items. I'm interested in retrieving documents inside a specific subfolder (Folder_B) based on the value of a certain custom column.
When I use the query sites/<site_id>/lists/<list_id>/items?$expand=fields&$filter=fields/Sent eq null, it gives me results from all the subfolders (as expected). In addition to this filter, I tried adding a parentReference/Id eq 'xxxxxxx' filter to try to get items that have Folder_B as parent, but that query returns a "General exception while processing" error.
Am I missing something, or is there any other option?
I have a list that is a parent folder (Folder_A). It has multiple subfolders as list items. I'm interested in retrieving documents inside a specific subfolder (Folder_B) based on the value of a certain custom column.
When I use the query sites/<site_id>/lists/<list_id>/items?$expand=fields&$filter=fields/Sent eq null, it gives me results from all the subfolders (as expected). In addition to this filter, I tried adding a parentReference/Id eq 'xxxxxxx' filter to try to get items that have Folder_B as parent, but that query returns a "General exception while processing" error.
Am I missing something, or is there any other option?
Share Improve this question edited Nov 19, 2024 at 2:53 Anirudh Sundaram asked Nov 19, 2024 at 2:51 Anirudh SundaramAnirudh Sundaram 12 bronze badges 1 |1 Answer
Reset to default 0Currently there is no such api to filter by subfolder. You could get the items by id of subfolder.
GET https://graph.microsoft/v1.0/groups/{group-id}/drive/items/{next-item-id}/children
I have a list that is a parent folder (Folder_A). It has multiple subfolders as list items. I'm interested in retrieving documents inside a specific subfolder (Folder_B) based on the value of a certain custom column.
When I use the query sites/<site_id>/lists/<list_id>/items?$expand=fields&$filter=fields/Sent eq null, it gives me results from all the subfolders (as expected). In addition to this filter, I tried adding a parentReference/Id eq 'xxxxxxx' filter to try to get items that have Folder_B as parent, but that query returns a "General exception while processing" error.
Am I missing something, or is there any other option?
I have a list that is a parent folder (Folder_A). It has multiple subfolders as list items. I'm interested in retrieving documents inside a specific subfolder (Folder_B) based on the value of a certain custom column.
When I use the query sites/<site_id>/lists/<list_id>/items?$expand=fields&$filter=fields/Sent eq null, it gives me results from all the subfolders (as expected). In addition to this filter, I tried adding a parentReference/Id eq 'xxxxxxx' filter to try to get items that have Folder_B as parent, but that query returns a "General exception while processing" error.
Am I missing something, or is there any other option?
Share Improve this question edited Nov 19, 2024 at 2:53 Anirudh Sundaram asked Nov 19, 2024 at 2:51 Anirudh SundaramAnirudh Sundaram 12 bronze badges 1-
I found a way to search inside a specific folder -
sites/<site_id>/drives/b!<drive_id>/items/<folder_b_id>/search(q=''), but I can't figure out how to generate a query string for a custom column. – Anirudh Sundaram Commented Nov 19, 2024 at 16:35
1 Answer
Reset to default 0Currently there is no such api to filter by subfolder. You could get the items by id of subfolder.
GET https://graph.microsoft/v1.0/groups/{group-id}/drive/items/{next-item-id}/children
本文标签： sharepoint onlineGraph APIList Itemfilter criteria to filter by subfolderStack Overflow
版权声明：本文标题：sharepoint online - Graph API - List Item - $filter criteria to filter by subfolder - Stack Overflow 内容由热心网友自发贡献，该文观点仅代表作者本人， 转载请联系作者并注明出处：http://it.en369.cn/questions/1745585214a2157549.html， 本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌抄袭侵权/违法违规的内容，一经查实，本站将立刻删除。
sites/<site_id>/drives/b!<drive_id>/items/<folder_b_id>/search(q=''), but I can't figure out how to generate a query string for a custom column. – Anirudh Sundaram Commented Nov 19, 2024 at 16:35