Best answer

Stripe GET balance transactions API call in zapier greater than or equal a unix timestamp issue

  • 14 August 2023
  • 8 replies
  • 172 views

Userlevel 1

Hey all, 

 

New to Zapier and API Calls. I am trying to retrieve a list of Stripe_fee balance transactions within the last 7 days of when the zap is trigged.

 

In the stripe API docs it mentions I can use a child parameter “created.gte” to return results where the “created” field is great than or equal to this value (value hopefully being a dynamic Unix timestamp that I pull from a previous action. I am guessing, but do you use a double underscore to signify a nested (child) parameter?

 

STRIPE API doc about created parameter
current settings successfully returning a list without regard to the created limitation.

 

This correct returns the last 10 stripe fee transactions but does not filter or take into account the created parameter. What am I doing wrong?

 

Thank you for any help!

icon

Best answer by Troy Tessalone 15 August 2023, 01:42

View original

8 replies

Userlevel 7
Badge +14

Hi @MattBia 

Good question.

What is the link to the Stripe API endpoint you are referencing?

Userlevel 1

Hi Troy,

 

As in the Stripe API docs?

https://stripe.com/docs/api/balance_transactions

Userlevel 7
Badge +14

@MattBia 

Looks like the URL is using an outdated structure.

 

 

You may have to deal with pagination if there are 101+ results.

 

For Created, try changing the left side to just created, then add the JSON to the right side. (remove any conditions you don’t need)

{
gt: null, // Greater than
gte: null, // Greater than or equal to
lt: null, // Less than
lte: null // Less than or equal to
}
Userlevel 1

@Troy Tessalone 

I updated the URL and tested without any created parameter and that was successful. 

I attempted the do what you said for the created and got this. Mind you I could be completely off with what I entered here because I have zero JSON experience. 

 

Userlevel 7
Badge +14

@MattBia 

replace null with the mapped output.

{gte: 0000000}

 

Userlevel 1

@Troy Tessalone 

Did both of these resulting in the same invalid integer error:

 

Userlevel 7
Badge +14

@MattBia 

Give this a try:

Left side: created[gte]

Right side: mapped variable

 

Userlevel 1

@Troy Tessalone 

 

That’s it! THANK YOU!!!!!!!!!! 

 

Reply