Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

Reply
HassanMoosa
Helper I
Helper I

How to get my social media pages live data through API call

Hello, right now I am struggling with importing data from facebook, instagram, twitter, linkedin, google analytics, google ads, youtube, etc.  I dont want to use 3rd party application to do this.  I need to connect directly with social media api's.  I want to achieve this ASAP but without using free or paid 3rd party apps.

 

- I also tried to find solution from youtube but it was two years old tutorial.  

- I am new to work with APIs I tried to follow facebook API Guidelines but unable to have success also I dont know on which IDE i can test quires right now I am using browsers search bar to excecute queries.  

- Is it possible if someone can provide me guided tutorial by screensharing if as per your convience?

 

Can anyone guide me on how to achieve this? Thanks in advance

2 REPLIES 2
HassanMoosa
Helper I
Helper I

Thank you so much @rubayatyasmin  for providing initial steps in detail I will follow your guidlines and will get back to you once got success. 

rubayatyasmin
Super User
Super User

Given the complexity and the number of APIs you're working with, it's not feasible to provide a complete guide here. However, I can give you an overview of the general steps you need to take, and guide you towards the official documentation of each platform, which should be your primary source of information.

Here are the basic steps you might take:

  1. Setting Up Your Developer Account: Most social media platforms will require you to have a developer account in order to access their APIs. Setting up a developer account is usually free and involves agreeing to the terms of service.

  2. Creating an App: Once you have your developer account, you will often need to create an "app" in the developer platform. This "app" is not a traditional application, but rather a set of credentials (API key, secret, etc.) that you will use to authenticate your requests.

  3. Getting Access Tokens: Once you've created your app, you will need to get access tokens. These tokens are used to authorize your API calls. The process of getting access tokens can vary from one platform to another, but often involves redirecting the user to a login page where they grant your app access.

  4. Making API Calls: After you have your access tokens, you can start making API calls. These are typically HTTP requests that you send to the platform's API endpoint. The specific format of these requests can vary from one platform to another, but you can find this information in the platform's API documentation.

  5. Handling the Response: When you make an API call, the server will send back a response. This response may contain the data you requested, or it may contain an error message. You will need to write code to handle these responses and extract the data you need.

To test API requests you can use platforms like Postman, Insomnia or even cURL commands in your terminal, which are much better suited for this than a browser's search bar.

Let me give you the links for each platform's developer portal and their API documentation:

  1. Facebook & Instagram: Facebook owns Instagram, so they share the same Graph API. You can find their developer portal at https://developers.facebook.com/, and the API documentation at https://developers.facebook.com/docs/apis-and-sdks/.

  2. Twitter: Twitter's developer portal can be found at https://developer.twitter.com/, and the API documentation at https://developer.twitter.com/en/docs.

  3. LinkedIn: LinkedIn's developer portal is at https://www.linkedin.com/developers/, and the API documentation can be found at https://docs.microsoft.com/en-us/linkedin/shared/api-guide.

  4. Google Analytics & Google Ads: Google has a comprehensive developer portal at https://developers.google.com/, and you can find the API documentation for Google Analytics at https://developers.google.com/analytics and for Google Ads at https://developers.google.com/google-ads.

  5. YouTube: YouTube's developer portal can be found at https://developers.google.com/youtube and the API documentation at https://developers.google.com/youtube/v3.

Also, please remember that dealing with APIs involves handling sensitive data, both your own and possibly your users'. Always be careful with access tokens and other credentials, never share them and ensure they are securely stored.

 

see if the article helps

 

https://research.aimultiple.com/social-media-scraping/

https://towardsdatascience.com/how-to-extract-data-from-the-twitter-api-using-python-b6fbd7129a33

 

 

rubayatyasmin_0-1689517080227.png


Did I answer your question? Mark my post as a solution!super-user-logo

Proud to be a Super User!


Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.