Índice:

Objetivo

Apresentar como utilizar o serviço ConRestProcess.

Requisitos

  Para utilizar os serviços Rest do RM é necessário que o DefultDB esteja configurado.
<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);

/* @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>


<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>


<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>

<div style="border:1px solid #aab8c6;padding:5px;-moz-border-radius: 5px;-webkit-border-radius: 5px;border-radius: 5px;background: #f7f7f7">     
	<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">Alias Default</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">DefaultDB</span><span style="float:right;margin-top: 4px;padding-right:5px;cursor:pointer" onclick="Show('hiddenDiv1', 'img1');"><img id="img1" name="img1" style="width: 16px; height: 16px; margin-top: 3px" src="/download/attachments/309398329/add.png?version=1&modificationDate=1509382756808&api=v2"></span>
			</div>
		</div>
	</div>
	<div style="background: #e2e2e2;">
		<div id="hiddenDiv1" class="HiddenDiv" style="visibility:hidden;height: 0px; line-height: 30px; padding-left: 5px; background: #e2e2e2;">
			<strong></strong>

Acesse a máquina ou servidor que está executando o serviço 
Vá ao diretório C:\totvs\CorporeRM\RM.Net e edite o arquivo RM.Host.Service.exe.config.

Inclua a tag <add key="DefaultDB" value="CorporeRM" /> dentro da limitação appSettings.
O valor a ser atribuído a tag DefaultDB deve ser idêntica ao nome do alias que aponta para a base de dados utilizada. No nosso exemplo que citamos atribuímos o valor "CorporeRM" ao alias e respectivamente ao DefaultDB.

<?xml version="1.0" encoding="utf-8"?>
<configuration>
	<appSettings>
		<add key="JobServer3Camadas" value="false" />
		<add key="Port" value="8050" />
		<add key="ServicesHostName" value="BHD0002773" />
		<add key="ActionsPath" value="C:\totvs\CorporeRM\RM.Net;C:\totvs\CorporeRM\Corpore.Net\Bin" />
		<add key="LibPath" value="C:\totvs\CorporeRM\RM.Net" />
		<add key="EnableDynamicLocalization" value="false" />
		<add key="EnableCompression" value="false" />
		<add key="LocalizationLanguage" value="pt-BR" />
        <add key="DefaultDB" value="CorporeRM" />
	</appSettings>
	<runtime>
		<gcServer enabled="true" />
	</runtime>
</configuration>

</div>
</div>
</div>

Métodos disponibilizados pelo serviço:

Exemplos de Utilização:

<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">ConRestProcess</span>

<span

style="float:left;padding:0px

5px">&raquo</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">&raquo</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;padding:0px

5px">&raquo</span>

<span

style="float:left;font-size:inherit;padding-left:5px">GetSchema</span>

</div>

<div

style="border:

1px

solid

#aab8c6">

<!--

Cabeçalho

-->

<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>

<!--

Body

-->

<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/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">

GetSchema<b> (Method)</b>

</span>

<span

style="float:right;margin-top:

4px;padding-right:5px;cursor:pointer"

onclick="Show('hiddenDiv2',

'img2');">

<img id="img2"

name="img2"

style="width:

16px;

height:

16px;

margin-top:

3px"

src="/download/attachments/309398329/add.png?version=1&modificationDate=1509382756808&api=v2">

</span>

</div>

<div id="hiddenDiv2"

class="HiddenDiv"

style="visibility:hidden;height:

0px;

line-height:

30px;

padding-left:

5px;

background:

#e2e2e2;">

<strong>URL</strong>:

<a

href="http://localhost:8051/rest/conrestprocess/getschema/GlbProcCopyConsSQL"

target="_blank"

>http://localhost:8051/rest/conrestprocess/getschema/GlbProcCopyConsSQL</

a>
</div>

</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:0px

solid

#d0d0d0;padding-bottom:0px;">

<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">

GetSchema<b> (Resposta)</b>

</span>

<span

style="float:right;margin-top:

4px;padding-right:5px;cursor:pointer"

onclick="Show('hiddenDiv3',

'img3');">

<img id="img3"

name="img6"

style="width:

16px;

height:

16px;

margin-top:

3px"

src="/download/attachments/309398329/add.png?version=1&modificationDate=1509382756808&api=v2">

</span>

</div>

<div id="hiddenDiv3" style="

visibility:

hidden;height: 0px; line-height:

30px;

padding-left:

5px;

background:

#e2e2e2;font-weight:normal"></div>

</div>

</div>

<!--

Separador

-->

<div

style="padding:3px"></div>

<div style="border:1px

solid

#aab8c6">

<!--

Cabeçalho

-->

<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>

<!--

Body

-->

<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;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">

Postman<b> (6.0.7)</b>

</span>

<span

style="float:right;margin-top:

4px;padding-right:5px;cursor:pointer"

onclick="Show('hiddenDiv4',

'img4');">

<img id="img4"

name="img4"

style="width:

16px;

height:

16px;

margin-top:

3px"

src="/download/attachments/309398329/add.png?version=1&modificationDate=1509382756808&api=v2">

</span>

</div>

<div id="hiddenDiv4"

style="visibility:hidden;height:

0px;

line-height:

30px;

padding-left:

5px;

background:

#e2e2e2;font-weight:normal"></div>

</div>

</div>

</div>

<!--

Separador

-->

<div

style="padding:10px"></div>

<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">ConRestProcess</span>

<span

style="float:left;padding:0px

5px">&raquo</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">&raquo</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;padding:0px

5px">&raquo</span>

<span

style="float:left;font-size:inherit;padding-left:5px">ExecuteProcess</span>

</div>

<div

style="border:

1px

solid #aab8c6">
<!--

Cabeçalho

-->

<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>

<!--

Body

-->

<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/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">

ExecuteProcess<b> (Method)</b>

</span>

<span

style="float:right;margin-top:

4px;padding-right:5px;cursor:pointer"

onclick="Show('hiddenDiv5',

'img5');">

<img id="img5"

name="img5"

style="width:

16px;

height:

16px;

margin-top:

3px"

src="/download/attachments/309398329/add.png?version=1&modificationDate=1509382756808&api=v2

">
</span>
</div>
<div id="hiddenDiv5"

class="HiddenDiv"

style="visibility:hidden;height:

0px;

line-height:

30px;

padding-left:

5px;

background:

#e2e2e2;">

<strong>URL</strong>:

<a

href="http://localhost:8051/rest/conrestprocess/executeprocess/GlbProcCopyConsSQL"

target="_blank"

>http://localhost:8051/rest/conrestprocess/executeprocess/GlbProcCopyConsSQL</

a>
</div>

</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:0px

solid

#d0d0d0;padding-bottom:0px;">

<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">

ExecuteProcess<b> (Resposta)</b>

</span>

<span

style="float:right;margin-top:

4px;padding-right:5px;cursor:pointer"

onclick="Show('hiddenDiv6',

'img6');">

<img id="img6"

name="img6"

style="width:

16px;

height:

16px;

margin-top:

3px"

src="/download/attachments/309398329/add.png?version=1&modificationDate=1509382756808&api=v2">

</span>
</div>
<div id="hiddenDiv6"

style="visibility:hidden;height:

0px;

line-height:

30px;

padding-left:

5px;

background:

#e2e2e2;font-weight:normal"></div>

</div>

</div>

<!--

Separador

-->

<div

style="padding:3px"></div>

<div style="border:1px

solid

#aab8c6">

<!--

Cabeçalho

-->

<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>

<!--

Body

-->

<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;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">

Postman<b> (6.0.7)</b>

</span>

<span

style="float:right;margin-top:

4px;padding-right:5px;cursor:pointer"

onclick="Show('hiddenDiv7',

'img7');">

<img id="img7"

name="img7"

style="width:

16px;

height:

16px;

margin-top:

3px"

src="/download/attachments/309398329/add.png?version=1&modificationDate=1509382756808&api=v2">

</span>

</div>

<div id="hiddenDiv7"

style="visibility:hidden;height:

0px;

line-height:

30px;

padding-left:

5px;

background:

#e2e2e2;font-weight:normal"></div>

</div>

</div>

</div>