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>
Plazo de Entrega: No definido