Problem using Insightly API within Google Sheets to retrieve opportunities
I am trying to call the Insightly API to copy Opportunities into a Google Sheet. I am getting the following error message:
Request failed for https://api.insight.ly/v2.2/Opportunities%20Authorization:%20Basic%20<my Base64 encoded API key> returned code 400. Truncated server response: <!DOCTYPE html> <html> <head> <title>Runtime Error</title> <meta name="viewport" content="width=device-width" /> <... (use muteHttpExceptions option to examine full response). (line 19, file "Code")
Can anyone suggest what might be wrong or even better provide some sample code that works in Google Sheets?