You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Hi,
I'm trying to import a JSON, it's as follow (using an example with same format here)
{
Par1:xxxx,
Par2:yyyy,
List: [{
{
index1,
index2,
index3{
value1,
value2
}
},
{
index1,
index2,
index3{
value1,
value2
}
},
{
index1,
index2,
index3{
value1,
value2
}
}
}],
Par5:zzzz,
}
I'm trying to import Par2, Par5, and from List, all the index1&2 and value1
My formula goes as :
=ImportJSONAPI("URL","$.Par3[*]","^^Par2,^^Par5,index1,index2,index3.value1"
The problem I'm having is, once all the values for all the index are populated, Par2 and 5 also gets repeated in every rows at the beginning, how to prevent this?
Using the original ImportJSON, it will be
=ImportJSON("URL","/Par2,/Par5,/list/index1,/list,index2,/list/index3/value1","")
at with this, Par2 and 5 only once and does not repeat for every entry of index123
Thanks, and sorry for the formattingm new to here.
The text was updated successfully, but these errors were encountered:
Hi,
I'm trying to import a JSON, it's as follow (using an example with same format here)
{
Par1:xxxx,
Par2:yyyy,
List: [{
{
index1,
index2,
index3{
value1,
value2
}
},
{
index1,
index2,
index3{
value1,
value2
}
},
{
index1,
index2,
index3{
value1,
value2
}
}
}],
Par5:zzzz,
}
I'm trying to import Par2, Par5, and from List, all the index1&2 and value1
My formula goes as :
=ImportJSONAPI("URL","$.Par3[*]","^^Par2,^^Par5,index1,index2,index3.value1"
The problem I'm having is, once all the values for all the index are populated, Par2 and 5 also gets repeated in every rows at the beginning, how to prevent this?
Using the original ImportJSON, it will be
=ImportJSON("URL","/Par2,/Par5,/list/index1,/list,index2,/list/index3/value1","")
at with this, Par2 and 5 only once and does not repeat for every entry of index123
Thanks, and sorry for the formattingm new to here.
The text was updated successfully, but these errors were encountered: