I would second that.

I am working with a few customers that use similar APIs.. why they're
putting all the HTTP codes, etc in the JSON itself is beyond me.


On Mon, Dec 2, 2024 at 7:48 AM Jim Oberholtzer <midrangel@xxxxxxxxxxxxxxxxx>
wrote:

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.

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

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.