voltar

API Referências: CampoSistema | ListarRelatorioPrincipal

post /api/CampoSistema/ListarRelatorioPrincipal?token=[SEU-TOKEN-SECRETO]&json=[JSON]

Request

Querystring parameters names Type
token string required
json

{
     Empresa: varchar,
     Usuario: varchar,
}

json required

Response


HttpResponse: OK
Property Type Default response
Status string ok
Code int 200
Success boolean true
Data

array json
{
     [
          AutonumeracaoEmpresa: int,
          CampoSistema: uniqueidentifier,
          Hash: uniqueidentifier,
          Titulo: string,
     ]
}

HttpResponse: Error
Property Type Default response
Status string error
Code int 500
Success boolean false
Data array json null

HttpResponse: Unauthorized
Property Type Default response
Status string error
Code int 401
Success boolean false
Data array json null
Message string Invalid token

API Referências: CampoSistema | ObterDadosLookupComplete

post /api/CampoSistema/ObterDadosLookupComplete?token=[SEU-TOKEN-SECRETO]&json=[JSON]

Request

Querystring parameters names Type
token string required
json

{
     Coluna: varchar,
     Empresa: varchar,
     Entidade: varchar,
     Termo: varchar,
     Tipo: varchar,
}

json required

Response


HttpResponse: OK
Property Type Default response
Status string ok
Code int 200
Success boolean true
Data

array json
{
     [
          Codigo: string,
          Titulo: string,
     ]
}

HttpResponse: Error
Property Type Default response
Status string error
Code int 500
Success boolean false
Data array json null

HttpResponse: Unauthorized
Property Type Default response
Status string error
Code int 401
Success boolean false
Data array json null
Message string Invalid token

API Referências: CampoSistema | Consultar

post /api/CampoSistema/Consultar?token=[SEU-TOKEN-SECRETO]&json=[JSON]

Request

Querystring parameters names Type
token string required
json

{
     Hash: varchar,
}

json required

Response


HttpResponse: OK
Property Type Default response
Status string ok
Code int 200
Success boolean true
Data

array json
{
     [
          AbaFormulario: int,
          AcaoDados: bit,
          AcessoLiberado: text,
          Ajuda: string,
          Alteracao: datetime,
          Altura: string,
          AtualizavelModoInsert: bit,
          AtualizavelModoUpdate: bit,
          AtualizavelPorApi: bit,
          AtualizavelPorSistema: bit,
          Autonumeracao: int,
          AutonumeracaoEmpresa: int,
          Cadastro: datetime,
          CampoChaveTabelaRelacionadaTabelaAssociativa: string,
          CampoTextoFonteDadosCustomizada: string,
          CampoValorFonteDadosCustomizada: string,
          CaracteresPermitidos: string,
          CaracteresProibidos: string,
          CasasDecimais: int,
          Categoria: int,
          Cep: bit,
          ClassesCss: string,
          ClassesCssImagem: string,
          CodigoOnChange: string,
          CodigoOnFocus: string,
          CodigoOnInit: string,
          CodigoOnKeyDown: string,
          CodigoOnKeyPress: string,
          CodigoOnKeyUp: string,
          ColunaOpcional: bit,
          ColunasOcupadas: int,
          ColunaSubdescricao1: string,
          ColunaSubdescricao2: string,
          ColunaSubdescricao3: string,
          ColunaSubdescricao4: string,
          ColunaTexto: string,
          ColunaTextoBadge1: string,
          ColunaTextoBadge2: string,
          ColunaTextoBadge3: string,
          ColunaTextoBadge4: string,
          ColunaTextoBadge5: string,
          ColunaTitulo: string,
          ColunaUrlImagem: string,
          ColunaValor: string,
          ColunaValorBadge: string,
          ColunaValorBadge1: string,
          ColunaValorBadge2: string,
          ColunaValorBadge3: string,
          ColunaValorBadge4: string,
          ColunaValorBadge5: string,
          ColunaValorFiltro: string,
          ColunaValorOrdenacao: string,
          CorFonte: string,
          CorFundo: string,
          DisplayFormatString: string,
          DisplayFormatString: string,
          EditavelModoInsert: bit,
          EditavelModoUpdate: bit,
          Email: bit,
          Empresa: uniqueidentifier,
          ExibirHoras: bit,
          ExibirTextoGrid: bit,
          ExpressaoRegularValidacao: string,
          FiltroAvancado: bit,
          FiltroDestaque: bit,
          FiltroGeralGrid: bit,
          FiltroPadrao: string,
          FluxoDadosSalvarComo: bit,
          FonteDadosCustomizada: bit,
          FonteDadosForeignKey: bit,
          FonteDadosLegenda: bit,
          GrupoPainelFormulario: int,
          Hash: uniqueidentifier,
          Italico: bit,
          Label: string,
          Largura: string,
          LarguraPopup: string,
          LegendaLabel: uniqueidentifier,
          Mascara: string,
          MaxCaracteres: int,
          Negrito: bit,
          Notificavel: bit,
          Obrigatorio: bit,
          ObservacoesAdicionais: text,
          Ordenacao: int,
          OrdenacaoFonteDadosCustomizada: string,
          PaginaSistema: uniqueidentifier,
          PermiteEspaco: bit,
          Placeholder: string,
          PrimaryKey: bit,
          Privado: bit,
          RegexValidacao: string,
          Small: bit,
          SomenteLetras: bit,
          SomenteNumeros: bit,
          SqlFonteDadosCustomizada: string,
          TabelaAssociativa: string,
          TipoControleWeb: int,
          TipoControleWebFiltro: int,
          TipoDados: string,
          TipoFiltro: int,
          TipoOrdenacao: int,
          Titulo: string,
          Tooltip: string,
          UrlEdicaoFonteDados: string,
          UrlLinkAjuda: string,
          UrlLinkavel: string,
          UrlNovoFonteDados: string,
          UsuarioAlteracao: uniqueidentifier,
          UsuarioAlteracaoDescricao: string,
          UsuarioAlteracaoEmail: string,
          UsuarioCriacao: uniqueidentifier,
          UsuarioCriacaoDescricao: string,
          UsuarioCriacaoEmail: string,
          ValorBadge1Danger: string,
          ValorBadge1Info: string,
          ValorBadge1Primary: string,
          ValorBadge1Success: string,
          ValorBadge1Warning: string,
          ValorBadge2Danger: string,
          ValorBadge2Info: string,
          ValorBadge2Primary: string,
          ValorBadge2Success: string,
          ValorBadge2Warning: string,
          ValorBadge3Danger: string,
          ValorBadge3Info: string,
          ValorBadge3Primary: string,
          ValorBadge3Success: string,
          ValorBadge3Warning: string,
          ValorBadge4Danger: string,
          ValorBadge4Info: string,
          ValorBadge4Primary: string,
          ValorBadge4Success: string,
          ValorBadge4Warning: string,
          ValorBadge5Danger: string,
          ValorBadge5Info: string,
          ValorBadge5Primary: string,
          ValorBadge5Success: string,
          ValorBadge5Warning: string,
          ValorBadgeDanger: string,
          ValorBadgeInfo: string,
          ValorBadgePrimary: string,
          ValorBadgeSuccess: string,
          ValorBadgeWarning: string,
          ValorMaximo: decimal(18,2),
          ValorMinimo: decimal(18,2),
          ValorPadrao: string,
          ValorPadraoInicial: string,
          Visivel: bit,
     ]
}

HttpResponse: Error
Property Type Default response
Status string error
Code int 500
Success boolean false
Data array json null

HttpResponse: Unauthorized
Property Type Default response
Status string error
Code int 401
Success boolean false
Data array json null
Message string Invalid token

API Referências: CampoSistema | Excluir

post /api/CampoSistema/Excluir?token=[SEU-TOKEN-SECRETO]&Hash=[Hash]

Request

Querystring parameters names Type
token string required
Hash guid required

Response


HttpResponse: OK
Property Type Default response
Status string ok
Code int 200
Success boolean true
Data

array json null

HttpResponse: Error
Property Type Default response
Status string error
Code int 500
Success boolean false
Data array json null

HttpResponse: Unauthorized
Property Type Default response
Status string error
Code int 401
Success boolean false
Data array json null
Message string Invalid token

API Referências: CampoSistema | Listar

post /api/CampoSistema/Listar?token=[SEU-TOKEN-SECRETO]

Request

Querystring parameters names Type
token string required

Response


HttpResponse: OK
Property Type Default response
Status string ok
Code int 200
Success boolean true
Data

array json
{
     [
          AbaFormulario: int,
          AcaoDados: bit,
          AcessoLiberado: text,
          Ajuda: string,
          Alteracao: datetime,
          Altura: string,
          AtualizavelModoInsert: bit,
          AtualizavelModoUpdate: bit,
          AtualizavelPorApi: bit,
          AtualizavelPorSistema: bit,
          Autonumeracao: int,
          AutonumeracaoEmpresa: int,
          Cadastro: datetime,
          CaracteresPermitidos: string,
          CaracteresProibidos: string,
          CasasDecimais: int,
          Categoria: int,
          Cep: bit,
          ClassesCss: string,
          ClassesCssImagem: string,
          CodigoOnChange: string,
          CodigoOnFocus: string,
          CodigoOnInit: string,
          CodigoOnKeyDown: string,
          CodigoOnKeyPress: string,
          CodigoOnKeyUp: string,
          ColunaOpcional: bit,
          ColunasOcupadas: int,
          CorFonte: string,
          CorFundo: string,
          DisplayFormatString: string,
          DisplayFormatString: string,
          EditavelModoInsert: bit,
          EditavelModoUpdate: bit,
          Email: bit,
          Empresa: uniqueidentifier,
          ExibirHoras: bit,
          ExibirTextoGrid: bit,
          ExpressaoRegularValidacao: string,
          FiltroAvancado: bit,
          FiltroDestaque: bit,
          FiltroGeralGrid: bit,
          FiltroPadrao: string,
          FluxoDadosSalvarComo: bit,
          FonteDadosCustomizada: bit,
          FonteDadosForeignKey: bit,
          FonteDadosLegenda: bit,
          GrupoPainelFormulario: int,
          Hash: uniqueidentifier,
          Italico: bit,
          Label: string,
          Largura: string,
          LarguraPopup: string,
          LegendaLabel: uniqueidentifier,
          Mascara: string,
          MaxCaracteres: int,
          Negrito: bit,
          Notificavel: bit,
          Obrigatorio: bit,
          ObservacoesAdicionais: text,
          Ordenacao: int,
          OrdenacaoFonteDadosCustomizada: string,
          PaginaSistema: uniqueidentifier,
          PermiteEspaco: bit,
          Placeholder: string,
          PrimaryKey: bit,
          Privado: bit,
          RegexValidacao: string,
          Small: bit,
          SomenteLetras: bit,
          SomenteNumeros: bit,
          SqlFonteDadosCustomizada: string,
          TipoControleWeb: int,
          TipoControleWebFiltro: int,
          TipoDados: string,
          TipoFiltro: int,
          TipoOrdenacao: int,
          Titulo: string,
          Tooltip: string,
          UrlEdicaoFonteDados: string,
          UrlLinkAjuda: string,
          UrlLinkavel: string,
          UrlNovoFonteDados: string,
          UsuarioAlteracao: uniqueidentifier,
          UsuarioCriacao: uniqueidentifier,
          ValorBadge1Danger: string,
          ValorBadge1Info: string,
          ValorBadge1Primary: string,
          ValorBadge1Success: string,
          ValorBadge1Warning: string,
          ValorBadge2Danger: string,
          ValorBadge2Info: string,
          ValorBadge2Primary: string,
          ValorBadge2Success: string,
          ValorBadge2Warning: string,
          ValorBadge3Danger: string,
          ValorBadge3Info: string,
          ValorBadge3Primary: string,
          ValorBadge3Success: string,
          ValorBadge3Warning: string,
          ValorBadge4Danger: string,
          ValorBadge4Info: string,
          ValorBadge4Primary: string,
          ValorBadge4Success: string,
          ValorBadge4Warning: string,
          ValorBadge5Danger: string,
          ValorBadge5Info: string,
          ValorBadge5Primary: string,
          ValorBadge5Success: string,
          ValorBadge5Warning: string,
          ValorBadgeDanger: string,
          ValorBadgeInfo: string,
          ValorBadgePrimary: string,
          ValorBadgeSuccess: string,
          ValorBadgeWarning: string,
          ValorMaximo: decimal(18,2),
          ValorMinimo: decimal(18,2),
          ValorPadrao: string,
          ValorPadraoInicial: string,
          Visivel: bit,
     ]
}

HttpResponse: Error
Property Type Default response
Status string error
Code int 500
Success boolean false
Data array json null

HttpResponse: Unauthorized
Property Type Default response
Status string error
Code int 401
Success boolean false
Data array json null
Message string Invalid token

API Referências: CampoSistema | Salvar

post /api/CampoSistema/Salvar?token=[SEU-TOKEN-SECRETO]&json=[JSON]

Request

Querystring parameters names Type
token string required
json

{
     AbaFormulario: int,
     AcaoDados: bit,
     AcessoLiberado: text,
     Ajuda: varchar,
     Altura: varchar,
     AtualizavelModoInsert: bit,
     AtualizavelModoUpdate: bit,
     AtualizavelPorApi: bit,
     AtualizavelPorSistema: bit,
     CampoChaveTabelaRelacionadaTabelaAssociativa: varchar,
     CamposAtualizados: nvarchar,
     CampoTextoFonteDadosCustomizada: varchar,
     CampoValorFonteDadosCustomizada: varchar,
     CaracteresPermitidos: varchar,
     CaracteresProibidos: varchar,
     CasasDecimais: int,
     Categoria: int,
     Cep: bit,
     ClassesCss: varchar,
     ClassesCssImagem: varchar,
     CodigoOnChange: varchar,
     CodigoOnFocus: varchar,
     CodigoOnInit: varchar,
     CodigoOnKeyDown: varchar,
     CodigoOnKeyPress: varchar,
     CodigoOnKeyUp: varchar,
     ColunaOpcional: bit,
     ColunasOcupadas: int,
     ColunaSubdescricao1: varchar,
     ColunaSubdescricao2: varchar,
     ColunaSubdescricao3: varchar,
     ColunaSubdescricao4: varchar,
     ColunaTexto: varchar,
     ColunaTextoBadge1: varchar,
     ColunaTextoBadge2: varchar,
     ColunaTextoBadge3: varchar,
     ColunaTextoBadge4: varchar,
     ColunaTextoBadge5: varchar,
     ColunaTitulo: varchar,
     ColunaUrlImagem: varchar,
     ColunaValor: varchar,
     ColunaValorBadge: varchar,
     ColunaValorBadge1: varchar,
     ColunaValorBadge2: varchar,
     ColunaValorBadge3: varchar,
     ColunaValorBadge4: varchar,
     ColunaValorBadge5: varchar,
     ColunaValorFiltro: varchar,
     ColunaValorOrdenacao: varchar,
     ConsultarPorCampo: varchar,
     CorFonte: varchar,
     CorFundo: varchar,
     DisplayFormatString: nvarchar,
     EditavelModoInsert: bit,
     EditavelModoUpdate: bit,
     Email: bit,
     Empresa: varchar,
     ExibirHoras: bit,
     ExpressaoRegularValidacao: varchar,
     FiltroGeralGrid: bit,
     FluxoDadosSalvarComo: bit,
     FonteDadosCustomizada: bit,
     FonteDadosForeignKey: bit,
     FonteDadosLegenda: bit,
     GrupoPainelFormulario: int,
     Hash: varchar,
     HashAplicado: uniqueidentifier,
     Italico: bit,
     Label: varchar,
     Largura: varchar,
     LarguraPopup: varchar,
     LegendaLabel: uniqueidentifier,
     Mascara: varchar,
     MaxCaracteres: int,
     Modo: varchar,
     Negrito: bit,
     Notificavel: bit,
     Obrigatorio: bit,
     ObservacoesAdicionais: text,
     Ordenacao: int,
     OrdenacaoFonteDadosCustomizada: varchar,
     PaginaSistema: uniqueidentifier,
     PermiteEspaco: bit,
     Placeholder: varchar,
     PrimaryKey: bit,
     Privado: bit,
     RegexValidacao: varchar,
     RetornarDataSet: bit,
     Small: bit,
     SomenteLetras: bit,
     SomenteNumeros: bit,
     SqlFonteDadosCustomizada: nvarchar,
     TabelaAssociativa: varchar,
     TipoControleWeb: int,
     TipoControleWebFiltro: int,
     TipoDados: varchar,
     TipoFiltro: int,
     TipoOrdenacao: int,
     Titulo: varchar,
     Tooltip: varchar,
     UrlEdicaoFonteDados: varchar,
     UrlLinkAjuda: varchar,
     UrlLinkavel: varchar,
     UrlNovoFonteDados: varchar,
     UsuarioAlteracao: uniqueidentifier,
     UsuarioCriacao: uniqueidentifier,
     ValorBadge1Danger: varchar,
     ValorBadge1Info: varchar,
     ValorBadge1Primary: varchar,
     ValorBadge1Success: varchar,
     ValorBadge1Warning: varchar,
     ValorBadge2Danger: varchar,
     ValorBadge2Info: varchar,
     ValorBadge2Primary: varchar,
     ValorBadge2Success: varchar,
     ValorBadge2Warning: varchar,
     ValorBadge3Danger: varchar,
     ValorBadge3Info: varchar,
     ValorBadge3Primary: varchar,
     ValorBadge3Success: varchar,
     ValorBadge3Warning: varchar,
     ValorBadge4Danger: varchar,
     ValorBadge4Info: varchar,
     ValorBadge4Primary: varchar,
     ValorBadge4Success: varchar,
     ValorBadge4Warning: varchar,
     ValorBadge5Danger: varchar,
     ValorBadge5Info: varchar,
     ValorBadge5Primary: varchar,
     ValorBadge5Success: varchar,
     ValorBadge5Warning: varchar,
     ValorBadgeDanger: varchar,
     ValorBadgeInfo: varchar,
     ValorBadgePrimary: varchar,
     ValorBadgeSuccess: varchar,
     ValorBadgeWarning: varchar,
     ValorConsultaPorCampo: varchar,
     ValorMaximo: decimal,
     ValorMinimo: decimal,
     ValorPadraoInicial: varchar,
     Visivel: bit,
}

json required

Response


HttpResponse: OK
Property Type Default response
Status string ok
Code int 200
Success boolean true
Data

array json Consultar: https://api.tempbox.com.br/referencias/camposistema?key=Consultar

HttpResponse: Error
Property Type Default response
Status string error
Code int 500
Success boolean false
Data array json null

HttpResponse: Unauthorized
Property Type Default response
Status string error
Code int 401
Success boolean false
Data array json null
Message string Invalid token