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

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?

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!

Page 1 / 1

Hi @MattBia

Good question.

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

Hi Troy,

As in the Stripe API docs?

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

@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
  }

@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.