topic Re: Issue In Restful Service in Talend Studio

Issue In Restful Service

Anonymous — Fri, 09 Feb 2018 13:19:19 GMT

Hi,

I am trying to access results from restful service. Here is my design

tRestClient_1 > tExtractJsonFields_1 > tLogRow_1

My JSON in response in following format

{"staff":[{"FirstName":"Tarunjit","LastName":"Chhatwal"},{"FirstName":"Sachin","LastName":"Tomar"}]}

If is use following job design then I could json in console. It means my restful service is working fine.

tRestClient_1 > tLogRow_1

When I add tExtractJsonFields as mentioned above then json doesn’t show in console. Please find attached component properties for > tExtractJsonFields_1.

Can someone please help me on this?

Re: Issue In Restful Service

Anonymous — Fri, 09 Feb 2018 13:21:03 GMT

In continuation to my previous comment. Please find attached schema.

JSONExtract-2.png

Re: Issue In Restful Service

Anonymous — Fri, 09 Feb 2018 15:44:35 GMT

Hi Tarunjit,

If you have't already, go into tRestClient in the Component->Advanced Settings tab, and uncheck the option "Convert Response To DOM Document". This will allow the response to show up in the Response Schema's "string" field.

Also, make sure you haven't changed the default built-in schema in tRestClient. Your response schema should have the original fields 'statusCode', 'body', and 'string'. If a different schema has been pushed into tRestClient, you may want to drop a new copy of the component and configure that one.

I hope that helps.