topic [Qlik Facebook Insights Connector] How to extract every post id from a Facebook Page in Connectivity & Data Prep

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

framacdev — Fri, 02 Apr 2021 08:54:12 GMT

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

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

chrisbrain — Wed, 22 Apr 2020 05:50:57 GMT

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

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

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

framacdev — Wed, 22 Apr 2020 13:03:03 GMT

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

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

skaredovs — Mon, 26 Sep 2022 09:24:07 GMT

Hi!

@framacdev , have you solve the issue?

BR,

Konstantins