Skip to main content
Best answer

How do I convert a JSON output to plain text?


Forum|alt.badge.img+1

I have a JSON output that goes as follows:

{
  "Item 1": [
    "Item 1 description."
  ],
  "Item 2": [
    "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.

Best answer by Troy Tessalone

Hi @MJ_IATC 

Try this tip:

 

View original
Did this topic help you find an answer to your question?
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

Troy Tessalone
Forum|alt.badge.img+14
  • Zapier Expert
  • 30829 replies
  • Answer
  • May 17, 2024

jayeshkumarbhatia
Forum|alt.badge.img+6

Hey @MJ_IATC ,

 

Can you tell us the expected output that you want?


fiona819
Forum|alt.badge.img+3
  • New
  • 111 replies
  • May 17, 2024

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