使用Rest API筛选SharePoint列表 [英] Filter SharePoint list with Rest API

问题描述

嗨

嗨
我有一个SharePoint列表，如下所示.

Hi 

I have a SharePoint list as below.


col1	col2	col3
India	Sudha	Yellow
Africa	Ajay	Green
America	Vijay	Red

col1是一个查找字段.
我想使用Rest API并以这种方式过滤col1上的列表

我尝试了"

col1 is a lookup field. 
I want to use Rest API and filter the list on a col1 in such a way that even if i give part of the string, it should search the record.

I tried "

隐藏   

Hide   Copy Code

推荐答案

请使用下面的REST URI来基于查找字段过滤值.

Please use the REST URI below to filter the values base on the lookup field.

https://sharepoint.com/sites/sitename/_api/web/lists/getbytitle('listname')/items?

select = Title， lookupfieldname/Title&

select=Title,lookupfieldname/Title&

expand = lookupfieldname&

expand=lookupfieldname&

这篇关于使用Rest API筛选SharePoint列表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！