How can i Upload Multiple Excel files along with Data using tREST component ?

[Anonymous]

I have 3 Excel files containing huge data, i want to Upload these files over server using REST services and i don't know how to use tREST,tRESTClient or tRESTRequest which should be use to upload an excel file along with data and how ?

[manodwhb · Accepted solution]

@meetmahajan,check the below link may be helpfull.

https://help.talend.com/reader/hCrOzogIwKfuR3mPf~LydA/~V42EBQClKxKQghNvzHF1g

[Anonymous]

@manodwhb

Can you please elaborate this, because i can't get that article how can i upload each file,
Scenario 1.
Folder consist of 3 files of Sub_{Date}.xlsx
Another folder consist of 3 files of Pay_{Date].xlsx
now i want to upload whole 6 files using 2 tRESTClient components, what is the flow of components should i use i.e. which components will be helpful to me to fetch thode files one by one and uploads it into the server along with data.? should i use tFileList ---->tRESTClients?

[manodwhb]

@meetmahajan, I belive you know how to get two same date files from folder using tFileList and then after tmap you can use tRestClient to upload into webservices.

[Anonymous]

By using this tFileList--->tFileInputExcel---->tRESTClient
Shall i able to upload Excel file with data ?

[manodwhb]

@meetmahajan,I belive you can do but i have never tried. you can try with webservice component too.

Please chekc below link.

https://help.talend.com/search/all?query=tWebService&content-lang=en&_ga=2.11442867.661092381.152808...

[Anonymous]

Thank you @manodwhb
I"ll try this approach and let you know what exactly happens when we use this approach.
tFileLIst-->tFileInputExcel-->tRESTClient