How to solve error when importing XML in google sheets? (could not fetch the URL)

Question

I would like to scrape price in the specific product link, but it turns error when I wrote the formula like this.

=IMPORTXML(https://www.tokopedia.com/foodrepublic/koepoe-koepoe-natrium-benzoat-33-gr-pengawet-makanan-minuman-halal,"//*[@id='pdp_comp-product_content']/div/div[2]/div")

page i want to scrape

Answer 1

you forgot to enclose the URL with double quotes. the correct syntax is:

=IMPORTXML("https://www.tokopedia.com/foodrepublic/koepoe-koepoe-natrium-benzoat-33-gr-pengawet-makanan-minuman-halal"; 
 "//*[@id='pdp_comp-product_content']/div/div[2]/div")