#mrelliot69
fair frigate
I'm using stripe express, and need a way to search payments py_ by id , but i dont see any documentation on if this is possible
nimble reef
Are these py_ objects being created by you making a Transfer to the Connected Account, or are they being created because the Connected Account is directly taking payments?
And what are you trying to accomplish by retrieving those objects?
fair frigate
that py_ is auto created when a charge is made in the system,
so in theory represents the payment of the platform to the connected account
i have a list table on the system, and want to allow my users to search on this list by id, so its easier to find
any news?
nimble reef
Gotcha, you can use the Charge endpoint to interact with those objects, so you can use this function to retrieve those:
https://stripe.com/docs/api/charges/retrieve
fair frigate
i cant use that one, because that one is to retrive one charge
i need to search thougt all charges
by the py_ id
nimble reef
Sorry, I'm not sure I'm following. If you already have the ID then why do you need to do a search?
fair frigate
i want to search by the customer name tough all the payments py_ id
nimble reef
I'm not sure whether "customer" in this case refers to your Connected Account or if it corresponds to information that you're adding onto those objects for tracking.
If you want to list all objects for a Connected Account, then you can use the list endpoint:
https://stripe.com/docs/api/charges/list
If you're trying to search through those objects based on information that they contain, then the Search API may be a better fit:
https://stripe.com/docs/api/charges/search
fair frigate
using the query how i can search for a substring on metada
metada["user"]:"test"
i trie using metada[user]~test,
but says that ~ is not supported
nimble reef
It looks like metadata is misspelled there and that the syntax is incorrect. You can reference the syntax for interacting with the Search API here:
https://stripe.com/docs/search#search-query-language
this section specifically covers working with metadata:
https://stripe.com/docs/search#metadata
fair frigate
i know i missspelled but i think you got the point
my question was if a can search the metada for a substring insted of the exact string
metadata["key"]:"value"
nimble reef
Oh, gotcha, I understand the question now. I'm not sure off-hand whether metadata supports substring searching, but if your request and syntax are set properly then it is likely that metadata cannot be used with a substring search.
Based on what I'm seeing on my end, it does look like the ability to do a substring search for metadata does not yet exist.
fair frigate
so theres no option to search by the custommer name on the charges ( person who made the purchase)
?
nimble reef
I don't think there is at that level. You can do a Customer search on your Platform's account:
https://stripe.com/docs/api/customers/search
You could then list the Customer's Payment Intents, and look for results that have a destination that matches the ID of your Connected Account.
https://stripe.com/docs/api/payment_intents/list