topic Re: tRESTClient not POSTING with No Errors! JSON String Input in Talend Studio

tRESTClient not POSTING with No Errors! JSON String Input

Anonymous — Tue, 07 Mar 2017 10:39:22 GMT

Hello,

Desperately seeking some help!

Using Talend Open Studio (6.1.1)

I am using tRESTClient to POST to an API that populates some MySQL tables.

Currently for testing I am simply passing a simple JSON String (with all special characters already escaped).

I have set the Http Headers for Content-Type & UserId.

I have connected the Response and Error rows to tLogRow. And receive a response:

.--------------------.
|   #1. tLogRow_3    |
+------------+-------+
| key        | value |
+------------+-------+
| statusCode | 200   |
| body       | null  |
| string     | null  |
+------------+-------+

But nothing is populated in the tables and No Error message is received. I have attached a screenshot of the job, can someone point me in the right direction. Is there a Logfile so I can see the Payload for the tRESTClient component?

Running the exact same POST request in POSTMAN or through SWAGGER generates the row in the DB flawlessly.

Any help would be much appreciated.

Thanks,

pp84

Re: tRESTClient not POSTING with No Errors! JSON String Input

Anonymous — Tue, 07 Mar 2017 10:44:22 GMT

Screenshot attached.

If it doesn't attach correctly, the mapping is as follows:

tFixedFlowInput - tLogRow - tRESTClient --> tLogRow (response), tLogRow (error)

Re: tRESTClient not POSTING with No Errors! JSON String Input

Anonymous — Tue, 07 Mar 2017 12:47:15 GMT

Finally managed to solve this.

Essentially, needed to add a "string" column to the tFixedFlowInput and put the JSON text into that as a value.

Thanks everyone!

pp84