[Qlik Facebook Insights Connector] How to extract every post id from a Facebook Page

[framacdev]

Hello Community,

I am working on extracting data from the Qlik Facebook Insights Connector.  I want to automatically extract the post ids from a Facebook page. I would like to extract data such as likes, reactions, ecc.. from single Facebook posts.

Is there a defined table that I can take a look at within the connector?

I appreciate your help.

Thank you

[chrisbrain]

Have you tried the Feed table in the Facebook Fan Pages Connector?

It has columns for total comments, likes and reactions counts.

[framacdev]

Hi Chris, thanks for answering my post.

I am not using the Facebook Fan Pages Connector because we decided to purchase the Facebook Insights Connector. After all, it gives more insights.

I can extract the daily aggregated total for reactions by using the table page_actions_post_reactions_total within the Facebook Insights Connector.

The issue is that when it comes to extracting data from the Post tables in the Facebook Insights Connector I need to manually add the Page_Id and the Post_Id in the Post ID field as shown on the attached screenshot.

I would like to automate this process by automatically adding the Post_Id.

Thank you,

Francesco

[skaredovs]

Hi!

@framacdev , have you solve the issue?

BR,

Konstantins