Forum Discussion

Colin's avatar
Colin
Frequent Visitor
10 years ago
Solved

Facebook Page Likes

Hi everyone,   I am building a dashboard for my Company's marketing department. So far, I have been able to load all of the data related to our page's "Posts" using the Get Data wizard with Faceboo...
Need Help
  • MattAllington's avatar
    MattAllington
    10 years ago

    I believe this is explicitly prevented by Facebook for either privacy and/or corporate IP purposes

DataChant's avatar
DataChant
Most Valuable Professional
10 years ago

Try to use the field since as a parameter in the URL. More details here.

 

sarafenwick's avatar
sarafenwick
Frequent Visitor
9 years ago

I'm having trouble getting the since function to work in conjunction with the access token... can you provide how you would modify the below to include a since period? 

 

let
    YourFacebookObjectName = "datachantblog",
    YourAccessToken = "Get the token from Facebook Graph Explorer, or APIGEE",
    Source = Json.Document(Web.Contents("https://graph.facebook.com/v2.7/" & YourFacebookObjectName & "/insights/page_fans?access_token=" & YourAccessToken)),
    data = Source[data],
    #"Converted to Table" = Table.FromList(data, Splitter.SplitByNothing(), null, null, ExtraValues.Error),
    #"Expanded Column1" = Table.ExpandRecordColumn(#"Converted to Table", "Column1", {"values"}, {"values"}),
    #"Expanded values" = Table.ExpandListColumn(#"Expanded Column1", "values"),
    #"Expanded values1" = Table.ExpandRecordColumn(#"Expanded values", "values", {"value", "end_time"}, {"value", "end_time"})
in
    #"Expanded values1"
  • DataChant's avatar
    DataChant
    Most Valuable Professional
    9 years ago

    Dear sarafenwick

    You can modify the line below and add the "since=2016-12-31" as a URL parameter after the question mark:

     

     Source = Json.Document(Web.Contents("https://graph.facebook.com/v2.7/" & YourFacebookObjectName & "/insights/page_fans?since=2016-12-31&access_token=" & YourAccessToken)),