cancel
Showing results for 
Search instead for 
Did you mean: 

Collection to JSON - Output format

Hi All, 

I am trying to create JSON text file with desired format. The action "Collection to JSON" is giving plain text without formatting and also its adding Category and Sub Category for each record. Is there a way I can have Category and Sub Category for entire table just once with desired formatting (Not plain text).

Thank you

------------------------------
Rajesh Kumar
RPA Developer
America/Chicago
------------------------------
1 REPLY 1

PabloSarabia
Level 11
Hi @Rajesh Kumar

Can we see your collection format?

Usually​, for a simple collection like this:

23243.png
I get this JSON text
[{"Field1":"2022-03-17T00:00:00Z","Field2":"Text1","Field3":true},{"Field1":"2022-03-26T00:00:00Z","Field2":"Text2","Field3":false},{"Field1":"2022-03-01T00:00:00Z","Field2":"Text3","Field3":false},{"Field1":"2022-03-06T00:00:00Z","Field2":"Text4","Field3":true},{"Field1":"2022-03-21T00:00:00Z","Field2":"Text5","Field3":false},{"Field1":"2022-03-11T00:00:00Z","Field2":"Text6","Field3":false}]


What exactly you miss with this format?

And, if I understand well, you want to create a file with this text, for this, use the "Append to Text File" action from the VBO "Utility - File Management"

23244.png


See you in the community, bye 🙂

------------------------------
Pablo Sarabia
Architect
Altamira Assets Management
Madrid
------------------------------