Help to get data from storage.googleapis.com

[manga63]

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

[jonboy49]

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.

[manga63]

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

[jonboy49]

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.

[Scott Klement]

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.

[manga63]

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

[Scott Klement]

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.