PUT request failing unexpectedly

[andrewsinnovations]

I'm trying to send a PUT request to an external service. I have code like this:

set url = (.... code that returns URL as text ....)

set request = (
    select json_build_object('method', 'PUT', 'url', $url, 'body', '')
);

set results = sqlpage.fetch($request);

I get the following error:

Failed to set the $results variable to StmtWithParams { query: "SELECT CAST($1 AS TEXT) AS sqlpage_set_expr", query_position: SourceSpan { start: SourceLocation { line: 0, column: 0 }, end: SourceLocation { line: 0, column: 0 } }, params: [FunctionCall(SqlPageFunctionCall { function: fetch, arguments: [PostOrGet("request")] })], delayed_functions: [], json_columns: [] }

Error in function call sqlpage.fetch($request).
Expected sqlpage.fetch(http_request)

Parameter http_request: Invalid http fetch request definition: {"method":"put","url":"...long contents of my url...","body":""}

When I grab the URL value and run it through bruno to test, it succeeds. I'm not sure what I'm doing wrong in my fetch, it feels like it doesn't support PUT method? I hope that isn't the case as the REST API I need to interface with requires it.

[lovasoa]

Hello and welcome to SQLPage !
Thanks for reporting this.

Short answer

You http request definition is missing the mandatory headers field. Fix it with

set url = 'https://sqlpage.free.beeceptor.com';

set request = json_build_object(
    'method', 'PUT',
    'url', $url,
    'headers', json_build_object(), -- The headers field is mandatory (but can be empty)
    'body', ''
);

select sqlpage.fetch($request);

Improvements

I'll fix two things inside sqlpage itself:

• The error message when the request object is malformed will point to exactly where the problem is.
• The headers field will be made optional, providing a reasonable set of headers by default.

[andrewsinnovations]

Thank you, this solved the problem!

[lovasoa]

I made the changes for the next version: 4c88bd7