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

Question

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

Anonymous

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

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=contains(fields/Title,'Auto')

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 40,496 Reputation points Microsoft External Staff

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

Your answer

RaytheonXie_MSFT 40,496 Reputation points Microsoft External Staff

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

Answer 1

RaytheonXie_MSFT 40,496 Microsoft External Staff

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.

Anonymous

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)
Anonymous

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

Want to search result any keyword used in Title
RaytheonXie_MSFT 40,496 Reputation points Microsoft External Staff

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

Anonymous

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

Anonymous

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

@RaytheonXie_MSFT

Please have a look on my comment.

Please Respond.
RaytheonXie_MSFT 40,496 Reputation points Microsoft External Staff

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
RaytheonXie_MSFT 40,496 Reputation points Microsoft External Staff

2024-05-29T09:28:18.4666667+00:00

Hi @Pradhaan, Surrya

Would you tell me whether your issue has been resolved or have any update? If you have any questions or progress, you can contact me in time.

Share via

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

1 answer

Your answer