Skip to main content
D
DanC25
Navigator | Tier 3
December 2, 2025
Solved

write json output to a csv file

  • December 2, 2025
  • 11 replies
  • 224 views

Hello Community

I’m trying to see if there’s a way to write the JSON output to a file.

Right now, the bot connects to the API, fetches the backup history, and returns JSON.
We only need a few fields — job ID, backup type, agent, and client name.
These show up fine in a message box, but how can we write them to a CSV? thanks

 

 

    Best answer by Aaron.Gleason

    ​@DanC25 Log text to file can write a CSV! Just put in something like this:

    $var1$,$var2$,$var3$

    Each Log text to file action will write the text you expect to one line of a file.

    11 replies

    Show previous replies
    Aaron.Gleason
    Automation Anywhere Team
    Aaron.Gleason
    Automation Anywhere Team
    December 3, 2025

    ​@Om Keskar There are an infinite number of ways to solve this problem. Your Python script isn't formatted the way that Automation Anywhere needs it. It must always be in a function format, and we only support one variable at a time being passed to the function. 

    It's good to have another suggestion like this, but build it and test it to ensure it works. That's why I add screen shots to my examples -- to show that I tested it and it works. 

    Terms & ConditionsAccessibility statement