scottklement.com

Hello
I have this problem:
If I Run on PostMan for test
https://storage.googleapis.com/shopify- ... on%2Fjsonl
I can download the result
---------------------
On server IBM i V 7.2
I get data from systool.HTTPgetCLOBverbose
SELECT *
FROM TABLE ( SYSTOOLS . HTTPgetCLOBverbose('https://storage.googleapis.com/shopify- ... on%2Fjsonl' ,
'<httpHeader>
<header name="User-Agent" value="Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:91.0) Gecko/20100101 Firefox/91.0"/>
</httpHeader>' )
)T1;
The error is 403
<?xml version="1.0" encoding="UTF-8" ?>
<httpHeader responseCode="403">
<responseMessage>Forbidden</responseMessage>
<header name="HTTP_RESPONSE_CODE" value="HTTP/1.1 403 Forbidden"/>
<header name="X-GUploader-UploadID" value="AOCedOEdyhUgvOqS8WDIgNgZjxVyj78RjhzXx6FHrilIkS7rZmTUm9Ar4YAiKznDvDICfY8EV__DMt8"/>
<header name="Alt-Svc" value="h3=&quot;:443&quot;; ma=2592000,h3-29=&quot;:443&quot;; ma=2592000"/>
<header name="Date" value="Mon, 24 Nov 2025 17:48:49 GMT"/>
<header name="Access-Control-Allow-Origin" value="*"/>
<header name="Content-Length" value="298"/>
<header name="Expires" value="Mon, 24 Nov 2025 17:48:49 GMT"/>
<header name="Content-Type" value="application/xml; charset=UTF-8"/>
<header name="Server" value="UploadServer"/>
<header name="Cache-Control" value="private, max-age=0"/>
</httpHeader>

Any Idea???

Can't help a lot with this but I noticed that switching from the old ** SYSTOOLS.HTTPgetCLOBverbose to QSYS2.HTTP_GET allowed me to get the
response back, which clearly states that: "That’s an error. Your client has issued a malformed or illegal request. That’s all we know."

One of the posts here https://community.shopify.com/t/bulk-op ... a/196441/2 indicates that the URL supplied by Shopify may need to be "cleaned" - see the last post in the thread.

You might also want to check your header content. I had to remove the header to get the error response. The SQL APIs just barfed with the value you supplied.

** You really should use the new functions - they are much faster and more robust. Although I am not sure if they can be used on 7.2 that is a really old release and hasn't been supported in a while.

Thanks for your answer, but on 7.2 QSYS2.HTTP_GET not exists

No idea why you are stuck on 7.2 but ...

I still think you need to look at the formation of the request and/or the headers. The response I got - using your exact request - was that the request was mail-formed.

403 Forbidden means you are not permitted access. Either the URL or the server, or something else (such as the IP address you are coming from) is not allowed.

UPDATE
Mornig to everybody

I have tested on IBM i 7.3 (other customer) with qsys2.HTTP_GET_VERBOSE an it work fine
on 7.2 with systools. i have add <httpHeader includeErrorMsg="true"/>' on header parameter

SELECT *
FROM TABLE ( SYSTOOLS . HTTPgetcLOBverbose('https://storage.googleapis.com/shopify- ... WAFQ%3D%3D'
,'<httpHeader includeErrorMsg="true"/>' )
)T1;

and the responsemsg is
<?xml version='1.0' encoding='UTF-8'?>
<Error>
<Code>SignatureDoesNotMatch</Code>
<Message>Access denied.</Message>
<Details>The request signature we calculated does not match the signature you provided. Check your Google secret key and signing method.</Details>
<StringToSign>GET

text/plain;charset=utf-8
1764684698
/shopify-tiers-assets-prod-us-east1/bulk-operation-outputs/v9ih3ergjsr2i51hsl7nurmcz969-final</StringToSign>
</Error>

My customer can't upgrade from 7.2 to 7.3
Any Idea??

manga63 wrote: Thu Nov 27, 2025 10:10 am My customer can't upgrade from 7.2 to 7.3
Any Idea??

Don't use the systools http routines... use HTTPAPI, this is the website for HTTPAPI, after all.