Re: usps verify address api

[Jack Woehr <jwoehr@xxxxxxxxxxxxxxxxxxxxxxxx>]

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
> --
> 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