topic [resolved] tExtractJSONFields - error on parsing json response from tHttpRequest in Talend Studio

[resolved] tExtractJSONFields - error on parsing json response from tHttpRequest

jdlo_25 — Tue, 23 Feb 2016 11:52:49 GMT

Hi Guys,
Good Day !
Can someone help me, I have a problem on extracting json response coming from tHttpRequest. I already used the tExtractJSONFields. The JSON response came from facebook graph API. I already extracted data on some JSON response but some response is throwing an error because of "An invalid XML character (Unicode: 0xb) was found in the element content". Is there anyway(configuration) or component that can help me parse properly the response ? Thanks in Advance
Best Regards,
John

Re: [resolved] tExtractJSONFields - error on parsing json response from tHttpRequest

Anonymous — Wed, 24 Feb 2016 03:59:56 GMT

Hi john,
Could you please directly post your json response coming from tHttpRequest into forum?
Best regards
Sabrina

Re: [resolved] tExtractJSONFields - error on parsing json response from tHttpRequest

jdlo_25 — Wed, 24 Feb 2016 08:48:50 GMT

Hello Sabrina,
Good Day ,
Here is the link:
https://graph.facebook.com/ManulifePH/posts?fields=created_time,link,type,message,shares,likes.summary(true){id,name},comments.summary(true){message,id,from,likes.summary(true),created_time},from{id,name}&access_token=CAAG1fPEW3FABALPZBaY4MGeB5w7vfS4CeGVZAiZArNhWEz6a27DsN3OWfkB5Y4LhZA2Xdw7nKdXrpwp7oLAfEefqPzJNZCiskGOXaBAT79Irs4Avz8rnXmvcDsQ67KeQ8VQicM7Dv56CkAZCybvZCCk9H0bssFQJRJcxUUSG9sOYWpxgrmpypLYNgI8HPUd8qIZD&limit=100
You can view the response in your browser. It only occurs in this page, I think its because of the character content returned in JSON response. If there is any component or configuration that may be set to help parse the JSON please let me know so that I would not encounter it again on different fb page. Thank you !!
Best Regards
John

Re: [resolved] tExtractJSONFields - error on parsing json response from tHttpRequest

jdlo_25 — Fri, 26 Feb 2016 03:36:45 GMT

Hi Sabrina,
Good Day !
Any update on this matter? I'm sorry I cannot upload the file because an error occurs while I'm trying to upload it
Have a nice day !
Best Regards
John