Explain Simply

Understanding SharePoint JSON Response Structure

This guide provides a comprehensive breakdown of a JSON response from SharePoint APIs, detailing key components such as metadata, results arrays, and user information, crucial for developers and data scientists working with SharePoint data.


Empty image or helper icon

Prompt

{
    "d": {
        "results": [
            {
                "__metadata": {
                    "id": "b080203d-5882-459c-98f2-9cf26e32d353",
                    "uri": "https://bostonscientificeur.sharepoint.com/sites/RegulatoryAffairs-VoiceoftheCustomer/_api/Web/Lists(guid'1cd980a0-1195-48d0-9cd1-9f96f58e2a44')/Items(1)",
                    "etag": "\"13\"",
                    "type": "SP.Data.TestListItem"
                },
                "Development": {
                    "__deferred": {
                        "uri": "https://bostonscientificeur.sharepoint.com/sites/RegulatoryAffairs-VoiceoftheCustomer/_api/Web/Lists(guid'1cd980a0-1195-48d0-9cd1-9f96f58e2a44')/Items(1)/Development"
                    }
                }
            },
            {
                "__metadata": {
                    "id": "84820a8b-9b98-4d61-ba86-195d77a809ee",
                    "uri": "https://bostonscientificeur.sharepoint.com/sites/RegulatoryAffairs-VoiceoftheCustomer/_api/Web/Lists(guid'1cd980a0-1195-48d0-9cd1-9f96f58e2a44')/Items(2)",
                    "etag": "\"7\"",
                    "type": "SP.Data.TestListItem"
                },
                "Development": {
                    "results": [
                        {
                            "__metadata": {
                                "id": "862bf3cf-8fe0-4dd2-9afe-5dd06dd14629",
                                "type": "SP.Data.UserInfoItem"
                            },
                            "Title": "Buduru, Alexandru"
                        }
                    ]
                }
            },
            {
                "__metadata": {
                    "id": "37902a19-5a1e-4866-93ce-41fadde09eaa",
                    "uri": "https://bostonscientificeur.sharepoint.com/sites/RegulatoryAffairs-VoiceoftheCustomer/_api/Web/Lists(guid'1cd980a0-1195-48d0-9cd1-9f96f58e2a44')/Items(3)",
                    "etag": "\"7\"",
                    "type": "SP.Data.TestListItem"
                },
                "Development": {
                    "results": [
                        {
                            "__metadata": {
                                "id": "b1e10983-7e1d-4ad4-a900-b907b3611f5d",
                                "type": "SP.Data.UserInfoItem"
                            },
                            "Title": "Buduru, Alexandru"
                        }
                    ]
                }
            },
            {
                "__metadata": {
                    "id": "5973a5bb-662a-4e4e-a54a-93ef5bb050ce",
                    "uri": "https://bostonscientificeur.sharepoint.com/sites/RegulatoryAffairs-VoiceoftheCustomer/_api/Web/Lists(guid'1cd980a0-1195-48d0-9cd1-9f96f58e2a44')/Items(4)",
                    "etag": "\"20\"",
                    "type": "SP.Data.TestListItem"
                },
                "Development": {
                    "results": [
                        {
                            "__metadata": {
                                "id": "c54f3fe9-b4e6-4e35-a3bc-aeff30286dda",
                                "type": "SP.Data.UserInfoItem"
                            },
                            "Title": "Bol, Roger"
                        }
                    ]
                }
            },
            {
                "__metadata": {
                    "id": "cec2f07a-e505-4699-83cb-5468860002eb",
                    "uri": "https://bostonscientificeur.sharepoint.com/sites/RegulatoryAffairs-VoiceoftheCustomer/_api/Web/Lists(guid'1cd980a0-1195-48d0-9cd1-9f96f58e2a44')/Items(5)",
                    "etag": "\"17\"",
                    "type": "SP.Data.TestListItem"
                },
                "Development": {
                    "results": [
                        {
                            "__metadata": {
                                "id": "c3b6a02d-2ae9-44ae-a776-3a7aca84e14e",
                                "type": "SP.Data.UserInfoItem"
                            },
                            "Title": "Bol, Roger"
                        }
                    ]
                }
            },
            {
                "__metadata": {
                    "id": "54bafe7f-d99d-4709-a776-8aa0e0384c05",
                    "uri": "https://bostonscientificeur.sharepoint.com/sites/RegulatoryAffairs-VoiceoftheCustomer/_api/Web/Lists(guid'1cd980a0-1195-48d0-9cd1-9f96f58e2a44')/Items(6)",
                    "etag": "\"11\"",
                    "type": "SP.Data.TestListItem"
                },
                "Development": {
                    "results": [
                        {
                            "__metadata": {
                                "id": "f0c3485f-4edc-4546-9bf5-dfbaefc1ab39",
                                "type": "SP.Data.UserInfoItem"
                            },
                            "Title": "Vilkaityte, Deimante"
                        }
                    ]
                }
            },
            {
                "__metadata": {
                    "id": "9331c145-550c-40ee-b964-52c03eb09c42",
                    "uri": "https://bostonscientificeur.sharepoint.com/sites/RegulatoryAffairs-VoiceoftheCustomer/_api/Web/Lists(guid'1cd980a0-1195-48d0-9cd1-9f96f58e2a44')/Items(7)",
                    "etag": "\"21\"",
                    "type": "SP.Data.TestListItem"
                },
                "Development": {
                    "results": [
                        {
                            "__metadata": {
                                "id": "58323df6-30ca-4ea9-a078-d47bc8200baf",
                                "type": "SP.Data.UserInfoItem"
                            },
                            "Title": "Bol, Roger"
                        }
                    ]
                }
            },
            {
                "__metadata": {
                    "id": "639075ad-8484-4f5a-9a4d-12188955bec9",
                    "uri": "https://bostonscientificeur.sharepoint.com/sites/RegulatoryAffairs-VoiceoftheCustomer/_api/Web/Lists(guid'1cd980a0-1195-48d0-9cd1-9f96f58e2a44')/Items(8)",
                    "etag": "\"15\"",
                    "type": "SP.Data.TestListItem"
                },
                "Development": {
                    "results": [
                        {
                            "__metadata": {
                                "id": "6bec6459-a9b6-4f57-b0e8-90f076332145",
                                "type": "SP.Data.UserInfoItem"
                            },
                            "Title": "Buduru, Alexandru"
                        }
                    ]
                }
            },
            {
                "__metadata": {
                    "id": "c83652ac-9167-41b2-9771-378257adc9b8",
                    "uri": "https://bostonscientificeur.sharepoint.com/sites/RegulatoryAffairs-VoiceoftheCustomer/_api/Web/Lists(guid'1cd980a0-1195-48d0-9cd1-9f96f58e2a44')/Items(9)",
                    "etag": "\"26\"",
                    "type": "SP.Data.TestListItem"
                },
                "Development": {
                    "results": [
                        {
                            "__metadata": {
                                "id": "49cc6887-1e81-47c8-b5b1-1ac5b0e27c01",
                                "type": "SP.Data.UserInfoItem"
                            },
                            "Title": "Vilkaityte, Deimante"
                        }
                    ]
                }
            },
            {
                "__metadata": {
                    "id": "e0d42494-b446-4915-94ad-ed7efb5ba36c",
                    "uri": "https://bostonscientificeur.sharepoint.com/sites/RegulatoryAffairs-VoiceoftheCustomer/_api/Web/Lists(guid'1cd980a0-1195-48d0-9cd1-9f96f58e2a44')/Items(10)",
                    "etag": "\"22\"",
                    "type": "SP.Data.TestListItem"
                },
                "Development": {
                    "results": [
                        {
                            "__metadata": {
                                "id": "7feddd0b-f2d3-43d3-a7a1-6deecc27fa78",
                                "type": "SP.Data.UserInfoItem"
                            },
                            "Title": "Bol, Roger"
                        }
                    ]
                }
            },
            {
                "__metadata": {
                    "id": "f3ea42af-1e4a-440e-9c79-3acf48838b4d",
                    "uri": "https://bostonscientificeur.sharepoint.com/sites/RegulatoryAffairs-VoiceoftheCustomer/_api/Web/Lists(guid'1cd980a0-1195-48d0-9cd1-9f96f58e2a44')/Items(11)",
                    "etag": "\"28\"",
                    "type": "SP.Data.TestListItem"
                },
                "Development": {
                    "results": [
                        {
                            "__metadata": {
                                "id": "f7765ea7-70a7-4968-9a2d-c4f982b923c3",
                                "type": "SP.Data.UserInfoItem"
                            },
                            "Title": "Bol, Roger"
                        },
                        {
                            "__metadata": {
                                "id": "d37f0963-7c6f-4c0c-8768-d2667d82d497",
                                "type": "SP.Data.UserInfoItem"
                            },
                            "Title": "Verstappen, Ksenia"
                        }
                    ]
                }
            },
            {
                "__metadata": {
                    "id": "39c9f89c-5a89-4e3f-818f-d894e1f2fa5d",
                    "uri": "https://bostonscientificeur.sharepoint.com/sites/RegulatoryAffairs-VoiceoftheCustomer/_api/Web/Lists(guid'1cd980a0-1195-48d0-9cd1-9f96f58e2a44')/Items(12)",
                    "etag": "\"34\"",
                    "type": "SP.Data.TestListItem"
                },
                "Development": {
                    "results": [
                        {
                            "__metadata": {
                                "id": "061e96a5-b719-4fae-a59e-1fdc50361c6b",
                                "type": "SP.Data.UserInfoItem"
                            },
                            "Title": "Bol, Roger"
                        },
                        {
                            "__metadata": {
                                "id": "7aa88318-a514-44ea-b299-269a778831d2",
                                "type": "SP.Data.UserInfoItem"
                            },
                            "Title": "Verstappen, Ksenia"
                        }
                    ]
                }
            },
            {
                "__metadata": {
                    "id": "982f6baa-d907-41ac-8158-72f2db18b158",
                    "uri": "https://bostonscientificeur.sharepoint.com/sites/RegulatoryAffairs-VoiceoftheCustomer/_api/Web/Lists(guid'1cd980a0-1195-48d0-9cd1-9f96f58e2a44')/Items(13)",
                    "etag": "\"50\"",
                    "type": "SP.Data.TestListItem"
                },
                "Development": {
                    "results": [
                        {
                            "__metadata": {
                                "id": "98f40248-eab3-4658-9d15-56c7987218e5",
                                "type": "SP.Data.UserInfoItem"
                            },
                            "Title": "Bol, Roger"
                        }
                    ]
                }
            },
            {
                "__metadata": {
                    "id": "3942568c-3b8d-4c25-b3be-657335dc0f50",
                    "uri": "https://bostonscientificeur.sharepoint.com/sites/RegulatoryAffairs-VoiceoftheCustomer/_api/Web/Lists(guid'1cd980a0-1195-48d0-9cd1-9f96f58e2a44')/Items(14)",
                    "etag": "\"16\"",
                    "type": "SP.Data.TestListItem"
                },
                "Development": {
                    "results": [
                        {
                            "__metadata": {
                                "id": "34ac41df-fe93-4b90-8795-b00259d6edb7",
                                "type": "SP.Data.UserInfoItem"
                            },
                            "Title": "Mohamad, Abd Al Hade"
                        }
                    ]
                }
            },
            {
                "__metadata": {
                    "id": "af3bfa26-1ca6-4b5d-98a3-8475072fcfe3",
                    "uri": "https://bostonscientificeur.sharepoint.com/sites/RegulatoryAffairs-VoiceoftheCustomer/_api/Web/Lists(guid'1cd980a0-1195-48d0-9cd1-9f96f58e2a44')/Items(15)",
                    "etag": "\"23\"",
                    "type": "SP.Data.TestListItem"
                },
                "Development": {
                    "results": [
                        {
                            "__metadata": {
                                "id": "017e072a-a245-4adc-90cf-8463e2f7ab31",
                                "type": "SP.Data.UserInfoItem"
                            },
                            "Title": "Vilkaityte, Deimante"
                        },
                        {
                            "__metadata": {
                                "id": "399c0160-7de7-45bd-ba58-9367a880807f",
                                "type": "SP.Data.UserInfoItem"
                            },
                            "Title": "Soare, Ecaterina"
                        }
                    ]
                }
            },
            {
                "__metadata": {
                    "id": "8ab93b4e-4478-4162-808c-109d65dee864",
                    "uri": "https://bostonscientificeur.sharepoint.com/sites/RegulatoryAffairs-VoiceoftheCustomer/_api/Web/Lists(guid'1cd980a0-1195-48d0-9cd1-9f96f58e2a44')/Items(16)",
                    "etag": "\"36\"",
                    "type": "SP.Data.TestListItem"
                },
                "Development": {
                    "results": [
                        {
                            "__metadata": {
                                "id": "0226bb6d-df04-48b3-bf86-c59b03da5f24",
                                "type": "SP.Data.UserInfoItem"
                            },
                            "Title": "Zauliczna, Anna (she/her/hers)"
                        },
                        {
                            "__metadata": {
                                "id": "82213dd7-4b5e-48b4-b04d-f8d4cc34f84a",
                                "type": "SP.Data.UserInfoItem"
                            },
                            "Title": "Yakimovich, Alena"
                        },
                        {
                            "__metadata": {
                                "id": "d5d413c5-dcae-48ae-9dae-880a68375852",
                                "type": "SP.Data.UserInfoItem"
                            },
                            "Title": "Camacho Vizcaino, Camila"
                        }
                    ]
                }
            },
            {
                "__metadata": {
                    "id": "cd8d5c9e-e98c-475e-a08e-47cce94b6dcf",
                    "uri": "https://bostonscientificeur.sharepoint.com/sites/RegulatoryAffairs-VoiceoftheCustomer/_api/Web/Lists(guid'1cd980a0-1195-48d0-9cd1-9f96f58e2a44')/Items(17)",
                    "etag": "\"17\"",
                    "type": "SP.Data.TestListItem"
                },
                "Development": {
                    "results": [
                        {
                            "__metadata": {
                                "id": "d02d0e88-2399-4d3d-af4c-8d6de20fbe8e",
                                "type": "SP.Data.UserInfoItem"
                            },
                            "Title": "Bol, Roger"
                        }
                    ]
                }
            },
            {
                "__metadata": {
                    "id": "2fccf3c0-0db4-4984-8455-6507cd70f7d8",
                    "uri": "https://bostonscientificeur.sharepoint.com/sites/RegulatoryAffairs-VoiceoftheCustomer/_api/Web/Lists(guid'1cd980a0-1195-48d0-9cd1-9f96f58e2a44')/Items(18)",
                    "etag": "\"18\"",
                    "type": "SP.Data.TestListItem"
                },
                "Development": {
                    "results": [
                        {
                            "__metadata": {
                                "id": "48152068-010b-4718-9df0-5a4bb086779a",
                                "type": "SP.Data.UserInfoItem"
                            },
                            "Title": "Bol, Roger"
                        }
                    ]
                }
            },
            {
                "__metadata": {
                    "id": "b49ab799-f874-4b36-8ad3-07d6b2682270",
                    "uri": "https://bostonscientificeur.sharepoint.com/sites/RegulatoryAffairs-VoiceoftheCustomer/_api/Web/Lists(guid'1cd980a0-1195-48d0-9cd1-9f96f58e2a44')/Items(19)",
                    "etag": "\"33\"",
                    "type": "SP.Data.TestListItem"
                },
                "Development": {
                    "results": [
                        {
                            "__metadata": {
                                "id": "52a4e3ee-357d-45d8-9f42-aac6db1b1f90",
                                "type": "SP.Data.UserInfoItem"
                            },
                            "Title": "Ocios, Marta"
                        },
                        {
                            "__metadata": {
                                "id": "fb943612-8bba-486f-b717-36a4ac0597c7",
                                "type": "SP.Data.UserInfoItem"
                            },
                            "Title": "Deka, Jitu Mani"
                        }
                    ]
                }
            },
            {
                "__metadata": {
                    "id": "bee970fe-2748-4f5d-9357-acefc1814af9",
                    "uri": "https://bostonscientificeur.sharepoint.com/sites/RegulatoryAffairs-VoiceoftheCustomer/_api/Web/Lists(guid'1cd980a0-1195-48d0-9cd1-9f96f58e2a44')/Items(20)",
                    "etag": "\"46\"",
                    "type": "SP.Data.TestListItem"
                },
                "Development": {
                    "results": [
                        {
                            "__metadata": {
                                "id": "34c296c7-6457-4fc0-989b-d6966c2d6038",
                                "type": "SP.Data.UserInfoItem"
                            },
                            "Title": "Bol, Roger"
                        }
                    ]
                }
            },
            {
                "__metadata": {
                    "id": "6bbb5eec-6cc3-4f8a-aa11-ae79d4ace87b",
                    "uri": "https://bostonscientificeur.sharepoint.com/sites/RegulatoryAffairs-VoiceoftheCustomer/_api/Web/Lists(guid'1cd980a0-1195-48d0-9cd1-9f96f58e2a44')/Items(21)",
                    "etag": "\"39\"",
                    "type": "SP.Data.TestListItem"
                },
                "Development": {
                    "results": [
                        {
                            "__metadata": {
                                "id": "afedeeef-8571-41a9-bce6-4e7199adc3bd",
                                "type": "SP.Data.UserInfoItem"
                            },
                            "Title": "Bol, Roger"
                        }
                    ]
                }
            },
            {
                "__metadata": {
                    "id": "6c273810-2e3d-4691-924a-1f637eaa1f50",
                    "uri": "https://bostonscientificeur.sharepoint.com/sites/RegulatoryAffairs-VoiceoftheCustomer/_api/Web/Lists(guid'1cd980a0-1195-48d0-9cd1-9f96f58e2a44')/Items(22)",
                    "etag": "\"35\"",
                    "type": "SP.Data.TestListItem"
                },
                "Development": {
                    "results": [
                        {
                            "__metadata": {
                                "id": "8cc4c028-d5f1-48da-ae51-5d5b26b9aa88",
                                "type": "SP.Data.UserInfoItem"
                            },
                            "Title": "Bol, Roger"
                        }
                    ]
                }
            },
            {
                "__metadata": {
                    "id": "c6421157-64bd-4589-a54a-96ab03a06894",
                    "uri": "https://bostonscientificeur.sharepoint.com/sites/RegulatoryAffairs-VoiceoftheCustomer/_api/Web/Lists(guid'1cd980a0-1195-48d0-9cd1-9f96f58e2a44')/Items(23)",
                    "etag": "\"14\"",
                    "type": "SP.Data.TestListItem"
                },
                "Development": {
                    "results": [
                        {
                            "__metadata": {
                                "id": "7aa2f74d-012a-4cd1-963a-14c6ec83ba6b",
                                "type": "SP.Data.UserInfoItem"
                            },
                            "Title": "Bol, Roger"
                        }
                    ]
                }
            },
            {
                "__metadata": {
                    "id": "9f04604d-98b5-41c5-a01c-3dea5cde6c28",
                    "uri": "https://bostonscientificeur.sharepoint.com/sites/RegulatoryAffairs-VoiceoftheCustomer/_api/Web/Lists(guid'1cd980a0-1195-48d0-9cd1-9f96f58e2a44')/Items(24)",
                    "etag": "\"11\"",
                    "type": "SP.Data.TestListItem"
                },
                "Development": {
                    "results": [
                        {
                            "__metadata": {
                                "id": "4320991b-2a1a-44ff-a2fc-5acf035537f6",
                                "type": "SP.Data.UserInfoItem"
                            },
                            "Title": "Bol, Roger"
                        }
                    ]
                }
            },
            {
                "__metadata": {
                    "id": "e93d621f-5007-45fd-849f-6da5b9383d23",
                    "uri": "https://bostonscientificeur.sharepoint.com/sites/RegulatoryAffairs-VoiceoftheCustomer/_api/Web/Lists(guid'1cd980a0-1195-48d0-9cd1-9f96f58e2a44')/Items(25)",
                    "etag": "\"29\"",
                    "type": "SP.Data.TestListItem"
                },
                "Development": {
                    "results": [
                        {
                            "__metadata": {
                                "id": "e8faeb63-4c66-4345-9504-d5fc89676fdf",
                                "type": "SP.Data.UserInfoItem"
                            },
                            "Title": "Staniszewska, Anna"
                        }
                    ]
                }
            },
            {
                "__metadata": {
                    "id": "e3895b9a-5735-49a3-b945-c7f6dc56fe7c",
                    "uri": "https://bostonscientificeur.sharepoint.com/sites/RegulatoryAffairs-VoiceoftheCustomer/_api/Web/Lists(guid'1cd980a0-1195-48d0-9cd1-9f96f58e2a44')/Items(26)",
                    "etag": "\"7\"",
                    "type": "SP.Data.TestListItem"
                },
                "Development": {
                    "results": [
                        {
                            "__metadata": {
                                "id": "bb0978ed-8944-4984-865e-0c4835c85465",
                                "type": "SP.Data.UserInfoItem"
                            },
                            "Title": "Verstappen, Ksenia"
                        }
                    ]
                }
            },
            {
                "__metadata": {
                    "id": "046dd3cd-cebe-4e8d-b97b-ee7d34c0ece9",
                    "uri": "https://bostonscientificeur.sharepoint.com/sites/RegulatoryAffairs-VoiceoftheCustomer/_api/Web/Lists(guid'1cd980a0-1195-48d0-9cd1-9f96f58e2a44')/Items(27)",
                    "etag": "\"37\"",
                    "type": "SP.Data.TestListItem"
                },
                "Development": {
                    "results": [
                        {
                            "__metadata": {
                                "id": "a6649599-73a0-4bb3-87ca-019636030f1d",
                                "type": "SP.Data.UserInfoItem"
                            },
                            "Title": "Vos, Dave"
                        },
                        {
                            "__metadata": {
                                "id": "8ed575d0-2d3c-4ab5-8eb3-9359c5525a82",
                                "type": "SP.Data.UserInfoItem"
                            },
                            "Title": "Sandoval, Cesar (he/him/his)"
                        }
                    ]
                }
            },
            {
                "__metadata": {
                    "id": "0e630eac-a994-496d-9216-c22a81f5b235",
                    "uri": "https://bostonscientificeur.sharepoint.com/sites/RegulatoryAffairs-VoiceoftheCustomer/_api/Web/Lists(guid'1cd980a0-1195-48d0-9cd1-9f96f58e2a44')/Items(28)",
                    "etag": "\"11\"",
                    "type": "SP.Data.TestListItem"
                },
                "Development": {
                    "results": [
                        {
                            "__metadata": {
                                "id": "c4cfe109-9ec0-4bcc-b769-2a2dff0b69f2",
                                "type": "SP.Data.UserInfoItem"
                            },
                            "Title": "Bol, Roger"
                        }
                    ]
                }
            },
            {
                "__metadata": {
                    "id": "fce73e0f-9260-48f9-831c-bd36a04d3662",
                    "uri": "https://bostonscientificeur.sharepoint.com/sites/RegulatoryAffairs-VoiceoftheCustomer/_api/Web/Lists(guid'1cd980a0-1195-48d0-9cd1-9f96f58e2a44')/Items(29)",
                    "etag": "\"24\"",
                    "type": "SP.Data.TestListItem"
                },
                "Development": {
                    "results": [
                        {
                            "__metadata": {
                                "id": "5a544c45-0ac4-4849-b8f0-bc88d15e66ab",
                                "type": "SP.Data.UserInfoItem"
                            },
                            "Title": "Sandoval, Cesar (he/him/his)"
                        }
                    ]
                }
            },
            {
                "__metadata": {
                    "id": "3a28b18b-1e83-4368-a79b-f08828e32272",
                    "uri": "https://bostonscientificeur.sharepoint.com/sites/RegulatoryAffairs-VoiceoftheCustomer/_api/Web/Lists(guid'1cd980a0-1195-48d0-9cd1-9f96f58e2a44')/Items(30)",
                    "etag": "\"35\"",
                    "type": "SP.Data.TestListItem"
                },
                "Development": {
                    "results": [
                        {
                            "__metadata": {
                                "id": "712d5aa1-310e-4abc-a287-cce4a33318ae",
                                "type": "SP.Data.UserInfoItem"
                            },
                            "Title": "Buduru, Alexandru"
                        }
                    ]
                }
            },
            {
                "__metadata": {
                    "id": "86125d0b-16bd-4eac-8584-a6292b31f870",
                    "uri": "https://bostonscientificeur.sharepoint.com/sites/RegulatoryAffairs-VoiceoftheCustomer/_api/Web/Lists(guid'1cd980a0-1195-48d0-9cd1-9f96f58e2a44')/Items(31)",
                    "etag": "\"12\"",
                    "type": "SP.Data.TestListItem"
                },
                "Development": {
                    "results": [
                        {
                            "__metadata": {
                                "id": "dff4480b-2811-4db3-b327-d6c388c44477",
                                "type": "SP.Data.UserInfoItem"
                            },
                            "Title": "Buduru, Alexandru"
                        }
                    ]
                }
            },
            {
                "__metadata": {
                    "id": "e0ef5d67-b4e5-47a5-a3cb-a325b5c8ccd4",
                    "uri": "https://bostonscientificeur.sharepoint.com/sites/RegulatoryAffairs-VoiceoftheCustomer/_api/Web/Lists(guid'1cd980a0-1195-48d0-9cd1-9f96f58e2a44')/Items(32)",
                    "etag": "\"35\"",
                    "type": "SP.Data.TestListItem"
                },
                "Development": {
                    "results": [
                        {
                            "__metadata": {
                                "id": "81c517b1-bc6e-466c-ba38-617c295c54f0",
                                "type": "SP.Data.UserInfoItem"
                            },
                            "Title": "Bol, Roger"
                        },
                        {
                            "__metadata": {
                                "id": "81345cc7-e117-4c2d-ad0b-835c54cfea41",
                                "type": "SP.Data.UserInfoItem"
                            },
                            "Title": "Buduru, Alexandru"
                        }
                    ]
                }
            },
            {
                "__metadata": {
                    "id": "c32e2d3b-cecc-40ff-8ee4-dbdc19d9de12",
                    "uri": "https://bostonscientificeur.sharepoint.com/sites/RegulatoryAffairs-VoiceoftheCustomer/_api/Web/Lists(guid'1cd980a0-1195-48d0-9cd1-9f96f58e2a44')/Items(33)",
                    "etag": "\"33\"",
                    "type": "SP.Data.TestListItem"
                },
                "Development": {
                    "results": [
                        {
                            "__metadata": {
                                "id": "f8981b93-4b3a-40b5-b563-e03d29d56736",
                                "type": "SP.Data.UserInfoItem"
                            },
                            "Title": "Vilkaityte, Deimante"
                        }
                    ]
                }
            },
            {
                "__metadata": {
                    "id": "aa68dc30-1a7d-4dcb-b533-0f50718c3bc3",
                    "uri": "https://bostonscientificeur.sharepoint.com/sites/RegulatoryAffairs-VoiceoftheCustomer/_api/Web/Lists(guid'1cd980a0-1195-48d0-9cd1-9f96f58e2a44')/Items(34)",
                    "etag": "\"40\"",
                    "type": "SP.Data.TestListItem"
                },
                "Development": {
                    "results": [
                        {
                            "__metadata": {
                                "id": "eab87dd0-9f03-49bd-a098-8cd37b14cba4",
                                "type": "SP.Data.UserInfoItem"
                            },
                            "Title": "Verstappen, Ksenia"
                        },
                        {
                            "__metadata": {
                                "id": "a7d9fba3-5932-4212-9c22-4d7b52767600",
                                "type": "SP.Data.UserInfoItem"
                            },
                            "Title": "Guidotti, Davide"
                        }
                    ]
                }
            },
            {
                "__metadata": {
                    "id": "4a6c0829-21b6-483c-8b0d-57af4e9009dc",
                    "uri": "https://bostonscientificeur.sharepoint.com/sites/RegulatoryAffairs-VoiceoftheCustomer/_api/Web/Lists(guid'1cd980a0-1195-48d0-9cd1-9f96f58e2a44')/Items(35)",
                    "etag": "\"62\"",
                    "type": "SP.Data.TestListItem"
                },
                "Development": {
                    "results": [
                        {
                            "__metadata": {
                                "id": "39d59f40-234f-475a-867b-58c27603b135",
                                "type": "SP.Data.UserInfoItem"
                            },
                            "Title": "Buduru, Alexandru"
                        }
                    ]
                }
            },
            {
                "__metadata": {
                    "id": "f19806a8-251d-417f-8483-50df04798775",
                    "uri": "https://bostonscientificeur.sharepoint.com/sites/RegulatoryAffairs-VoiceoftheCustomer/_api/Web/Lists(guid'1cd980a0-1195-48d0-9cd1-9f96f58e2a44')/Items(36)",
                    "etag": "\"15\"",
                    "type": "SP.Data.TestListItem"
                },
                "Development": {
                    "__deferred": {
                        "uri": "https://bostonscientificeur.sharepoint.com/sites/RegulatoryAffairs-VoiceoftheCustomer/_api/Web/Lists(guid'1cd980a0-1195-48d0-9cd1-9f96f58e2a44')/Items(36)/Development"
                    }
                }
            },
            {
                "__metadata": {
                    "id": "9396d271-9f64-45ad-9af5-a7c61ddf6fa1",
                    "uri": "https://bostonscientificeur.sharepoint.com/sites/RegulatoryAffairs-VoiceoftheCustomer/_api/Web/Lists(guid'1cd980a0-1195-48d0-9cd1-9f96f58e2a44')/Items(37)",
                    "etag": "\"37\"",
                    "type": "SP.Data.TestListItem"
                },
                "Development": {
                    "results": [
                        {
                            "__metadata": {
                                "id": "1a168826-f878-48fc-ba37-6e5c59c3b52c",
                                "type": "SP.Data.UserInfoItem"
                            },
                            "Title": "Vilkaityte, Deimante"
                        },
                        {
                            "__metadata": {
                                "id": "bddfc59b-6ded-4ca1-8a21-4bfb42aa96b8",
                                "type": "SP.Data.UserInfoItem"
                            },
                            "Title": "Soare, Ecaterina"
                        }
                    ]
                }
            },
            {
                "__metadata": {
                    "id": "b6be0559-9fa0-4597-a7e1-daa6962532ea",
                    "uri": "https://bostonscientificeur.sharepoint.com/sites/RegulatoryAffairs-VoiceoftheCustomer/_api/Web/Lists(guid'1cd980a0-1195-48d0-9cd1-9f96f58e2a44')/Items(38)",
                    "etag": "\"28\"",
                    "type": "SP.Data.TestListItem"
                },
                "Development": {
                    "results": [
                        {
                            "__metadata": {
                                "id": "1571fc3a-3df1-48e7-baf0-a6618e840e02",
                                "type": "SP.Data.UserInfoItem"
                            },
                            "Title": "Vilkaityte, Deimante"
                        }
                    ]
                }
            },
            {
                "__metadata": {
                    "id": "86eac8c8-1da5-46ae-817e-c40add3f0367",
                    "uri": "https://bostonscientificeur.sharepoint.com/sites/RegulatoryAffairs-VoiceoftheCustomer/_api/Web/Lists(guid'1cd980a0-1195-48d0-9cd1-9f96f58e2a44')/Items(39)",
                    "etag": "\"5\"",
                    "type": "SP.Data.TestListItem"
                },
                "Development": {
                    "results": [
                        {
                            "__metadata": {
                                "id": "d284f117-60bb-4af4-8912-edf362ec6208",
                                "type": "SP.Data.UserInfoItem"
                            },
                            "Title": "Bol, Roger"
                        }
                    ]
                }
            },
            {
                "__metadata": {
                    "id": "4240b8d4-a7e4-42da-bd58-f5b54bdafab9",
                    "uri": "https://bostonscientificeur.sharepoint.com/sites/RegulatoryAffairs-VoiceoftheCustomer/_api/Web/Lists(guid'1cd980a0-1195-48d0-9cd1-9f96f58e2a44')/Items(40)",
                    "etag": "\"7\"",
                    "type": "SP.Data.TestListItem"
                },
                "Development": {
                    "results": [
                        {
                            "__metadata": {
                                "id": "475ddee7-72d7-402a-9cd6-de8a5202c41e",
                                "type": "SP.Data.UserInfoItem"
                            },
                            "Title": "Verstappen, Ksenia"
                        }
                    ]
                }
            },
            {
                "__metadata": {
                    "id": "e0105e9d-d53e-4723-ab2e-c74d42126dec",
                    "uri": "https://bostonscientificeur.sharepoint.com/sites/RegulatoryAffairs-VoiceoftheCustomer/_api/Web/Lists(guid'1cd980a0-1195-48d0-9cd1-9f96f58e2a44')/Items(41)",
                    "etag": "\"6\"",
                    "type": "SP.Data.TestListItem"
                },
                "Development": {
                    "results": [
                        {
                            "__metadata": {
                                "id": "bcf0951a-1c83-430d-b979-f212745d47bd",
                                "type": "SP.Data.UserInfoItem"
                            },
                            "Title": "Bol, Roger"
                        },
                        {
                            "__metadata": {
                                "id": "efb02391-6903-4ad3-97cb-cb534300cf15",
                                "type": "SP.Data.UserInfoItem"
                            },
                            "Title": "Guidotti, Davide"
                        }
                    ]
                }
            },
            {
                "__metadata": {
                    "id": "104b1977-e676-4d77-b301-4e60682b82d6",
                    "uri": "https://bostonscientificeur.sharepoint.com/sites/RegulatoryAffairs-VoiceoftheCustomer/_api/Web/Lists(guid'1cd980a0-1195-48d0-9cd1-9f96f58e2a44')/Items(42)",
                    "etag": "\"6\"",
                    "type": "SP.Data.TestListItem"
                },
                "Development": {
                    "results": [
                        {
                            "__metadata": {
                                "id": "e073d827-86ce-45e7-a2ef-1cc0bf3775af",
                                "type": "SP.Data.UserInfoItem"
                            },
                            "Title": "Guidotti, Davide"
                        }
                    ]
                }
            },
            {
                "__metadata": {
                    "id": "e2be52a6-ba40-49c0-bfc4-bbf867d994a7",
                    "uri": "https://bostonscientificeur.sharepoint.com/sites/RegulatoryAffairs-VoiceoftheCustomer/_api/Web/Lists(guid'1cd980a0-1195-48d0-9cd1-9f96f58e2a44')/Items(43)",
                    "etag": "\"6\"",
                    "type": "SP.Data.TestListItem"
                },
                "Development": {
                    "results": [
                        {
                            "__metadata": {
                                "id": "02e16fae-e4c2-4c01-b193-53230f558c88",
                                "type": "SP.Data.UserInfoItem"
                            },
                            "Title": "Bol, Roger"
                        }
                    ]
                }
            },
            {
                "__metadata": {
                    "id": "e8cb191e-00c1-440f-b3ae-fae916e41dd0",
                    "uri": "https://bostonscientificeur.sharepoint.com/sites/RegulatoryAffairs-VoiceoftheCustomer/_api/Web/Lists(guid'1cd980a0-1195-48d0-9cd1-9f96f58e2a44')/Items(44)",
                    "etag": "\"4\"",
                    "type": "SP.Data.TestListItem"
                },
                "Development": {
                    "results": [
                        {
                            "__metadata": {
                                "id": "efb8dcbe-2b21-4727-834d-342a3e05d250",
                                "type": "SP.Data.UserInfoItem"
                            },
                            "Title": "Bol, Roger"
                        }
                    ]
                }
            },
            {
                "__metadata": {
                    "id": "46762c15-7f60-4060-905f-4f24f995ff5f",
                    "uri": "https://bostonscientificeur.sharepoint.com/sites/RegulatoryAffairs-VoiceoftheCustomer/_api/Web/Lists(guid'1cd980a0-1195-48d0-9cd1-9f96f58e2a44')/Items(45)",
                    "etag": "\"5\"",
                    "type": "SP.Data.TestListItem"
                },
                "Development": {
                    "results": [
                        {
                            "__metadata": {
                                "id": "3a8b9d27-3f11-4e6c-9a8a-bb1ad8d6f678",
                                "type": "SP.Data.UserInfoItem"
                            },
                            "Title": "Vilkaityte, Deimante"
                        }
                    ]
                }
            },
            {
                "__metadata": {
                    "id": "ec8b010b-c4d6-4eff-b22d-8ac33f5908ba",
                    "uri": "https://bostonscientificeur.sharepoint.com/sites/RegulatoryAffairs-VoiceoftheCustomer/_api/Web/Lists(guid'1cd980a0-1195-48d0-9cd1-9f96f58e2a44')/Items(46)",
                    "etag": "\"7\"",
                    "type": "SP.Data.TestListItem"
                },
                "Development": {
                    "__deferred": {
                        "uri": "https://bostonscientificeur.sharepoint.com/sites/RegulatoryAffairs-VoiceoftheCustomer/_api/Web/Lists(guid'1cd980a0-1195-48d0-9cd1-9f96f58e2a44')/Items(46)/Development"
                    }
                }
            },
            {
                "__metadata": {
                    "id": "4bfee380-d6e1-41c5-8c66-d3d5aef6522f",
                    "uri": "https://bostonscientificeur.sharepoint.com/sites/RegulatoryAffairs-VoiceoftheCustomer/_api/Web/Lists(guid'1cd980a0-1195-48d0-9cd1-9f96f58e2a44')/Items(47)",
                    "etag": "\"13\"",
                    "type": "SP.Data.TestListItem"
                },
                "Development": {
                    "results": [
                        {
                            "__metadata": {
                                "id": "84875896-8b1a-456b-be33-738449f5f3c2",
                                "type": "SP.Data.UserInfoItem"
                            },
                            "Title": "Vilkaityte, Deimante"
                        }
                    ]
                }
            },
            {
                "__metadata": {
                    "id": "d79d0058-1df1-4b1c-b1c1-4715b2c125c4",
                    "uri": "https://bostonscientificeur.sharepoint.com/sites/RegulatoryAffairs-VoiceoftheCustomer/_api/Web/Lists(guid'1cd980a0-1195-48d0-9cd1-9f96f58e2a44')/Items(48)",
                    "etag": "\"15\"",
                    "type": "SP.Data.TestListItem"
                },
                "Development": {
                    "__deferred": {
                        "uri": "https://bostonscientificeur.sharepoint.com/sites/RegulatoryAffairs-VoiceoftheCustomer/_api/Web/Lists(guid'1cd980a0-1195-48d0-9cd1-9f96f58e2a44')/Items(48)/Development"
                    }
                }
            },
            {
                "__metadata": {
                    "id": "46830246-9826-415a-948d-a56d43a58b97",
                    "uri": "https://bostonscientificeur.sharepoint.com/sites/RegulatoryAffairs-VoiceoftheCustomer/_api/Web/Lists(guid'1cd980a0-1195-48d0-9cd1-9f96f58e2a44')/Items(49)",
                    "etag": "\"21\"",
                    "type": "SP.Data.TestListItem"
                },
                "Development": {
                    "results": [
                        {
                            "__metadata": {
                                "id": "23701202-d105-4bf5-b38c-e08c7ecefa96",
                                "type": "SP.Data.UserInfoItem"
                            },
                            "Title": "Potocki, Michal"
                        }
                    ]
                }
            },
            {
                "__metadata": {
                    "id": "6ba29393-9e19-4363-b4e9-39ebeb4e22f8",
                    "uri": "https://bostonscientificeur.sharepoint.com/sites/RegulatoryAffairs-VoiceoftheCustomer/_api/Web/Lists(guid'1cd980a0-1195-48d0-9cd1-9f96f58e2a44')/Items(50)",
                    "etag": "\"24\"",
                    "type": "SP.Data.TestListItem"
                },
                "Development": {
                    "results": [
                        {
                            "__metadata": {
                                "id": "b6504bf6-8489-4238-8a87-a930ae0cf4ac",
                                "type": "SP.Data.UserInfoItem"
                            },
                            "Title": "Bol, Roger"
                        }
                    ]
                }
            },
            {
                "__metadata": {
                    "id": "ae72a9db-9519-4028-9334-9393846b1719",
                    "uri": "https://bostonscientificeur.sharepoint.com/sites/RegulatoryAffairs-VoiceoftheCustomer/_api/Web/Lists(guid'1cd980a0-1195-48d0-9cd1-9f96f58e2a44')/Items(51)",
                    "etag": "\"19\"",
                    "type": "SP.Data.TestListItem"
                },
                "Development": {
                    "results": [
                        {
                            "__metadata": {
                                "id": "34c618c8-0255-4e03-96a4-f59d922f2799",
                                "type": "SP.Data.UserInfoItem"
                            },
                            "Title": "Bol, Roger"
                        }
                    ]
                }
            },
            {
                "__metadata": {
                    "id": "108ab718-31a9-4ead-8dc6-bebca557b664",
                    "uri": "https://bostonscientificeur.sharepoint.com/sites/RegulatoryAffairs-VoiceoftheCustomer/_api/Web/Lists(guid'1cd980a0-1195-48d0-9cd1-9f96f58e2a44')/Items(52)",
                    "etag": "\"22\"",
                    "type": "SP.Data.TestListItem"
                },
                "Development": {
                    "results": [
                        {
                            "__metadata": {
                                "id": "785befc1-b8b3-4bc6-83c7-44ba9b89f733",
                                "type": "SP.Data.UserInfoItem"
                            },
                            "Title": "Bol, Roger"
                        }
                    ]
                }
            },
            {
                "__metadata": {
                    "id": "0dfecafd-a223-4932-9191-16cdb60a6502",
                    "uri": "https://bostonscientificeur.sharepoint.com/sites/RegulatoryAffairs-VoiceoftheCustomer/_api/Web/Lists(guid'1cd980a0-1195-48d0-9cd1-9f96f58e2a44')/Items(53)",
                    "etag": "\"18\"",
                    "type": "SP.Data.TestListItem"
                },
                "Development": {
                    "results": [
                        {
                            "__metadata": {
                                "id": "12d42031-2896-4f6b-8212-8391b4786790",
                                "type": "SP.Data.UserInfoItem"
                            },
                            "Title": "Bol, Roger"
                        }
                    ]
                }
            },
            {
                "__metadata": {
                    "id": "838a5557-ad62-44ab-97e1-8f157dfc8e26",
                    "uri": "https://bostonscientificeur.sharepoint.com/sites/RegulatoryAffairs-VoiceoftheCustomer/_api/Web/Lists(guid'1cd980a0-1195-48d0-9cd1-9f96f58e2a44')/Items(54)",
                    "etag": "\"10\"",
                    "type": "SP.Data.TestListItem"
                },
                "Development": {
                    "__deferred": {
                        "uri": "https://bostonscientificeur.sharepoint.com/sites/RegulatoryAffairs-VoiceoftheCustomer/_api/Web/Lists(guid'1cd980a0-1195-48d0-9cd1-9f96f58e2a44')/Items(54)/Development"
                    }
                }
            },
            {
                "__metadata": {
                    "id": "ec7ba837-802c-4e5d-ac7e-cc96bca495cc",
                    "uri": "https://bostonscientificeur.sharepoint.com/sites/RegulatoryAffairs-VoiceoftheCustomer/_api/Web/Lists(guid'1cd980a0-1195-48d0-9cd1-9f96f58e2a44')/Items(55)",
                    "etag": "\"16\"",
                    "type": "SP.Data.TestListItem"
                },
                "Development": {
                    "results": [
                        {
                            "__metadata": {
                                "id": "7958728a-595d-4814-ac9a-b90e8f7a4a04",
                                "type": "SP.Data.UserInfoItem"
                            },
                            "Title": "Buduru, Alexandru"
                        }
                    ]
                }
            },
            {
                "__metadata": {
                    "id": "0ca55bf3-c49e-45c0-aa84-4b5a83ad6779",
                    "uri": "https://bostonscientificeur.sharepoint.com/sites/RegulatoryAffairs-VoiceoftheCustomer/_api/Web/Lists(guid'1cd980a0-1195-48d0-9cd1-9f96f58e2a44')/Items(56)",
                    "etag": "\"36\"",
                    "type": "SP.Data.TestListItem"
                },
                "Development": {
                    "results": [
                        {
                            "__metadata": {
                                "id": "3320ce99-64dc-4301-a520-8d6867af0c75",
                                "type": "SP.Data.UserInfoItem"
                            },
                            "Title": "Attri, Neeraj"
                        }
                    ]
                }
            },
            {
                "__metadata": {
                    "id": "f26e8627-e2f0-4bdf-b89c-f3f10e3112c3",
                    "uri": "https://bostonscientificeur.sharepoint.com/sites/RegulatoryAffairs-VoiceoftheCustomer/_api/Web/Lists(guid'1cd980a0-1195-48d0-9cd1-9f96f58e2a44')/Items(57)",
                    "etag": "\"14\"",
                    "type": "SP.Data.TestListItem"
                },
                "Development": {
                    "__deferred": {
                        "uri": "https://bostonscientificeur.sharepoint.com/sites/RegulatoryAffairs-VoiceoftheCustomer/_api/Web/Lists(guid'1cd980a0-1195-48d0-9cd1-9f96f58e2a44')/Items(57)/Development"
                    }
                }
            },
            {
                "__metadata": {
                    "id": "ec595bbc-e1d4-4205-9fc3-de9ed35eb7d5",
                    "uri": "https://bostonscientificeur.sharepoint.com/sites/RegulatoryAffairs-VoiceoftheCustomer/_api/Web/Lists(guid'1cd980a0-1195-48d0-9cd1-9f96f58e2a44')/Items(58)",
                    "etag": "\"13\"",
                    "type": "SP.Data.TestListItem"
                },
                "Development": {
                    "__deferred": {
                        "uri": "https://bostonscientificeur.sharepoint.com/sites/RegulatoryAffairs-VoiceoftheCustomer/_api/Web/Lists(guid'1cd980a0-1195-48d0-9cd1-9f96f58e2a44')/Items(58)/Development"
                    }
                }
            },
            {
                "__metadata": {
                    "id": "97a317c4-54d1-4386-b151-0da3cc3fa3d9",
                    "uri": "https://bostonscientificeur.sharepoint.com/sites/RegulatoryAffairs-VoiceoftheCustomer/_api/Web/Lists(guid'1cd980a0-1195-48d0-9cd1-9f96f58e2a44')/Items(59)",
                    "etag": "\"6\"",
                    "type": "SP.Data.TestListItem"
                },
                "Development": {
                    "__deferred": {
                        "uri": "https://bostonscientificeur.sharepoint.com/sites/RegulatoryAffairs-VoiceoftheCustomer/_api/Web/Lists(guid'1cd980a0-1195-48d0-9cd1-9f96f58e2a44')/Items(59)/Development"
                    }
                }
            },
            {
                "__metadata": {
                    "id": "0ba73845-5d62-4ac2-affb-52721efe29cc",
                    "uri": "https://bostonscientificeur.sharepoint.com/sites/RegulatoryAffairs-VoiceoftheCustomer/_api/Web/Lists(guid'1cd980a0-1195-48d0-9cd1-9f96f58e2a44')/Items(60)",
                    "etag": "\"6\"",
                    "type": "SP.Data.TestListItem"
                },
                "Development": {
                    "__deferred": {
                        "uri": "https://bostonscientificeur.sharepoint.com/sites/RegulatoryAffairs-VoiceoftheCustomer/_api/Web/Lists(guid'1cd980a0-1195-48d0-9cd1-9f96f58e2a44')/Items(60)/Development"
                    }
                }
            },
            {
                "__metadata": {
                    "id": "e2a93924-9ded-4871-9159-b10a6f915fcb",
                    "uri": "https://bostonscientificeur.sharepoint.com/sites/RegulatoryAffairs-VoiceoftheCustomer/_api/Web/Lists(guid'1cd980a0-1195-48d0-9cd1-9f96f58e2a44')/Items(61)",
                    "etag": "\"12\"",
                    "type": "SP.Data.TestListItem"
                },
                "Development": {
                    "__deferred": {
                        "uri": "https://bostonscientificeur.sharepoint.com/sites/RegulatoryAffairs-VoiceoftheCustomer/_api/Web/Lists(guid'1cd980a0-1195-48d0-9cd1-9f96f58e2a44')/Items(61)/Development"
                    }
                }
            },
            {
                "__metadata": {
                    "id": "cdde897d-90fe-4a04-9b90-0ad5dcd53d89",
                    "uri": "https://bostonscientificeur.sharepoint.com/sites/RegulatoryAffairs-VoiceoftheCustomer/_api/Web/Lists(guid'1cd980a0-1195-48d0-9cd1-9f96f58e2a44')/Items(62)",
                    "etag": "\"16\"",
                    "type": "SP.Data.TestListItem"
                },
                "Development": {
                    "__deferred": {
                        "uri": "https://bostonscientificeur.sharepoint.com/sites/RegulatoryAffairs-VoiceoftheCustomer/_api/Web/Lists(guid'1cd980a0-1195-48d0-9cd1-9f96f58e2a44')/Items(62)/Development"
                    }
                }
            },
            {
                "__metadata": {
                    "id": "bc581b6c-3cd4-4901-80c9-d4a7bbacdcc2",
                    "uri": "https://bostonscientificeur.sharepoint.com/sites/RegulatoryAffairs-VoiceoftheCustomer/_api/Web/Lists(guid'1cd980a0-1195-48d0-9cd1-9f96f58e2a44')/Items(63)",
                    "etag": "\"2\"",
                    "type": "SP.Data.TestListItem"
                },
                "Development": {
                    "__deferred": {
                        "uri": "https://bostonscientificeur.sharepoint.com/sites/RegulatoryAffairs-VoiceoftheCustomer/_api/Web/Lists(guid'1cd980a0-1195-48d0-9cd1-9f96f58e2a44')/Items(63)/Development"
                    }
                }
            },
            {
                "__metadata": {
                    "id": "b4f1808d-4071-4d93-991f-425fcb5cc442",
                    "uri": "https://bostonscientificeur.sharepoint.com/sites/RegulatoryAffairs-VoiceoftheCustomer/_api/Web/Lists(guid'1cd980a0-1195-48d0-9cd1-9f96f58e2a44')/Items(64)",
                    "etag": "\"18\"",
                    "type": "SP.Data.TestListItem"
                },
                "Development": {
                    "__deferred": {
                        "uri": "https://bostonscientificeur.sharepoint.com/sites/RegulatoryAffairs-VoiceoftheCustomer/_api/Web/Lists(guid'1cd980a0-1195-48d0-9cd1-9f96f58e2a44')/Items(64)/Development"
                    }
                }
            },
            {
                "__metadata": {
                    "id": "acc43172-4c07-4474-a5b0-f65bb3317f32",
                    "uri": "https://bostonscientificeur.sharepoint.com/sites/RegulatoryAffairs-VoiceoftheCustomer/_api/Web/Lists(guid'1cd980a0-1195-48d0-9cd1-9f96f58e2a44')/Items(65)",
                    "etag": "\"15\"",
                    "type": "SP.Data.TestListItem"
                },
                "Development": {
                    "results": [
                        {
                            "__metadata": {
                                "id": "56792abc-ddfa-4766-b685-eaf9edac64a0",
                                "type": "SP.Data.UserInfoItem"
                            },
                            "Title": "Vilkaityte, Deimante"
                        }
                    ]
                }
            },
            {
                "__metadata": {
                    "id": "0836623f-f1ba-40ac-8eb2-b44dd2f511cd",
                    "uri": "https://bostonscientificeur.sharepoint.com/sites/RegulatoryAffairs-VoiceoftheCustomer/_api/Web/Lists(guid'1cd980a0-1195-48d0-9cd1-9f96f58e2a44')/Items(66)",
                    "etag": "\"2\"",
                    "type": "SP.Data.TestListItem"
                },
                "Development": {
                    "results": [
                        {
                            "__metadata": {
                                "id": "310bca86-122e-475f-baf5-7b9f23050322",
                                "type": "SP.Data.UserInfoItem"
                            },
                            "Title": "Soare, Ecaterina"
                        }
                    ]
                }
            },
            {
                "__metadata": {
                    "id": "cef40fef-e80a-4c0e-a08c-31bd9f307196",
                    "uri": "https://bostonscientificeur.sharepoint.com/sites/RegulatoryAffairs-VoiceoftheCustomer/_api/Web/Lists(guid'1cd980a0-1195-48d0-9cd1-9f96f58e2a44')/Items(67)",
                    "etag": "\"6\"",
                    "type": "SP.Data.TestListItem"
                },
                "Development": {
                    "__deferred": {
                        "uri": "https://bostonscientificeur.sharepoint.com/sites/RegulatoryAffairs-VoiceoftheCustomer/_api/Web/Lists(guid'1cd980a0-1195-48d0-9cd1-9f96f58e2a44')/Items(67)/Development"
                    }
                }
            }
        ]
    }
}

Answer

Overview of the JSON Structure

The provided content is a JSON response typically returned from an API call to SharePoint, specifically targeting a list of items within a SharePoint site. Here’s a simple breakdown of what each part signifies.

Key Components

  1. Root Object:

    • The root object is denoted by "d", indicating that it begins the data structure.
  2. Results Array:

    • The "results" key contains an array of objects, each representing an item in a SharePoint list.
  3. Item Metadata:

    • Each item has a "__metadata" object that provides specific information about that item:
      • id: A unique identifier for the item.
      • uri: A link to access the item in SharePoint.
      • etag: A version identifier for concurrency.
      • type: Specifies the type of the item, often categorized by the nature of the data (in this case, it indicates SP.Data.TestListItem).
  4. Development Field:

    • Each item has a "Development" key, which can either contain:
      • A nested "results" array, listing associated users (user information), or
      • An __deferred object (with a URI) indicating that more data is available but has not yet been loaded completely.
  5. User Information:

    • Within the "Development" results, each user object contains:
      • "__metadata": Contains metadata specific to the user.
      • Title: This field typically contains the name of the user.

Example Breakdown

Here’s an illustration using the first item in the results array:

{
   "__metadata": {
       "id": "b080203d-5882-459c-98f2-9cf26e32d353",
       "uri": "https://bostonscientificeur.sharepoint.com/sites/RegulatoryAffairs-VoiceoftheCustomer/_api/Web/Lists(guid'1cd980a0-1195-48d0-9cd1-9f96f58e2a44')/Items(1)",
       "etag": "\"13\"",
       "type": "SP.Data.TestListItem"
   },
   "Development": {
       "__deferred": {
           "uri": "https://bostonscientificeur.sharepoint.com/sites/RegulatoryAffairs-VoiceoftheCustomer/_api/Web/Lists(guid'1cd980a0-1195-48d0-9cd1-9f96f58e2a44')/Items(1)/Development"
       }
   }
}

Breakdown:

  • Item ID: Identified as b080203d-5882-459c-98f2-9cf26e32d353.
  • Access URI: The item can be accessed via the provided URI.
  • Etag: The version number is 13, indicating the item's version in SharePoint.
  • Type: Indicates this item belongs to the TestListItem group.

In this case, the Development field does not directly provide user information but instead refers to more data that can be accessed later.

Importance of Each Field

  • IDs and URIs: Essential for uniquely identifying and accessing items.
  • Etag: Useful for maintaining data integrity and concurrency control by tracking versions.
  • User Titles: Provides context about which users are associated with each item, which can be valuable for reporting or display purposes.

Conclusion

This JSON structure provides a detailed overview of SharePoint list items and their metadata, enabling developers and data scientists to effectively interact with SharePoint data through APIs. Understanding each component of this structure is important for manipulating, querying, and displaying data within applications or reports.

For further exploration into interacting with SharePoint data using APIs, consider leveraging resources from the Enterprise DNA Platform.

Create your Thread using our flexible tools, share it with friends and colleagues.

Your current query will become the main foundation for the thread, which you can expand with other tools presented on our platform. We will help you choose tools so that your thread is structured and logically built.

Description

This guide provides a comprehensive breakdown of a JSON response from SharePoint APIs, detailing key components such as metadata, results arrays, and user information, crucial for developers and data scientists working with SharePoint data.