Recent content by RobertJ

You might find writing the collection to a CSV file faster. You can then still open it in Excel if needed.

You create the stored procedure in the database then use BP to execute the stored procedure. I don't have an example to share but you should just do some research on creating stored procedures. You should be able to call it from Blue Prism or you could create you own code block using some C#...

You could try creating a stored procedure for the large query and then have BP execute it. I believe this would also offer a speed advantage since SQL Server could create an execution plan in advance.

A 500 error can be from not supplying the proper credentials for the request but there can be other defects that might trigger this error.

Gil's calculation blew up for me if month = 12. If you want to create a date function that returns the last day of the month in BP then you need have two calculations and a decision object to branch. If the month is 1 - 11 then use AddDays(MakeDate(1,[Month]+1, [Year]), -1) If month is 12...

Attached is the process. Use the loop construct from the tool box to access every item in the collection. The second block of code I provided above is in the "Format New Line" calculation, then the "Append Line" takes the calculation result and adds it to the main body of the email text.

It is not necessary to have a code stage. Start your email body with table tags and a heading if needed like-- <table style = 'border-bottom: 1px solid black; border-bottom-style: collapse;' > <tr style = 'border-bottom: 1px solid black; padding: 10px;'> <tr> <th style = 'border-bottom: 1px...

See post https://www.rpaforum.net/threads/can-we-create-blueprism-process-as-rest-api.12091/#post-24303 for an example.

Use the VBO Utility - HTTP and select the HTTP Request Option. Attached is an example using a restful service to send emails.

Hi AAH, I am using BP version 6.x and I too needed to use the Accessibility mode for items in the ribbon. But when Power BI first opens a sort of a splash screen is displayed that has several options (Get Data, Recent Sources, Open other reports) and these can be identified using the UI...

I have not used Power BI very much so far, but I have Power BI desktop installed and I was able to create an object and along with the application modeler to create elements. Seems to handle like any other desktop application.

Elhamdouni, The error listed in your attachment 1548234496922.png references SQL Server. I think you may be using the SQL Server VBO instead of the oleDB object which would be needed for Oracle.

I am using version 6.3.1.7631. How do you "clone the permission as per the user"? This is a Blue Prism supplied VBO that I want to modify. Thanks for the feed back.

Not sure I understand your comment. I don't see where AD has a role in Blue Prism development if I am an admin and developer. The error talks about linked or business processes which are are part of the BP environment.

I imported the new Webservice REST VBO into the studio. Some modifications were made to it so that it would work with a particular REST Service but when I tried to save the changes I received the following error message-- This business object cannot be saved because you do not have permission...