Edgar Silva edgars

## gist:1dcab49543952136c8d1
<sequence xmlns="http://ws.apache.org/ns/synapse" name="resultadoCSVSequence">
   <log level="custom">
      <property name="sequence" value="fileWriteSequence"></property>
   </log>
   <property xmlns:ns2="http://org.apache.synapse/xsd" xmlns:ns="http://org.apache.synapse/xsd" name="transport.vfs.ReplyFileName" expression="fn:concat(fn:substring-after(get-property('MessageID'), 'urn:uuid:'), '.txt')" scope="transport"></property>
   <property name="OUT_ONLY" value="true"></property>
   <send>
      <endpoint name="FileEpr">
         <address uri="vfs:file:///Users/edgar/Documents/esb/csv/saida"></address>
      </endpoint>

## gist:f06ffaeeddda3721827b
<sequence xmlns="http://ws.apache.org/ns/synapse" name="sendMailSequence">
   <log level="custom">
      <property name="sequence" value="sendMailSequence"></property>
   </log>
   <property name="messageType" value="text/html" scope="axis2"></property>
   <property name="ContentType" value="text/html" scope="axis2"></property>
   <property name="Subject" value="File Received" scope="transport"></property>
   <property name="OUT_ONLY" value="true"></property>
   <send>
      <endpoint name="FileEpr">

## bruno.xml
<?xml version="1.0" encoding="UTF-8"?>
<proxy xmlns="http://ws.apache.org/ns/synapse"
       name="CSVProxy"
       transports="vfs"
       statistics="disable"
       trace="disable"
       startOnLoad="true">
   <target>
      <inSequence>
         <log level="full"/>

## bruno2.csv

          
            Cama
            Decoracao de cama e mesa

            
              Moveis
              Moveis de alto padrao

            
              Cervejas
               Cervejas Artesanais

            
              Carnes
               Carnes de Alto Padrao

## gist:7b5f22013a325d5a56dd
SELECT CategoryID, CategoryName, Description FROM northwind.Categories;

## gist:2ca6480a9e0e52d2e37f
INSERT into Categories
(CategoryName,Description) values
(?,?);

## gist:f174aed5c478e7bd05d5
http://www.webservicex.net/globalweather.asmx?WSDL

## gist:7d36d9f2c27468ad6a30
Nome : CurrencyConverterProxy
WSDL: http://www.webservicex.net/currencyconvertor.asmx?wsdl

## gist:0eabd49ec595e45c37bc
<?xml version="1.0" encoding="UTF-8"?>
<proxy xmlns="http://ws.apache.org/ns/synapse"
       name="CSVProxy"
       transports="vfs"
       statistics="disable"
       trace="disable"
       startOnLoad="true">
   <target>
      <inSequence>
         <log level="full"/>

## gist:08fa16e39caf8f12733a
<api xmlns="http://ws.apache.org/ns/synapse" name="MV" context="/api/mv">
   <resource methods="GET" uri-template="/category">
      <inSequence>
         <log level="full"></log>
         <property name="NO_ENTITY_BODY" scope="axis2" action="remove"></property>
         <payloadFactory media-type="xml">
            <format>
               <body></body>
            </format>
            <args></args>
	<sequence xmlns="http://ws.apache.org/ns/synapse" name="resultadoCSVSequence">
	<log level="custom">
	<property name="sequence" value="fileWriteSequence"></property>
	</log>
	<property xmlns:ns2="http://org.apache.synapse/xsd" xmlns:ns="http://org.apache.synapse/xsd" name="transport.vfs.ReplyFileName" expression="fn:concat(fn:substring-after(get-property('MessageID'), 'urn:uuid:'), '.txt')" scope="transport"></property>
	<property name="OUT_ONLY" value="true"></property>
	<send>
	<endpoint name="FileEpr">
	<address uri="vfs:file:///Users/edgar/Documents/esb/csv/saida"></address>
	</endpoint>
	<sequence xmlns="http://ws.apache.org/ns/synapse" name="sendMailSequence">
	<log level="custom">
	<property name="sequence" value="sendMailSequence"></property>
	</log>
	<property name="messageType" value="text/html" scope="axis2"></property>
	<property name="ContentType" value="text/html" scope="axis2"></property>
	<property name="Subject" value="File Received" scope="transport"></property>
	<property name="OUT_ONLY" value="true"></property>
	<send>
	<endpoint name="FileEpr">
	<?xml version="1.0" encoding="UTF-8"?>
	<proxy xmlns="http://ws.apache.org/ns/synapse"
	name="CSVProxy"
	transports="vfs"
	statistics="disable"
	trace="disable"
	startOnLoad="true">
	<target>
	<inSequence>
	<log level="full"/>
	Cama	Decoracao de cama e mesa
	Moveis	Moveis de alto padrao
	Cervejas	Cervejas Artesanais
	Carnes	Carnes de Alto Padrao
	INSERT into Categories
	(CategoryName,Description) values
	(?,?);
	Nome : CurrencyConverterProxy
	WSDL: http://www.webservicex.net/currencyconvertor.asmx?wsdl
	<api xmlns="http://ws.apache.org/ns/synapse" name="MV" context="/api/mv">
	<resource methods="GET" uri-template="/category">
	<inSequence>
	<log level="full"></log>
	<property name="NO_ENTITY_BODY" scope="axis2" action="remove"></property>
	<payloadFactory media-type="xml">
	<format>
	<body></body>
	</format>
	<args></args>