Can anyone suggest the steps to read and update data from sharepoint list using botflow.
Best answer by mbalslow
View originalCan anyone suggest the steps to read and update data from sharepoint list using botflow.
Best answer by mbalslow
View originalHi @priyaes,
There are many ways of approaching this. First of all, it is relevant to consider what version of Sharepoint you are using as that dictates the available options.
Potentially, you could:
- Access; read, write, update data in Sharepoint lists using an API, which you can call either using the REST action or one of the programming actions like Python.
- Access your Sharepoint via the UI in a browser like you would manually, then you would build the steps of opening the browser, signing in, navigate to the list, and the perform the relevant steps using the bot like you would manually. Here, depending on the objective, you can apply different approaches. For example, if you want to read a lot of data, you could use the function in Sharepoint to export the list to Excel and then read the data from Excel.
So there are various options. It depends on your available options and the objectives. I have made plenty of solutions with both approaches.
Thank you for your sugesstion.I am using sharepoint online environment.
It will be help if you can share images of the settings for REST call for GET,POST method.
I tried the GET method but unable to read data.
Facing the below issue.
err nbr = 5 err desc = The remote server returned an error: (403) Forbidden.
Hi @mbalslow ,
Today I tried the approach of export to excel in sharepoint list.But I am stuck in the step to detect the save action.Can you let me know the best action that can be used to save or open the excel.I have tried targetting and mouse records both is not working.
Your thoughts will be helpful on this.
Hi @priyaes,
Apologies for the late response - busy days...
To answer your different points:
from settings import settings
from office365.runtime.auth.authentication_context import AuthenticationContext
from office365.sharepoint.client_context import ClientContext
ctxAuth = AuthenticationContext(url=settings["sharepoint_url"])
if ctxAuth.acquire_token_for_user(username=settings["sharepoint_username"], password=settings["sharepoint_password"]):
ctx = ClientContext(settings["sharepoint_url_site"], ctxAuth)
else:
print(ctxAuth.get_last_error())
def get_data(list):
list_object = ctx.web.lists.get_by_title(list)
items = list_object.get_items()
ctx.load(items)
ctx.execute_query()
data = []
for item in items:
data.append(item.properties)
return data
get_data("Name of your Sharepoint list")
Hi Priyaes,
I've a similar requirement for my project.
Tried to update the list item using REST API but was getting the error 403 and then i saw your post.
Just wondering if you would be able to share your solution. Not good with Python.
Thanks in advance.
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.