Skip to main content
Question

Extract whole JSON from Zapier Tables instead of individual items list

  • May 8, 2025
  • 3 replies
  • 36 views

I’m trying to use Zapier Tables to store a JSON, but I need later to extract that json and whenever I try to access the json, it only leaves me the possibility to access each item inside the json instead of the whole object.

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
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+14
  • Zapier Orchestrator & Solution Partner
  • May 8, 2025

Hi ​@Plinio moraes 

Info about different field types in Zapier Tables: https://help.zapier.com/hc/en-us/articles/9775472454157-Different-field-types-in-Zapier-Tables

 

If you want to get the raw JSON, then use this field type: Long Text

 

 


Hey Troy, thanks for the reply.

So, there isn’t a way to access the whole object if I store it as a JSON in the Zapier Tables?


Troy Tessalone
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+14
  • Zapier Orchestrator & Solution Partner
  • May 8, 2025

@Plinio moraes 

To store the JSON and retrieve the raw JSON, use this field type: LONG TEXT

Do not use this field type: JSON