Skip to main content
Best answer

How do I convert a JSON output to plain text?

  • 17 May 2024
  • 3 replies
  • 80 views

I have a JSON output that goes as follows:

{
  "Item 1": "
    "Item 1 description."
  ],
  "Item 2": e
    "Item 2 description."
  ],
  "Item 3":  
    "Item 3 description."
  ]
}

Each item has a column in my Google sheet. I want each item description to end up in its relevant column.


I know I can do the last part via mapping to Google sheet via the Google Sheet action. The part I don’t know is how to convert the JSON to plain text, and then have each item description as line items or items I can map separately. 

Any tips would be appreciated.

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

3 replies

Userlevel 7
Badge +14

Hi @MJ_IATC 

Try this tip:

 

Userlevel 6
Badge +6

Hey @MJ_IATC ,

 

Can you tell us the expected output that you want?

Userlevel 3
Badge +3

@MJ_IATC Based on Troy’s suggestion, some screenshots to help you

Â