使用Rest API筛选SharePoint列表
问题描述：
嗨
嗨
我有一个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&