Share via

Invalid filter clause: Could not find a property named 'field_2' on type 'microsoft.graph.listItem

TI TECNOLOGIA 20 Reputation points
2024-05-10T22:56:05.59+00:00

Hi, please help me with a problem. When i make a request like this, a error just prompting. Sorry for my english.

https://graph.microsoft.com/v1.0/sites/sepromotora844.sharepoint.com,70128961-2076-497d-92ed-1b680168b245,bba80bdc-568e-45a9-aa23-b0f32111a538/lists/fc3a7a4a-75c6-4411-ad89-a010beee2fc9/items?$expand=fields&$filter=field_2 eq 'city'

User's image or 

https://graph.microsoft.com/v1.0/sites/sepromotora844.sharepoint.com,70128961-2076-497d-92ed-1b680168b245,bba80bdc-568e-45a9-aa23-b0f32111a538/lists/fc3a7a4a-75c6-4411-ad89-a010beee2fc9/items?$expand=fields&$filter=fields/field_2 eq 'city'

User's image

I need get this information

User's image

Source 

{
    "@odata.context": "https://graph.microsoft.com/v1.0/$metadata#sites('.sharepoint.com%2C70128961-2076-497d-92ed-1b680168b245%2')/lists('fc3a7a4a-75c6-4411-ad89-a010beee2fc9')/items(fields())",
    "@microsoft.graph.tips": "Use $select to choose only the properties your app needs, as this can lead to performance improvements. For example: GET sites('<key>')/lists('<guid>')/items?$select=contentType,sharepointIds",
    "value": [
        {
            "@odata.etag": "\"b5fcda92-d48b-4263-ab5b-2cbe8a270241,2\"",
            "createdDateTime": "2024-05-02T20:07:22Z",
            "eTag": "\"b5fcda92-d48b-4263-ab5b-2cbe8a270241,2\"",
            "id": "1",
            "lastModifiedDateTime": "2024-05-10T22:34:18Z",
            "webUrl": "https://.sharepoint.com/Lists/USUSARIOS_SISTEMAS/1_.000",
            "createdBy": {
                "user": {
                    "email": "",
                    "id": "81a3209d-1f01-4713-852b-e72b9b0bbed8",
                    "displayName": "TI TECNOLOGIA"
                }
            },
            "lastModifiedBy": {
                "application": {
                    "id": "ab9b8c07-8f02-4f72-87fa-80105867a763",
                    "displayName": "OneDrive SyncEngine"
                },
                "user": {
                    "email": "ti@.onmicrosoft.com",
                    "id": "81a3209d-1f01-4713-852b-e72b9b0bbed8",
                    "displayName": "TI TECNOLOGIA"
                }
            },
            "parentReference": {
                "id": "1015fcc6-008e-4d14-86bb-46844841e5ea",
                "siteId": ".sharepoint.com,70128961-2076-497d-92ed-1b680168b245,538"
            },
            "contentType": {
                "id": "0x0100F5E630E73181E84D884EA147F281A463009B493E0A25F89340916E4760EEEE5B71",
                "name": "Item"
            },
            "fields@odata.context": "https://graph.microsoft.com/v1.0/$metadata#sites('.sharepoint.com%2C70128961-2076-497d-92ed-1b680168b245%2Cbba80bdc-568e-4')/lists('fc3a7a4a-75c6-4411-ad89-a010beee2fc9')/items('1')/fields/$entity",
            "fields": {
                "@odata.etag": "\"b5fcda92-d48b-4263-ab5b-2cbe8a270241,2\"",
                "Title": "COMUNICAÇÕES LTDA - ME",
                "field_1": "7474747474",
                "field_2": "city",
                "field_3": "person 1",
                "field_4": "00000001",
                "field_5": "8585855",
                "field_6": "fhfjff",
                "field_7": 44444444444444,
                "field_8": "1900-01-14T08:00:00Z",
                "field_9": 31,
                "field_10": "1900-01-27T08:00:00Z",
                "field_11": -8,
                "field_12": "1900-01-29T08:00:00Z",
                "field_13": 12,
                "field_14": "SUB",
                "field_15": "aaaaaaaaaaaaa",
                "field_16": "09999",
                "field_18": "449t9595",
                "LinkTitle": "COMUNICAÇÕES LTDA - ME",
                "id": "1",
                "ContentType": "Item",
                "Modified": "2024-05-10T22:34:18Z",
                "Created": "2024-05-02T20:07:22Z",
                "AuthorLookupId": "10",
                "EditorLookupId": "10",
                "_UIVersionString": "2.0",
                "Attachments": false,
                "Edit": "",
                "LinkTitleNoMenu": "COMUNICAÇÕES LTDA - ME",
                "ItemChildCount": "0",
                "FolderChildCount": "0",
                "_ComplianceFlags": "",
                "_ComplianceTag": "",
                "_ComplianceTagWrittenTime": "",
                "_ComplianceTagUserId": "",
                "AppAuthorLookupId": "20",
                "AppEditorLookupId": "20"
            }
        },
        {
            "@odata.etag": "\"e4d4eee6-3a34-425c-883a-3858fe90f17a,1\"",
            "createdDateTime": "2024-05-09T22:45:20Z",
            "eTag": "\"e4d4eee6-3a34-425c-883a-3858fe90f17a,1\"",
            "id": "2",
            "lastModifiedDateTime": "2024-05-09T22:45:20Z",
            "webUrl": "https://.sharepoint.com/Lists/USUSARIOS_SISTEMAS/2_.000",
            "createdBy": {
                "user": {
                    "email": "",
                    "id": "81a3209d-1f01-4713-852b-e72b9b0bbed8",
                    "displayName": "TI TECNOLOGIA"
                }
            },
            "lastModifiedBy": {
                "application": {
                    "id": "ab9b8c07-8f02-4f72-87fa-80105867a763",
                    "displayName": "OneDrive SyncEngine"
                },
                "user": {
                    "email": "ti@.onmicrosoft.com",
                    "id": "81a3209d-1f01-4713-852b-e72b9b0bbed8",
                    "displayName": "TI TECNOLOGIA"
                }
            },
            "parentReference": {
                "id": "1015fcc6-008e-4d14-86bb-46844841e5ea",
                "siteId": ".sharepoint.com,70128961-2076-497d-92ed-1b680168b245,bba80bdc-568e-45a9-aa23-b0f32111a538"
            },
            "contentType": {
                "id": "0x0100F5E630E73181E84D884EA147F281A463009B493E0A25F89340916E4760EEEE5B71",
                "name": "Item"
            },
            "fields@odata.context": "https://graph.microsoft.com/v1.0/$metadata#sites('.sharepoint.com%2C70128961-2076-497d-92ed-1b680168b245%2Cbba80bdc-568e-45a9-aa23-b0f32111a538')/lists('fc3a7a4a-75c6-4411-ad89-a010beee2fc9')/items('2')/fields/$entity",
            "fields": {
                "@odata.etag": "\"e4d4eee6-3a34-425c-883a-3858fe90f17a,1\"",
                "Title": "ghghghg",
                "field_1": "hghghgh",
                "field_2": "hghgh",
                "field_3": "hghg",
                "field_4": "hghgh",
                "field_5": "hghgh",
                "field_7": 0,
                "field_9": 0,
                "field_11": 0,
                "field_13": 0,
                "LinkTitle": "ghghghg",
                "id": "2",
                "ContentType": "Item",
                "Modified": "2024-05-09T22:45:20Z",
                "Created": "2024-05-09T22:45:20Z",
                "AuthorLookupId": "10",
                "EditorLookupId": "10",
                "_UIVersionString": "1.0",
                "Attachments": false,
                "Edit": "",
                "LinkTitleNoMenu": "ghghghg",
                "ItemChildCount": "0",
                "FolderChildCount": "0",
                "_ComplianceFlags": "",
                "_ComplianceTag": "",
                "_ComplianceTagWrittenTime": "",
                "_ComplianceTagUserId": "",
                "AppAuthorLookupId": "20",
                "AppEditorLookupId": "20"
            }
        }
    ]
}
Microsoft 365
Microsoft 365
Formerly Office 365, is a line of subscription services offered by Microsoft which adds to and includes the Microsoft Office product line.
3,959 questions
Microsoft Graph
Microsoft Graph
A Microsoft programmability model that exposes REST APIs and client libraries to access data on Microsoft 365 services.
10,874 questions
Accepted answer
  1. awijekoon 1,260 Reputation points Microsoft Vendor
    2024-05-12T17:03:59.5333333+00:00

    Hi @TI TECNOLOGIA Change the filter query like this $filter=fields/field_2 eq 'city' and it will return the relevant field. Also use the header 'prefer' with value 'HonorNonIndexedQueriesWarningMayFailRandomly'

    
prefer : HonorNonIndexedQueriesWarningMayFailRandomly 

https://graph.microsoft.com/v1.0/sites/sepromotora844.sharepoint.com,70128961-2076-497d-92ed-1b680168b245,bba80bdc-568e-45a9-aa23-b0f32111a538/lists/fc3a7a4a-75c6-4411-ad89-a010beee2fc9/items?$expand=fields&$filter=fields/field_2 eq 'city'

    User's image

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

    1 person found this answer helpful.

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest