Re: usps verify address api

thanks Chris, with your suggestion I got it working... along with 1 more
thing...
the API=RateV4 should be API=Verify...

so there was nothing related to urlencode with this implementation I
was missing using the other systools.httpgetclobverbose that I was
overlooking..

appreciate all the input... this now works... thanks

Jay

On Thu, Nov 10, 2022 at 9:43 AM Hiebert, Chris <chris.hiebert@xxxxxxxxxxxxxx>
wrote:

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?
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: https://amazon.midrange.com