REST API over
Peru's public budget.

🐚 curl (bash · terminal)

curl -X POST https://app.gestionpublicaperu.com.pe/api/insights/query \
  -H "Content-Type: application/json" \
  -d '{
    "sql": "SELECT anio, ROUND(SUM(MTO_PIM)/1e9, 1) AS pim_mil_M FROM mef_historico WHERE SECTOR LIKE \"11%\" GROUP BY anio ORDER BY anio"
  }'

🐍 Python (httpx · ideal for notebooks and scripts)

# pip install httpx polars
import httpx
import polars as pl

resp = httpx.post(
    "https://app.gestionpublicaperu.com.pe/api/insights/query",
    json={
        "sql": """
            SELECT anio,
                   ROUND(SUM(MTO_PIM)/1e9, 1)            AS pim_bn_PEN,
                   ROUND(SUM(DEVENGADO_)*100
                       / NULLIF(SUM(MTO_PIM),0), 1)      AS execution_pct
            FROM mef_historico
            WHERE PLIEGO LIKE '036%'   -- MTC (Ministry of Transport)
            GROUP BY anio
            ORDER BY anio
        """,
        "limit": 9500,   # server default is 1000; raise it if you expect more rows
    },
    timeout=60,
)
resp.raise_for_status()

# Response returns rows as records (not lists) -> Polars loads them directly
df = pl.DataFrame(resp.json()["filas"])
print(df)

# Polars is 10-100x faster than pandas on agg/joins. Same stack as the backend.
# Full client with error handling: github.com/sulk1n/gestionpublicaperu-api-clients

🌐 JavaScript (fetch · browser or Node)

const r = await fetch("https://app.gestionpublicaperu.com.pe/api/insights/query", {
  method: "POST",
  headers: { "Content-Type": "application/json" },
  body: JSON.stringify({
    sql: `
      SELECT DEPARTAMENTO_META,
             ROUND(SUM(MTO_PIM)/1e6, 1) AS pim_M
      FROM mef_historico
      WHERE anio = 2025 AND DEPARTAMENTO_META != '00 '
      GROUP BY DEPARTAMENTO_META
      ORDER BY pim_M DESC
      LIMIT 5
    `,
  }),
});
const { columnas, filas, n_filas } = await r.json();
console.table(filas);

📊 Excel · Power Query M

// Excel → Data → Get Data → From Other Sources → Blank Query → Advanced Editor
let
    url     = "https://app.gestionpublicaperu.com.pe/api/insights/query",
    sql     = "SELECT anio, ROUND(SUM(MTO_PIM)/1e9, 1) AS pim FROM mef_historico GROUP BY anio ORDER BY anio",
    body    = Json.FromValue([sql = sql]),
    resp    = Web.Contents(url, [
                Content = body,
                Headers = [#"Content-Type" = "application/json"]
              ]),
    json    = Json.Document(resp),
    tabla   = Table.FromRecords(json[filas])
in
    tabla

In Excel: Data → Get Data → From Other Sources → Blank Query → Advanced Editor. Paste the block and refresh whenever you want fresh data.

// Power BI Desktop → Get data → Blank query → Advanced Editor
// Data source credentials: Anonymous (at the https://app.gestionpublicaperu.com.pe level)
let
    url     = "https://app.gestionpublicaperu.com.pe/api/insights/query",
    sql     = "SELECT anio,
                      ROUND(SUM(MTO_PIM)/1e9, 1)                     AS pim_bn,
                      ROUND(SUM(DEVENGADO_)/1e9, 1)                  AS dev_bn,
                      ROUND(SUM(DEVENGADO_)*100
                          / NULLIF(SUM(MTO_PIM),0), 1)               AS execution_pct
               FROM mef_historico
               GROUP BY anio
               ORDER BY anio",
    body    = Json.FromValue([sql = sql]),
    resp    = Web.Contents(url, [
                Content = body,
                Headers = [#"Content-Type" = "application/json"],
                ManualStatusHandling = {400, 429, 504}
              ]),
    json    = Json.Document(resp),
    tabla   = Table.FromRecords(json[filas]),
    typed   = Table.TransformColumnTypes(tabla, {
                {"anio",          Int64.Type},
                {"pim_bn",        type number},
                {"dev_bn",        type number},
                {"execution_pct", type number}
              })
in
    typed