Re: QSYS2.HTTP_GET problem with the USPS APIs

[Jack Woehr <jwoehr@xxxxxxxxxxxxxxxxxxxxxxxx>]

Yeah, but you gotta get past SQL's quote parsing, methinks.


On Mon, Jan 3, 2022 at 10:02 AM Sam_L <lennon_s_j@xxxxxxxxxxx> wrote:

> Won't my url_encode take care of this?
>
> On 1/3/2022 11:57 AM, Jack Woehr via MIDRANGE-L wrote:
> > Quick guess is that you are condemned to quote-escaping purgatory.
> >
> > On Mon, Jan 3, 2022 at 9:51 AM Sam_L <lennon_s_j@xxxxxxxxxxx> wrote:
> >
> > > QSYS2.HTTP_GET('http://production.shippingapis.com/ShippingAPI.dll'
> concat
> > > url_encode('?API=Verify' concat
> > >       '&XML='concat
> > >       '<AddressValidateRequest USERID="xxxxxxxxx">' concat
>
> --
> 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