topic Re: Get data from GitHub using talend tRESTClient? in Talend Studio

Get data from GitHub using talend tRESTClient?

Anonymous — Sat, 16 Nov 2024 09:27:30 GMT

Hi All, I'm trying to get the data from Github url using tRESTClient of Big Data Open Studio. But I got error. My job is, 1. tRESTClient 2. tXMLMap 3. tLogRow In tRESTClient, URL "https://api.github.com/users/sample/repos", HTTP Method "GET" and Accept Type "XML". When i trying to execute this job, I'm getting Error. Exception in component tRESTClient_1 javax.ws.rs.NotSupportedException: HTTP 415 Unsupported Media Type How can i resolve this issue?Even i added content type in advanced settings.

Re: Get data from GitHub using talend tRESTClient?

cterenzi — Wed, 02 Aug 2017 14:50:02 GMT

I tested the same with the sample link you provided. The service is returning JSON, not XML.

Re: Get data from GitHub using talend tRESTClient?

Anonymous — Wed, 02 Aug 2017 14:53:15 GMT

I tried with Accept Type in JSON, But is giving NULL values.How can get the data? Is tXMLMap need to change anything?

Re: Get data from GitHub using talend tRESTClient?

jilanisyed — Wed, 02 Aug 2017 15:05:17 GMT

Hi
I tried with Accept Type in JSON, it is giving Response in XML format. i believe you need to check txmlmap configuration

Re: Get data from GitHub using talend tRESTClient?

Anonymous — Wed, 02 Aug 2017 15:10:29 GMT

I'm getting NULL values, when tired with JSON in Accept Type

Re: Get data from GitHub using talend tRESTClient?

Anonymous — Wed, 02 Aug 2017 15:12:00 GMT

This is my tXMLMap Detail
3.png

Re: Get data from GitHub using talend tRESTClient?

jilanisyed — Wed, 02 Aug 2017 15:19:10 GMT

Hi Praksh,

there is one extra root element is coming from response please see my txmlmap configuration

Re: Get data from GitHub using talend tRESTClient?

Anonymous — Wed, 02 Aug 2017 15:31:04 GMT

I couldn't open your image.

Re: Get data from GitHub using talend tRESTClient?

Anonymous — Wed, 02 Aug 2017 15:33:38 GMT

Is this right way of mapping data using tXMLMap? I tried with tExtractJSONFields, but i'm getting this error. A JSONObject text must begin with '{' at character 1 of

Re: Get data from GitHub using talend tRESTClient?

jilanisyed — Wed, 02 Aug 2017 16:43:14 GMT

can you check now

xmlmap.png

Re: Get data from GitHub using talend tRESTClient?

jilanisyed — Wed, 02 Aug 2017 16:46:03 GMT

I don`t believe we can use tExtractJsonFields because the response in XML format. so we could use tXmlMap or tExtractXmlfields.