export-xlsx 1.0

Transform json input to xlsx spreadsheet

---

• Categories: unknown

• Image: registry.coadcorp.com/export-xlsx:1.0

• License: Apache-2.0

• Issue Tracking: https://git.coadcorp.com/nathan/export-xlsx/issues

• URL: https://git.coadcorp.com/nathan/export-xls

• Maintainer: nathan.coad@dell.com

---

About export-xlsx

Transform json input to excel spreadsheet via json2excel command

Example(s)

Function Configuration

functions:
- id: export-xlsx
  image: registry.coadcorp.com/export-xlsx:1.0
  type: knative-workflow

Basic

- id: export-xlsx
  type: action
  action:
    function: export-xlsx
    input: 
      out-filename: example.xlsx
      sheets:
      - name: "TestSpreadsheet"
        input-file:
         - name: input.json
           data: |
             jq(.input)

Use jq to add a parent key 'input' containing array of objects

- id: export-xlsx
  type: action
  action:
    function: export-xlsx
    input: 
      out-filename: example.xlsx                   
      sheets:
      - name: "TestSpreadsheet"
        input-file:
        - name: input.json
          data: |
            jq(.array | {input: . } | tostring )                  

Secrets

• export-xlsxSecret: This is a secret value

Request

Request Attributes

PostParamsBody

Response

List of executed commands.

Reponse Types

PostOKBody

Example Reponses

"{\"export-excel\": \"JVBERi0xLjUKJdDUxdgKNSAwIG9iago8PAov==\"}"

Errors

Type	Description
io.direktiv.command.error	Command execution failed
io.direktiv.output.error	Template error for output generation of the service
io.direktiv.ri.error	Can not create information object from request

Types

postOKBody

Properties

Name	Type	Go type	Required	Default	Description	Example
export-excel	string	string

postParamsBody

Properties

Name	Type	Go type	Required	Default	Description	Example
out-filename	string	string		"output.xlsx"	the filename of the output spreadsheet
sheets	[]PostParamsBodySheetsItems	[]*PostParamsBodySheetsItems			Array of worksheets to create in spreadsheet

postParamsBodySheetsItems

Properties

Name	Type	Go type	Required	Default	Description	Example
infile	string	string			Name of the json input file to utilise
input-file	[]DirektivFile	[]apps.DirektivFile			File to create before running commands
name	string	string		"Sheet1"	Label for the worksheet created in the spreadsheet