Search for user based on stripe id doesn't work in live

I am having a simple page where users can manage billing from the website. After they canceled the subscription, I have the stripe webhook calling bubble to update the status of the subscriptions.

The stripe wehbook return successful calling and returned the right stripe customer ID. On the backend API flow, I would search for users, user_subscription_id = request data object customer. I was able to find the users in the database when i am in the development mode. When I switch everything to live, and do the same test, I am not able to locate the user. IE, when I search for users that has the same customer ID, it shows me empty search even though I see it in the database.

I’ve checked all the privacy setting, ignore privacy_setting at back end and even changed user to a public object, but I am still not able to search user based in customer id in live mode.

any thoughts?

(1) webhook looks okay:


(2) the customer id ending is: vzzMj and it was returned in the call
(3) In my live database, for the same user… i have the same customer ID
image
(4) Finally, this is the setting on the backend flow

and I have privacy setting ignored

Hi there, @luyilousia… sorry, but I have to ask the obvious question. You know the development and live databases are different, right? Are the users that are in the development database also in the live database?

Best…
Mike

Yes. i have different customer ID in the live and the test mode

I also tried to find the customer ID… search for users… customer_stripe_id=“xxx” (hardcoded test) on the front-end, I am able to locate the user in the database in a live mode. It’s just when I am calling it on the backend

Well, if it’s not something simple like there not being any data in the live database, then you are likely going to have to share screenshots in order for someone to be able to help.

lol…just updated the text and added screenshot…let me know if you need any other info

Your webhook URL has /version-test/ in it

1 Like

omg you are right. yep yep! thank you so much!

1 Like

Not sure what we were lol’ing about there, but that’s why you include screenshots… lol.