我在一个名为"profile"的表中有一列，它以下面的格式存储信息：

[{"id":"X","type":"location"}],"avatar":{"id":"X","type":"Avatar"},"gender":{"id":"F","type":"Gender","value":"F"},"contacts":[{"id":"0230", "role": "teacher", "school": "XYZ"}],"lastName":"","nickname":"B","religion":{"id":"Unknown","type":"Religion"},"birthDate":"2a","ethnicity":{"id":"NotStated","type":"Ethnicity","category":"OtherEthnicGroups"},"firstName":"","nameTitle":""}

如何访问contacts中role和school的值？我尝试使用：profile->'contacts'->'role'和profile->'contacts'->0->'role'，但这两个都没有按预期工作。
先谢谢你。