luismota

[honest anchor]

Not currently possible, you'd need to loop through them in your own integration/code

[bronze owl]

I've done that, using auto pagination, but that is very time consuming

[honest anchor]

Only way right now I'm afraid!

[bronze owl]

isn't there a way to query the data by the canceled_at key, for example?

[honest anchor]

Not a supported Search field, no: https://stripe.com/docs/search#query-fields-for-subscriptions

[bronze owl]

ok, that was what I was afraid of

thanks @honest anchor

can a service such as Data Pipeline be a work around?

[honest anchor]

I guess you could cache data and query that yep

[bronze owl]

would that work for all of the data, or there is a limited time range on which I can read the data, like the events?

[honest anchor]

I guess that depends on how you implement the data store/cache

[bronze owl]

what do you mean

[honest anchor]

You're considering piping Subscription data from Stripe into a third-party store/cache, yes?

[bronze owl]

not really, I just want to read the data on demand, meaning that I would query the Data Pipeline to get the data that I want, and not need to store it anywhere else

[honest anchor]

I don't know what 'Data Pipeline' is

Assumed you were referencing some third-party service

[bronze owl]

no, I was referencing this stripe service, https://stripe.com/en-gb-us/data-pipeline

[honest anchor]

Our team doesn't really know anything about that

Also, it's reliant on a third-party service to actually store the data

Data Pipeline just facilitates the moving of the data

[bronze owl]

oh ok, so I would always need to fetch all the data from stripe and have my own storage

[honest anchor]

I'm not really sure what you're asking

[bronze owl]

what I mean is, I can't just have stripe providing the info that I want everytime, I would have to store it using a third party service, and then query that for the data

what I wanted was to query stripe directly without needing a third party service

[honest anchor]

If you want to use Data Pipeline, yes. The concept is that it can pipe your Stripe data into external services for you to query

[honest anchor]

You can, but the fields you want to use aren't currently supported. So you either need to:

• Filter locally.
• Pipe the data into another store (maybe via Data Pipeline) and query the fields there.