c8y(1)

okay bestie, welcome to the c8y(1) manual 💖 this page is all about c8y-util-repeatcsv, and she’s giving “turn csv files into newline-delimited json so you can pipe them into other commands” main character energy. no cap, she’s a utility and she slays ✨

🌸 NAME 🌸

c8y-util-repeatcsv — iterate over csv files and convert them to json lines. like, that’s the whole name and it’s iconic 💅

🦋 SYNOPSIS 🦋

c8y util repeatcsv  [...FILE] [flags]

💅 DESCRIPTION 💅

okay so she’s a generic utility to iterate over csv files and transform them into newline delimited json objects which can be piped to other commands. that’s the tea 🍵

✨ OPTIONS ✨

• --columns=[] — manually define the headers/columns used in the csv file. you’re the boss of the column names 💅
• --delimiter="" — field delimiter. it will be auto detected by default, so you only need this if the vibe is custom.
• --first=0 — only include first x lines. 0 = all lines.
• -h, --help[=false] — help for repeatcsv.
• --infinite[=false] — repeat forever. you will need to Ctrl+C to stop it 😭
• --max=1 — max number of (randomized) times to repeat the input (inclusive). 0 = no output. inclusive means included, periodt.
• --min=1 — min number of (randomized) times to repeat the input (inclusive).
• --noHeader[=false] — input data does not have a header row. treat the first row as a data row.
• --randomDelayMax="0ms" — random maximum delay after each request, i.e. 5ms, 1.2s. it must be larger than randomDelayMin. 0 = disabled.
• --randomDelayMin="0ms" — random minimum delay after each request, i.e. 5ms, 1.2s. it must be less than randomDelayMax. 0 = disabled.
• --randomSkip=-1 — randomly skip line based on a percentage, probability as a float: 0 to 1, 1 = always skip, 0 = never skip, -1 = disabled.
• --times=1 — number of times to repeat the input.

🫶 OPTIONS INHERITED FROM PARENT COMMANDS 🫶

these come from the parent command, but they’re still part of the group chat. every single one, bestie:

• --abortOnErrors=10 — abort batch when reaching specified number of errors.
• --allowEmptyPipe[=false] — don’t fail when piped input is empty (stdin).
• --cache[=false] — enable cached responses.
• --cacheBodyPaths=[] — cache should limit hashing of selected paths in the json body. empty indicates all values.
• --cacheTTL="60s" — cache time-to-live (TTL) as a duration, i.e. 60s, 2m.
• -c, --compact[=false] — compact instead of pretty-printed output when using json output. pretty print is the default if output is the terminal.
• --confirm[=false] — prompt for confirmation.
• --confirmText="" — custom confirmation text.
• --currentPage=0 — current page which should be returned.
• --customQueryParam=[] — add custom URL query parameters. i.e. --customQueryParam 'withCustomOption=true,myOtherOption=myvalue'.
• --debug[=false] — set very verbose log messages.
• --delay="0ms" — delay after each request, i.e. 5ms, 1.2s.
• --delayBefore="0ms" — delay before each request, i.e. 5ms, 1.2s.
• --dry[=false] — dry run. don’t send any data to the server.
• --dryFormat="markdown" — dry run output format. i.e. json, dump, markdown or curl.
• --examples[=false] — show examples for the current command.
• --filter=[] — apply a client side filter to response before returning it to the user.
• --flatten[=false] — flatten json output by replacing nested json properties with properties where their names are represented by dot notation.
• -f, --force[=false] — do not prompt for confirmation. ignored when using --confirm.
• -H, --header=[] — custom headers. i.e. --header "Accept: value, AnotherHeader: myvalue".
• --includeAll[=false] — include all results by iterating through each page.
• -k, --insecure[=false] — allow insecure server connections when using SSL.
• -l, --logMessage="" — add custom message to the activity log.
• --maxJobs=0 — maximum number of jobs. 0 = unlimited (use with caution!) ⚠️
• --noAccept[=false] — ignore Accept header will remove the Accept header from requests, however PUT and POST requests will only see the effect.
• --noCache[=false] — force disabling of cached responses (overwrites cache setting).
• -M, --noColor[=false] — don’t use colors when displaying log entries on the console.
• --noLog[=false] — disables the activity log for the current command.
• --noProgress[=false] — disable progress bars.
• --noProxy[=false] — ignore the proxy settings.
• -n, --nullInput[=false] — don’t read the input (stdin). useful if using in shell for/while loops.
• -o, --output="table" — output format i.e. table, json, csv, csvheader.
• --outputFile="" — save JSON output to file (after select/view).
• --outputFileRaw="" — save raw response to file (before select/view).
• --outputTemplate="" — jsonnet template to apply to the output.
• -p, --pageSize=5 — maximum results per page.
• --progress[=false] — show progress bar. this will also disable any other verbose output.
• --proxy="" — proxy setting, i.e. http://10.0.0.1:8080.
• -r, --raw[=false] — show raw response. this mode will force output=json and view=off.
• --retries=3 — max number of attempts when a failed http call is encountered.
• --select=[] — comma separated list of properties to return. wildcards and globstar accepted, i.e. --select 'id,name,type,**.serialNumber'.
• --session="" — session configuration.
• --sessionMode="" — override default session mode for a single command which would normally be disabled.
• -P, --sessionPassword="" — override session password.
• -U, --sessionUsername="" — override session username. i.e. peter or t1234/peter (with tenant).
• --silentExit[=false] — silent status codes do not affect the exit code.
• --silentStatusCodes="" — status codes which will not print out an error message.
• --timeout="600s" — request timeout duration, i.e. 60s, 2m.
• --totalPages=0 — total number of pages to get.
• -v, --verbose[=false] — verbose logging.
• --view="auto" — use views when displaying data on the terminal. disable using --view off.
• --withError[=false] — errors will be printed on stdout instead of stderr.
• --withTotalElements[=false] — request Cumulocity to include the total elements in the response statistics under .statistics.totalElements (introduced in 10.13).
• -t, --withTotalPages[=false] — request Cumulocity to include the total pages in the response statistics under .statistics.totalPages.
• --workers=1 — number of workers.

🍓 EXAMPLE 🍓

$ c8y util repeatcsv input.csv

convert the input.csv to json ✨

$ c8y util repeatcsv *.csv

convert multiple csv files 🦋

$ c8y util repeatcsv input-without-header-row.csv --columns custom1,custom2,custom3 --noHeader

convert csv file which does not have a header row. manually define the names of the columns 💅

👑 SEE ALSO 👑

c8y-util(1) — go see her too, bestie 🫶

---

that’s the whole page, bestie 🫶 this is the c8y(1) manual, dated Jan 1980 — go repeat those csvs and make newline-delimited json look iconic ✨💅