As of dbFront 1.2.0.0730, you can now select the action button type of WebRequest.
This allows you to pull data into a table field. You can receive the data as either RAW, JSON or XML.
You would mark the data as RAW if the data is neither Json or Xml or if you want to process the data yourself using database specific JSON and XML handling functionality.
If you select JSON then you need to specify a JsonPath string that will be used to parse and extract the data you want.
If you select XML then you need to specify the XPath string that will be used to parse and extract the data you want.
In the original request the URL pointed to an XML data set. To retrieve the currency type and rate you would:
- Add a new Action Button of the type WebRequest,
- Set the URL to: 'http://www.ecb.int/stats/eurofxref/eurofxref-daily.xml'
- Set the data type to XML,
- Set the XPath string to: "//Cube/@rate|//Cube/@currency".
The result would be a listing of Currency Names and Currency Rates.
JsonPath Syntax and Help
XPath Syntax And Help