Forum Engagement Daily Reports

[system]

Daily Forum Report | 17 March 2024

Top 3 Topics with Most Views

Read something from Chart made by @starterui with 42 views.

Orchestrator queue items limit made by @A_Learner with 38 views.

Connect Token > invalid_request made by @Mesut_Can with 37 views.

Top 3 Topics with Most Replies

How to extract the data in Excel using linq query made by @Baby123 with 15 replies.

Hello, i need support for excell automation with Oracle made by @mohamed.saty2012 with 12 replies.

Connect Token > invalid_request made by @Mesut_Can with 9 replies.

Top 3 Users Who Posted The Most

@Anil_G made 21 posts!

@ashokkarale made 11 posts!

@vrdabberu made 11 posts!

Top 3 Most Liked Posts

This post made by @devasaiprasad_K received 2 likes!

SAP Integration with UiPath

what are the options that needs to be enabled in SAP if we want to start automating SAP scrapping… one of the answer i knew is enable GUI settings in Options Tab in SAP, so that SAP allows scripting from any external application… but this answer did not satisfied interviewers… is there any other options we need to enable in SAP or any packages that needs to be download for the SAP automtion?

This post made by @ashokkarale received 2 likes!

Connect Token > invalid_request

@Mesut_Can, you need two API calls. First API call to endpoint - /odata/QueueItems. This will return you all the queue Items int the Tennent. We need two things from this API response. 1. OrganizationUnitId 2. Id [image] So we have two inputs required for our second API call to endpoint - /odata/QueueItems({key}) Configure API request as below. key = Id X-UIPATH-OrganizationUnitId = `OrganizationUnitId` [image] That’s it. Click execute. Result: [image] Thanks, Ashok …

This post made by @Yoichi received 2 likes!

Number Formats - Range of Numbers

Hi, Can you try the following sample? [image] intStart = CInt(system.Text.RegularExpressions.Regex.Match(yourString,"(?<=\()\d+").Value) intNumber = CInt(system.Text.RegularExpressions.Regex.Match(yourString,"\d+(?=\))").Value)-intStart+1 Then arrStr = Enumerable.Range(intStart,intNumber).Select(Function(i) System.Text.RegularExpressions.Regex.Match(yourString,"[^(]+").Value+"("+i.ToString+")").ToArray() Sample Sample20240316-3a.zip (2.6 KB) Regards,

Top 3 Most Liked Solutions

This solution provided by @ashokkarale received 2 likes!

Connect Token > invalid_request

@Mesut_Can, you need two API calls. First API call to endpoint - /odata/QueueItems. This will return you all the queue Items int the Tennent. We need two things from this API response. 1. OrganizationUnitId 2. Id [image] So we have two inputs required for our second API call to endpoint - /odata/QueueItems({key}) Configure API request as below. key = Id X-UIPATH-OrganizationUnitId = `OrganizationUnitId` [image] That’s it. Click execute. Result: [image] Thanks, Ashok …

This solution provided by @ashokkarale received 2 likes!

Number Formats - Range of Numbers

@manikandan.murugan, Try this one. [image] Code: NumberFormat.xaml (10.5 KB) Output: [image] Thanks, Ashok

This solution provided by @Gautham_Pattabiraman received 1 likes!

Orchestrator queue items limit

Hello there, In UiPath, there is no maximum limit for the number of items that can be loaded into the queue. As to answer your second question we can use swagger for, adding items, getting items, updating items, and deleting items Note : we have activities which we can make use of for the above listed functionalities as well. Thanks, Gautham.

---

That’s it for now, see you tomorrow for a new report!

Don’t forget to share ideas for other fun stuff we should add to the reports here.