topic Re: [resolved] Getting json Array in Talend Studio

[resolved] Getting json Array

Anonymous — Mon, 08 Aug 2016 11:34:30 GMT

Hi,
I read a json flow like this

{
   "id": 89170,
   "created_at": "2016-08-05T15:54:43Z",
   "updated_at": "2016-08-08T09:52:46Z",
   "tags":    [
      "test_tag",
      "test_tag2"
   ],
}

I couldn't manage to see the tags data.
I try in a String with isArray unchecked, a String with Array checked, A list with isArraChecked (IsArray is the property of my textractjsonfield) : no success.

Thanks for your help

Re: [resolved] Getting json Array

Anonymous — Wed, 10 Aug 2016 08:44:55 GMT

Hi,
Have you tried to use tfileinputjson component to see if it works?
Best regards
Sabrina

Re: [resolved] Getting json Array

Anonymous — Wed, 10 Aug 2016 08:50:37 GMT

Sorry. I do not take time to update my post.
In fact it's working without any problem with textractjsonfield.
The ws from where I get the data didn't give the information so I do not have output.
So you can get these tags into a list with textractjsonfield.
Afterwards you can use it in a tjavarow for example :

if (input_row.tags!=null) {
for (Object str : input_row.tags) {
System.out.println(str);
}
}

Re: [resolved] Getting json Array

Anonymous — Wed, 10 Aug 2016 09:59:51 GMT

Hi,
Thanks for posting that you have resolved your issue and sharing your solution with us.
Best regards
Sabrina