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?

select *
from table(systools.httppostclobverbose(systools.urlencode('
https://secure.shippingapis.com/ShippingAPI.dll?API=Verify&xml=','')

,systools.urlencode('<httpHeader><header name="Content‑Type"
value="text/xml; charset=utf‑8"/></httpHeader>','')

,systools.urlencode('<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;

jay

On Wed, Nov 9, 2022 at 8:24 PM Jack Woehr via MIDRANGE-L <
midrange-l@xxxxxxxxxxxxxxxxxx> wrote:

See https://developer.ibm.com/tutorials/dm-1105httprestdb2/ especially the
section "URL encoding/decoding"

On Wed, Nov 9, 2022 at 6:20 PM Jack Woehr <jwoehr@xxxxxxxxxxxxxxxxxxxxxxxx

wrote:

you have to URI encode the xml

On Wed, Nov 9, 2022 at 5:41 PM Jay Vaughn <jeffersonvaughn@xxxxxxxxx>
wrote:

surely someone is using this out there?

what am I doing wrong?
I keep getting error message...

80040B19XML Syntax Error: Please check the XML request to see if it can

be

parsed.USPSCOM::DoAuth

so I know I am getting there... just something wrong with my xml
delivery...
my userid all XXXXX'x for security...

select RESPONSEMSG
from table(systools.httppostclobverbose('
https://secure.shippingapis.com/ShippingAPI.dll?API=Verify&xml='
,'<httpHeader><header
name="Content-type" value="x-www-form-urlencoded"/></httpHeader>'


,systools.urlencode('<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;

when I run in postman, all good... I get the verification xml back...
using the same url, same xml string...
in postman I choose x-www-form-urlencoded and XML


tia...

Jay

--

*JACK WOEHR, IBM Champion 2021-2022
<https://www.credly.com/users/jack-woehr/badges>*

*SENIOR IBM i ENGINEER*

303.847.8442
jwoehr@xxxxxxxxxxxxxxxxxxxxxxxx
stay connected
<https://www.linkedin.com/company/absolute-performance-inc./>

<https://www.absolute-performance.com/>
www.absolute-performance.com

NON-DISCLOSURE NOTICE: This communication including any and all
attachments is for the intended recipient(s) only and may contain

confidential and privileged information. If you are not the intended
recipient of this communication, any disclosure, copying further

distribution or use of this communication is prohibited. If you received
this communication in error, please contact the sender and

delete/destroy all copies of this communication immediately.
--
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