Office 365: Where are modern pages comments stored?

As you know, SPO Communication Sites allows to create a special type of page called Post News that provide a comments area where any user can type comments about the post. But, where are these comments actually stored? This a great question and the answer is that page comments are stored in a hidden list you can discover by using SharePoint Designer 2013 (SPD 2013):

image

If you browse list details in SPD 2013, you will see that the list is storing comments information:

image

But here is where I have found a great challenge: so far I have not been able to access to comments information stored in the list no matter if I use a tool to easily access this information (CAL Designer or SharePoint Online Client browser) or some PowerShell coding.

image

Update: Fortunately there is a way to get this comments by means of a REST call as you can read in the following article: Vardhaman Deshpande

http://www.vrdmn.com/2017/07/working-with-page-comments-rest-api-in.html

As you can read there, modern page comments are not stored in a list, they are stored in an independent data storage.

Office 365: Where are modern pages comments stored?

As you know, SPO Communication Sites allows to create a special type of page called Post News that provide a comments area where any user can type comments about the post. But, where are these comments actually stored? This a great question and the answer is that page comments are stored in a hidden list you can discover by using SharePoint Designer 2013 (SPD 2013):

image

If you browse list details in SPD 2013, you will see that the list is storing comments information:

image

But here is where I have found a great challenge: so far I have not been able to access to comments information stored in the list no matter if I use a tool to easily access this information (CAL Designer or SharePoint Online Client browser) or some PowerShell coding.

image

Office 365: ¿Dónde se guardan los comentarios de páginas modernas de SPO? (I)

Cómo sabéis, las páginas modernas de SPO de tipo Post News incorporan una zona de comentarios en la que se pueden realizar “comentarios” sobre la página. Una pregunta que os puede rondar la cabeza es: ¿Dónde se guardan estos comentarios?¿En Yammer?¿En la propia página?…¿O dónde? La respuesta es que se guardan en una lista oculta que podemos acceder mediante SharePoint Designer 2013:

image

Si accedemos a los detalles de la lista, podremos ver que en la misma hay información almacenada:

image

Lo que no encontré en su momento es una forma rápida, ni siquiera programáticamente, para acceder al valor de los comentarios…ni siquiera con CAML Designer o el SharePoint Online Client Browser he podido llegar a ver esa información.

image

Update a fecha 26/07/2017: Afortunadamente si que hay una forma de leer estos comentarios vía REST como podéis leer en este post de Vardhaman Deshpande

http://www.vrdmn.com/2017/07/working-with-page-comments-rest-api-in.html

Interesante que los comentarios no se guardan en la lista, sino en un data store independiente.