I’d like to use KNIME to connect Sharepoint site to handle excel files. The steps what I want to achieve is Read file list and find the destination file, check out the file and edit, check in the file. I am not sure whether KNIME can support this kind of workflow and which node can be used.
1 Like
we’re confident that with the upcoming 4.2 release it will be possible to read from / write to share point.
Best
Mark
5 Likes
@Mark_Ortmann,
Thank you for your message! When the version 4.2 can be released? Is there any plan about it?
1 Like
We expect to release 4.2. Next week. If you want to try the sharepoint online connector right away you can always download our nightly build.
Best
Mark
2 Likes
I have installed the nightly build version. But I am facing the Not authenticated issue. Is there any document can guide me to configure the Sharepoint Online Connector node?
1 Like
If that doesn’t work for you, I had success implementing Sharepoint read/write using the following: https://keathmilligan.net/automate-your-work-with-msgraph-and-python.
In my workflow I am using a Python node to initiate the upload session and just POST and GET nodes to authenticate via Graph API to download files from folders. If you would like I can add more instructions here if it’s something you want to try.
1 Like
Thank you for your message! I will go through your solution firstly. And will come to you if I have questions.
I went through Automate your work with the Microsoft Graph API and Python and tried to address to Azure Active Directory > App registrations. It’s a pity that I don’t have access. I think it is disabled by our IT policy.
My real problem is that how to use KNIME to connect shareponit to check out & check in excel files. Do you have any idea about this activity?
1 Like
Hi @zhengyao. My understanding, according to the Graph API documentation here: https://docs.microsoft.com/en-us/graph/use-the-api you have to register an app via Azure that you will connect through.
I did this recently in my org and I didn’t have any issues registering my ‘KNIME’ app. There may be a way to use the SharePoint API but I’m not certain how you would tie into it given that again my understanding is that Graph API is the way-ahead.
To your question about checking files in and out to manipulate a file in file that originates in SharePoint you need to get the url of the file and connect to that essentially downloading the file to your machine in a temp directory. Once you’ve made your changes you would need to re-upload that changed file back to it’s SharePoint location. You could theoretically DL the file into KNIME, then go another GET that marks it as ‘checked out’. Then upload the new file and check it back in.
If you do happen to check again via your orgs. Azure portal you’ll need the Tenant ID and App ID to use to get authenticated.
I’m sorry I can’t be of greater assistance here given your current situation. If you have any other questions though please reach out.
1 Like
Thank you for your so clear explanation!
The issue what I am facing, it is caused by our IT security policy. Any connector of sharepoint is disabled. I am trying to connect our IT to check whether I can apply an exemption.
I think I will come back to you very soon. Thank you in advance!
Sry it took me so long to follow up.
To my understanding you tried the Microsoft Authentication (Labs) node, opened the dialog and click authenticate and it did not work. Is this correct? If so did your browser open and ask you to grant KNIME certain permissions?
Best
Mark
Yes, I tried the Microsoft Authentication (Labs) node. And the browser opened and shown the error “KNIME is disabled”. I guess the connection of 3rd party application like KNIME is disabled by our IT policy. Am I right?
This topic was automatically closed 182 days after the last reply. New replies are no longer allowed.