Git Product home page Git Product logo

minha-despesa's Introduction

minha-despesa

API web para consulta de informações de Despesas do Espírito Santo

minha-despesa's People

Contributors

sswellington avatar

Watchers

avatar

minha-despesa's Issues

Integration with API dados.es.gov.br

Resource

YEAR GUID - RESOURCE_ID
2024 b34ae52a-a739-412a-9bab-80f53ba72f4f
2023 2c3328bd-329e-4db6-b742-630619b0dd65
2022 2dddb456-5481-43f7-ab09-5b0a0faa784f
2021 3f0d341b-7c09-4b4a-83b1-bdf5ae26ec13
2020 19c1fe94-56e7-41e3-957f-46c3de28a2ab
2019 8f3e2097-d89e-4ac7-8f20-660ca9dbd75d
2018 2c26fe9a-7d90-4c44-a3fb-68fcd5790800
2017 22476243-8565-4649-bd4f-abd2cafbd144
2016 f10178de-008f-4942-a249-89cdc172dd03
2015 3739e443-e01e-4eca-bd89-87e42aa50a9d
2014 5ddb74e2-73a7-40e4-bad0-6632bdbfc982
2013 a42b22d5-96bd-4778-8279-d1077cffb2a4
2012 152335dc-473d-481b-a61d-77cc4300ef5d
2011 732be7ee-8e04-4568-901d-800ec515f6ca
2010 55d2ab05-f8a7-41d2-9bb3-23a6b919e0b7
2009 cf68f140-d077-4fe4-98fe-45232dc584a9
2008 9c3ca5da-b821-43c9-ad4d-bf992935382c
2007 294656bd-d840-4efd-afc7-3172c75892d9
2006 f931a6bc-a8da-49fd-adb6-291cc2c47b03
2005 cebd540a-95da-4774-a183-068a9397b944
2004 8ffd4e6c-6e30-419d-9baa-921045caa22e

Reference

Despesas

https://docs.ckan.org/en/2.8/api/#get-able-api-functions

https://dados.es.gov.br/api/3/action/help_show?name=datastore_search

"Search a DataStore resource.
The datastore_search action allows you to search data in a resource.
DataStore resources that belong to private CKAN resource can only be
read by you if you have access to the CKAN resource and send the
appropriate authorization.

:param resource_id: id or alias of the resource to be searched against
:type resource_id: string
:param filters: matching conditions to select, e.g {\"key1\": \"a\", \"key2\": \"b\"} (optional)
:type filters: dictionary
:param q: full text query. If it's a string, it'll search on all fields on
          each row. If it's a dictionary as {\"key1\": \"a\", \"key2\": \"b\"},
          it'll search on each specific field (optional)
:type q: string or dictionary
:param distinct: return only distinct rows (optional, default: false)
:type distinct: bool
:param plain: treat as plain text query (optional, default: true)
:type plain: bool
:param language: language of the full text query (optional, default: english)
:type language: string
:param limit: maximum number of rows to return (optional, default: 100)
:type limit: int
:param offset: offset this number of rows (optional)
:type offset: int
:param fields: fields to return (optional, default: all fields in original order)
:type fields: list or comma separated string
:param sort: comma separated field names with ordering e.g.: \"fieldname1, fieldname2 desc\"
:type sort: string
:param include_total: True to return total matching record count (optional, default: true)
:type include_total: bool
:param records_format: the format for the records return value:
    'objects' (default) list of {fieldname1: value1, ...} dicts,
    'lists' list of [value1, value2, ...] lists,
    'csv' string containing comma-separated values with no header,
    'tsv' string containing tab-separated values with no header
:type records_format: controlled list


Setting the ``plain`` flag to false enables the entire PostgreSQL
`full text search query language`_.

A listing of all available resources can be found at the
alias ``_table_metadata``.

.. _full text search query language: http://www.postgresql.org/docs/9.1/static/datatype-textsearch.html#DATATYPE-TSQUERY

If you need to download the full resource, read :ref:`dump`.

**Results:**

The result of this action is a dictionary with the following keys:

:rtype: A dictionary with the following keys
:param fields: fields/columns and their extra metadata
:type fields: list of dictionaries
:param offset: query offset value
:type offset: int
:param limit: query limit value
:type limit: int
:param filters: query filters
:type filters: list of dictionaries
:param total: number of total matching records
:type total: int
:param records: list of matching results
:type records: depends on records_format value passed
"

Endpoints

  • Ano
  • Entidade/Unidade Gestora
  • Código da Unidade Gestora
  • CNPJ
  • Código do Processo
  • Tipo de Licitação
  • Documento
  • Documento de Empenho

Retorno:

"success": true,
"result" : 
{
  "include_total": true,
    "records_format": "objects",
    "q": "Query",
    "total" : n,
  "fields": [
        {
          "type": "int",
          "id": "_id"
        },
        {
          "type": "numeric",
          "id": "Ano"
        },
        {
          "type": "timestamp",
          "id": "Data"
        },
        {
          "type": "text",
          "id": "ValorEmpenho"
        },
        {
          "type": "text",
          "id": "ValorLiquidado"
        },
        {
          "type": "text",
          "id": "ValorPago"
        },
        {
          "type": "text",
          "id": "ValorRap"
        },
        {
          "type": "text",
          "id": "CpfCnpjNis"
        },
        {
          "type": "numeric",
          "id": "TipoFavorecido"
        },
        {
          "type": "text",
          "id": "CargoFuncao"
        },
        {
          "type": "text",
          "id": "Favorecido"
        },
        {
          "type": "numeric",
          "id": "IdFavorecido"
        },
        {
          "type": "text",
          "id": "TipoLicitacao"
        },
        {
          "type": "text",
          "id": "HistoricoDocumento"
        },
        {
          "type": "text",
          "id": "Documento"
        },
        {
          "type": "text",
          "id": "DocumentoEmpenho"
        },
        {
          "type": "numeric",
          "id": "CodigoProcesso"
        },
        {
          "type": "text",
          "id": "Processo"
        },
        {
          "type": "text",
          "id": "ProcessoAssunto"
        },
        {
          "type": "numeric",
          "id": "CodigoFuncionalProgramatica"
        },
        {
          "type": "numeric",
          "id": "CodigoCategoriaEconomica"
        },
        {
          "type": "text",
          "id": "CategoriaEconomica"
        },
        {
          "type": "numeric",
          "id": "CodigoUnidadeGestora"
        },
        {
          "type": "text",
          "id": "UnidadeGestora"
        },
        {
          "type": "numeric",
          "id": "CodigoGrupoDespesa"
        },
        {
          "type": "text",
          "id": "GrupoDespesa"
        },
        {
          "type": "numeric",
          "id": "CodigoElementoDespesa"
        },
        {
          "type": "text",
          "id": "ElementoDespesa"
        },
        {
          "type": "text",
          "id": "DescricaoElementoDespesa"
        },
        {
          "type": "numeric",
          "id": "CodigoSubtitulo"
        },
        {
          "type": "text",
          "id": "Subtitulo"
        },
        {
          "type": "numeric",
          "id": "CodigoFonte"
        },
        {
          "type": "text",
          "id": "Fonte"
        },
        {
          "type": "numeric",
          "id": "CodigoOrgao"
        },
        {
          "type": "text",
          "id": "Orgao"
        },
        {
          "type": "numeric",
          "id": "CodigoFuncao"
        },
        {
          "type": "text",
          "id": "Funcao"
        },
        {
          "type": "numeric",
          "id": "CodigoSubFuncao"
        },
        {
          "type": "text",
          "id": "SubFuncao"
        },
        {
          "type": "numeric",
          "id": "CodigoPrograma"
        },
        {
          "type": "text",
          "id": "Programa"
        },
        {
          "type": "numeric",
          "id": "CodigoAcao"
        },
        {
          "type": "text",
          "id": "Acao"
        },
        {
          "type": "numeric",
          "id": "CodigoModalidade"
        },
        {
          "type": "text",
          "id": "Modalidade"
        },
        {
          "type": "numeric",
          "id": "CodigoSubelementoDespesa"
        },
        {
          "type": "text",
          "id": "SubelementoDespesa"
        },
        {
          "type": "numeric",
          "id": "CodigoGestaoEmitente"
        },
        {
          "type": "numeric",
          "id": "CodigoPlanoOrcamentario"
        },
        {
          "type": "text",
          "id": "PlanoOrcamentario"
        },
        {
          "type": "numeric",
          "id": "NumeroProcesso"
        },
        {
          "type": "numeric",
          "id": "CodigoConvenioRecebido"
        },
        {
          "type": "numeric",
          "id": "CodigoConvenioConcedido"
        },
        {
          "type": "numeric",
          "id": "Id"
        }
      ],
     "records": []
}

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. 📊📈🎉

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google ❤️ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.