<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic Pulling Data From Stripe to Databricks using the Webhook in Data Engineering</title>
    <link>https://community.databricks.com/t5/data-engineering/pulling-data-from-stripe-to-databricks-using-the-webhook/m-p/31683#M23080</link>
    <description>&lt;P&gt;I am doing some investigation in how to connect Databricks and Stripe. Stirpe has really good documentation and I have decided to set up a webhook in Django as per their recommendation. This function handles events as they occur in stripe:&lt;/P&gt;&lt;P&gt;----------------&lt;/P&gt;&lt;P&gt;import json&lt;/P&gt;&lt;P&gt;from django.http import HttpResponse&lt;/P&gt;&lt;P&gt;from django.views.decorators.csrf import csrf_exempt&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;# Using Django&lt;/P&gt;&lt;P&gt;@csrf_exempt&lt;/P&gt;&lt;P&gt;def my_webhook_view(request):&lt;/P&gt;&lt;P&gt;&amp;nbsp;payload = request.body&lt;/P&gt;&lt;P&gt;&amp;nbsp;event = None&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;try:&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;event = stripe.Event.construct_from(&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;json.loads(payload), stripe.api_key&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;)&lt;/P&gt;&lt;P&gt;&amp;nbsp;except ValueError as e:&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;# Invalid payload&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;return HttpResponse(status=400)&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;# Handle the event&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;if event['type'] == 'customer.created':&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;customer = event['data']['object']&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;elif event['type'] == 'customer.deleted':&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;customer = event['data']['object']&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;elif event['type'] == 'customer.source.created':&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;source = event['data']['object']&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;elif event['type'] == 'customer.subscription.created':&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;subscription = event['data']['object']&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;elif event['type'] == 'customer.subscription.updated':&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;subscription = event['data']['object']&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;# ... handle other event types&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;else:&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;print('Unhandled event type {}'.format(event['type']))&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;return HttpResponse(status=200)&lt;/P&gt;&lt;P&gt;-------------------------&lt;/P&gt;&lt;P&gt;I now need to integrate some logic to make this work. I wanted to ask:&lt;/P&gt;&lt;UL&gt;&lt;LI&gt;Is there an established approach for connecting stripe to databricks?&lt;/LI&gt;&lt;LI&gt;How can I set up my endpoint in databricks?&lt;/LI&gt;&lt;/UL&gt;&lt;P&gt;Thanks&lt;/P&gt;</description>
    <pubDate>Thu, 15 Sep 2022 10:00:36 GMT</pubDate>
    <dc:creator>190809</dc:creator>
    <dc:date>2022-09-15T10:00:36Z</dc:date>
    <item>
      <title>Pulling Data From Stripe to Databricks using the Webhook</title>
      <link>https://community.databricks.com/t5/data-engineering/pulling-data-from-stripe-to-databricks-using-the-webhook/m-p/31683#M23080</link>
      <description>&lt;P&gt;I am doing some investigation in how to connect Databricks and Stripe. Stirpe has really good documentation and I have decided to set up a webhook in Django as per their recommendation. This function handles events as they occur in stripe:&lt;/P&gt;&lt;P&gt;----------------&lt;/P&gt;&lt;P&gt;import json&lt;/P&gt;&lt;P&gt;from django.http import HttpResponse&lt;/P&gt;&lt;P&gt;from django.views.decorators.csrf import csrf_exempt&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;# Using Django&lt;/P&gt;&lt;P&gt;@csrf_exempt&lt;/P&gt;&lt;P&gt;def my_webhook_view(request):&lt;/P&gt;&lt;P&gt;&amp;nbsp;payload = request.body&lt;/P&gt;&lt;P&gt;&amp;nbsp;event = None&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;try:&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;event = stripe.Event.construct_from(&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;json.loads(payload), stripe.api_key&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;)&lt;/P&gt;&lt;P&gt;&amp;nbsp;except ValueError as e:&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;# Invalid payload&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;return HttpResponse(status=400)&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;# Handle the event&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;if event['type'] == 'customer.created':&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;customer = event['data']['object']&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;elif event['type'] == 'customer.deleted':&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;customer = event['data']['object']&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;elif event['type'] == 'customer.source.created':&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;source = event['data']['object']&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;elif event['type'] == 'customer.subscription.created':&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;subscription = event['data']['object']&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;elif event['type'] == 'customer.subscription.updated':&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;subscription = event['data']['object']&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;# ... handle other event types&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;else:&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;print('Unhandled event type {}'.format(event['type']))&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;return HttpResponse(status=200)&lt;/P&gt;&lt;P&gt;-------------------------&lt;/P&gt;&lt;P&gt;I now need to integrate some logic to make this work. I wanted to ask:&lt;/P&gt;&lt;UL&gt;&lt;LI&gt;Is there an established approach for connecting stripe to databricks?&lt;/LI&gt;&lt;LI&gt;How can I set up my endpoint in databricks?&lt;/LI&gt;&lt;/UL&gt;&lt;P&gt;Thanks&lt;/P&gt;</description>
      <pubDate>Thu, 15 Sep 2022 10:00:36 GMT</pubDate>
      <guid>https://community.databricks.com/t5/data-engineering/pulling-data-from-stripe-to-databricks-using-the-webhook/m-p/31683#M23080</guid>
      <dc:creator>190809</dc:creator>
      <dc:date>2022-09-15T10:00:36Z</dc:date>
    </item>
  </channel>
</rss>

