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

How do you parse retrieve index/row from an array? #150

Open soundofyogi opened 4 years ago

soundofyogi commented 4 years ago

=ImportJSON("https://api.guildwars2.com/v2/items/1182","/details/infix_upgrade/attributes/attribute","noInherit,rawHeaders")

Gives me:

/details/infix_upgrade/attributes/attribute

Vitality Healing ConditionDamage

while,

=ImportJSON("https://api.guildwars2.com/v2/items/1182","/details/infix_upgrade/attributes/attribute[1]","noInherit,rawHeaders")

Expecting to get "Healing" but instead, gives me #Ref! Error..

Is there any way to get specific data in arrays?

coolfarmer commented 4 years ago

I'm getting the same error. I'm trying to get /response/data/0/rows but have the same error than you, look like his script can't do that :(