Collection to JSON - Output format

[rajeshkumarmuthineni]

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
------------------------------

[PabloSarabia]

Hi @Rajesh Kumar

Can we see your collection format?

Usually​, for a simple collection like this:


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"




See you in the community, bye 🙂

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