Skip to main content

WRITE.JSON

Zoltán Mikolás
  • Updated

 

Write data to JSON-format.

Properties

From Name of the Input Data Source.
The input-source can be either an In-memory Xml-document, JSON-document or the neutral Table-format.
To Name of the Output Data Source.
The output-source can contain either a File-path, a PBinaryStream object or a .Net Stream object. See WRITE.* Property "To" for more information's and examples.
The format of the output will be written as JSON. If the input-source is a Table, or in Xml-format, it will be automatically converted to JSON.

Parameters

@OutputFileAs

Allows to retrieve the output of an action and write it to a file path, a stream, or the application server jobs log. Possible values:

  • FilePath - The file is saved to the specified path.
  • Stream - The file is returned as a stream. 
  • JobLog - The file is attached to the application server job log.

Guide

The purpose of this Command is only to write the contents of the input-source to a File-path or send it to a Stream. No mapping or data manipulations are done.
If the input-source is a JSON document, this command will write out the JSON exactly as it is.
If the input-source is an Xml document, this command automatically convert it to JSON in the equivalent structure. Xml attribute names will be prefixed with @ to avoid conflicting names.
If the input-source is in the Table-format, the table will automatically be converted to JSON in a tabular structure, such as shown below.

{
"Row": [{
      "SKU": "AUA4L18TFS",
      "Name": "Audi A4 1.8 TFSI",
      "EngineVolume": "1.8",
      },
      {
      "SKU": "BM320ISED",
      "Name": "BMW 320i SE Saloon",
      "EngineVolume": "2",
    }]

Related articles

Comments

0 comments

Please sign in to leave a comment.