Create a SharePoint list, click "Connect to external data source" in the list settings, select the data provider, enter connection settings and data query as shown below. That's it.
Connected data always up-to-date
The connected JSON data updates automatically in the background (via SharePoint Timer Job), or alternatively, on-demand (Action Menu / Ribbon Button, URL, via workflow, API).
One-way and optional two-way connection
write-back the changes made in SharePoint to the external JSON
data source automatically with full CRUD (Create / Update / Delete)
functionality. The SharePoint list can act as a full-featured front-end
for external systems.
Well-known BCS "external list" issues and limitations are completely solved
All list features are to you. Views, sorting and grouping, filters, calculated fields, search, managed metadata. Lookups, additional columns and attachments can be created as normal. All kind of lists can be used, e.g. contacts, tasks, calendar, or custom lists. You can take external data offline via Outlook.
Workflows and notifications on JSON data change
List workflows and change notifications per RSS or email can be used to take business actions in SharePoint, when JSON data records are changed.
JSON specific SharePoint List Configuration settings
Please note the following about JSON-specific settings.
Please download and install the CDATA Provider directly from the vendor: https://www.cdata.com/drivers/json/ado/. After that you can select the CData ADO.NET Data Provider for JSON in the list of installed providers.
You can make use of any connection string option supported by the data provider. Here is a list of these available options:http://cdn.cdata.com/help/DJC/ado/Connection.htm It will be the best to start with a free JSON test site: URI=https://jsonplaceholder.typicode.com/posts
You can make use of all SQL queries your data provider supports. Please start with the following querie, if you are unsure: SELECT * FROM JSONData
Please specify a primary Key. Write-back is generally supported by the JSON data provider. Please make sure that a primary key is defined for this.
Advise and Information
For more complex JSON content note the "JSON Path" parameter in the connection string.
Write-back synchronization is generally supported. Your JSON service must allow writing for this.
Complex SharePoint fields like lookups, user or group picker etc. are generally supported. You have to make sure providing values that fit into the fields.
Find more Use Cases for your SharePoint integration