How to return plain text from function?

[maxbaluev]

I am use postgrest as part of supabsase. And i need to response plain text to user from function. Function below work like a charm, but result always inside double quotes. How to return plain text without quotes?

Function:

Result:

[wolfgangwalther]

Have a look at the fine docs here: https://postgrest.org/en/v8.0/api.html#plain-text-output

You need to make the request with Accept: text/plain. This should then take care of the Content-Type header automatically, if I remember correctly, no need to manually set that.

[maxbaluev]

@wolfgangwalther Yep, thank you, but i have a problem with that method. I am use it with external service webhook and can't set request header manually.

[wolfgangwalther]

Hm. What kind of Accept header does this external service send?

[maxbaluev]

@wolfgangwalther here example of headers

[wolfgangwalther]

Hm. Instead of posting pictures, it'd be much better to copy & paste that as text. Increases readability on all kinds of devices and allows full-text search.

Anyway, if the external service is specifically requesting application/json, answering with anything else like text/plain or so seems just... wrong. If you really want to do that (and I fail to see why - there must be a reason why they expect application/json or any other structured format), you'll need to add a reverse proxy like nginx inbetween and rewrite the request to that endpoint.

[steve-chavez]

At first I thought #1582 could help with this use case but seeing the Accept header they don't even include */*. So as Wolfgang mentioned, the external service must be expecting a structured format and it's likely it won't work with text/plain(since it's not valid json or xml).