Converts CSV into JSON

convert-to-json.sh

#!/bin/bash

jq --slurp --raw-input --raw-output \
  'split("\n") | .[1:] | map(split(",")) |
      map({"id": .[0],
           "fname": .[1],
           "lname": .[2],
           "email": .[3],
           "ipv4": .[5]})' \
  mock_data.csv > mock_data.json
  
  

mock_data.csv

Works fine but has a final record of null values.

@nmagee Changing the range to [1:-1] will remove the last null value, let me know if it works

#!/bin/bash

jq --slurp --raw-input --raw-output \
  'split("\n") | .[1:-1] | map(split(",")) |
      map({"id": .[0],
           "fname": .[1],
           "lname": .[2],
           "email": .[3],
           "ipv4": .[5]})' \
  mock_data.csv > mock_data.json