Collection to JSON - Output format

rajeshkumarmuthineni — Wed, 23 Mar 2022 05:22:00 GMT

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

RE: Collection to JSON - Output format

PabloSarabia — Wed, 23 Mar 2022 05:36:00 GMT

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

topic RE: Collection to JSON - Output format in Product Forum

Collection to JSON - Output format

RE: Collection to JSON - Output format