Currency Rates Add-In

Currency Rates Description

Currency Rates add-in displays currency rates based on JSON data from configurable data sources. The Currency Rates add-in can be used as an app part on SharePoint pages.

Currency Rates Configuration

To configure the app, go to the ‘About app’ page (go to the site contents and click on the ‘Currency Rates’ app icon).

Data source configuration

Data source configuration list contains URLs for getting currency rates data.

The app uses Yahoo Query Language (YQL) to receive currency rates. The query is "select * from html where url='<url from datasourse configuration list>'". To check the results and properly configure the app, you can use YQL Console.

The fields are:

  • Title – source name;
  • RequestUrl – URL template for getting currency rates data. It is possible to use the following format specifiers:
    • {{d}} - The day of the month, from 1 through 31
    • {{dd}} - The day of the month, from 01 through 31
    • {{m}} - The month, from 1 through 12
    • {{mm}} - The month, from 01 through 12
    • {{yy}} - The year, from 00 to 99
    • {{yyyy}} - The year as a four-digit number
  • Fraction – fraction used for formatting numeric values
  • Active – the source is used to display data

Data source mapping configuration

Data source mapping configuration list contains paths to data in a JSON object received by requesting the data source.

The fields are:

  • Source – a source from the source list that you want to configure
  • Field – a type of the field to retrieve. You need to have a separate configuration item for each type of the field:
    • Rates array – a path to the array with currency rates
    • Rates date – a path to the currency rate date
    • Currency code – a path to the currency code for an element from the currency array
    • Currency name – a path to the currency name for an element from the currency array
    • Currency rate – a path to the currency rate for an element from the currency array
    • Currency scale – a path to the currency scale for an element from the currency array
  • Path – a JSON path in the object.

Adding Currency Rates to a Page

To add the Currency Rates add-in to a SharePoint page, follow the instructions: https://support.office.com/en-us/article/Add-an-App-Part-to-a-page-6f06c0b7-44b8-4c69-b4ad-85197eee8d78

Should you have any questions, do not hesitate to contact us.