Forum Discussion

atapia197's avatar
atapia197
Frequent Visitor
8 years ago
Solved

get data web with calendar options

Hi all, here is the challenge ;)

 

I am getting data web from booking.com, using for example this url:

 

https://www.booking.com/hotel/es/marina.es.html?label=gen173nr-1FCAEoggJCAlhYSDNYBGhGiAEBmAEKwgEDYWJuyAEU2AEB6AEB-AELkgIBeagCBA;sid=ad5bdc9f752a31a45da242f60929b3f9;checkin=2018-05-25;checkout=2018-05-26;ucfs=1;srpvid=9ac6615f846900ac;srepoch=1527256257;highlighted_blocks=9729201_90772511_0_0_0;all_sr_blocks=9729201_90772511_0_0_0;bshb=2;room1=A%2CA;hpos=1;hapos=1;dest_type=city;dest_id=-373226;srfid=5e48963f46da5da1c0e069a14222ace2b6112768X1;from=searchresults;hptv=do#hotelTmpl

 

PowerBI returns a table with the rates of this Hotel for these dates: checkin=2018-05-25;checkout=2018-05-26

 

The question is: If I have an excel with X urls with different checkin&checkout dates, is there any way to merge the different tables of each url, with a process like the Get Data Folder (creating a parameter, function and example file)?

 

Thanks a lot.

1 Reply