topic Re: Trying to automate Telend API Tester in Talend Studio

Trying to automate Telend API Tester

LISpeedyG — Sat, 16 Nov 2024 03:22:46 GMT

Hi,

I'm having issues using TOS to get the same JSON response to a Post query on API Tester. Below is a working example of a query that works. However, I cannot seem to find a way to make it work using tRestClient in TOS, i.e., I can't seem to find where all the needed variables are hidden.

Can someone here please point me in a relevant direction? Thanks.

Re: Trying to automate Telend API Tester

Anonymous — Tue, 04 Feb 2020 10:45:23 GMT

Below I am sharing images of where you can set each of the properties you need to set using the tRestClient.

The schema button highlighted above is how you pass your JSON body to the component. It needs to be built prior to reaching this component and then sent to this component's "string" column.

Headers can be set on the Advanced tab.

This simply shows the "string" Body column.

Re: Trying to automate Telend API Tester

LISpeedyG — Tue, 04 Feb 2020 11:56:52 GMT

Thank You so much for the response.

I've been working on this while waiting and have found most of the areas. However, I'm not getting any return from the query. I think it's a problem in the body.

1. I've created a JSON file in the Metadata repository

2. I then set this as an input to the tRESTClient

3. I entered the Header Information on the Advanced Tab

4. However, when I run the query I get no response

Do you have any clues as to why I'm not seeing any response to the query?

Re: Trying to automate Telend API Tester

Anonymous — Tue, 04 Feb 2020 12:03:37 GMT

You've broken the tRestClient's input schema. This is easily done unfortunately. It should just have two columns; string and body. You need a new tRestClient component and be careful not to force a change of its input schema. It can ONLY be string and body. Your JSON must be supplied to the string column.

Re: Trying to automate Telend API Tester

LISpeedyG — Tue, 04 Feb 2020 12:16:11 GMT

Originally, I was unable to see any columns to the input schema. I've just added a new tRESTClient and now see the correct schema.

I can't seem to understand how I supply the JSON file to the string column. Can you please help?

Re: Trying to automate Telend API Tester

Anonymous — Tue, 04 Feb 2020 14:33:30 GMT

Add a tMap between your tRestClient component and your JSON component. Then connect your JSON output column to the string column being fed to the tRestClient.

Re: Trying to automate Telend API Tester

LISpeedyG — Tue, 04 Feb 2020 16:29:03 GMT

I have 3 columns (see above picture that shows JSON file columns). Do I connect all 3 columns like below?

Thanks again for all your help!

Re: Trying to automate Telend API Tester

Anonymous — Tue, 04 Feb 2020 19:15:56 GMT

You need to recreate the one JSON document that you used in your API Tester example at the beginning. Building 3 separate JSON docs will not work. They are 3 parameters within a JSON doc....unless I have misunderstood?

Re: Trying to automate Telend API Tester

LISpeedyG — Tue, 04 Feb 2020 20:16:20 GMT

There is only 1 file:

When I place the JSON file (created within the Repository>Meta Data>File JSON) on the design surface it thinks I want to apply the tExtractJSONFields (See below). Is there another way to add it to the design surface?

Re: Trying to automate Telend API Tester

Anonymous — Wed, 05 Feb 2020 10:33:23 GMT

Sorry, I thought you were using a tWriteJSONFields component not the tExtractJSONFields component. You can either build your JSON using the tExtractJSONFields component, you can write it in Java using the tJavaFlex component or you can simply read it from a file using a tFileInputJSON. The tFileInputJSON method is the easiest. Just create a file with your JSON in it. Use the tFileInputJSON with "$" as the loop and a single column called "string" which has this JSONPath "$".

Re: Trying to automate Telend API Tester

LISpeedyG — Thu, 06 Feb 2020 17:23:55 GMT

Thank You so much. It now works.

I have another question:

1. What is the best way to recursively increment the dates in the JSON file, i.e., use variables vs dates and increment the variables?

2. Which component is best to use to parse the returning JSON and append the resulting data into a SQL table?

Thanks again for the EXCELLENT help.

Re: Trying to automate Telend API Tester

Anonymous — Thu, 06 Feb 2020 18:18:35 GMT

With regard to the date question, this code will give you an idea. Paste it into a tJava and run it to see how it works.....

String strDate = "2014-08-07T04:18:21.000-07:00";

Date date = routines.TalendDate.parseDateInUTC("yyyy-MM-dd'T'HH:mm:ss.SSSX", strDate);


for(int i=0; i<100; i++){
	date = routines.TalendDate.addDate(date, 1, "dd");
	System.out.println(routines.TalendDate.formatDateInUTC("yyyy-MM-dd HH:mm:ssXXX", date));
}

The best component for extracting data from a JSON String is the tExtractJSONFields.