Pull Linkedin Page insights (new followers, likes ...) using ADF

Question

Hello, I am trying to connect Linkedin to ADF using the REST API with the need of retriving key insights about my Linkedin page ! can you help on this ? Thank you

Answer 1

Hi @Wajih Arfaoui

Welcome to Microsoft Q&A platform and thanks for your query.

Yes, you can use Azure Data Factory (ADF) to pull LinkedIn page insights using the LinkedIn REST API. Here are the steps you can follow:

Create a LinkedIn App:

• Go to the LinkedIn Developer Portal and create a new app.
• Add the required permissions for the app to access the LinkedIn page insights API.
• Note down the Client ID and Client Secret of the app.

Create a Linked Service in ADF:

• In the ADF portal, create a new Linked Service of type REST.
• Enter the Client ID and Client Secret of the LinkedIn app in the Authentication section.
• Set the Base URL to https://api.linkedin.com/v2/.
• Test the connection to ensure its successful.

Create a Dataset in ADF:

• Create a new Dataset of type REST.
• Set the Linked Service to the one created in step 2.
• Set the Relative URL to the LinkedIn page insights API endpoint, e.g. organizations/{organizationId}/pageStatistics.
• Set the HTTP Method to GET.
• Define the required parameters and headers for the API call, such as the organizationId and X-Restli-Protocol-Version.
• Test the connection to ensure its successful.

Create a Pipeline in ADF:

• Create a new Pipeline and add a Web Activity.
• Set the Linked Service to the one created in step 2.
• Set the Dataset to the one created in step 3.
• Set the Method to GET.
• Run the pipeline to retrieve the LinkedIn page insights.

Note: You may need to adjust the API endpoint and parameters based on your specific requirements. Also, make sure to follow LinkedIn's API usage guidelines and rate limits to avoid any issues.

Please refer this documentation for REST API's in ADF.

I hope this helps! Let me know if you have any further questions.