billinghamj-ad-hoc-prices | Stripe Developers | Page 1

crystal iron Jun 29, 2022, 3:33 PM

#

Hello 👋
Give me a moment to catch up here and I'll respond as soon as I can 🙂 Thanks

#

Moving this here for the context

Context:
https://stripe.com/docs/products-prices/manage-prices#ad-hoc-prices
https://stripe.com/docs/api/prices/list?lang=curl#list_prices-active

queen coral Jun 29, 2022, 3:36 PM

#

Thank you

#

curl https://api.stripe.com/v1/prices/search -d query="active:'false'"

This does work, so I'm not sure why the regular listing API doesn't

#

The ad-hoc + API docs do seem to suggest, from stating "they’re marked as active=false" and providing the option to query with the active param, that listing with active=false should show them

There's no mention that they're a special case, or that there's some other difference in the object type etc

misty dock Jun 29, 2022, 3:50 PM

#

👋 stepping in here as hanzo had to step away.

queen coral Jun 29, 2022, 3:50 PM

#

ty

misty dock Jun 29, 2022, 3:50 PM

#

Can you provide a request ID for your retrieval?

#

https://support.stripe.com/questions/finding-the-id-for-an-api-request

Finding the ID for an API Request : Stripe: Help & Support

Find help and support for Stripe. Our support center provides answers on all types of situations, including account information, charges and refunds, and subscriptions information. Get your questions answered and find international support for Stripe.

queen coral Jun 29, 2022, 3:50 PM

#

Sure - req_elwBg2D1VSu5Mo

#

That was:

curl -G https://api.stripe.com/v1/prices \
  -u sk_test_xxx: \
  -d active=false -v```

#

{
  "object": "list",
  "data": [

  ],
  "has_more": false,
  "url": "/v1/prices"
}

misty dock Jun 29, 2022, 3:55 PM

#

Thanks, looking

#

So I'm just seeing one price on the account and it is active

queen coral Jun 29, 2022, 3:56 PM

#

Check out req_ZMYtBmCzINuMRu - a search

#

Example non-active price ID price_1LG21jDAfGskkGiU6OdtMiHk

#

I'm assuming internally ad-hoc prices are stored a bit differently maybe? If so, that seems to be leaking into the API behaviour

misty dock Jun 29, 2022, 4:07 PM

#

Oh okay yeah that price is inactive

#

Huh okay I just tested on mine and the query is returning fine

queen coral Jun 29, 2022, 4:09 PM

#

Is that with an ad-hoc price though?

#

one made with price_data when creating a sub

#

ref: https://stripe.com/docs/api/subscriptions/create?lang=curl#create_subscription-items-price_data

misty dock Jun 29, 2022, 4:12 PM

#

Good question. Let me test again with creating a new one that way

misty dock Jun 29, 2022, 4:34 PM

#

Sorry, server is really busy.

queen coral Jun 29, 2022, 4:34 PM

#

np np 🙂

misty dock Jun 29, 2022, 4:59 PM

#

Okay so yeah as far as I can tell Search doesn't handle this scenario

#

So feels like a bug to me and I'll need to file a ticket

queen coral Jun 29, 2022, 4:59 PM

#

Thank you, that'd be helpful 🙂

#

The underlying reason I've flagged this is because Fivetran isn't syncing the prices, so I was going to coach them through how the API should be used

#

So I will prob leave that ticket on hold until it's resolved on the Stripe side

misty dock Jun 29, 2022, 5:03 PM

#

Go ahead and write into our Support team (https://support.stripe.com/contact/login) and mention bismarck in your ticket and let me know when you have sent the ticket. Then I can grab the ticket and keep you updated for when this is fixed.

#

Let me know when you have submitted the ticket so I can go grab it

queen coral Jun 29, 2022, 5:04 PM

#

Thanks, will do

queen coral Jun 29, 2022, 5:21 PM

#

Sent that 🙂

#

em_yfjvsl3dc8cbdcolednj2nj2xi4mpr

misty dock Jun 29, 2022, 5:26 PM

#

Great I see it. I'll get back to you over email

#billinghamj-ad-hoc-prices