Parsing this JSON to obtain a human readable list

Question

I have a JSON file whit this structure. For every URL field, we have a RESULT field which contains hundreds of LINKS. Would it be somehow possible to parse it and obtain a (ie. csv) list which contains all the LINKS for every URL?

 [{
    "url": "https://example.org/yyy",
    "result": "{\"links\":[{\"link\":\"https://example.org/xxx/xxx\",\"text\":\"\"
},
{
    \"link\":\"https://example.org/xxx/xxx\",\"text\":\"\"
},
{
    \"link\":\"https://example.org/xxx/xxx\",\"text\":\"yyy\"}[.......]

Thanks in advance

Sure. You can parse the JSON with `JSON.parse`, iterate over the array and process the information in any way you like. Do you have a specific question about any of these steps? Does [Access / process (nested) objects, arrays or JSON](https://stackoverflow.com/q/11922383/218196) help you? — Felix Kling, Jun 09 '17 at 20:08
@FelixKling, he did not mention "javascript", so `JSON.parse` might be for another case — RomanPerekhrest, Jun 09 '17 at 20:13
@RomanPerekhrest: Ugh, you are right... jumped to conclusions too quickly. — Felix Kling, Jun 09 '17 at 20:14
@FelixKling, that's because you like javascript very much )) — RomanPerekhrest, Jun 09 '17 at 20:15

score 0 · Answer 1 · answered Sep 08 '17 at 06:26

Here is a solution using jq. If data.json contains the sample data

[{"url": "https://example.org/yyy", "result": "{\"links\":[{\"link\":\"https://example.org/xx1/xx1\",\"text\":\"\"},{\"link\":\"https://example.org/xx2/xx2\",\"text\":\"\"}]}"}]

then the command

$ jq -Mr '.[].result | fromjson | .links[].link' data.json

produces

https://example.org/xx1/xx1
https://example.org/xx2/xx2

If you would like both the url and the links, the command

$ jq -Mr '.[] | .url as $url | .result | fromjson | "\($url),\(.links[].link)"' data.json

produces

https://example.org/yyy,https://example.org/xx1/xx1
https://example.org/yyy,https://example.org/xx2/xx2

Parsing this JSON to obtain a human readable list

1 Answers1