About Zapier Community
New to our Community? Get to know more about our space and how to make the most of your time here.

Code of Conduct Community FAQ's Zapier Common Questions What to Expect

Get Started With Zapier
New to Zapier? We have got you covered with our Zapier 101 Resources.

Zapier Essentials

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Zapier Products
Learn more about Zapier's new products.

Zapier Tables Zapier Interfaces

Zapier Reading
All of our best learning resources can be found here.

Featured Articles Show & Tell AI Hub Zapier Tools Hub

Learning Groups
Excited to meet other builders? Check out our interest areas full of doers, dreamers, and in-betweeners.

User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

Best answer

Extract contents of .JSON file contents from s3

  • 29 September 2020
  • 3 replies
  • 1745 views
U
Userlevel 1

Hi there

I have an app running on AWS which uploads exported data files to an s3 bucket. The files include a .json file with client data and .pdf file. I want to use ‘files added to s3’ as my trigger then I need a way to open the .json file, likey with a python code step. 

The data/file will then be used in further steps and will ultimately trigger transactional emails within a CRM.

 

.json file updated to S3 bucket
.json file contains data I need parsed via python code step.

 I found this article opening a text file, however it did not work for me. https://stackoverflow.com/questions/45404000/read-text-file-content-with-python-at-zapier

Please help me, as I am unsure how to approach this!

Joe

icon

Best answer by Danvers 30 September 2020, 13:23

View original
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

Danvers
Userlevel 7
Badge +12

From what I can see, the tricky part here getting the contents of the file in a way that the Python can parse it.

It’s not currently possible to view a file’s contents when you uploaded it so S3, you can only get a link for the file. This is a feature request that we have open, but right now it’s not something that we can do because the S3 API doesn’t allow this. I’ve added you to the feature request in case that’s something that changes in the future; we’ll send you an email if we’re able to add the ability to get the contents of the file. 

 

I’m sorry that I can’t be of more help!

U
Userlevel 1

Hi @Danvers 

Thanks for coming back to me. Just wondering if it is possible to GET the object from the S3 and send elsewhere? - I can’t see a GET object as an available S3 zap action but wonder if it may be possible with webhooks given the object name will be known? 

Or is the Zapier S3 integration many for uploads and not object downloads?

Many thanks

Joe

N
Userlevel 1

import json
import requests

asset_url = input_data['file']
r = requests.get(url=asset_url)

if r.ok:
    output = [r.json()]
else:
    output = [{"error": r.content}]
 

Terms & Conditions