JSON

JSON (JavaScript Object Notation) is a lean and easy-to-read text-based data format that efficiently represents structured data. It is preferably used to exchange data between server and client, in APIs and to format configuration files. Its universal applicability is based on a clear structure and simplicity that can be easily processed by both humans and machines.

Features of JSON

StructureData is organised in key-value pairs.
SyntaxCurly brackets {} indicate objects, square brackets [] define arrays, and values such as strings are enclosed in inverted commas " included.
Supported data typesJSON accepts strings, numbers, Boolean values, arrays and objects.

JSON in SAP Business One

JSON plays a central role in SAP Business One, especially in data communication and automation. Examples of its use are

Service Layer APIJSON is the main format for communication between clients and servers.
Document extractionThe results of document information analyses are saved in JSON and stored in the SAP system.Database used.
User-defined queries (UDQs)SQL queries return results in JSON format by default.
UDO APIsJSON is used here for the transmission and processing of data, comparable to the DI-API.

Examples of JSON usage

GET requests to the Service Layer API can return business partner data in JSON format.
Scripts for the creation of user-defined objects (UDOs) use JSON data.
Extended usage options, such as integration with third-party tools, are also based on JSON.

JSON is therefore proving to be an indispensable tool for smooth data integration and optimised process handling in SAP Business One.