Unnesting JSON using R

[kwebihaf]

Source=https://jsonformatter.org/e038ec

The above is nested json.

I want the output to be as below
dataElements.name,dataElements.id,categoryOptionCombos.name,categoryOptionCombos.id

Any help in r?

[pieterjanvc]

Hi,

How would you like to 'unlist' this? as a data frame?
JSON is different from a data frame in that it can store lists of varying length or subdivisions, which you can't simply convert to a table format. For example: categoryOptionCombos.name is a sublist of 3 values, so for every dataElements.name,dataElements.id you would have 3 values of categoryOptionCombos.name. Of course you can repeat the values higher in the list to force it into table format, but I don't know if that's what you want?

PJ

[kwebihaf]

For example: categoryOptionCombos.name is a sublist of 3 values, so for every dataElements.name,dataElements.id you would have 3 values of categoryOptionCombos.name. Of course you can repeat the values higher in the list to force it into table format, but I don't know if that's what you want?

That is what I want, the repeatitions.

[nirgrahamuk]

Try this function jsonlite::fromJSON from the jsonlite package