Forum Discussion

Drawyiana's avatar
Drawyiana
New Member
8 years ago
Solved

Facebook: (#100) Tried accessing nonexisting field (comments) on node type (Page)

Hello Power BI Community,

 

I could solve the problem by entering the code:

 

let
    Source = Facebook.Graph("https://graph.facebook.com/v2.8/microsoftbi/posts?limit=100"),
    #"Expanded object_link" = Table.ExpandRecordColumn(Source, "object_link", {"connections"}, {"object_link.connections"}),
    #"Expanded object_link.connections" = Table.ExpandRecordColumn(#"Expanded object_link", "object_link.connections", {"comments"}, {"object_link.connections.comments"}),
    #"Expanded object_link.connections.comments" = Table.ExpandTableColumn(#"Expanded object_link.connections", "object_link.connections.comments", {"created_time", "from", "message", "id", "object_link"}, {"object_link.connections.comments.created_time", "object_link.connections.comments.from", "object_link.connections.comments.message", "object_link.connections.comments.id", "object_link.connections.comments.object_link"})
in
    #"Expanded object_link.connections.comments"

 

But now my question is, if I can also see the replies of the comments? Is there another code?

 

So my desired order would look like this:

 

Post -> Comment -> Replies to the comments 

 

Kind of like this:

 

But I would also like to see all replies, so not only one single reply.

 

Regards

  • v-yulgu-msft's avatar
    v-yulgu-msft
    8 years ago

    Hi Drawyiana,

     

    After getting all Posts, please expand corresponding items following below sequence:

    object_link

    -> object_link.connections

    -> object_link.connections.comments

    -> object_link.connections.comments.object_link

    -> object_link.connections.comments.object_link.connections

    -> object_link.connections.comments.object_link.connections.comments

    -> object_link.connections.comments.object_link.connections.comments.message

     

    let
Source = Facebook.Graph("xxxxxxxx"),
#"Expanded object_link" = Table.ExpandRecordColumn(Source, "object_link", {"connections"}, {"object_link.connections"}),
#"Expanded object_link.connections" = Table.ExpandRecordColumn(#"Expanded object_link", "object_link.connections", {"comments"}, {"object_link.connections.comments"}),
#"Expanded object_link.connections.comments" = Table.ExpandTableColumn(#"Expanded object_link.connections", "object_link.connections.comments", {"object_link"}, {"object_link.connections.comments.object_link"}),
#"Expanded object_link.connections.comments.object_link" = Table.ExpandRecordColumn(#"Expanded object_link.connections.comments", "object_link.connections.comments.object_link", {"connections"}, {"object_link.connections.comments.object_link.connections"}),
#"Expanded object_link.connections.comments.object_link.connections" = Table.ExpandRecordColumn(#"Expanded object_link.connections.comments.object_link", "object_link.connections.comments.object_link.connections", {"comments"}, {"object_link.connections.comments.object_link.connections.comments"}),
#"Expanded object_link.connections.comments.object_link.connections.comments" = Table.ExpandTableColumn(#"Expanded object_link.connections.comments.object_link.connections", "object_link.connections.comments.object_link.connections.comments", {"message"}, {"object_link.connections.comments.object_link.connections.comments.message"})
in
#"Expanded object_link.connections.comments.object_link.connections.comments"

     

    Best regards,

    Yuliana Gu

5 Replies

  • Drawyiana's avatar
    Drawyiana
    New Member
    8 years ago

    Hello Power BI Community,

     

    I could solve the problem by entering the code:

     

    let
    Source = Facebook.Graph("https://graph.facebook.com/v2.8/microsoftbi/posts?limit=100"),
    #"Expanded object_link" = Table.ExpandRecordColumn(Source, "object_link", {"connections"}, {"object_link.connections"}),
    #"Expanded object_link.connections" = Table.ExpandRecordColumn(#"Expanded object_link", "object_link.connections", {"comments"}, {"object_link.connections.comments"}),
    #"Expanded object_link.connections.comments" = Table.ExpandTableColumn(#"Expanded object_link.connections", "object_link.connections.comments", {"created_time", "from", "message", "id", "object_link"}, {"object_link.connections.comments.created_time", "object_link.connections.comments.from", "object_link.connections.comments.message", "object_link.connections.comments.id", "object_link.connections.comments.object_link"})
in
    #"Expanded object_link.connections.comments"

     

    But now my question is, if I can also see the replies of the comments? Is there another code?

     

    So my desired order would look like this:

     

    Post -> Comment -> Replies to the comments 

     

    Kind of like this:

     

    help.JPG

    But I would also like to see all replies, so not only one single reply.

     

    Regards

  • v-yulgu-msft's avatar
    v-yulgu-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    8 years ago

    Hi Drawyiana,

     

    After getting all Posts, please expand corresponding items following below sequence:

    object_link

    -> object_link.connections

    -> object_link.connections.comments

    -> object_link.connections.comments.object_link

    -> object_link.connections.comments.object_link.connections

    -> object_link.connections.comments.object_link.connections.comments

    -> object_link.connections.comments.object_link.connections.comments.message

     

    let
Source = Facebook.Graph("xxxxxxxx"),
#"Expanded object_link" = Table.ExpandRecordColumn(Source, "object_link", {"connections"}, {"object_link.connections"}),
#"Expanded object_link.connections" = Table.ExpandRecordColumn(#"Expanded object_link", "object_link.connections", {"comments"}, {"object_link.connections.comments"}),
#"Expanded object_link.connections.comments" = Table.ExpandTableColumn(#"Expanded object_link.connections", "object_link.connections.comments", {"object_link"}, {"object_link.connections.comments.object_link"}),
#"Expanded object_link.connections.comments.object_link" = Table.ExpandRecordColumn(#"Expanded object_link.connections.comments", "object_link.connections.comments.object_link", {"connections"}, {"object_link.connections.comments.object_link.connections"}),
#"Expanded object_link.connections.comments.object_link.connections" = Table.ExpandRecordColumn(#"Expanded object_link.connections.comments.object_link", "object_link.connections.comments.object_link.connections", {"comments"}, {"object_link.connections.comments.object_link.connections.comments"}),
#"Expanded object_link.connections.comments.object_link.connections.comments" = Table.ExpandTableColumn(#"Expanded object_link.connections.comments.object_link.connections", "object_link.connections.comments.object_link.connections.comments", {"message"}, {"object_link.connections.comments.object_link.connections.comments.message"})
in
#"Expanded object_link.connections.comments.object_link.connections.comments"

     

    Best regards,

    Yuliana Gu

    • Drawyiana's avatar
      Drawyiana
      New Member
      8 years ago

      Thank you so much! I finally can see all replies to one post.

       

      Is there also the possibility to see the user names / id´s of the repliers?

       

      Regards,

       

      Sebastian

      • v-yulgu-msft's avatar
        v-yulgu-msft
        Icon for Microsoft Employee rankMicrosoft Employee
        8 years ago

        Hi Drawyiana,

         

        object_link

        -> object_link.connections

        -> object_link.connections.comments

        -> object_link.connections.comments.object_link

        -> object_link.connections.comments.object_link.connections

        -> object_link.connections.comments.object_link.connections.comments

        -> object_link.connections.comments.object_link.connections.comments.from

        -> object_link.connections.comments.object_link.connections.comments.from.name

         

        Best regards,

        Yuliana Gu