Consuming data from a web site

sebastianmereny · 03-01-2023 07:55 AM

Hi,

Is it possible to create a field in AppSheet that queries a data from an external website and brings it automatically?

For example, create a field of type Decimal called "Exchange Rate" that brings the value of the dollar in my national currency.

And the value I am interested in is from the row "DLS. USA BILLET" and column "Sale".

The idea is that when that value changes in the web site, it also changes in my AppSheet field automatically.

I appreciate if anyone has the answer.
Thank you very much.

Koichi_Tsuji

this should not be posted to AppSheet community but to be posted to Google Workspace commuinity.

your target site should have "table" then you use Spreadsheet formula of IMPORTHTML to get the table data back on Spreadsheet.

then connect sheet with AppSheet as a table.

Steve

@sebastianmereny wrote:

Is it possible to create a field in AppSheet that queries a data from an external website and brings it automatically?

Nope.

danielrpamaker

Hola Sebastian,

En RPAMAKER.COM somos expertos en automatización de procesos y podemos ayudarte a obtener los datos del BCU en un Google Sheet.

Saludos

Daniel