Problems getting Data into Rest Service and receiving the wanted answer

Ulonis — Mon, 10 Jul 2023 08:59:17 GMT

Hello Talend experts,

i've spent several hours into trying and reading online but it seems to not work out with my knowledge.

I need to connect to a REST service via tRest or tRest Client to get around 20 thousand data records back.

For this I have got several Filters etc. which i need to provide for this call.

Input needs to be in x-www-form-urlencoded where the Data needs to be formatted in JSON. The answer should be in same format.

The Inputs are given completely and the whole case is working in postman.

It doesn't matter how I try. Talend is giving me either a HTTP Code 200 |Code -2 or -3 "Access Denied" or HTTP Code 200 |Code -2 or -3 "Incorrect Document"

Depending on how I try, the first error should be a wrong authorisation or input of my parameters to a place where this user didnt got access.

The second error is literally my endboss as I seem to not get any futher on this topic than this.

Where is my error in this talend job?

See attached several Screenshots of postman and my Talend Job.

The tFileInputDelimited is reading the String in JSON Format for this input. As there are a lot of special characters making problems with normal string handling I decided to import it like this rather than commenting every " and ; manually.

Thanks in advance!

Re: Problems getting Data into Rest Service and receiving the wanted answer

anselmopeixoto — Mon, 10 Jul 2023 20:35:06 GMT

Hi @Patrick Huebner

Using tRESTClient, try enabling "Log messages" option on advanced settings of the component and test the Job again.

This way you'll be able to check what the Job is sending to the API, compare with your tests on postman and identify the issue.

topic Re: Problems getting Data into Rest Service and receiving the wanted answer in Talend Studio

Problems getting Data into Rest Service and receiving the wanted answer

Re: Problems getting Data into Rest Service and receiving the wanted answer