Problem using Insightly API within Google Sheets to retrieve opportunities

Hi,

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?

Thanks!

0

Comments

1 comment
  • Hello Richard,

    Authorization needs to be passed in the request header. Could you please try that?

     

    Thanks!

    0
    Comment actions Permalink

Please sign in to leave a comment.