Histórico da Página
Aviso |
---|
Os serviços do Corpore RM com as funcionalidades para utilização do TOTVS | HTML Framework estarão disponíveis em 2016. No momento versões controladas serão disponibilizadas para as equipes de Segmentos envolvidas no projeto de Experiências de Uso |
Nota | ||
---|---|---|
| ||
Disponível à partir da versão 12.1.6 da linha RM. |
Get
Retorna o registro do dataserver representado pelo identificador da URL {id}. O FrameHTML faz a manipulação dos dados considerando que o mesmo possui um campo id como chave. Isso causa limitações no RM visto que a maior parte das chaves primárias do RM são compostas. Para contornar esse problema foi necessário concatenar o valor dos campos da chave primária e um campo chamado id (Caso já exista um campo id na tabela, esse será renomeado no json para "RESTDS_TEMP_id").
O id é o resultado da concatenação da chave primária utilizando como separador a string "$_$". Se for tomado como exemplo a tabela local de estoque e um registro cujos campos CodColigada, CodFilial e CodLoc possuem, respectivamente, os valores 1, 1 e 06, o identificador que será gerado no json de retorno será "1$_$1$_$06".
O analista não deve manipular o valor do campo id, uma vez que ele é para uso interno do FrameHTML e do RM Host.
HTML |
---|
<script type="text/javascript" language="javascript"> /* @license ! jQuery-mutate - v0.0.2 - * Licensed under the MIT license * http://www.opensource.org/licenses/mit-license.php * Date: 2015-04-19 */ !function(t){mutate_event_stack=[{name:"width",handler:function(a){var e=t(a);return e.data("mutate-width")||e.data("mutate-width",e.width()),e.data("mutate-width")&&e.width()!=e.data("mutate-width")?(e.data("mutate-width",e.width()),!0):!1}},{name:"height",handler:function(a){var e=t(a);return e.data("mutate-height")||e.data("mutate-height",e.height()),e.data("mutate-height")&&e.height()!=e.data("mutate-height")?(e.data("mutate-height",e.height()),!0):void 0}},{name:"top",handler:function(a){var e=t(a);return e.data("mutate-top")||e.data("mutate-top",e.css("top")),e.data("mutate-top")&&e.css("top")!=e.data("mutate-top")?(e.data("mutate-top",e.css("top")),!0):void 0}},{name:"bottom",handler:function(a){var e=t(a);return e.data("mutate-bottom")||e.data("mutate-bottom",e.css("bottom")),e.data("mutate-bottom")&&e.css("bottom")!=e.data("mutate-bottom")?(e.data("mutate-bottom",e.css("bottom")),!0):void 0}},{name:"right",handler:function(a){var e=t(a);return e.data("mutate-right")||e.data("mutate-right",e.css("right")),e.data("mutate-right")&&e.css("right")!=e.data("mutate-right")?(e.data("mutate-right",e.css("right")),!0):void 0}},{name:"left",handler:function(a){var e=t(a);return e.data("mutate-left")||e.data("mutate-left",e.css("left")),e.data("mutate-left")&&e.css("left")!=e.data("mutate-left")?(e.data("mutate-left",e.css("left")),!0):void 0}},{name:"hide",handler:function(a){var e=t(a),r=e.is(":hidden"),d=void 0==e.data("prev-hidden")?r:e.data("prev-hidden");return e.data("prev-hidden",r),r&&r!=d?!0:void 0}},{name:"show",handler:function(a){var e=t(a),r=e.is(":visible"),d=void 0==e.data("prev-visible")?r:e.data("prev-visible");return e.data("prev-visible",r),r&&r!=d?!0:void 0}},{name:"scrollHeight",handler:function(a){var e=t(a);return e.data("prev-scrollHeight")||e.data("prev-scrollHeight",e[0].scrollHeight),e.data("prev-scrollHeight")&&e[0].scrollHeight!=e.data("prev-scrollHeight")?(e.data("prev-scrollHeight",e[0].scrollHeight),!0):void 0}},{name:"scrollWidth",handler:function(a){var e=t(a);return e.data("prev-scrollWidth")||e.data("prev-scrollWidth",e[0].scrollWidth),e.data("prev-scrollWidth")&&e[0].scrollWidth!=e.data("prev-scrollWidth")?(e.data("prev-scrollWidth",e[0].scrollWidth),!0):void 0}},{name:"scrollTop",handler:function(a){var e=t(a);return e.data("prev-scrollTop")||e.data("prev-scrollTop",e[0].scrollTop()),e.data("prev-scrollTop")&&e[0].scrollTop()!=e.data("prev-scrollTop")?(e.data("prev-scrollTop",e[0].scrollTop()),!0):void 0}},{name:"scrollLeft",handler:function(a){var e=t(a);return e.data("prev-scrollLeft")||e.data("prev-scrollLeft",e[0].scrollLeft()),e.data("prev-scrollLeft")&&e[0].scrollLeft()!=e.data("prev-scrollLeft")?(e.data("prev-scrollLeft",e[0].scrollLeft()),!0):void 0}}]}(jQuery); |
HTML |
---|
/* @license ! jQuery-mutate - v0.0.1 - * Licensed under the MIT license * http://www.opensource.org/licenses/mit-license.php * Date: 2015-04-19 */ !function(a){function b(){var c=mutate;"undefined"!=c.event_stack&&c.event_stack.length&&a.each(c.event_stack,function(a,b){mutate.add_event(b)}),c.event_stack=[],a.each(c.stack,function(b,d){a(d.selector).each(function(a,b){c.events[d.event_name](b)===!0?d.callback&&d.callback(b,d):d.false_callback&&d.false_callback(b,d)})}),setTimeout(b,mutate.speed)}mutate={speed:100,event_stack:mutate_event_stack,stack:[],events:{},add_event:function(a){mutate.events[a.name]=a.handler},add:function(a,b,c,d){mutate.stack[mutate.stack.length]={event_name:a,selector:b,callback:c,false_callback:d}}},b(),a.fn.extend({mutate:function(){var b=!1,c=arguments[1],d=this,e=arguments[2]?arguments[2]:function(){};return"extend"==arguments[0].toLowerCase()?(mutate.add_event(c),this):(a.each(a.trim(arguments[0]).split(" "),function(a,f){b=f,mutate.add(b,d,c,e)}),this)}})}(jQuery); </script> |
HTML |
---|
<style type="text/css"> .expand-container{ margin-top:5px !important; font-weight: normal !important; } .expand-control{ margin-bottom: 5px !important; } pre{ white-space: inherit !important; } table tr:nth-child(odd), table tr:nth-child(odd) > *{ background: transparent !important; border: 0 !important; } .pdl .codeContent .gutter{ border-right: 1px solid #ccc !important; } .wiki-content .innerCell { overflow-y: hidden; } .HiddenDiv .confluence-information-macro { width: calc(100% - 25px); background: #fff !important; border: 0 !important; -moz-border-radius: 0px !important; -webkit-border-radius: 0px !important; border-radius: 0px !important; color: #333; margin: 10px 0 1em 0; min-height: 20px; padding: 10px; position: relative; } .HiddenDiv .confluence-information-macro .confluence-information-macro pre{ display: none; } .HiddenDiv .wiki-content a:link, .HiddenDiv .wiki-content a, .HiddenDiv .tab-nav-link, .HiddenDiv .current{ color: #000 !important; } .wiki-content a:link { color: #000 !important; } .lastDiv + pre{ font-family: inherit; } </style> |
Exemplo de utilização
HTML |
---|
<div style="border:1px solid #aab8c6;padding:5px;-moz-border-radius: 5px;-webkit-border-radius: 5px;border-radius: 5px;background: #f7f7f7"> <div style="background:#f7f7f7;width:calc(100% - 10px);height:30px;color: #000;font-weight:bold;font-size: 16px;padding:5px;border-bottom: 1px solid #aab8c6;margin-bottom:14px"> <span style="float:left"><img style="width: 16px; height: 16px; margin-top:3px" src="/download/attachments/309398329/folder3.png?version=2&modificationDate=1509366835661&api=v2" /></span> <span style="float:left;font-size:inherit;padding-left:5px">Restful</span> <span style="float:left;padding:0px 5px">»</span> <span style="float:left"><img style="width: 16px; height: 16px; margin-top:3px" src="/download/attachments/309398329/transfer3.png?version=2&modificationDate=1509366835358&api=v2" /></span> <span style="float:left;font-size:inherit;padding-left:5px">localhost:8051</span> <span style="float:left;padding:0px 5px">»</span> <span style="float:left"><img style="width: 16px; height: 16px; margin-top:3px" src="/download/attachments/190516500/copy.png?version=1&modificationDate=1509567801070&api=v2"/></span> <span style="float:left;font-size:inherit;padding-left:5px">1$_$1$_$06</span> <span style="float:left;padding:0px 5px">»</span> <span style="float:left"><img style="width: 16px; height: 16px; margin-top:3px" src="/download/attachments/190516500/programming-code-signs.png?version=1&modificationDate=1509568429032&api=v2"/></span> <span style="float:left;font-size:inherit;padding-left:5px">GET</span> </div> <div style="border: 1px solid #aab8c6"> <div style="background:#f7f7f7;width:calc(100% - 10px);height:30px;color: #000;font-weight:bold;font-size: 16px;padding:5px;border-bottom: 0px;"> <span style="float:left;margin-top: 4px"><img style="width: 16px; height: 16px; margin-top:3px" src="/download/attachments/190516500/info.png?version=1&modificationDate=1509568958717&api=v2" /></span> <span style="float:left;font-size:inherit;padding-left:5px;margin-top: 3px">Informações Gerais</span> </div> <div style="background:#f0f0f0;width:calc(100% - 10px);height:auto;min-height:30px;color: #000;font-weight:bold;font-size: 16px;padding:5px;border-bottom: 0px;"> <div><span style="float:left;margin-top: 4px;font-weight:normal !important"><img style="width: 16px; height: 16px; margin-top:3px" src="/download/attachments/190516500/programming-code-signs.png?version=1&modificationDate=1509568429032&api=v2" /></span> <span style="float:left;font-size:inherit;padding-left:5px;margin-top: 4px;font-weight:normal !important">Get <b>(Method)</b></span><span style="float:right;margin-top: 4px;padding-right:5px;cursor:pointer" onclick="Show('hiddenDiv22', 'img22');"><img id="img22" name="img22" style="width: 16px; height: 16px; margin-top: 3px" src="/download/attachments/309398329/add.png?version=1&modificationDate=1509382756808&api=v2"></span></div> </div> <div style="background: #e2e2e2;"> <div id="hiddenDiv22" class="HiddenDiv" style="visibility:hidden;height: 0px; line-height: 30px; padding-left: 5px; background: #e2e2e2;"> <strong>URL</strong>: <a href="http://localhost:8051/rmsrestdataserver/rest/EstLOCData/1$_$1$_$06" target="_blank">http://localhost:8051/rmsrestdataserver/rest/EstLOCData/1$_$1$_$06</a> |
HTML |
---|
</div> </div> </div> <div style="padding:7px"></div> <div style="border: 1px solid #aab8c6"> <div style="background:#f7f7f7;width:calc(100% - 10px);height:30px;color: #000;font-weight:bold;font-size: 16px;padding:5px;border-bottom: 0px;"> <span style="float:left;margin-top: 4px"><img style="width: 16px; height: 16px; margin-top:3px" src="/download/attachments/190516500/json.png?version=1&modificationDate=1509569485552&api=v2" /></span> <span style="float:left;font-size:inherit;padding-left:5px;margin-top: 3px">Modelo JSON</span> </div> <div style="background:#f0f0f0;width:calc(100% - 10px);height:auto;min-height:30px;color: #000;font-weight:bold;font-size: 16px;padding:5px;border-bottom: 0px;"> <div><span style="float:left;margin-top: 4px;font-weight:normal !important"><img style="width: 16px; height: 16px; margin-top:3px" src="/download/attachments/309398329/programming-code.png?version=1&modificationDate=1509451197195&api=v2" /></span> <span style="float:left;font-size:inherit;padding-left:5px;margin-top: 4px;font-weight:normal !important">Get <b>(Resposta)</b></span><span style="float:right;margin-top: 4px;padding-right:5px;cursor:pointer" onclick="Show('hiddenDiv16', 'img16');"><img id="img16" name="img16" style="width: 16px; height: 16px; margin-top: 3px" src="/download/attachments/309398329/add.png?version=1&modificationDate=1509382756808&api=v2"></span></div> </div> <div style="background: #e2e2e2;"> <div id="hiddenDiv16" class="HiddenDiv" style="visibility:hidden;height: 0px; line-height: 30px; padding-left: 5px; background: #e2e2e2;"> <strong>Descrição:</strong> Retorna o registro do dataserver representado pelo identificador da URL {id}. |
Informações | |||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|
| |||||||||||
|
HTML |
---|
</div> </div> </div> <div style="padding:7px"></div> <div style="border: 1px solid #aab8c6"> <div style="background:#f7f7f7;width:calc(100% - 10px);height:30px;color: #000;font-weight:bold;font-size: 16px;padding:5px;border-bottom: 0px;"> <span style="float:left;margin-top: 4px"><img style="width: 16px; height: 16px; margin-top:3px" src="/download/attachments/190516500/binary-code.png?version=1&modificationDate=1509570539048&api=v2" /></span> <span style="float:left;font-size:inherit;padding-left:5px;margin-top: 3px">Exemplos</span> </div> <div style="background:#f0f0f0;width:calc(100% - 10px);height:auto;min-height:30px;color: #000;font-weight:bold;font-size: 16px;padding:5px;border-bottom: 0px;"> <div style="width:100%;height: 30px;border-bottom:1px solid #d0d0d0;padding-bottom:5px;"><span style="float:left;margin-top: 4px;font-weight:normal !important"><img style="width: 16px; height: 16px; margin-top:3px" src="/download/attachments/190516500/new-page-view.png?version=1&modificationDate=1509570210360&api=v2" /></span> <span style="float:left;font-size:inherit;padding-left:5px;margin-top: 4px;font-weight:normal !important">SOAP UI <b>(5.3.0)</b></span><span style="float:right;margin-top: 4px;padding-right:5px;cursor:pointer" onclick="Show('hiddenDiv17', 'img17');"><img id="img17" name="img17" style="width: 16px; height: 16px; margin-top: 3px" src="/download/attachments/309398329/add.png?version=1&modificationDate=1509382756808&api=v2"></span></div> <div style="background: #e2e2e2;"> <div id="hiddenDiv17" style="visibility:hidden;height: 0px; line-height: 30px; padding-left: 5px; background: #e2e2e2;font-weight:normal"> Criar um novo projeto <strong>REST</strong> no <strong>SOAP UI</strong>: <div style="background: #fff; padding:10px;text-align:center;width:calc(100% - 25px);margin:10px 0px;"> |
HTML |
---|
</div> Após a criação do projeto, o método GET irá ser apresentado, como a imagem abaixo: <div style="background: #fff; padding:10px;text-align:center;width:calc(100% - 25px);margin:10px 0px;"> |
HTML |
---|
</div> Não se esqueça que a <strong>Autenticação</strong> Basic deverá ser preenchida. <div style="background: #fff; padding:10px;text-align:center;width:calc(100% - 25px);margin:10px 0px;"> |
HTML |
---|
</div> Ao realizar a requisição o resultado é apresentado como a imagem abaixo: <div style="background: #fff; padding:10px;text-align:center;width:calc(100% - 25px);margin-top:10px;"> |
HTML |
---|
</div> </div> </div> <div style="width:100%;height: 30px;padding-top:5px"><span style="float:left;margin-top: 4px;font-weight:normal !important"><img style="width: 16px; height: 16px; margin-top:3px" src="/download/attachments/190516500/new-page-view.png?version=1&modificationDate=1509570210360&api=v2" /></span> <span style="float:left;font-size:inherit;padding-left:5px;margin-top: 4px;font-weight:normal !important">POC <b>(1.0.0 - Owner)</b></span><span style="float:right;margin-top: 4px;padding-right:5px;cursor:pointer" onclick="Show('hiddenDiv18', 'img18');"><img id="img18" name="img18" style="width: 16px; height: 16px; margin-top: 3px" src="/download/attachments/309398329/add.png?version=1&modificationDate=1509382756808&api=v2"></span></div> <div style="background: #e2e2e2;"> <div id="hiddenDiv18" style="visibility:hidden;height: 0px; line-height: 30px; padding-left: 5px; background: #e2e2e2;font-weight:normal"> Foi criado uma aplicação à parte do <strong>RM</strong> que faz a requisição ao serviço de <strong>Rest</strong> através do método <strong>GET</strong>, e a resposta obtida foi a mesma que a apresentada pelo <strong>SOAP UI</strong>. <div class="lastDiv" style="background: #fff; padding:10px;text-align:center;width:calc(100% - 25px);margin-top:10px;"> |
HTML |
---|
</div> |
O Download da POC pode ser realizado aqui.
HTML |
---|
</div> </div> </div> </div> </div> |
HTML |
---|
<script type="text/javascript" language="javascript"> Show = function(divName, imgName){ window["currentElement"] = divName; if(typeof divName === "string"){ if(document.getElementById(divName).offsetHeight < 2){ $("#" + divName).animate({height: $("#" + divName).get(0).scrollHeight + 7}); $("#" + divName).css("visibility", "visible") $("#" + imgName).attr('src', '/download/attachments/309398329/remove.png?version=1&modificationDate=1509386912062&api=v2'); $(".HiddenDiv .tab-nav-link").on("click", function(){ window["currentElement"] = $(this).parents().find(".HiddenDiv").attr("id"); }); $(".HiddenDiv .confluence-information-macro").mutate('height',function (element,info){ this.selector.each(function(index, element){ if($(this).parent().attr("id") == window["currentElement"]) $(this).parent().height($(this).outerHeight() + 61); }); }); } else{ $("#" + divName).animate({height: "0px"}); $("#" + divName).css("visibility", "hidden") $("#" + imgName).attr('src', '/download/attachments/309398329/add.png?version=1&modificationDate=1509382756808&api=v2'); } } } </script> |