Pushing files to Share Point

[HemaS1]

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

[Anonymous]

Hello,

There are 2 issues about your tFileFetch settings:

1. in basic settings, the 'Destination Directory' should be an absolute path, it should be "c:/Users/HShanthi/Documents/Employee - EDW"
2. 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?

[HemaS1]

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)

[Anonymous]

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 ?

[Covid19]

Hi @Hema Shanthi​,

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

Happy learning,

Kind regards,

😷19.

[HemaS1]

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

[Covid19]

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.