How to download facebook report using Insights API Asynchronous Jobs?

Question

Hi I'am new to facebook marketing API. I want to download account complete report in csv format for which I am using Insights API Asynchronous Jobs , Using which I am able to get "report_run_id" and after that I made api request for this link .Its giving wrong response. Can anybody help me how can download report in csv format.code which i tried is:

OkHttpClient client = new OkHttpClient();    
Request request = new Request.Builder()
  .url("https://www.facebook.com/ads/ads_insights/export_report/?report_run_id=279445242544715&name=reports&format=csv")
  .get()
  .build();

Response response = client.newCall(request).execute();
if(response.isSuccessful()){
 String resposes=response.body().string();
}

You found a solution on how to do it with the API?

AgeValed
– AgeValed

2019-03-06 21:05:18 +00:00
Commented Mar 6, 2019 at 21:05 — AgeValed
– AgeValed, Commented Mar 6, 2019 at 21:05

Paul Bain · Accepted Answer · 2017-10-17 14:29:27Z

4

I'll give examples using curl, but you should be able to translate these to javascript easily.

Using the report_run_id, you can query the completeness of the async query, for example:

curl -G \
  -d 'access_token=<ACCESS_TOKEN>' \
  https://graph.facebook.com/v2.10/1000002

This should eventually give you a completion of 100%:

{
  "id": "6044775548468",
  "account_id": "1010035716096012",
  "time_ref": 1459788928,
  "time_completed": 1459788990,
  "async_status": "Job Completed",
  "async_percent_completion": 100
}

You then need to query the report_run_id for with the insights edge:

curl -G \
  -d 'access_token=<ACCESS_TOKEN>' \
  https://graph.facebook.com/v2.10/<YOUR_REPORT_RUN_ID>/insights

answered Oct 17, 2017 at 14:29

Paul Bain

4,4171 gold badge19 silver badges31 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Naved Ahmad Over a year ago

Great, Worked for me!

Sodved Over a year ago

Is there any way to get a CSV export via the API?

linehrr Over a year ago

hi guys, where to find the access token ? I am struggling to find the access token here.

Collectives™ on Stack Overflow

How to download facebook report using Insights API Asynchronous Jobs?

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related