IonToXml
Read an ion serialized data file and write it to a XML file.
yaml
type: "io.kestra.plugin.serdes.xml.IonToXml"
Read a CSV file, transform it and store the transformed data as an XML file.
yaml
id: ion_to_xml
namespace: company.team
tasks:
- id: download_csv
type: io.kestra.plugin.core.http.Download
description: salaries of data professionals from 2020 to 2023 (source ai-jobs.net)
uri: https://huggingface.co/datasets/kestra/datasets/raw/main/csv/salaries.csv
- id: avg_salary_by_job_title
type: io.kestra.plugin.jdbc.duckdb.Query
inputFiles:
data.csv: "{{ outputs.download_csv.uri }}"
sql: |
SELECT
job_title,
ROUND(AVG(salary),2) AS avg_salary
FROM read_csv_auto('{{ workingDir }}/data.csv', header=True)
GROUP BY job_title
HAVING COUNT(job_title) > 10
ORDER BY avg_salary DESC;
store: true
- id: result
type: io.kestra.plugin.serdes.xml.IonToXml
from: "{{ outputs.avg_salary_by_job_title.uri }}"
Dynamic YES
Source file URI
Dynamic YES
Default items
Xml root name
Dynamic YES
Default UTF-8
The name of a supported charset
Default value is UTF-8.
Dynamic YES
Default Etc/UTC
Timezone to use when no timezone can be parsed on the source.
Format uri
URI of a temporary result file