Is this service available for On-Prem installations, or just on the cloud?
I would love to see a ServiceNow Connector! Really looking forward to watching Integrations grow <3
Super pumped to see what the SharePoint connector will do to our triggering game
I see that I am able to create multiple folders with the same name on the Google Drive. This makes sense as these two folders will have different folder ID’s.
At the same time, I don’t see anything in GDrive activities that would tell me if a folder exists.
Sorry if I missed something or if this question has been already posed and answered elsewhere.
Does the Gmail activity work even if Two Factor Authentication is enabled?
Per my findings less secure apps can be enabled only if 2FA is disabled.
The OneDrive Folder reference seems to be pretty much unusable in almost any other OneDrive activity.
Here is an example:
At 1. I create a OneDrive folder and save reference to a local variable
At 2. I elect to use existing Folder Id
At 3. The local reference variable I saved at 1. is unavailable
So, what is the significance of saving the reference to a OneDrive artifact if it isn’t accessible elsewhere in the flow?
You are not using the reference from step 1 properly. That is, once you have a reference to an object, there’s no need to use Get File/Folder - just use it directly.
Most activities that create an object also output that object so that it can be directly used later. See this example:
Enter ID is for situations where you know the ID of an item but you don’t yet have a reference to it and want to obtain one.
You use it to enter an ID (from a string variable or saved value or whatever) and you get as an output an object that you can then use in your workflows.
See this more complex example that uses the Enter ID functionality:
- you get a folder based on ID, obtaining a reference to it (A)
- you create a new folder, obtaining a reference to it (B)
- you move (B) into (A)
If you really really want to obtain a new reference to an object that you already know, you can do this:
But really, there’s no need to.
Hope this helps clarify things!
Thanks for getting back to me @ovidiu.iliescu .
You’re right. That was an attempt to check where and where not, I could use a OneDrive reference. I will go through all your inputs later today as I am signed in from a different laptop right now.
That said, here is another test I performed before I received your response and it failed on me.
- Is there is some error in configuring this flow below?
- As seen below, at design-time I am able to Browse to the OneDrive folder I need to loop through
- How and where to use the MyDriveItem object in the For Each construct?
- Example: If I wanted to get the name of the file how do I inspect this object?
In your examples above, the references that you create are accessible in subsequent steps. In my case I am not able to access that reference anywhere downstream! Is this a StudioX problem?
I tried to move each file between two existing folder. Regardless, the tests ended in this failure:
Please let me know if I am missing something here yet again.
Regarding the file name, for now you have to go to advanced mode and enter the expression manually, e.g.:
cc @ovidiuponoran - we might need to add an improvement for this, at least for the common properties of a DriveItem
For the copy file operation, you might indeed run into some problems. In your case, it seems like there’s a problem with the integration service.
Two other things to note that may be applicable to you:
There is some caching delay between what you see in OneDrive in a web browser and what Microsoft exposes through their API. This means that you may have files that are already moved/deleted/renamed when seen in the web browser, but which are still reported by the API. This is a known issue, waiting 5-10 minutes is usually enough to sync the two (note that we cannot force a sync, it’s done exclusively on Microsoft’s side).
We have currently also opened a ticket with Microsoft as they seem to have introduced a breaking change in their APIs that may make the For Each activity unstable in some circumstances (e.g. the foreach may end up returning no files). What I can tell you for sure is that, before this bug was introduced and with a properly synced folder, the following workflow worked as expected:
I have. When I type the object name, I get a design time error.
I am perplexed about why the DriveItem variable is visible to a Copy/Move folder activity and not a Write Activity. Similarly, it is not visible even to the If/Else activity.
Which begs the question, if I want to perform some functions based on the name or type of file, how would I do it in StudioX?
The fact that I am unable to access the DriveItem variable also prevents me from renaming a file based on the incoming file name when I move or copy it to a target folder.
Example: if DriveItem.Name returns “SomeFile.png”, I must be able to use this expression to derive the output file name such as “SomeFile_Copy.png”
If this is the case, then it further confuses me on why the same connection works flawlessly when I use the Upload file activity inside it. I have run it several times, and it has not failed even once!
Likewise, if I remove all of the activities from within the Use OneDrive scope and run the automation, with an empty scope, there are no errors.
The files in the Source folder have been there since Oct 28, 2021(screen grab below). To state clearly, the file upload tests were done on one day, and the file Copy/Move tests at least a day after their upload. Therefore, if the API is not able to see the files even after one whole day, we have bigger problems!
This might sound dismissive, but we seem to be having problems with any operation that requires us to read out of OneDrive. Which leads me to ask if the Connector works with free OneDrive accounts or not?
Date of file upload: 10/28/2021 (below)
Date of Error in my previous post: 10/30/2021
@AndyMenon Regarding the design time error you are getting, can you please post here:
- a screenshot of the error
- the exact Studio version you are using
- the package versions you are using in your project (a screenshot from the Project tab or from the package manager would suffice)
You can see from my screenshot that I don’t get any error when typing “DriveItem.Name” - if you on the other hand do, this information would help us investigate why.
Regarding why you are seeing DriveItem in Copy but not in Write Line, it’s because Write Line only accepts strings, whereas the Copy activity directly accepts DriveItems.
(To get into a bit of detail: some types have converters that allow them to show up in the plus menu of other types - DriveItem does not yet, which is why you only see it for properties that directly accept it.)
Error File Attached: As before, the execution failed as a result of an Authentication error. In addition after I set the Target folder to the standard Documents OneDrive folder, I started to see this error for the first time .
Therefore, I tried two other configurations:
First, I set the Limit to First to Blank
Second, I set this additional filter to isolate only the files needed:
End Result: There was no change, I kept getting the error attached.
StudioX_OneDrive_IntSvcs_Error.txt (2.7 KB)
Yes, that connector supports personal accounts.
@AndyMenon Are you using a personal Microsoft account or a work/school account? The error you are getting is known to happen for personal accounts, since the Graph Api Search Endpoint does not support them: searchEntity: query - Microsoft Graph v1.0 | Microsoft Docs - this being said, we will try to make this clearer in the docs.
Also, just to clarify, you are not getting any errors in Studio itself when designing the workflow, just when you are running/executing it, correct?
I’m getting errors during execution and I’m using a personal account.
I did ask about this in my previous post. But then, the upload file activity works with the personal account. I’m wondering why that would be the case - allow uploads , folder creating and deleting but not any file/folder based ops?
Hello @RyanBoone, we tried the integrations and it works well. Yet, here is one thing, which could be improved regarding “Use OneDrive & SharePoint” connection.
When selecting the files, especially those shared with one, there should be a possibility to input the file or folder name or to filter / select the list. Otherwise, the list will become so long that it will take time to find the files.
First, thank you so much for your feedback and question. I’d like to bring in @Brandon_Brown and @Anthony_Petro into the conversation who will be able to either answer or consume your feedback into future updates.
Please keep the questions and feedback coming, at UiPath we are laser focused on you … our customer and product champ!
Hi @RyanBoone how are you?
I’m having trouble finding/setting some connections, I cannot find connectors for GMail nor Slack:
Also, if I try to use the
Use GMail activity with use connections, I get this error:
Could you help me with this? What should I do?
Hi @nerlichman I’m good, hope your doing well yourself. Appreciate you taking the time to dive in. For Gmail and Slack, Either @Anthony_Petro or @brandon.brown from our PM team can assist with this or future timelines
@RyanBoone thanks for the response!
After checking I realized that the videos/demos I saw where they had those Connections/Triggers were all using the staging cloud environment, so I guess those are still not released into community cloud.