JSON Form Data Store

The JSON Form Data Store feature allows users to save and load data into a Joget form using the JSON format. This feature lets data be loaded into a form through a JSON URL.

Configure JSON API

When configuring a JSON Form Data Store, you will be presented with the following form:

Configure the properties by filling in the following fields:

JSON URL: The URL from which JSON data will be loaded. This field is required when JSON API is selected as the datasource. For example, https://dummyjson.com/products/1.
Call Type: The HTTP method for sending and receiving API requests.
Passover Current Request Cookies: Option to pass the current request cookies.
Base JSON Object Name for Multirow Data: The name of the object that contains an array for multirow data.
Request Headers: Add names and values to the request header.
Primary Key: The unique key used to identify records.
Manual Field Mapping: Check if you want to assign the records to the form fields manually.
Field Mapping: Map JSON data with form fields.
- Field Name: The form field ID.
- JSON Object Name: The JSON property name.
Debug Mode: Show relevant debug entries in the server log for debugging purposes.
Handling For Field Workflow Variable?: Check to update workflow variables based on form fields. Not applicable to grid elements.
Handling for Uploaded Files?: Check to store uploaded files in app_formuploads based on the form properties table name.