OL Learn

Error resolving the URL : Error connecting with SSL

Hi OL Experts

I’m trying to do a query to Mailjet API which works in the internet browser
https://api.mailjet.com/v3/REST/message?CustomID=00056678_

But when execution from the workflow (including API key + password) I get this error message.
[0007] W3730 : Error resolving the URL : Error connecting with SSL.
[0007] HTTP Client Input: W1603 : Plugin failed - 10:51:14 (elapsed time: 00:00:00.018)

Do you have any advice?

I would surmise that the server is expecting a TLS encryption level that’s not supported by the HTTP Client Input task.

You will probably have to use a script instead.
Something like:

var http = new ActiveXObject("Microsoft.xmlhttp");
http.open("GET","https://api.mailjet.com/v3/REST/message?CustomID=00056678_",false);
http.send();

var fso = new ActiveXObject("Scripting.FileSystemObject");
var responseFile = fso.createTextFile(Watch.GetJobFileName(), true);
responseFile.writeLine(http.responseText);
responseFile.close();

Notes:

  • This code is untested, I wrote it off the top of my head, so you’ll probably have to tweak it.
  • The code overwrites the current job file.
  • No authentication is provided. If Mailjet supports basic authentication, then you can simply change your URL to use a format like https://username:password@api.mailjet.com/...

Thanks @Phil I will try this out.