Alteryx Designer Desktop Discussions

MadMax · ‎03-02-2017

I'm using the downloading tool with a correct URL and I got the following error:

HTTP/1.1 407 Proxy Authentication Required
Proxy-Authenticate: NEGOTIATE
Proxy-Authenticate: NTLM
Proxy-Authenticate: BASIC realm="MillwardBrownDC"
Cache-Control: no-cache
Pragma: no-cache
Content-Type: text/html; charset=utf-8
Proxy-Connection: close
Set-Cookie: BCSI-CS-f89c73c53b0f638a=2; Path=/
Connection: close
Content-Length: 849

I've read that it should be due to my company is using a proxy for some outbound connections but the thing is that when I try to do this with an internet browser, I don't have any problem.

If I do this coding with Java, I don't have problems either and I don't need to tell java any user or password to connect through any proxy.

The URL that I'm trying to access belongs to an OSM API. I've tried using a URL to access to the Google Places API from Alteryx and it works like a charm.

Any idea how to solve this?

Thanks!

MadMax · ‎03-03-2017

It seems that has nothing to do with any proxy authentication since I tested it from home too and I got the following error:

HTTP/1.1 400 Bad Request
Date: Thu, 02 Mar 2017 19:42:12 GMT
Server: Apache/2.4.18 (Ubuntu)
Vary: Accept-Encoding
Content-Encoding: gzip
Content-Length: 441
Connection: close
Content-Type: text/html; charset=utf-8

Sadly, I still have no idea how to solve it.

patrick_mcauliffe · ‎03-09-2017

Hey, @MadMax I've been through dozens of variations on this issue.

Can you tell me what you see when you get to the LAN Settings screen?

Internet Explorer --> Go to Tools --> Internet Options --> Connections Tab --> LAN Settings

MadMax · ‎03-10-2017

Hi @patrick_mcauliffe,

Thanks for you reply.

Here it is what I see in my LAN Settings screen:

Thanks in advance!

patrick_mcauliffe · ‎03-10-2017

@MadMax

That's about what I expected.

There are a few options, almost all involve talking to your IT Security team, but let's just try a workaround first.

Delete the text in the address box, then uncheck the first two boxes.

Try to run your workflow again immediately after clicking OK.

MadMax · ‎03-10-2017

Hi Patrick,

That's solved a problem that I was just having with another API (thank you very much!) but not the one that I still have with the OSM API.

I'm trying to download a JSON object from this URL. I can see on my browser (Chrome/Firefox/IE) and, as I've already said, in my Java code, but with alteryx I got the following error.

DownloadHeaders

HTTP/1.1 400 Bad Request
Date: Fri, 10 Mar 2017 15:16:21 GMT
Server: Apache/2.4.18 (Ubuntu)
Vary: Accept-Encoding
Content-Encoding: gzip
Content-Length: 441
Connection: close
Content-Type: text/html; charset=utf-8

DownloadData

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
<head>
<meta http-equiv="content-type" content="text/html; charset=utf-8" lang="en"/>
<title>OSM3S Response</title>
</head>
<body>

The data included in this document is from www.openstreetmap.org. The data is made available under ODbL.
Error: line 1: parse error: Unknown type "%" 
Error: line 1: parse error: An empty query is not allowed 
Error: line 1: parse error: Unknown type "3" 
Error: line 1: parse error: An empty query is not allowed 
Error: line 1: parse error: Unknown type "E" 
Error: line 1: parse error: An empty query is not allowed 
Error: line 1: parse error: Unknown type ";" 
Error: line 1: parse error: An empty query is not allowed

</body>
</html>

I'll try later from home to see if now it's working.

Thanks!

patrick_mcauliffe · ‎03-10-2017

@MadMax

In the Download tool configuration, uncheck "Encode URL".

MadMax · ‎03-13-2017

Sorry for the delay in my reply.

Now, it works!!!

Thanks a million!