Error reading response when accepting GZIP encoding

[durango]

SELECT http_post(
      'https://api.openai.com/v1/chat/completions',
      headers => MAP {
        'Content-Type': 'application/json',
        'Accept': '*/*',
        'Authorization': 'Bearer <key>',
        'Host': 'api.openai.com',
        'Accept-Encoding': 'gzip, deflate, br'
      },
      params => MAP {}
  );

┌──────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────┐
│ http_post('https://api.openai.com/v1/chat/completions', headers := main."map"(main.list_value('Content-Type', 'Accept', 'Authorization', 'User-Agent', 'Host', 'Accept-Encoding'), main.list_value('application/json', '*/*', 'Bearer …  │
│                                                                                                                                 json                                                                                                                                 │
├──────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────┤
│ { "status": -1, "reason": "HTTP POST request failed. Error reading response.", "body": "" }                                                                                                                                                                          │
└──────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────┘

[lmangani]

Thanks for the report @durango this should be as simple as adding a definition to the extension including httplib.hpp

#define CPPHTTPLIB_OPENSSL_SUPPORT
#define CPPHTTPLIB_ZLIB_SUPPORT
#include "httplib.hpp"

[lmangani]

Well nothing is ever as easy as it looks!
I can't find a way to use ZLIB in WASM builds so that's excluded - for now. Will ask @carlopi when an opportunity arises.

[lmangani]

@durango #13 should offer the required functionality. Are you able to test this branch locally?

[durango]

@lmangani looks good on that branch, glad it was a quick fix, thank you

[ahuarte47]

Bravo!!

[lmangani]

Submitted to Community Extensions repo: duckdb/community-extensions#195

[lmangani]

Implemented in latest release. I hope it works!