How to retrieve JSON content from Zapier Storage using Python

Other Questions Zapier
1

I managed to store a JSON file in Zapier Storage using a POST request and it worked fine. Now I want to fetch that JSON data using Python code running on my local machine. I can connect to the storage and see there’s data there, but I’m having trouble getting the actual JSON content.

import urllib.request
import json
import codecs

def fetch_data_from_storage(storage_url, token):
    endpoint = 'https://hooks.zapier.com/services/'
    req = urllib.request.urlopen(endpoint)
    utf8_reader = codecs.getreader("utf-8")
    result = json.load(utf8_reader(req))
    return result

api_token = "my_secret_token"
response = fetch_data_from_storage(endpoint, api_token)
print(response)

The output I’m getting is just metadata:

{'attempt': '2c847b12-89af-41c2-b45e-a892def5b123',
 'id': '9f21c48a-7634-42ab-bc89-120d5e89f432',
 'request_id': '2c847b12-89af-41c2-b45e-a892def5b123',
 'status': 'success'}

But what I actually need is the stored JSON data:

{'FirstName': 'John',
 'City': 'New York'}

What am I missing here?

2

you’re not passing the auth token right. zapier storage requires authentication to pull data - add your token to the headers or try it as a query parameter. that endpoint looks too generic too, shouldn’t it point to your specific storage item?

3

Your code’s hitting the wrong endpoint. You’re using a generic URL instead of the specific storage item endpoint Zapier gave you when you stored the data. When you first stored that JSON, Zapier should’ve returned a specific URL or ID - that’s what you need for retrieval. Fix your request by adding proper auth headers and targeting the correct endpoint for your stored data. Add the authorization header with your token and make sure you’re hitting the right URL that matches your stored item. That metadata response means the request’s working but not finding the actual content. Double-check your Zapier webhook config - you need the exact retrieval URL from when you first stored the data.

4

Your fetch function isn’t using the parameters you’re passing in. You’ve got storage_url and token defined but you’re hitting a hardcoded endpoint instead. I hit this same issue last month with Zapier Storage. You need to build the request with proper auth headers:

import urllib.request
import json

def fetch_data_from_storage(storage_url, token):
    req = urllib.request.Request(storage_url)
    req.add_header('Authorization', f'Bearer {token}')
    response = urllib.request.urlopen(req)
    return json.loads(response.read().decode('utf-8'))

Use the actual storage URL Zapier gave you when you created the storage item, not the generic hooks endpoint. That metadata response means you’re connecting but not accessing the stored content.

5

import requests

Replace with your actual Zapier Storage URL and key name

ZAPIER_STORAGE_URL = ‘https://store.zapier.com/api/records/YOUR_KEY’
HEADERS = {
‘Content-Type’: ‘application/json’
}

response = requests.get(ZAPIER_STORAGE_URL, headers=HEADERS)

if response.status_code == 200:
data = response.json()
print(“Retrieved JSON data:”, data)
else:
print(“Error:”, response.status_code, response.text)
If you’re using it within a Zap, you may need to set up a Webhooks by Zapier trigger to send the JSON to your server or retrieve it dynamically using “Get Value” with a webhook step.