It looks like you are merging the GET request and a POST request. Move the API and &XML into the Request Message instead of the URL.
It appear you should be doing something like this:
select *
from table(systools.httppostclobverbose('
https://secure.shippingapis.com/ShippingAPI.dll'
,'<httpHeader><header name="Content-type" value="text/xml"/></httpHeader>'
,'API=RateV4&XML=<AddressValidateRequest USERID="xxxxxxxxxxxx"><Revision>1</Revision><Address ID="0"><Address1>4166 Berkeley Landing</Address1></Address2><City>Kennesaw</City><State>GA</State><Zip5>30144</Zip5></Zip4></Address></AddressValidateRequest>'
)
) as request;
Which gave me this response, because of user xxx.
<?xml version="1.0" encoding="UTF-8"?>
<Error><Number>80040B19</Number><Description>XML Syntax Error: Please check the XML request to see if it can be parsed.(B)</Description><Source>USPSCOM::DoAuth</Source></Error>
--
Chris Hiebert
Senior Programmer/Analyst
Disclaimer: Any views or opinions presented are solely those of the author and do not necessarily represent those of the company.
From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of Jay Vaughn
Sent: Thursday, November 10, 2022 5:46 AM
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxxxxxxxx>
Subject: Re: usps verify address api
Thanks Jack... I did take a look at the link you provided... after that I
applied the following and still have no luck...
I added, value="text/xml; charset=utf‑8" and encoded url, header, and xml
(just to play it safe... and every combination in between)... still cannot
get a valid response...
anymore clues?
midrange.com
