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)

import httpx

r = httpx.post(
    "https://app.gestionpublicaperu.com.pe/api/insights/query",
    json={
        "sql": """
            SELECT anio,
                   ROUND(SUM(MTO_PIM)/1e9, 1)            AS pim_mil_M,
                   ROUND(SUM(DEVENGADO_)*100
                       / NULLIF(SUM(MTO_PIM),0), 1)      AS avance_pct
            FROM mef_historico
            WHERE PLIEGO LIKE '036%'   -- MTC (Ministry of Transport)
            GROUP BY anio
            ORDER BY anio
        """,
    },
    timeout=60,
)
data = r.json()
print(data["columnas"])   # ['anio', 'pim_mil_M', 'avance_pct']
print(data["filas"])      # [[2013, 4.2, 87.5], [2014, 5.1, 89.1], ...]

🌐 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.FromRows(json[filas], json[columnas])
in
    tabla

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