Scheduler
- Add – Authentication Type details now has a new option to restrict its usage the to the original Task and Action Code at the time of its creation. This prevents the details being used to retrieve other content at a later date if the Task is cloned for example.
- Change – Developer Tab revised to show more examples.
Query Builder
- Fix – The Expression FinancialDataSpot() was using Google Finance API to get the currency rates but it stopped working due to Google policy changes. The Google API calls has now been replaced with the European Central Bank API https://exchangeratesapi.io/ This provides the worlds main currencies, however it does not do Stock exchange prices. The function FinancialDataSpot works basically the same way as it did before but with the new feature of also providing a date. The default is always todays rate if a date is not passed. E.g FinancialDataSpot( “CURRENCY”, “USDGBP” ) or FinancialDataSpot( “CURRENCY”, “USDGBP”,”2018-11-23” )
- Fix – System Finance Data Historical and Spot are now using the European Central Bank API because Google’s API is no longer free to use. The table can now only do Currency Rates and no Stock exchange values. The historical data is much improved and it is possible to get over 20 years of data in one query. If month and weekly averages are required these can be calculated using the aggregation and date function on the outputs.
- Add – System / Excel table can now read Office365 workbooks based of just their URL link. Enter the Authentication Type details
- Add – Authentication Type details now has a new option to restrict its usage the whatever the parent URL is. This prevents the details being used to retrieve other content at a later date.
Publisher
- Add – Page Tab now has options to add PDF download Icon and Annotation Icon to HTML content. Add –
- Links Tab now shows Client Secret Options. This is used by Developers when using Sharperlight to feed external Application like Office365 with data without the need of a user name and password. Client Secrets can be revoked and have an expiry data.