search

bradjasper / ImportJSON

Import JSON into Google Sheets, this library adds various ImportJSON functions to your spreadsheet
GNU Lesser General Public License v3.0
2.1k stars 1.06k forks source link

The script outputs the data in 1 line #221

Open Hoochie63 opened 2 years ago

Hoochie63 commented 2 years ago

Greetings! Guys, help me figure it out, I did not find information ... When the script is requested, it returns data in one line, it looks like this (applied the TRANSPOSE formula to make it easier to watch, and marked where the columns should end): image

With a similar query, the data is displayed normally, as it should be, in columns and rows: image

The data comes in this form:

  1. Which is on the first screen image

  2. Which is on the second screen, as it should be. image

I roughly understand what the problem might be, but, unfortunately, I cannot solve it, I do not have enough knowledge. Maybe someone has already encountered a similar problem and knows its solution, I ask for help ... @bradjasper @kenorb @tommyvernieri @luislobo @kasitmp

lowk3v commented 2 years ago

using "noHeaders"

Hoochie63 commented 2 years ago

Unfortunately it doesn't help - I tried it first. All the same outputs the data on one line.