Any news on support og JSON?

[former_member748080]

I 2016 there was a discussion on JSON and SAP would look into how to support Json structures.

Is there any news on that or anyone, who has made a script to interface Json ?

[GeorgeMcGeachie]

Support for JSON in the PDM was introduced recently, in 16.6 service pack 04, though I don't think it supports reverse-engineering JSON yet.

Here's what the Help says about the JSON PDM:

In a JSON PDM, the model represents a JSON document containing an array, objects, in which each table is a JSON object containing:

• A property, id, containing the table's code.
• An array, fields, containing the table's columns as objects with an id and type.

  To change a column to type array containing an array items, open the column property sheet and select the Array property.

• An object for each reference to a child table.

  To embed the child table inside the reference object, open the property sheet of the reference link and select the Nested child property.

• An array, primary key, containing the table's primary keys.
• An array required containing the table's columns that are set to Mandatory.

To preview the JSON to be generated for a table, open its property sheet, click the Preview tab, and select the Schema sub-tab.

To preview the JSON to be generated for the model, open its property sheet, click the Preview tab, and select the Schema sub-tab.

The following generation options are available on the model property sheet Options tab:

Option

Description

Label for ... Specify the labels for the arrays of tables, columns, users, and rules. Include title Specifies to include a title property containing the object's Name on all objects. Include description Specifies to include a description property containing the object's Comment on all objects. Include owner Specifies to include an owner property containing the table's Owner on table objects.

Selecting this option will also add an array, schemas at the document root.

Include creation date Specifies to include a date property containing the object's Creation Date on all objects. Include rules Specifies to include a rules array containing the business rules associated with the table on table objects