cdubs44 | Stripe Developers | Page 1

tame trellisBOT Feb 16, 2023, 1:11 AM

#

minor wharf Feb 16, 2023, 1:13 AM

#

Would it be metadata['State']~'" + state + "'" ?

dim edge Feb 16, 2023, 1:13 AM

#

Hi there you can try to use Substring match operator ~ https://stripe.com/docs/search#search-syntax

Search

Look up objects in your Stripe data.

minor wharf Feb 16, 2023, 1:14 AM

#

thought so. Thanks!

#

Would the ~ work on metadata though?

#

@dim edge It doesn't look like the ~ works for metadata

dim edge Feb 16, 2023, 1:16 AM

#

Did you try metadata['State']~UT ?

minor wharf Feb 16, 2023, 1:17 AM

#

Query = "active:'true' AND metadata['Page']:'Gymshare Main Payment' AND metadata['State']~'" + state + "'"

#

wait one sec. forgot to reset my service

#

Yeah, even stripe is saying this

#

Stripe.StripeException: The operator ~ is not a supported search operator for field metadata in resource products. Try using one of the supported operators: :.

dim edge Feb 16, 2023, 1:19 AM

#

OK, so you can't use ~ in metadata field.

minor wharf Feb 16, 2023, 1:20 AM

#

do you have any wildcards or anything?

dim edge Feb 16, 2023, 1:21 AM

#

https://stripe.com/docs/search#field-types,-substring-matching,-and-numeric-comparators looks like you can only use substring operator in string value

#

I'm afraid for metadata you can only use : operator.

minor wharf Feb 16, 2023, 1:22 AM

#

hmmm maybe a feature to think about adding in a future release or something

#cdubs44