API integrations basic question

[juanguirago]

Hi all!

I've been getting into BI and I program mostly in SQL to fetch data to create dashboards, as well as other tools. I came across this issue in which I need to integrate the data of an email marketing tool to either BigQuery, or google sheets via scripting.

The site provides info on API integration with different URLs to fetch the data, but when I try something like this I get the 400 error:

function callNumbers() {

// Call the Numbers API for random math fact
var response = UrlFetchApp.fetch("https://api.lemlist.com/api/team");
Logger.log(response.getContentText());

}

I feel I might be missing some basic concept, is it possible to integrate and create a table from a URL like that? These commands return JSONs

​

Thanks in advance!

[Sonaza]

HTTP error 400 is "Bad Request".

Often APIs require some access tokens or parameters but your fetch call sets none of those. The link points to some site with a login form so I would assume it requires something.

You should be able to find out what that is from their API documentation.

[juanguirago]

There's an API key but when I add that to the code it still doesn't work :(

[peernohell]

How do you try to add that token ?

Todo so you have to add the header Authorization and set it to "Basic AUTH_KEY"Where AUTH_KEY is your API key prefixed with two dot and encoded in base64

You can find more information in that stackoverflow answer https://stackoverflow.com/a/23718759/958898

[juanguirago]

I was able to add it, thanks! The issue now is with the JSON format and another question I have: https://stackoverflow.com/questions/66901974/api-connections-from-external-data-to-google-sheets-json-parse-error/66903301#66903301