topic Re: [resolved] How to convert JSON string with loop elements into another JSON format in Talend Studio

[resolved] How to convert JSON string with loop elements into another JSON format

Anonymous — Sat, 16 Nov 2024 10:31:05 GMT

Hi,
I have one JSON string like below:

{
        "taglist": ,
        "errcode": 0,
        "errmsg": "ok"
    }

As you see, taglist is an array. I want to convert this JSON string into another format like:

{
       "tags":
}

How to do it?

Re: [resolved] How to convert JSON string with loop elements into another JSON format

Anonymous — Tue, 12 Jul 2016 15:24:41 GMT

Re: [resolved] How to convert JSON string with loop elements into another JSON format

_AnonymousUser — Tue, 12 Jul 2016 20:27:13 GMT

I use these tools to validate and share json data Json Viewer and Json Formatter

Re: [resolved] How to convert JSON string with loop elements into another JSON format

Anonymous — Wed, 13 Jul 2016 03:34:21 GMT

Thanks, Lin.
This approach works for now.
Because it relies on "Group by" feature on tWriteJSONField to output one single line, this approach only works for constant count.
What to do if count has different value? E.g.

{
       "tags":
}

Re: [resolved] How to convert JSON string with loop elements into another JSON format

Anonymous — Wed, 13 Jul 2016 09:09:22 GMT

Hello seanzhang1212,
You can just create a field 'bidon'(french) and you don't use it at the end. I take the same exemple, if the field 'bidon' is 'count', you delete just the link of the 'count' in the component tWriteJSONField. I hope that is understandable for you.

Re: [resolved] How to convert JSON string with loop elements into another JSON format

Anonymous — Wed, 20 Jul 2016 11:13:15 GMT

Thank you , Lin.
After tried with a few scenarios, I feel tWriteJSONField is not feasible enough to cater for complex JSON format. I have changed to use tJSONDoc* component which are available in Exchange.