exceljson-jsonexcel-component v1.0.0

exceljson-jsonexcel-component

The purpose of this component is to do a file transformation which consists of being able to transform a json file into a excel file and vice versa. This component is too easy of implement because it uses just a couple of parameters like headers and content, and we can send the content encoding in base64

This component allow us to transform data depending on our needs if we want to work with data in json format o with data in excel file.

Features

• Make a transformation from a excel file to a json file, we can send "xls" file or "xlsx" file.
• Make a transformation from a json file to a excel file, only with the condition that the json data must be defined at a single level.
• The post result depends of the process that we are using, in the "exceñ_json" trasnformation we are going to get the data in json format, but in the "json_excel" transormation we are going to get the excel file in base64 encode.

Libraries

• msgbroker-nxg-cg
• utils-nxg-cg
• exceljson-jsonexcel-cg-library

For more detail of the functionality review exceljson-jsonexcel-cg-library documentation

Installation

Docker image: cloudgenuser/exceljson-jsonexcel-component:1.0.0

Functions

• trigger:
  • excel_json_source
  • json_excel_source
• action:
  • excel_json
  • json_excel

Fields: excel_json tranformation

• content(required): This parameter is the content that will be transformed and has to be sent encoded in base64.
• headers (no required): This parameter is to determine if the first line of the excel file will be taken as headers for the json property names or the json property names will be created dynamically.

json_csv tranformation

• content(required): Is the base64 encoded json file content that we want to transform into excel file.