Read Google Sheet using the first row as keys

[fab10m]

Hi,

I have a Google Sheet with a table with a header row and three rows and 4 columns of data.

If I read the file without using the first row as keys I get the following json

[
  [
    "service",
    "rating-count",
    "rating-value"
  ],
  [
    "Satispay",
    "83305",
    "4,6"
  ],
  [
    "Revolut",
    "124000",
    "3,6"
  ],
  [
    "N26",
    "4500",
    "4,8"
  ]
]

but if I read the file using the first row as keys I get the following json:

[
  {
    "service": "Satispay",
    "rating-count": "83305",
    "rating-value": "4,6",
    "url": "https://play.google.com/store/apps/details?id=com.satispay.customer"
  },
  {
    "service": "Satispay",
    "rating-count": "83305",
    "rating-value": "4,6",
    "url": "https://play.google.com/store/apps/details?id=com.satispay.customer"
  },
  {
    "service": "Satispay",
    "rating-count": "83305",
    "rating-value": "4,6",
    "url": "https://play.google.com/store/apps/details?id=com.satispay.customer"
  },
  {
    "service": "Satispay",
    "rating-count": "83305",
    "rating-value": "4,6",
    "url": "https://play.google.com/store/apps/details?id=com.satispay.customer"
  },
  {
    "service": "Revolut",
    "rating-count": "124000",
    "rating-value": "3,6",
    "url": "https://play.google.com/store/apps/details?id=com.revolut.revolut&hl=it"
  },
  {
    "service": "Revolut",
    "rating-count": "124000",
    "rating-value": "3,6",
    "url": "https://play.google.com/store/apps/details?id=com.revolut.revolut&hl=it"
  },
  {
    "service": "Revolut",
    "rating-count": "124000",
    "rating-value": "3,6",
    "url": "https://play.google.com/store/apps/details?id=com.revolut.revolut&hl=it"
  },
  {
    "service": "Revolut",
    "rating-count": "124000",
    "rating-value": "3,6",
    "url": "https://play.google.com/store/apps/details?id=com.revolut.revolut&hl=it"
  },
  {
    "service": "N26",
    "rating-count": "4500",
    "rating-value": "4,8",
    "url": "https://play.google.com/store/apps/details?id=de.number26.android&hl=it"
  },
  {
    "service": "N26",
    "rating-count": "4500",
    "rating-value": "4,8",
    "url": "https://play.google.com/store/apps/details?id=de.number26.android&hl=it"
  },
  {
    "service": "N26",
    "rating-count": "4500",
    "rating-value": "4,8",
    "url": "https://play.google.com/store/apps/details?id=de.number26.android&hl=it"
  },
  {
    "service": "N26",
    "rating-count": "4500",
    "rating-value": "4,8",
    "url": "https://play.google.com/store/apps/details?id=de.number26.android&hl=it"
  }
]

As you can see each row of the table is repeated as many times as the number of columns. Where am I doing wrong?

Regards,
Fabio

[fab10m]

Thanks for the quick solution @Kholid060 !