Need help Google Sheets truncating data

[NonDScript]

I'm trying to use this script to import JSON from something called Ship Matrix, for a game (Star Citizen) but for whatever reason, data gets truncated. My skill level in coding is near zero, so please be gentle here.

The Google Sheet in question - https://docs.google.com/spreadsheets/d/1xRo3bonuKIG0BXoQQD2Nz4fW7k9jZR3guOfD96ZDDHg/edit?usp=sharing

The JSON table/index location is https://robertsspaceindustries.com/ship-matrix/index (Firefox lets you view the data in a clean way)

Script used is the latest listed here, yet as you scroll down you can see elements disappearing, and some elements that I do not see in the JSON table/index show up, i don't know what to make of it.

the script command is hidden on below each column header, below the dark cell/heading title, i a light gray box right below the dark box.

So if you'd like to help, here's an example, on Row 71 Column U, value for xacceleration comes up blank on the the JSON index/table, yet on the sheet it has the value of 15.6. If you look at the index/table directly, that data is listed under data/67

67
id	"96"
production_status	"in-concept"
production_note	"Concept complete."
length	"38.0"
beam	"26.5"
height	"9.5"
size	"medium"
mass	"238616"
type	"combat"
cargocapacity	"0"
min_crew	"2"
max_crew	"2"
scm_speed	"0"
afterburner_speed	"0"
pitch_max	null
yaw_max	null
roll_max	null
xaxis_acceleration	null
yaxis_acceleration	null
zaxis_acceleration	null
manufacturer_id	"12"
chassis_id	"30"

Please help, I'm grateful for any help :)
Thanks.

[mbencho]

quick guess here but you may want to add the "noInherit,noTruncate" section after your import. .

=ImportJSON("https://robertsspaceindustries.com/ship-matrix/index", "/data/id")
would look like
=ImportJSON("https://robertsspaceindustries.com/ship-matrix/index", "/data/id","noInherit,noTruncate")

sometimes without that it does some weird stuff.

[NonDScript]

I added those to each call and it seems there's no change. Do I have to somehow force a data refresh? reloading the sheet seems to have reloaded it, but i'm not 100% sure.

Thanks for suggestion.

[NonDScript]

Something seems corrupt, I found the previously mentioned value of 15.6 belongs to a different location, in this case it belongs to ship labeled "600i Explorer" which on the sheet is under Row 111 column U

[mbencho]

I think it's likely because you are calling the sheet multiple times so your rows aren't lining up.

you don't need individual importjson for each column you want. you can just separate them via a comma
So columns A and B
=ImportJSON("https://robertsspaceindustries.com/ship-matrix/index", "/data/id","noInherit,noTruncate")
=ImportJSON("https://robertsspaceindustries.com/ship-matrix/index", "/data/manufacturer/code","noInherit,noTruncate")

become

=ImportJSON("https://robertsspaceindustries.com/ship-matrix/index", "/data/id,/data/manufacturer/code","noInherit,noTruncate")

in cell A3.

You can just keep adding as many /data/... as you need. just separate them via comma. that way the data should lineup properly and you only have to call the webpage once.

[NonDScript]

Thank you, this worked!.

I had to figure out how to use =query to sort columns how I wanted them listed, as a result I have an extra tab with the pure data imported, and then I use another tab/sheet to =query (sort) wonder if there's another way.