I have been trying to set up an API call to the USPS to lookup zip +4 for a selected address in a tableau worksheet. the API looks like this:
http://production.shippingapis.com/ShippingAPITest.dll?API=Verify &XML=<AddressValidateRequest USERID="651NORTH0110"><Address ID="0"><Address1></Address1> <Address2>6406 Ivy Lane</Address2><City>Greenbelt</City><State>MD</State> <Zip5></Zip5><Zip4></Zip4></Address></AddressValidateRequest>
Several issues have come up. when tableau looks at the url string it sees anything in the <> brackets as a field that is to be inserted so it does not work
I have created a table with each of these fields ie: Zip5, /Zip5, State, /State etc so tableau will allow them to be in the string but when it sends the url command the http looks like this:
I get a format error as follows
<?xml version="1.0" encoding="UTF-8"?>
<Description>XML Syntax Error: Please check the XML request to see if it can be parsed.</Description>
It is not sending the <> characters, instead it is replacing them %2F
IS this possible or is there a better way?
BTW i dont have the WEB API plugin
Have you found a solution for this? What are the data sources in use and is is possible to use an extract in the .twbx that has been posted here.