topic Re: How do I get/see the URL that tRESTClient is generating? in Talend Studio

How do I get/see the URL that tRESTClient is generating?

Anonymous — Fri, 28 Sep 2018 16:05:50 GMT

Hi All,

I have been doing data work for about 20 years now, but I am VERY new to Talend.

I have setup a tRESTClient for pulling data from Zendesk.

When I run the job it says it is getting a return code of 200 (which is good), but no results returned.

That doesn't make any sense because when I run the same query in Postman I get several hundred results.

So I am trying to troubleshoot this and I would like to know how I can see the URL that the tRESTClient is generating and using to make the API call.

Any idea where that is?

Thanks.

Re: How do I get/see the URL that tRESTClient is generating?

Anonymous — Fri, 28 Sep 2018 17:35:43 GMT

Can you post some specs from your job?

Re: How do I get/see the URL that tRESTClient is generating?

Anonymous — Fri, 28 Sep 2018 17:35:49 GMT

Can you give us a screenshot of your job layout? Also, can you connect a tLogRow to your Response and Error output exiting your tRestClient? Try running with that. You should be some output.

Re: How do I get/see the URL that tRESTClient is generating?

Anonymous — Fri, 28 Sep 2018 17:43:54 GMT

Hello rhall_2_0,

Thanks for the reply!

I have attached a screen shot showing my flow ~ it is VERY simple (I am a total n00b, remember?).

Please let me know what you think.

Thanks.

Screen Shot 2018-09-28 at 11.41.43 AM.png

Re: How do I get/see the URL that tRESTClient is generating?

Anonymous — Fri, 28 Sep 2018 18:04:44 GMT

You are getting an XML response, but it is a response with no data. This suggests that maybe your input parameters may be incorrect (or different to those that get you results in your other tool). Can you show your tRESTClient config?

Re: How do I get/see the URL that tRESTClient is generating?

Anonymous — Mon, 01 Oct 2018 16:28:04 GMT

Hi rhall_2_0,

I apologize for not replying sooner. My boss had other plans for me on Friday.

Attached are the two screenshots with my config.

I unchecked the option to "Convert response to DOM document" and the output is now JSON instead of XML, but it still isn't finding any records.

Thanks.

Screen Shot 2018-10-01 at 10.24.07 AM.png
Screen Shot 2018-10-01 at 10.24.34 AM.png

Re: How do I get/see the URL that tRESTClient is generating?

Anonymous — Mon, 01 Oct 2018 16:41:45 GMT

Can you put the whole path in the URL and forget about the relative path. I don't think you will need to use that unless you intend to use service locator.

Also, your external_id parameter is hardcoded to "none". Is this what you did in your other tool?

Was the URL in your other tool....

https://{subdomain}.zendesk.com/api/v2/users/search.json?eternal_id=none

If so, try just adding that URL into the URL field and forgetting about the query parameters section to start with.

Re: How do I get/see the URL that tRESTClient is generating?

Anonymous — Mon, 01 Oct 2018 16:53:59 GMT

I tried that and got an error.

Please see attached.

Screen Shot 2018-10-01 at 10.53.09 AM.png
Screen Shot 2018-10-01 at 10.52.55 AM.png
Screen Shot 2018-10-01 at 10.52.27 AM.png

Re: How do I get/see the URL that tRESTClient is generating?

Anonymous — Mon, 01 Oct 2018 17:00:49 GMT

That is a compilation error. It means that you have filled in a component parameter incorrectly. Can you show the tRestClient_1 component config (this is where the error is). It may just be a String parameter not surrounded by quotes, so check that first.

Re: How do I get/see the URL that tRESTClient is generating?

Anonymous — Mon, 01 Oct 2018 17:05:19 GMT

I think everything is quoted like it should be....

Screen Shot 2018-10-01 at 11.04.16 AM.png

Re: How do I get/see the URL that tRESTClient is generating?

Anonymous — Mon, 01 Oct 2018 17:23:03 GMT

Your URL looks wrong......but that is not causing the compilation error. You have "external_id:none" instead of "external_id=none". A colon is used instead of an equals symbol.

Your compilation error is caused (I believe) by the "Relative Path" being empty. I know I said to remove it, but I meant to replace it with an empty String (""). This is what it will have in an unconfigured component. Sorry, that was my fault.

Re: How do I get/see the URL that tRESTClient is generating?

Anonymous — Mon, 01 Oct 2018 17:35:51 GMT

Ah, thanks for clearing that up.

The Zendesk documentation explicitly states that a colon should be used when looking for "none" or null values. They also specify using the colon for other things as well.

https://support.zendesk.com/hc/en-us/articles/203663226

Woohoo! That did it though! I am now getting data.

Now I just have to figure out how to process it....back to the tutorials.

THANK YOU VERY MUCH for your help in getting the API connection to work. I really appreciate it.

Craig

Re: How do I get/see the URL that tRESTClient is generating?

Anonymous — Mon, 01 Oct 2018 19:12:35 GMT

No problem. Web services can be really tricky sometimes, even when you've spent ages working with them. It turns out that everyone who implements services does it in a slightly different way and documents them in completely different ways.....well that may be an exaggeration, but it certainly feels like it sometimes 😉