search

usesql / roadmap

Use SQL across your CSVs, Google Sheets, APIs, Airtables, and more!
https://www.usesql.com
1 stars 0 forks source link

Add the ability to scrape a website using xpath #44

Open dylanroy opened 1 year ago

dylanroy commented 1 year ago

💡 For general support requests and bug reports, please email support@usesql.com or check docs.usesql.com

Is your feature request related to a problem? Please describe. I want an easy way to scrape a website and retrieve information that isn't in a table, but still can be returned in a tabular format.

Describe the solution you'd like I would like to be able to write the following query to retrieve prices on pages like the Ebay Deals page.

SELECT 
    '.dne-itemtile-detail span[class^="ebayui-ellipsis"]' as product,
    '.dne-itemtile-detail .dne-itemtile-price span.first' as price
FROM "https://www.ebay.com/deals/"
dylanroy commented 1 year ago

Added this feature to the product. Feel free to take a look at https://www.usesql.com/for/web-scraping for a quick example.