Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hello,
There are 2 issues about your tFileFetch settings:
could you please try the changes to see if it work?
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)
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 ?
Hi @Hema Shanthi,
https://community.talend.com/s/feed/0D55b00007QRgwUCAT
Happy learning,
Kind regards,
😷19.
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
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.