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

Stripe Data missing

  • 12 October 2022
  • 3 replies
  • 54 views
A

Hey There,

We are using Stripe with Zapier to to pull in data and place to a google doc.

It seems though two weird things are happening, Our order dates come in incorrectly more than half the time

Example: 
2022-10-11 17:35:14 -- Correct
44845.3087152778.   -- Failed

Then our customer addresses will come in and be missing everything but the Zipcode.

Has anyone encountered this, if i pull in the stripe Data on one that failed running a test, it appears to work just fine. 

icon

Best answer by Troy Tessalone 12 October 2022, 02:02

View original

3 replies

Troy Tessalone
Userlevel 7
Badge +14

Hi @Alopex 

Good question.

For the date formatting issue, you can adjust that in GSheets.

 

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
A

Hi @Alopex 

Good question.

For the date formatting issue, you can adjust that in GSheets.

 

Thank you for that tip!

ClintEmsley
Userlevel 4

Hi ​​​@Alopex ,

I’m glad you were able to get the issue with the dates fixed! I wanted to address your second questions as best as I could:

 

...
Then our customer addresses will come in and be missing everything but the Zipcode.
 

In my experience with Stripe, sometimes test data looks a bit different from live data. It could be that the customer address is coming in, but under different fields.

Could you check the “Data Out” on the Stripe trigger for one of these Zap runs where the address was mostly missing? That will show you all of the data that we got from Stripe.

You might be able to find where the address is in live data, if it exists. If you do find fields that contain the address in the “Data Out” tab, you can then map those specific fields in the Zap itself. That should work when the Zap runs live.

Can you check that and let me know what you find out? Thanks!

Reply


Terms & Conditions