Hi, I’m working in UiPath community edition 2023.12.0 and I’m trying to get data from a sharepoint table but I can’t get it at all. First I tried the extract table data activity but it always threw me 0 rows and now I’m trying get text and it’s giving me this error: Argument ‘FullSelectorArgument’: BC31190: XML literals and XML axis properties are not available. Add references to System.Xml, System.Xml.Linq, and System.Core or other assemblies declaring System.Linq.Enumerable, System.Xml.Linq.XElement, System.Xml.Linq.XName, System.Xml.Linq.XAttribute and System.Xml.Linq.XNamespace types.
Target is not valid because no targeting methods are enabled. do you know what to do?
Hi!
Take a look at one of these threads and see if there’s anything helpful.
In short, the best way is to integrate with sharepoint or use syncing to a onedrive folder instead.
Get data from sharepoint list - Help / Studio - UiPath Community Forum
How to extract table from sharepoint - Help / Studio - UiPath Community Forum
UiPath: Advice on how to approach Excel file on Sharepoint - Ask - RobotICT Community
Thank you, but i can’t use sharepoint activities. I need to use extract table data or get text and it’s not working, look at it.
Can you download the file instead?
The data on that sharepoint can change from time to time, so I’d rather need to get that data out of there somehow.
You can have the process download the file?
Just remember to delete the local file when you’ve read the file information into your process.
Do you mean that you are unable to spy anything in Edge?
Have you enabled the UiPath extension?
Studio - Extension for Edge (uipath.com)
I can spy anything in Edge, but im getting the error, which is on the picture and i dont know how to fix it. Look at it, i have extension for edge
Ok!
I suggest you import the missing namespaces:
Studio - Importing New Namespaces (uipath.com)
When i try to get help from bot, he recommended me to add reference, but i didnt found, where is it.
Could you post a screenshot of your selector?
It seems like you’re passing a variable into the selector which is of a type Xelement, when the selector can only contain a string.
Yes, there it is:“webctrl tag=‘PRE’ />”
Screenshot please.
And you don’t really need the find element activity unless you’re planning to use the element you’ve found for something.
You’re really only interested in getting the text right?
My goal is to get the data from that sharepoint and there are two columns I’m interested in. Application name and Business analyst. And I’m always going to use that app name to, for example, list the business analyst. I’d like to use sharepoint activities, but unfortunately my company hasn’t allowed me to connect to sharepoint yet, so I’m sort of using resources purely on UiPath.
What I meant is - you only need the get text activity.
And once again, I’d advise you to have the process download the file if that is possible.
could you tell me, how to do it?
Just recreate what you would do for downloading the file?
