Evaluando propuestas

Crear consulta automatica Xml desde Google Sheets

Publicado el 24 Febrero, 2021 en Programación y Tecnología

Sobre este proyecto

Abierto

Buenas necesito crear una consulta automática en google apps básicamente necesito que google sheets cada 5 minutos me envie un XLM con la consult a un ip y un puerto y esta le va a devolver otro xml con la información que debe organizar

Yo le envio esto como un POST

<soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<soap:Header>
<HTNGHeader xmlns="http://htng.org/1.1/Header/">
<EX_HOTEL>
    <login>
      <username>p1</username>
      <password>p1</password>
    </login>
</EX_HOTEL>
</HTNGHeader>
</soap:Header>

<soap:Body>
<GET_EXT_INHOUSE>
  <Query_Date>2021-02-24</Query_Date>
</GET_EXT_INHOUSE>
</soap:Body>

</soap:Envelope>

El me devuelve esto

<INHOUSE>
    <RESERVATION_LINE ID="10001">
        <Reservation_ID>RS-0001101</Reservation_ID>
        <Booking>ATAN147111</Booking>
        <Arrival> 2021-02-20</Arrival>
        <Departure> 2021-03-03</Departure>
        <Room>16</Room>
        <RoomType>1</RoomType>
        <Agency>memorable costa rica</agency>
        <guarantee>02</guarantee>
        <marketcode>02</marketcode>
        <submarketcode>01</submarketcode>
        <guestprofile>
            <name>jana</name>
            <surname>jungwirth</surname>
            <identification>522825674</identification>
            <telephone1>(920)6026524</telephone1>
            <telephone2></telephone2>
            <pobox></pobox>
            <country>us</country>
            <email>rydjackson@yahoo.com</email>
            <BirthDate>11-1976</BirthDate>
        </GuestProfile>
    </RESERVATION_LINE>
    <RESERVATION_LINE ID="10001">
        <Reservation_ID>RS-0001270</Reservation_ID>
        <Booking></Booking>
        <Arrival> 2021-02-24</Arrival>
        <Departure> 2021-02-27</Departure>
        <Room>19</Room>
        <RoomType>1</RoomType>
        <Agency>costa rican trails</agency>
        <guarantee>02</guarantee>
        <marketcode>02</marketcode>
        <submarketcode>01</submarketcode>
        <guestprofile>
            <name>maria</name>
            <surname>cancel</surname>
            <identification></identification>
            <telephone1></telephone1>
            <telephone2></telephone2>
            <pobox></pobox>
            <country>us</country>
            <email></email>
            <birthdate>0-0</birthdate>
        </guestprofile>
    </reservation_line>
    <reservation_line id="10001">
        <reservation_id>rs-0001359</reservation_id>
        <booking></booking>
        <arrival> 2021-02-24</arrival>
        <departure> 2021-02-27</departure>
        <room>25</room>
        <roomtype>1</roomtype>
        <agency>completely costa rica</agency>
        <guarantee>02</guarantee>
        <marketcode>02</marketcode>
        <submarketcode>01</submarketcode>
        <guestprofile>
            <name>amanda</name>
            <surname>tornquist</surname>
            <identification></identification>
            <telephone1></telephone1>
            <telephone2></telephone2>
            <pobox></pobox>
            <country>us</country>
            <email></email>
            <birthdate>0-0</birthdate>
        </guestprofile>
    </reservation_line>
    <reservation_line id="10001">
        <reservation_id>rs-0001395</reservation_id>
        <booking>arfi157912</booking>
        <arrival> 2021-02-23</arrival>
        <departure> 2021-02-26</departure>
        <room>05</room>
        <roomtype>1</roomtype>
        <agency>ara tours</agency>
        <guarantee>02</guarantee>
        <marketcode>03</marketcode>
        <submarketcode>03</submarketcode>
        <guestprofile>
            <name>kilian</name>
            <surname>meier</surname>
            <identification>x2763543</identification>
            <telephone1></telephone1>
            <telephone2></telephone2>
            <pobox></pobox>
            <country>ch</country>
            <email>kilian_meier@bluewin.ch</email>
            <BirthDate>0-0</BirthDate>
        </GuestProfile>
    </RESERVATION_LINE>
    <RESERVATION_LINE ID="10001">
        <Reservation_ID>RS-0001402</Reservation_ID>
        <Booking></Booking>
        <Arrival> 2021-02-24</Arrival>
        <Departure> 2021-02-28</Departure>
        <Room>21</Room>
        <RoomType>1</RoomType>
        <Agency>costa rican trails</agency>
        <guarantee>02</guarantee>
        <marketcode>02</marketcode>
        <submarketcode>01</submarketcode>
        <guestprofile>
            <name>michael</name>
            <surname>ross</surname>
            <identification>549896629</identification>
            <telephone1></telephone1>
            <telephone2></telephone2>
            <pobox></pobox>
            <country>us</country>
            <email>rosel9321@aol.com</email>
            <BirthDate>2-50</BirthDate>
        </GuestProfile>
    </RESERVATION_LINE>
    <RESERVATION_LINE ID="10001">
        <Reservation_ID>RS-0001418</Reservation_ID>
        <Booking>ATFI148133</Booking>
        <Arrival> 2021-02-20</Arrival>
        <Departure> 2021-02-25</Departure>
        <Room>15</Room>
        <RoomType>2</RoomType>
        <Agency>memorable costa rica</agency>
        <guarantee>02</guarantee>
        <marketcode>02</marketcode>
        <submarketcode>01</submarketcode>
        <guestprofile>
            <name>kent</name>
            <surname>stewart</surname>
            <identification>657079209</identification>
            <telephone1></telephone1>
            <telephone2></telephone2>
            <pobox></pobox>
            <country>us</country>
            <email>kstewart1082@gmail.com</email>
            <BirthDate>10-95</BirthDate>
        </GuestProfile>
    </RESERVATION_LINE>
    <RESERVATION_LINE ID="10001">
        <Reservation_ID>RS-0001429</Reservation_ID>
        <Booking>1971432</Booking>
        <Arrival> 2021-02-21</Arrival>
        <Departure> 2021-02-25</Departure>
        <Room>03</Room>
        <RoomType>1</RoomType>
        <Agency>anywhere costa rica</agency>
        <guarantee>02</guarantee>
        <marketcode>02</marketcode>
        <submarketcode>01</submarketcode>
        <guestprofile>
            <name>jack</name>
            <surname>bannister</surname>
            <identification>518760298</identification>
            <telephone1></telephone1>
            <telephone2></telephone2>
            <pobox></pobox>
            <country>us</country>
            <email>jacksbannister@gmail.com</email>
            <BirthDate>2-85</BirthDate>
        </GuestProfile>
    </RESERVATION_LINE>
    <RESERVATION_LINE ID="10001">
        <Reservation_ID>RS-0001485</Reservation_ID>
        <Booking></Booking>
        <Arrival> 2021-02-23</Arrival>
        <Departure> 2021-02-26</Departure>
        <Room>09</Room>
        <RoomType>1</RoomType>
        <Agency>DIRECTOS</Agency>
        <Guarantee>01</Guarantee>
        <MarketCode>01</MarketCode>
        <SubMarketCode>01</SubMarketCode>
        <GuestProfile>
            <Name>JANOS</Name>
            <Surname>SKARE</Surname>
            <Identification>BJ7786446</Identification>
            <Telephone1></Telephone1>
            <Telephone2></Telephone2>
            <POBox></POBox>
            <Country>HU</Country>
            <email>jskore@gmail.com</email>
            <BirthDate>2-72</BirthDate>
        </GuestProfile>
    </RESERVATION_LINE>
    <RESERVATION_LINE ID="01001">
        <Reservation_ID>WR-001461</Reservation_ID>
        <Booking>OTA-1726343231-04</Booking>
        <Arrival> 2021-02-22</Arrival>
        <Departure> 2021-02-26</Departure>
        <Room>20</Room>
        <RoomType>1</RoomType>
        <Agency>EXPEDIA.COM</Agency>
        <Guarantee>02</Guarantee>
        <MarketCode></MarketCode>
        <SubMarketCode>2</SubMarketCode>
        <GuestProfile>
            <Name>MEGAN</Name>
            <Surname>VOEPEL</Surname>
            <Identification>538717871</Identification>
            <Telephone1>0 0 8165031361</Telephone1>
            <Telephone2></Telephone2>
            <POBox></POBox>
            <Country>US</Country>
            <email>voepel.megan@gmail.com</email>
            <BirthDate>0-0</BirthDate>
        </GuestProfile>
    </RESERVATION_LINE>
    <RESERVATION_LINE ID="01001">
        <Reservation_ID>WR-001766</Reservation_ID>
        <Booking>QVZJMMH</Booking>
        <Arrival> 2021-02-24</Arrival>
        <Departure> 2021-02-25</Departure>
        <Room></Room>
        <RoomType>1</RoomType>
        <Agency>directos web</agency>
        <guarantee>01</guarantee>
        <marketcode></marketcode>
        <submarketcode>0</submarketcode>
        <guestprofile>
            <name>thomas</name>
            <surname>morley</surname>
            <identification></identification>
            <telephone1>13106288464</telephone1>
            <telephone2></telephone2>
            <pobox></pobox>
            <country>us</country>
            <email>globaltriberetreats@gmail.com</email>
            <BirthDate>0-0</BirthDate>
        </GuestProfile>
    </RESERVATION_LINE>
</INHOUSE>

Categoría Programación y Tecnología
Subcategoría Programación Web
¿Cuál es el alcance del proyecto? Bug o cambio pequeño
¿Es un proyecto o una posición? Un proyecto
Actualmente tengo No aplica
Disponibilidad requerida Según se necesite
Roles necesarios Programador

Plazo de Entrega: No definido

Habilidades necesarias