topic Pushing files to Share Point in Talend Studio

Pushing files to Share Point

HemaS1 — Fri, 15 Nov 2024 22:44:55 GMT

Hello,

I am trying to upload files to Share Point and need help on how to set do this using tFileFetch POST method. Here are my Basic and Advanced setting for this. When I run this job it is throwing 'Exception in component tFileFetch_1 (job_load_charge_projection_sharepoint)

java.io.FileNotFoundException: File is not a normal file.' error. Attached are Basic and Advanced settings for this.

Thanks,

Hema

Re: Pushing files to Share Point

Anonymous — Wed, 13 Jul 2022 07:42:10 GMT

Hello,

There are 2 issues about your tFileFetch settings:

in basic settings, the 'Destination Directory' should be an absolute path, it should be "c:/Users/HShanthi/Documents/Employee - EDW"
in advanced settings, Upload file settings, the Content-Type should be ""application/octet-stream"

could you please try the changes to see if it work?

Re: Pushing files to Share Point

HemaS1 — Wed, 13 Jul 2022 07:53:35 GMT

Hello,

Changes the settings but still getting same error:

Starting job job_load_charge_projection_sharepoint at 00:48 13/07/2022.

[statistics] connecting to socket on port 3373

[statistics] connected

Exception in component tFileFetch_1 (job_load_charge_projection_sharepoint)

java.io.FileNotFoundException: File is not a normal file.

at org.apache.commons.httpclient.methods.multipart.FilePartSource.<init>(FilePartSource.java:68)

Re: Pushing files to Share Point

HemaS1 — Wed, 13 Jul 2022 07:53:52 GMT

Re: Pushing files to Share Point

Anonymous — Wed, 13 Jul 2022 08:48:35 GMT

Hello,

regarding to the error log, seems it's related to the upload file path which contains white spaces.

could you please re-name the excel file name under the folder 'c:/Users/HShanthi/Documents/Employee - EDW' to remove white spaces, and reset the tFileFetch related settings ?

Re: Pushing files to Share Point

InfoCraft — Wed, 13 Jul 2022 14:03:48 GMT

Hi @Hema Shanthi,

https://community.talend.com/s/feed/0D55b00007QRgwUCAT

Happy learning,

Kind regards,

😷19.

Re: Pushing files to Share Point

HemaS1 — Thu, 14 Jul 2022 04:45:39 GMT

Chen,

Thank you. I error with file got resolved. Now I need client id and secret to move with this, as I am getting '403 Forbidden' error.

@Covid19,

Thanks for the information on the integration details. Once I get the client id and Secret I will try your method for the integration.

Hema

Re: Pushing files to Share Point

InfoCraft — Fri, 15 Jul 2022 14:23:54 GMT

Hi @Hema Shanthi,

Yes you need to have the Client Id and client secret to generate a bearer token.

but in the meantime you can use Graph Explorer to obtain a temporary token (valid for one hour)

https://developer.microsoft.com/fr-fr/graph/graph-explorer

Kind regards,

😷19.