Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

tRESTClient not POSTING with No Errors! JSON String Input

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

Labels (2)
2 Replies
Anonymous
Not applicable
Author

Screenshot attached.

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

tFixedFlowInput - tLogRow - tRESTClient --> tLogRow (response), tLogRow (error)
Anonymous
Not applicable
Author

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