topic Re: How to upload a CSV/EXCEL file into Sharepoint? in Talend Studio

How to upload a CSV/EXCEL file into Sharepoint?

Anonymous — Sat, 16 Nov 2024 03:33:07 GMT

All,

I have combined 2 sharepoint lists into one by using tSOAP, tXMLMAP & tUNIT and stored the result in a CSV/Excel format(anything is fine).

I would like to publish/move this excel sheet back to sharepoint.

I have visited many threads here and found lot of inputs.

tHTTPREQUEST, tRESTClient, tFileFetch etc., can be used, but i realy don't know which one will fit and how to use?

Any JOB design would be highly appreciated.

Thanks

Karthik M

Re: How to upload a CSV/EXCEL file into Sharepoint?

fdenis — Mon, 20 Jan 2020 10:41:11 GMT

there s probably a soap service for that. But I think RPA is the best way for that.

good luck

Re: How to upload a CSV/EXCEL file into Sharepoint?

Anonymous — Tue, 21 Jan 2020 16:18:00 GMT

What is RPA ?

Re: How to upload a CSV/EXCEL file into Sharepoint?

fdenis — Wed, 22 Jan 2020 09:26:52 GMT

RPA is Robotic Process Automation
etl is data integration step (the truck one time a lot of data).
esb is data integration step (the bike one time by data)
RPA is human integration (a robot it make known task to free up time for human)

https://www.serial.ch/en/imagine-your-business-with-rpa/