How to use contains string in filter criteria in microsoft graph api?

Pradhaan, Surrya 0

I am using graph api to search product list from sharepoint.

I am able to search product using startsWith function but my requirement is to search product using any keyword which contains product name.

I am currently using below url statsWith function to search product.

https://graph.microsoft.com/v1.0/sites/{siteId}/lists/{listId}/items?select=fields&expand=fields(select=Title,Product_Description,Product_x0020_Portfolio,Product_Manager_txt)&$filter=startsWith(fields/Title,'Auto')

but i need to search product any keyword from the product name .

When i use key word contains it throws error contains key

response:

{

"error": {

"code": "itemNotFound",

"message": "Item not found",

"innerError": {

"date": "2024-05-08T20:26:09",

"request-id": "2fc2e894-9435-4320-a036-c53ab4ff4f4b",

"client-request-id": "c7892a64-3dc8-e409-8292-abbe0c38fce1"

}

Please Help me to solve my issue and fulfill my requirement

RaytheonXie_MSFT 32,081 Reputation points Microsoft Vendor

2024-05-10T01:25:54.66+00:00

Hi @Pradhaan, Surrya

I am currently doing some research on this issue, will let you know as soon as possible

1 answer

RaytheonXie_MSFT 32,081 Microsoft Vendor

Hi @Pradhaan, Surrya

Per my research, list item doesn't support contains. You could refer to following issue similar with yours

[https://learn.microsoft.com/en-us/answers/questions/1016924/graph-api-sharepoint-list-search-(contains-startsw](https://learn.microsoft.com/en-us/answers/questions/1016924/graph-api-sharepoint-list-search-(contains-startsw)

As a workaround, you could use rest api to Realize the contain function. Please refer to following api

 /_api/web/lists/getByTitle('Address')/items?$select=Title,Id,Company,City&$filter=substringof('e',Company)

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Pradhaan, Surrya 0 Reputation points

2024-05-13T11:46:30.3933333+00:00

Thanks for your response.

But i tried this it did not work for me

https://graph.microsoft.com/v1.0/sites/{siteid}/lists/{listid}/items?select=Title,Product_Description,Product_x0020_Portfolio,Product_Manager_txt&$filter=substringof('Auto',fields/Title)

response:

https://graph.microsoft.com/v1.0/sites/{siteid}/lists/{listid}/items?select=Title,Product_Description,Product_x0020_Portfolio,Product_Manager_txt&$filter=substringof('Auto',fields/Title)
Pradhaan, Surrya 0 Reputation points

2024-05-13T11:54:34.6133333+00:00

Want to search result any keyword used in Title
RaytheonXie_MSFT 32,081 Reputation points Microsoft Vendor

2024-05-14T01:15:58.2566667+00:00
Hi @Pradhaan, Surrya

The substringof should be used in rest api like following

https://xxx.sharepoint.com/sites/sitename/_api/web/lists/getByTitle('Address')/items?$select=Title,Id,Company,City&$filter=substringof('e',Company)

To use search api, you could refer to the document

https://learn.microsoft.com/en-us/graph/search-concept-files#example-2-search-list-items

Pradhaan, Surrya 0

Hi ,

My originial o/p with out filter is below format:

.......

           },
            "contentType": {
                "id": "0x010083992BFC0D6950439A2ABF6A2DE5213F",
                "name": "Item"
            },
            "fields@odata.context": "https://graph.microsoft.com/v1.0/$metadata#sites('e97d6daf-3546-47bb-afd2-e227c94f4039')/lists('b3f2523b-e56b-4113-b7c5-55ce8ba6ad4a')/items('30')/fields/$entity",
            "fields": {
                "@odata.etag": "\"cb9ba704-447c-49ab-85ae-fe344da0e1c4,84\"",
                "Business_Area": "Air IT",
                "Product_x0020_Portfolio": "Fulfillment",
                "Product_x0020_Category": "Departure Control",
                "Title": "Auto Seating / Seat Block Optimizer",
                "Taxonomy_Flag": true,
                "RD_Flag": true,
                "Product_x0020_Manager_x0020__x00LookupId": "168",
                "Product_MarketingLookupId": "3647",
                "Product_L4LookupId": "56",
                "CARE_FunctionalAreaLookupId": "123",
                "Delivery_FunctionalAreaLookupId": "140",
                "LinkTitleNoMenu": "Auto Seating / Seat Block Optimizer",
                "LinkTitle": "Auto Seating / Seat Block Optimizer",
                "Product_L4_x003a_IDLookupId": "56",
                "CARE_FunctionalArea_x003a_IDLookupId": "123",
                "Delivery_FunctionalArea_x003a_IDLookupId": "140",
                "Product_Manager_txt": "Stokes, Summer",
                "Product_Marketing_txt": "Freeman, Katie",
                "id": "30",
                "ContentType": "Item",
                "Modified": "2024-02-07T20:48:09Z",
                "Created": "2020-10-07T01:15:48Z",
                "AuthorLookupId": "14",
                "EditorLookupId": "15",
                "_UIVersionString": "1.0",
                "Attachments": false,
                "Edit": "",
                "ItemChildCount": "0",
                "FolderChildCount": "0",
                "_ComplianceFlags": "",
                "_ComplianceTag": "",
                "_ComplianceTagWrittenTime": "",
                "_ComplianceTagUserId": ""
            }
        },

my search based in  "Title": which is present inside fields{} Kindly follow above original response format.
According to you i have tried with below get method:
https://graph.microsoft.com/v1.0/sites/TSPortfolioMgmt/lists/getByFields('Title')/items?$fields(select=Title,Product_x0020_Portfolio)&$filter=substringof('Auto',fields/Title)


getting below error:


{
    "error": {
        "code": "BadRequest",
        "message": "Invalid filter clause: An unknown function with name 'substringof' was found. This may also be a function import or a key lookup on a navigation property, which is not allowed.",
        "innerError": {
            "date": "2024-05-14T10:44:05",
            "request-id": "9c7815cb-275c-48ea-9cdc-5f01f09c14a8",
            "client-request-id": "91174491-0e55-ca4d-db0c-953383a01b2b"
        }
    }
}

And also i followed the search api ref doc and i tried with

post: https://graph.microsoft.com/v1.0/search/query

{

"requests": [

{

"entityTypes": [

"listItem"

"query": {

"queryString": "seat block"

"fields": [

"Title",

"Product_Manager_txt",

"Product_Description",

"Additional_Product_Manager_txt"

]

}

]

}

o/p: i am only getting Title , not getting other fields eg "Product_Manager_txt",

"Product_Description",

"Additional_Product_Manager_txt"

these values.

json:

 {
                            "hitId": "88e3cf85-9bbf-4944-9eec-a423a4d81314",
                            "rank": 1,
                            "summary": "<ddd/><c0>Seat</c0> <c0>Blocks</c0> Adjacent <c0>Seat</c0> <c0>Blocks</c0> – Overview Sabre offers carriers the option to apply a “<ddd/><c0>block</c0> to a <c0>seat</c0> adjacent to a premium passenger. This is supported for <c0>seats</c0> requested <ddd/><c0>seat</c0><ddd/>",
                            "resource": {
                                "@odata.type": "#microsoft.graph.listItem",
                                "fields": {
                                    "title": "Adjacent Seat Blocks Overview"
                                }
                            }
                        }

Please respond .
Thank you

Pradhaan, Surrya 0 Reputation points

2024-05-16T14:00:37.4166667+00:00

@RaytheonXie_MSFT

Please have a look on my comment.

Please Respond.
RaytheonXie_MSFT 32,081 Reputation points Microsoft Vendor

2024-05-17T07:04:21.55+00:00

Hi @Pradhaan, Surrya

The rest api is not graph api. The url should be https://xxx.sharepoint.com/sites/sitename

But in your request is https://graph.microsoft.com/v1.0/sites/TSPortfolioMgmt

Share via

How to use contains string in filter criteria in microsoft graph api?

1 answer