May 01 2021 06:52 PM - edited May 01 2021 07:09 PM
hi.
here is a site where i would like to get data from
https://www.sodimac.cl/sodimac-cl/
now lets go to actual page
sodimac- construccion y ferreteria- materiales de construccion- tabiqueria- yeso/carton-volcanita
you should land on this page
https://www.sodimac.cl/sodimac-cl/category/scat102027/?cid=bnnlnd74741
take a note what sity (commune) is selected there they have their headquarter.
lets change commune to
region: Vlll region del bio bio
comuna: los angeles
and you will have los angeles
if i open link from my default browser, i already will have my location because have account open there
for me, to get their default commune, i have to open link in private mode (incognito mode)
so,
from this page we want to get items number and price.
from here and from each category the store has.
my idea was to
create a table with bunch of links for each category and
by power query get needed info
bunch links for each category and pages available. one link can show maximum 28 items.
here is example
below there is a file how i am getting the data. in short
- table with links
- power query
- read link as a text file, because as html table i have nothing)
- splitting columns by delimiter to separate info needed
- filtering and deleting columns
- wrapping it all as a function to get data from multiple links in a table
- loading another query with this function
problem: i get items and prices from default commune (cerrillos).
in different communes availability and prices are different.
in cerrillos you have 19 items evailable,
in los angeles - 10
how can i get info from my commune, los angeles?
looks like excel opens link as in private mode, or like you just did.
if it has something to do with permissions,
i tried other options, and had no difference.
if you think here can be solution, please tell.
hope here is enough info to get best solution.
many thanks to any help and advices provided