screen_restatements

SIGNAL, NOT A VERDICT. Funds whose B3 Fundos.NET (FNET) re-filings — documents with versao > 1 — in the trailing p_months of delivery days (ending p_end, default today) number at least p_min_restatements AND make up at least p_min_rate_pct of the fund’s documents in the window. restatements_re (voluntary, Reapresentação Espontânea) and restatements_rc (required by CVM, Reapresentação por Exigência) split them as FNET publishes modalidade; p_modalidade counts only one kind. A fund is known ONLY by its cnpjFundo link (the CNPJ SILO queried FNET with) — never by fund_name, which is FNET’s label, served for reading. The same pattern comes from routine corrections of typos, an administrator or custodian migration that re-submits a whole book, the resolution-175 adaptation, a FNET template change forcing re-submission, one error cascading through consecutive informes, or a CVM supervision sweep that required re-filings across an administrator’s funds; an RC says CVM asked, not what was wrong. Documents not yet linked by the fortnightly sweep and history before SILO’s first crawl are not counted (coverage() fnet_documents). Defaults 12 months, 3 re-filings, 20%. Every row carries screen and params. More than 1000 rows RAISES 22023 (never trimmed): raise the thresholds or pin p_modalidade.

Row cap. A window producing more than 1000 rows raises SQLSTATE 22023 naming this function. Nothing is trimmed to fit — PostgREST would silently cut the response at 1000 and a cut-short series is indistinguishable from one that simply ends. This function does not page — narrow the window instead.

POST /rpc/screen_restatements

screen_restatements

cURL

curl --request POST \
  --url https://zcjbtpxuhdekpwcxmepn.supabase.co/rest/v1/rpc/screen_restatements \
  --header 'Content-Type: application/json' \
  --header 'apikey: <api-key>' \
  --data '
{
  "p_months": 12,
  "p_end": null,
  "p_min_restatements": 3,
  "p_min_rate_pct": 20,
  "p_modalidade": null
}
'

200

[
  {
    "cnpj": "<string>",
    "tipo_fundo": "<string>",
    "fund_name": "<string>",
    "window_from": "2023-12-25",
    "window_to": "2023-12-25",
    "documents": 123,
    "restatements": 123,
    "restatements_re": 123,
    "restatements_rc": 123,
    "restatement_pct": 123,
    "last_restated_at": "2023-11-07T05:31:56Z",
    "screen": "<string>",
    "params": {}
  }
]

Authorizations

apikey · string · header · required

The publishable key (sb_publishable_…), on every request. It is NOT a JWT — sending it as Authorization: Bearer is rejected as an invalid JWT. It identifies the project, not you, and maps to the Postgres anon role.

Body

application/json

p_months · integer<int32> | null · default: 12

Defaults to 12.

p_end · string<date> | null

Defaults to NULL::date.

p_min_restatements · integer<int32> | null · default: 3

Defaults to 3.

p_min_rate_pct · number | null · default: 20

Defaults to 20.

p_modalidade · enum<string> | null

Defaults to NULL::text.

Available options: RE, RC

Response

200

application/json

The result set, oldest first. An unknown id is an empty array, not a 404 and never a guessed value.

cnpj · string | null

tipo_fundo · string | null

fund_name · string | null

window_from · string<date> | null

window_to · string<date> | null

documents · integer<int64> | null

restatements · integer<int64> | null

restatements_re · integer<int64> | null

restatements_rc · integer<int64> | null

restatement_pct · number | null

last_restated_at · string<date-time> | null

screen · string | null

params · object | null