Download Tool Payload Configuration - Comma in front of Values

[Aguisande]

Hi All,

I’m having a hard time trying to figure this out. I’m trying to use a Web Service (definition here: http://www.webservicex.net/geoipservice.asmx?WSDL), so I made this workflow:

As you can see, URL and IP to check are there, and the way to call the WS is:

http://www.webservicex.net/geoipservice.asmx/GetGeoIP?IPAddress=IPAddress (In this case: http://www.webservicex.net/geoipservice.asmx/GetGeoIP?IPAddress=200.75.200.2)

The expected response is:

<GeoIP xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns="http://www.webservicex.net/">
<ReturnCode>1</ReturnCode>
<IP>200.75.200.2</IP>
<ReturnCodeDetails>Success</ReturnCodeDetails>
<CountryName>Panama</CountryName>
<CountryCode>PAN</CountryCode>
</GeoIP>

But when I run the workflow, I can see from the [Downloaded Data] that there is a comma preceding the value of the IP Address field, what causes an “Invalid IP address” Return Code.

What am I doing wrong / missing here?

Thanks a lot

[MarqueeCrew]

I didn't receive the same error message.  I ran yours without the comma issue. Mine said "No XML Elemeents named "CountryName" were found.

I created a formula to construct the query string and then point to it within the download payload.

Panama

[rdoptis]

For this API, you don't put the IP in the payload. Just construct your URLs such as (http://www.webservicex.net/geoipservice.asmx/GetGeoIP?IPAddress=200.75.200.2) and feed that whole thing into the URL field of the download tool on the Basic Tab. The only other thing you need to set is to make sure the download tool is performing a GET from the Payload Tab. This will bring back what you want. 

Once your data come back from the download tool, use the XML parse tool to get your data into table form. 

Best,

Ryan

[danielbrun2 · Accepted solution]

Hi,

As far as I can see, the issue is that you have the IP address two times in the payload. The configuration should look like this which will put the IPaddress in the query string.

Not like this:

But like this:

Let me know if it works.

Best regards,

Daniel

[Aguisande]

That's it!

I supposed that you must name the Value (thats why the first IPAddress is there!)

Thanks a lot!