Forum Discussion
Helper IIIParsing Json File Giving Unexpected Results
Hey!
It really depends on your json and how it's structured.
What's inside of those lists? is it effectively a list of records? do those records have the same or quite a similar schema to the records that are shown in your screenshot?
If the latter is true, then you can try and transform the record values in your column to be a list of records.
Basically create a new columns using the code below:
if Type.Is( Value.Type([ColumnNameGoesHere]), type record) then {[ColumnNameGoesHere]} else [ColumnNameGoesHere]That new column would have a single type which should be the list which you can later expand and then later expand the records.
But in the end it all depends on how your json is structured
Community AdminHey!
It really depends on your json and how it's structured.
What's inside of those lists? is it effectively a list of records? do those records have the same or quite a similar schema to the records that are shown in your screenshot?
If the latter is true, then you can try and transform the record values in your column to be a list of records.
Basically create a new columns using the code below:
if Type.Is( Value.Type([ColumnNameGoesHere]), type record) then {[ColumnNameGoesHere]} else [ColumnNameGoesHere]That new column would have a single type which should be the list which you can later expand and then later expand the records.
But in the end it all depends on how your json is structured