SS&C Blue Prism Community

EasyBluePrism · 13-02-26

I have the following JSON Path:$.categories[0].Details[0]["G-Nummer"]and this JSON:{ "categories": [ { "Kategorie": "Police Nr.", "Details": [ { "G-Nummer": "G-0100-0273" }, { "VN-Key": "406335.002...

EasyBluePrism · 31-10-25

I have an Excel file on Sharepoint. Every day I want to add a few new lines there, because it is a report. Until now, we had this report on an ordinary drive. That’s why we used the VBO Excel with the following actions, amongst others: Go To Next Emp...

EasyBluePrism · 03-01-25

I have the following problem:I want to save a collection as a CSV file in a Sharepoint folder.I know the Action Microsoft 365 Excel Write Collection. Is there something similar for CSV? Another option would be to first store the Excel file on Sharepo...

EasyBluePrism · 02-12-24

I have two questions about handling CSV files with Microsoft 365 Excel VBO.Firstly, I should be able to read a CSV and save it as a collection. In other words, I am looking for an action analogous to Get CSV Text as Collection.On the other hand, I sh...

EasyBluePrism · 15-05-24

I have now transferred my test processes for Sharpoint and Micorsoft 365 API from production to the test environment, as I had done initial tests on production.I configured the BP Web API analogously and adjusted the IDs (tenant, client) and client s...

EasyBluePrism · 13-02-26

Excellent! Thank you very much. It works 

EasyBluePrism · 06-11-25

Hi @Kirk.Russell Thank you very much. That’s how it works, as long as the Excel doesn’t have formatting. My Excel had marked the rows with different colours. So with GetNumberOfRows, all the empty rows were counted. As soon as I removed these formatt...

EasyBluePrism · 15-04-25

Hi @GeoffHirst I come back to the subject of CSV files. I wanted to ask if it is now possible to store a collection as a CSV file in Sharpoint (!)? Which VBO does this work with?

EasyBluePrism · 21-02-25

@John_Carter: this is no longer correct. If you type “ISO-8859–1” in FileEncoding, then European special characters will be read.

EasyBluePrism · 23-01-25

@ewilson @Neel1 Here you have two screenshots:

SS&C Blue Prism Community

User Statistics

User Activity

My JSON and JsonPath do not work with Utility JSON

VBO Microsoft 365 Excel: Dynamically describe Excel

Save a collection as a CSV file in a Sharepoint folder.

Microsoft 365 - Excel VBO Reading and Writing CSV

Microsoft Graph - SharePoint - GetDefaultDriveDetails

Re: My JSON and JsonPath do not work with Utility JSON

Re: VBO Microsoft 365 Excel: Dynamically describe Excel

Re: Save a collection as a CSV file in a Sharepoint folder.

Re: Reading UTF-8 Text files?

Re: Uploading file to Sharepoint Folder