RE: HTTP_STATUS_CODE":302" with QSYS2.HTTP_GET_VERBOSE

You have it coded wrong:

Try
'{"headers": { "Authorization" : "Basic Y____u ", "requireSecure": "true" } ,"redirect": 5} '

Or
'{"redirect": 5,"headers": { "Authorization" : "Basic Y____u ", "requireSecure": "true" } } '

-----------------------------------------------
Nadir Amra
e-mail: amra@xxxxxxxxxx


From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> on behalf of gio.cot via MIDRANGE-L <midrange-l@xxxxxxxxxxxxxxxxxx>
Date: Thursday, November 28, 2024 at 8:08 AM
To: midrange-l@xxxxxxxxxxxxxxxxxx <midrange-l@xxxxxxxxxxxxxxxxxx>
Cc: gio.cot <gio.cot@xxxxxxxxxxx>
Subject: [EXTERNAL] RE: HTTP_STATUS_CODE":302" with QSYS2.HTTP_GET_VERBOSE
Hi Nadir



I tried to run this statement with "redirect" , but i get the same answer



select * from
table(QSYS2.HTTP_GET_VERBOSE(https://zzz.xxxxxx.com/api/v1/mapping/catalog/ '
, '{"headers": {
"Authorization" : "Basic Y____u ", "requireSecure": "true" ,
"redirect": 5 } } ')) as x ;



Response

{"HTTP_STATUS_CODE":302,"Date":"Thu, 28 Nov 2024 13:59:24
GMT","Content-Length":0,"Connection":"keep-alive","x-ratelimit-limit":200,"x
-ratelimit-remaining":199,"x-ratelimit-reset":60,"location":"https://pr-back
end-s3-catalog0.s3.eu-west-1.amazonaws.com/catalog/export/catalog.csv?X-Amz-
Algorithm=AWS4-HMAC-SHA256&X-Amz-Content-Sha256=UNSIGNED-PAYLOAD&X-Amz-Crede
ntial=AS__128%2Feu-west-1%2Fs3%2Faws4_request&X-Amz-Date=20241128T135924Z&X-
Amz-Expires=3600&X-Amz-Security-Token=I__Yw%3D%3D&X-Amz-Signature=0xxxxxxxxX
-Amz-SignedHeaders=host&x-id=GetObject"}



Pheraps is wrong my statament ??