topic Re: How to upload PDF file (1) and other parameters (2) through POST REST API in Talend Studio

How to upload PDF file (1) and other parameters (2) through POST REST API

Ziedkh — Fri, 15 Nov 2024 23:29:06 GMT

Hello community,

I would like to create a REST request with the following parameters int Talend. Which component should I use and how to pass parameters to this component (body)? I have all necessary metadata on an input edge, need to transform somehow to body/string parameter and add definition for file to upload (path on the edge).

I have used tRestClient :

and I used tRest :

Any Help please

xdshi

@richard Hall

Thank you.

Re: How to upload PDF file (1) and other parameters (2) through POST REST API

Anonymous — Thu, 25 Nov 2021 05:16:27 GMT

Hello,

Could you please stick to one topic:

https://community.talend.com/s/question/0D55b00006e5eJ3CAI/api-rest-post-pdf-file-with-other-params so that we could pay individual attention to your issue. Thanks for your time.

Bets regards

Sabrina

Re: How to upload PDF file (1) and other parameters (2) through POST REST API

Anonymous — Thu, 25 Nov 2021 10:47:52 GMT

Hi @zied khayechi,

Unfortunately it is very difficult to help with web service queries like this as they all have their own requirements. One solution certainly doesn't fit all when it comes to services.

However, I have spotted a few issues in your config that might be causing this.

First of all, in your tRestClient config, you are not setting the "Accept Type" to Multipart. This needs to be done when transferring files.

Also, when you are using the FORM Content Type, the query params box below becomes the place to configure your form params. So all of your params shown in the top image need to be in there and named appropriately.

WIth regard to the file name, you may need to play around with this a bit. It won't just be the name you need to supply, I suspect that it will need to be the full path to the file.

Can you try this out and let us know how you get on?

Re: How to upload PDF file (1) and other parameters (2) through POST REST API

Ziedkh — Thu, 25 Nov 2021 14:42:22 GMT

Hello @Richard Hall

i have already test it, but it didn't work for me 😞

Re: How to upload PDF file (1) and other parameters (2) through POST REST API

Anonymous — Thu, 25 Nov 2021 16:13:55 GMT

Can you post the error message please? The NullPointerException should not be happening.

Also, what is being sent via the tJava4. The tJava is not meant to be used like that. It would be better to use the tJavaFlex to send row data. Can you share the code and show your tRestClient input schema?

Re: How to upload PDF file (1) and other parameters (2) through POST REST API

Ziedkh — Fri, 26 Nov 2021 13:54:21 GMT

In fact, i wanna just post a pdf file and queries via API .

and I don't have anything as input ( BODY/STRING) ( as we have multipart/form-data content-type)

when i put accepter-type = multipart I got a NullPointerException

But as accepter type = all , I got Bad request ( missing queries )

|400 |{"code":400,"success":false,"data":{"error":"Bad request - repository_id is missing or null"}}|

This is the API Swagger:

Thanks @Richard Hall

Re: How to upload PDF file (1) and other parameters (2) through POST REST API

Anonymous — Fri, 26 Nov 2021 16:34:55 GMT

Can you try moving the repository_id from params to the header section. It looks like you have it as a header variables in your tRest that is working. However in your tRestClient version you have it as a param.

Re: How to upload PDF file (1) and other parameters (2) through POST REST API

Ziedkh — Fri, 26 Nov 2021 16:42:52 GMT

does't work either 😞

Re: How to upload PDF file (1) and other parameters (2) through POST REST API

Anonymous — Fri, 26 Nov 2021 17:02:16 GMT

Can you share the API documentation? It is almost impossible to guess at what an API requires I'm afraid.

Re: How to upload PDF file (1) and other parameters (2) through POST REST API

Ziedkh — Mon, 29 Nov 2021 08:38:48 GMT

here the API DOc

Re: How to upload PDF file (1) and other parameters (2) through POST REST API

Anonymous — Mon, 29 Nov 2021 10:49:17 GMT

OK, this is going to take some trial and error I'm afraid. First of all, the repository_id and type_id are both form properties, so do not go in the header. They are also both of type integer and not String. We'll ignore the metadata until we get rid of the repository_id error. Can set the repository_id and type_id params to be integers (remove the double quotes) and see what that returns please?

Re: How to upload PDF file (1) and other parameters (2) through POST REST API

Ziedkh — Mon, 29 Nov 2021 13:48:26 GMT

I've already tried that, but the param mehode doesn't allow integer as a values.

Re: How to upload PDF file (1) and other parameters (2) through POST REST API

Anonymous — Mon, 29 Nov 2021 14:36:28 GMT

I've just noticed something that makes me think part of your problem is caused by something else in your job failing. This image here......

Shows a nullpointerexception that is not necessarily linked to your tRestClient. The URL at the top of the sys out suggests that you have a tRestRequest in this job somewhere. Can you show the whole job and show the whole of the error messages you get in text please?

Re: How to upload PDF file (1) and other parameters (2) through POST REST API

Ziedkh — Tue, 30 Nov 2021 10:19:35 GMT

here the job,

First I've used tRequest to get file and params,

as you see here, I've got the file in my local repo through Postman Request:

And then i get the NullPointerException in tRestClient .

For me it's the first time that i handle a Post file through an API that why i didn't catch exactly the prob 😟

" Démarrage du job WS_GED_POST_TEST a 11:23 30/11/2021.

Endpoint deployed at: http://127.0.0.1:8040/api/v1/documents

[statistics] connecting to socket on port 3394

[statistics] connected

Exception in component tRESTClient_2 (WS_GED_POST_TEST)

java.lang.NullPointerException

at inter_application.ws_ged_post_test_0_1.WS_GED_POST_TEST.tRESTClient_2Process(WS_GED_POST_TEST.java:3057)

at inter_application.ws_ged_post_test_0_1.WS_GED_POST_TEST.tRESTRequest_1_LoopProcess(WS_GED_POST_TEST.java:4721)

at inter_application.ws_ged_post_test_0_1.WS_GED_POST_TEST$RestServiceProviderImpl4TalendJob.processRequest(WS_GED_POST_TEST.java:714)

at inter_application.ws_ged_post_test_0_1.WS_GED_POST_TEST$RestServiceProviderImpl4TalendJob.Request(WS_GED_POST_TEST.java:813)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

at java.lang.reflect.Method.invoke(Method.java:498)

at org.apache.cxf.service.invoker.AbstractInvoker.performInvocation(AbstractInvoker.java:179)

at org.apache.cxf.service.invoker.AbstractInvoker.invoke(AbstractInvoker.java:96)

at org.apache.cxf.jaxrs.JAXRSInvoker.invoke(JAXRSInvoker.java:193)

at org.apache.cxf.jaxrs.JAXRSInvoker.invoke(JAXRSInvoker.java:103)

at org.apache.cxf.interceptor.ServiceInvokerInterceptor$1.run(ServiceInvokerInterceptor.java:59)

at org.apache.cxf.interceptor.ServiceInvokerInterceptor.handleMessage(ServiceInvokerInterceptor.java:96)

at org.apache.cxf.phase.PhaseInterceptorChain.doIntercept(PhaseInterceptorChain.java:308)

at org.apache.cxf.transport.ChainInitiationObserver.onMessage(ChainInitiationObserver.java:121)

at org.apache.cxf.transport.http.AbstractHTTPDestination.invoke(AbstractHTTPDestination.java:267)

at org.apache.cxf.transport.http_jetty.JettyHTTPDestination.doService(JettyHTTPDestination.java:247)

at org.apache.cxf.transport.http_jetty.JettyHTTPHandler.handle(JettyHTTPHandler.java:79)

at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:132)

at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:257)

at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1345)

at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:205)

at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1247)

at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:144)

at org.eclipse.jetty.server.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:220)

at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:132)

at org.eclipse.jetty.server.Server.handle(Server.java:505)

at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:370)

at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:267)

at org.eclipse.jetty.io.AbstractConnection$ReadCallback.succeeded(AbstractConnection.java:305)

at org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:103)

at org.eclipse.jetty.io.ChannelEndPoint$2.run(ChannelEndPoint.java:117)

at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:698)

at org.eclipse.jetty.util.thread.QueuedThreadPool$Runner.run(QueuedThreadPool.java:804)

at java.lang.Thread.run(Thread.java:748)

[FATAL]: inter_application.ws_ged_post_test_0_1.WS_GED_POST_TEST - tRESTClient_2 null