How to implement stripe Webhooks?

[JetLi]

I am trying to create a subscription based application using stripe and
I am searching the forum for strip and I came across this https://forum.alphasoftware.com/show...ghlight=STRipe
in one of the replies it says "Stripe under Alpha was never fully implemented... only the very basics were exposed and have Actions"and rec

Is there an example on how to use webhooks to update records on tables when a payment is successful and update some dates on a database table for end of billing and automatically send emails to customers as a reminder and disable some functionalities of the application when the payment is not made?

Thanks!

[Davidk]

Re: How to implement stripe Webhooks?

A Webhook is simply a pointer to a url. For Alpha this means an a5w page residing on your server. That a5w page contains no html... it only contains XBasic. When Stripe fires the webhook... it is simply a call to the a5w page URL. That page gets run... and since it's XBasic... the XBasic is run... just regular XBasic to update tables.

Webhooks are implemented differently between companies. You'll have to review the Stripe doc to see how they do it. The data sent along with the Webhook call will probably be somewhere in Context.Request so you'll need to review the Alpha doc for that as well.

The forum post you site has nothing to do with Webhooks and Webhooks has nothing to do with Alpha's implementation of Stripe.

[JetLi]

Re: How to implement stripe Webhooks?

Thanks David. Hope you can share an example of how to implement updating table records upon payment, and also sending message to the App url when the billing period ends.

[CharlesParker]

Re: How to implement stripe Webhooks?

I know this may not answer your question directly but the idea is the same in many ways. The following is a webhook page I made that spark-post calls when an email is sent.
As you will see, I get the data from them and update the tables in my database. What David is saying is you'll need to get the data from them (stripe), break it down and use it to update your database. As I said, this is NOT the same company or what is needed but can maybe show you what code structure might go on an a5w page to parse the data and update tables...it would be awesome if some posted the before stuff from stripe...

<%a5
dim events as c = Request.body
dim pp as p
pp = json_parse(events,.t.)

dim from as c
dim eventtype as c
dim msgwho as c
dim msgfrom as c
dim dbtype as c
dim msgsub as c
dbtype = "Message"
from = pp[1].msys.message_event.friendly_from
eventtype = pp[1].msys.message_event.type
msgwho = pp[1].msys.message_event.rcpt_to
msgfrom = pp[1].msys.message_event.msg_from
msgsub = pp[1].msys.message_event.subject

	dim cn as sql::Connection
	dim result as l = .f.
	dim args as sql::arguments
		result = cn.open("::Name::Connection1")
			if result then
		args.Set("pub",events)
		args.Set("ff",from)
		args.Set("msgtype",eventtype)
		args.Set("towho",msgwho)
		args.Set("msgfrom",msgfrom)
		args.Set("dbtype",dbtype)
		args.Set("sub",msgsub)

			postsql = "INSERT INTO alphanwcopro.spost SET message_event_towho = :towho, msg_subject = :sub, post = :pub, friendly_from = :ff, message_event_type = :msgtype, msgfrom = :msgfrom, webhook = :dbtype"
cn.execute(postsql,args)			
end if
cn.close()
%>