{"api_version":2,"name":"piflow_excel_write_sort","version":"1.0","role":"transform","type":"sdk","description":"Sort records on the selected columns and emit an XLSX byte stream with data written at the requested cell.","icon":{"path":"M3 5h18v14H3zM3 10h18M9 5v14"},"inputs":{"source":{"representations":["records"],"formats":[]}},"outputs":{"result":{"view":"bytes"}},"parameters":{"type":"object","properties":{"sortField":{"type":"string","description":"Comma-separated sort columns, in priority order."},"sortOrder":{"type":"string","description":"Sort direction.","enum":["asc","desc"]},"header":{"type":"boolean","description":"Write field names above the data."},"dataAddress":{"type":"string","description":"Worksheet and starting cell."}},"required":["sortField","sortOrder","header","dataAddress"],"additionalProperties":false},"documentation":{"inputs":{"source":"Arrow records. The example uses sensor, value."},"outputs":{"result":"Bytes stream. Sort records on the selected columns and emit an XLSX byte stream with data written at the requested cell."},"parameters":{"sortField":{"description":"Comma-separated sort columns, in priority order.","help":"Comma-separated sort columns, in priority order.","example":"sensor"},"sortOrder":{"description":"Sort direction.","help":"Sort direction.","example":"asc"},"header":{"description":"Write field names above the data.","help":"Write field names above the data.","example":true},"dataAddress":{"description":"Worksheet and starting cell.","help":"Worksheet and starting cell.","example":"Readings!A1"}},"example_job":"name: Sort records and export Excel\nsteps:\n- id: read_source\n  operator: item_source@1.0\n  inputs: {}\n  params:\n    uri: context:/piflow/source.jsonl\n    view: records\n- id: process\n  operator: piflow_excel_write_sort@1.0\n  inputs:\n    source: read_source\n  params:\n    sortField: sensor\n    sortOrder: asc\n    header: true\n    dataAddress: Readings!A1\n- id: receive\n  operator: client_sink@1.0\n  inputs:\n    result: process\n"},"runtime":{"image":"sha256:40db7fee594f1452790d1cc99c2e5429e187eb64633c716b8c6f903c47576975","archive":{"sha256":"e1844833e35390f2eaf9fc9ec7b67057ad0305ad713c0da6c8b055980a66946c","size":73825792,"filename":"python-arrow-2.0-runtime.tar"}},"execution":{"executor":"python","entrypoint":"xstream_piflow_excel_write_sort","config":{}},"source_public":true,"provenance":{"license":"Apache-2.0","source_repository":"https://github.com/cas-bigdatalab/piflow","source_revision":"db177aa6d9b84d91078caa9a591574b1fe3cf20c","build_instructions":"Build the Python SDK adapter in src/ with python-arrow@2.0. See job.yaml for an example using the supplied fixtures.","source_archive":{"sha256":"f8a68a5fbcb1e45968786748a92a8bfce58437ab7e9c002aa585cd021efea84c","size":278229,"filename":"piflow_excel_write_sort-sources.zip"},"license_file":{"sha256":"c71d239df91726fc519c6eb72d318ec65820627232b2f796219e87dcf35d0ab4","size":11357,"filename":"LICENSE.txt"}},"artifact":{"sha256":"0b6565aadaafe459b1d363957ca65462e6fc3a27bf2f42fc81ad724c4de34a0d","size":573668,"filename":"operator.zip"},"categories":["PiFlow","Excel"],"trust":{"score":4,"assessed_by":"administrator","reviewed_at_ms":1795081623317},"publication":{"author":"dacp-examples","submitted_at_ms":1795081612211,"approved_at_ms":1795081623317,"last_submitted_at_ms":1795081612211,"last_approved_at_ms":1795081623317},"download_count":3}