I have a talend job which pulls data from an api and loads into SQL Server. I am constantly running into this error message for the last few days:
[FATAL]: SR_Reservation_Extract - tRunJob_1 Child job returns 1. It doesn't terminate normally.
Exception in component tRESTClient_1 (SR_Reservation_API_Child)
javax.ws.rs.BadRequestException: HTTP 400 Bad Request
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
I know this a client error and the the server is unable to process the request sent by the client ( Could be invalid syntax) . I tested the api url with query paramaters in POSTMAN and i am seeing the request as successful. It appears there is an issue with how i am making the request in talend job
Can someone tell me how i can debug the issue? Any settings i need to change?
Hi @desanip ,
Can you please print the whole URL, that you are generating in Talend, and then use the full URL in postman/browser and check if you are hitting the correct API.
Thanks and Regards,
Hi @subhadip13 ,
Yes i did print out the full url and i was able to successfully make a request to the api url in postman. I can see the data as well. My HTTP method is GET and Accept type is XML if i have to be more specific.
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Watch the recorded webinar!
The Talend Cloud Developer Series was created to give you a solid foundational understanding of Talend’s Cloud Integration Platform
An integration platform-as-a-serviceto help enterprises collect, govern, transform, and share data from any data sources
Move from On-Premises to the Cloud by following the advice of experts