About this integration

Integration Summary

WordPress is a software that enables you to design and update websites or multimedia applications dynamically. One of its functionalities enables you to retrieve and manipulate website content in raw JSON format, e.g. news or blog posts.

You can then integrate this data in any  app using an Online REST data source that points to the URL of the JSON feed, and display it, for example, using a Data Viewer widget. Data will automatically be updated in the  app each time the content is modified on the website.
 

Notes

• The WordPress REST API plugin must be installed on the website whose content you want to retrieve in JSON format.
• Generally, the URL of the JSON feed is as follows: http://www.<WebSite>/json/.
             http://www.easyvista.com/json

Procedure: How to display the content of a website created using WordPress

1. Install the WordPress REST API plugin on the website.

           Download the plugin

2. Go to  and integrate the content retrieved from the website in an app:

• Open the app you want.
• Add a dynamic Online REST data source pointing to the website content in JSON format:
  • In the Objects pane, click . In the Online category, select the Online REST data source.
  • Rename the data source so you can easily identify it.
  • In the Content > Authentication Type drop-down list, select the None authentication method because the REST API is open or public.
  • Select Content > Base URI and indicate the URL of the JSON feed.
              http://www.easyvista.com/json

• Select the data you want to display from the content in JSON format:
  • Click  next to the Selector field.
  • You can click the tag you want in the JSON table (Note: It will appear in yellow). You can also enter an expression in the search field and click [ APPLY ].
               In the content retrieved from the easyvista.com website, display all news headings using the title tag.
  • Click [ OK ].
             

• Display the selected data using a Data Viewer widget:
  • In the Objects pane, click . In the Basic category, click and drag the Data Viewer widget to the Design pane.
  • Rename the widget so you can easily identify it.
  • Select the data source you previously created from the Content > Data Source drop-down list. The data retrieved from the website will automatically be displayed.
  • Select the display mode you want using the Content > Default View drop-down list, i.e. Grid (formatted using Theme > Cell Style/Grid Style), Line (formatted using Line properties), or Tile (formatted using Tile properties).   See the description of properties. In your  app, check that the data retrieved from the website is correctly displayed.

• Click  to switch to preview mode and check the data displayed.
• Check that the data is automatically refreshed:
  • Go to the website and make a modification.
  • Return to your  app. Switch to preview mode and refresh the screen (Note: Some time may be required before the data is refreshed).

SAS_IntegrationRESTAboutTheUse