Solved: Trying to get web contents from job board

jaryszek · ‎12-07-2022

hi Guys,

i want to get this job searching results into Power Query in Excel:

https://justjoin.it/?q=business%20analyst@keyword

How to make relative path and query in web contents to get full table?

Best,
Jacek

v-jingzhang · ‎12-07-2022

Hi @jaryszek

Relative path and query is usually used when querying data from an API. However the job searching results are displayed in the web page, I'm afraid Web.Contents() function cannot get this data.

Please try if Extract data from a Web page by example feature helps.

Power Query Get Data from Web by Example • My Online Training Hub

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.

View solution in original post

v-jingzhang · ‎12-07-2022

Hi @jaryszek

Relative path and query is usually used when querying data from an API. However the job searching results are displayed in the web page, I'm afraid Web.Contents() function cannot get this data.

Please try if Extract data from a Web page by example feature helps.

Power Query Get Data from Web by Example • My Online Training Hub

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.