Facebook Graph API not working on UrlFetchApp

Question

I run a query on Facebook Graph API Explorer successfully but when I run the same query on Google Apps Script with UrlFetchApp I get an Error - Invalid argument. The query is this:

https: //graph.facebook.com/v4.0/act_1015703131******/insights?fields=spend&level=account&date_preset=yesterday&filtering=[{field:campaign.name,operator:CONTAIN,value:perf},{field:adset.name,operator:NOT_CONTAIN,value:rmk}]&access_token=********

When I run the same query without filtering it works as expected!

Json Result:

EDIT: I tried to encode the filtering parameters and it throws a new error:

Request failed for https://graph.facebook.com returned code 400. Truncated server response: {"error":{"message":"(#100) param filtering must be an array.","type":"OAuthException","code":100,"fbtrace_id":"AMw2vkaHXbuiVSQuSNg28yZ"}} (use muteHttpExceptions option to examine full response)

What is causing the problem exactly since the error doesn't give any specific description?

It is UrlFetchApp and the url I shared on my question without the asterisks of course. — yannis-sp, Nov 01 '19 at 13:02
Look at that : https://developers.google.com/apps-script/reference/url-fetch/url-fetch-app — Kevkeev13, Nov 01 '19 at 13:04
call it without the filter, see the JSON object you get back and work from there — Kevkeev13, Nov 01 '19 at 13:22
Possible duplicate of [Encode URL in JavaScript?](https://stackoverflow.com/questions/332872/encode-url-in-javascript) — TheMaster, Nov 01 '19 at 13:50
No it's not a duplicate because none of the suggestions solved my problem :/ — yannis-sp, Nov 01 '19 at 14:02

score 3 · Accepted Answer · answered Nov 01 '19 at 14:28

First put your filtering value into an array:

var fbCallFiltering = [{'field':'campaign.name','operator':'CONTAIN','value':'perf'},{'field':'adset.name','operator':'NOT_CONTAIN','value':'rmk'}];

Then use JSON.stringify()

var fbCallFilteringString = encodeURIComponent(JSON.stringify(fbCallFiltering));

Finally use the fbCallFilteringString variable in the URL you use to make the UrlFetchApp call after the &filtering=.

This should work.

Facebook Graph API not working on UrlFetchApp

1 Answers1

Linked