Level 51
what's the value of dd('query' => 'amount>'.$transaction->amount.' AND metadata[\'email\']:\''.$transaction->user->email.'\'') ?
Apr 15, 2022
10
Level 41
Search try stripe transaction
Hi I need to search try my stripe transaction cording to email and amount according to the documentation on stripe https://stripe.com/docs/api/charges/search?lang=php my code is
$transactions = Transaction::with('user')->whereStatus('pending')->get();
foreach ($transactions as $transaction) {
$stripe = new StripeClient(
'sk_test_51ILwQcDTtGd18F0vf'
);
$stripe->charges->search([
'query' => 'amount>'.$transaction->amount.' AND metadata[\'email\']:\''.$transaction->user->email.'\'',
]);
dd($stripe);
}
getting this error
We were unable to parse your search query. Try using the format `metadata["key"]:"value"` to query for metadata or key:"value" to query for other fields.
Level 41
array:1 [▼
"query" => "amount>424.79 AND metadata['email']:'[email protected]'"
]
Level 27
@KalimeroMK The documentation consistently uses double quotes, so it may be considering the single quotes invalid – have you tried this instead?
"query" => "amount > {$transaction->amount} AND metadata[\"email\"]:\"{$transaction->user->email}\"
That would be an easy first thing to try, at least.
Edit: Oh, actually it doesn’t. The documentation for the search query language and supported query fields both use double quotes, but the example on the page you linked to uses single quotes, so it’s probably not that after all.
Level 51
@KalimeroMK Try
'query' => 'amount>'.$transaction->amount.' AND email:\'' . $transaction->user->email . '\'',
Level 41
@kokoshneta already try not working same erroe
Level 41
@MohamedTammam nope same error
Level 27
@KalimeroMK Are you sure the API accepts floats? The documentation only calls it “numeric”, which is wonderfully vague, but I seem to recall from past dealings with the Stripe API that amounts must be integers, at least back when I was integrating it some years ago.
Have you tried using $transaction->amount * 100?
Level 51
@KalimeroMK What do you get when you just search for amount?
Level 41
@MohamedTammam search for amount returns the correct records
Level 41
The doc is wrong or I understand it wrong the end point it is for mount only for email need separate endpoint
Please or to participate in this conversation.