Steps to add or modify a JSON connection in PADS4
1. Start the Data Provider Wizard
- Open the Data Provider Wizard using the steps in Adding a Data Provider or Editing a Data Provider.
- Select JSON Feed (for an online source) or JSON File (for a local source).
2. Specify the JSON source
-
For JSON Feeds (Online)
- Enter the URL (URI) of the JSON feed.
- Ensure the URL is publicly accessible or has the proper authentication settings.
-
For JSON Files (Local)
- Specify the file path.
- The file can be located in the PADS4 Content Library or an external location.
- If stored outside the PADS4 Content Library, it won’t sync automatically to the viewer.
3. Select the data source
- JSON structures can contain multiple tables and nested data.
- Click Select to open a tree view of the JSON structure.
- Browse through different levels to find the right data.
- Once found, click OK to confirm.
Advanced selection (for technical users)
- Modify the JSON Path Expression manually.
- Use JSONPath syntax for advanced filtering and selection.
- Refer to JSONPath documentation for more details.
4. Configure data handling settings
- Include Parent Level Column Name → Adds parent-level identifiers for hierarchical relationships.
- Create Additional Columns Without HTML5 Tags → Removes HTML formatting and extracts plain text.
- Flatten Hierarchical Data → Converts nested JSON structures into a flat data table.
5. Configure request method
- GET (default) → Retrieves data without modifying it.
- POST → Used for sending additional parameters (fill in the request body if required).
- Specify Encoding → Select a text encoding format if needed.
6. Configure security and authentication
-
Authorization (if required)
- Enable Authorization Required.
- Enter UserID, Password, and Domain.
-
Proxy Server (if applicable)
- Configure proxy settings if access to the internet requires authentication.
-
User-Agent Identification
- Some servers require a specific User-Agent string (e.g., for API access).
7. Finalizing the JSON provider setup
- Click Finish to complete the setup.
Important considerations
-
PADS4 Data Server
- If using a Data Server, ensure the JSON source is accessible from the server.
- If not using a Data Server, the Designer and Viewers must have direct access to the JSON feed or file.
-
Joining Multiple Data Tables
- If you need to combine data from multiple JSON sources, use the Join Data Provider.

