Get Data From Web

[learningthings]

Hi everyone, I have this link:

https://api.metalpriceapi.com/v1/latest?api_key=a886016317100cc59d6ffd920c13376c&base=USD&currencies=EUR,XAU,XAG

It gives live precious metal prices. I want to create a code where if I click a button (cmd1) on my form (form1) my textbox (txt1) is filled with the xau price (ex. "XAU":0.00053665)

I've tried looking for answers but nothing seems to work quite right. Any help is so much appreciated! Thank you

 

[welshgasman]

Google web scraping

 

[jdellasala]

Go to Data -> From Web, paste your URL into the field when requested, use an Anonymous connection, and the data will be pulled in as a Record. Click the Into Table button at the top right, and you'll see a table like this:

Name	Value
success	TRUE
base	USD
timestamp	1676715940
rates	[Record]

Double click on [Record] to show the Record's values, and then click the Into Table button again. Select the Home tab and select the Drop Down and chose Close & Load To... and select Table when prompted. You'll end up with a table like this:

Book1
	A	B
1	Name	Value
2	EUR	0.93492895
3	XAG	0.04602145
4	XAU	0.00054277
Sheet1

It appears to be a live feed. Clicking Refresh All in the Data tab updates the values.