Since you are trying an Amazon site, maybe contact them for some help?


Jim Oberholtzer
Agile Technology Architects

On Dec 2, 2024, at 6:44 AM, gio.cot via MIDRANGE-L <midrange-l@xxxxxxxxxxxxxxxxxx> wrote:



Hi Nadir



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" } } '



First suggestion

'{"headers": {"Authorization" : "Basic Y____u ", "requireSecure": "true"
} ,"redirect": 5 } ')) as x ;

i receive:

{"HTTP_STATUS_CODE":400,"x-amz-request-id":"2__H","x-amz-id-2":"Q_I=","Conte
nt-Type":"application/xml","Transfer-Encoding":"chunked","Date":"Mon, 02 Dec
2024 12:00:33 GMT","Connection":"close","Server":"AmazonS3"}



Second suggestion:

select * from table(
'{"headers": {"redirect": 5 , "Authorization" : "Basic Y____u ",
"requireSecure": "true"
} } ')) as x ;

i receive:

{"HTTP_STATUS_CODE":302,"Date":"Mon, 02 Dec 2024 12:40:19
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=Axx2%2Feu-west-1%2Fs3%2Faws4_request&X-Amz-Date=20241202T124019Z&X-Amz
-Expires=3600&X-Amz-Security-Token=xxX-Amz-Signature=9ezz&X-Amz-SignedHeader
s=host&x-id=GetObject"}



Thanks









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


As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:
Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.