c34f7862创建于 1月15日历史提交
README.md

Eventbrite Handler

Eventbrite handler for MindsDB provides interfaces to connect to Eventbrite via APIs into MindsDB. Here is the API documentation: https://www.eventbrite.com/platform/api

About Eventbrite

Eventbrite is a global self-service ticketing platform for live experiences that allows anyone to create, share, find and attend events that fuel their passions and enrich their lives. From music festivals, marathons, conferences, community rallies and fundraisers, to gaming competitions and air guitar contests. Our mission is to bring the world together through live experiences.

Eventbrite Handler Implementation

This handler was implemented using the eventbrite-python library. eventbrite-python is a Python library that wraps Eventbrite API v3.

Eventbrite Handler Initialization

The Eventbrite handler is initialized with the following parameters:

  • access_token: API key to use for authentication and have an access to data

Read about creating a Eventbrite API Authentication here.

Example Usage

CREATE DATABASE my_eventbrite_handler
WITH ENGINE = "eventbrite",
PARAMETERS = {
  "access_token": "your access token"
};

Use the established connection to query your database:

For ListEventsTable, you need organization permission to list all of their events. Otherwise, 403 error

SELECT * FROM my_eventbrite_handler.user
SELECT * FROM my_eventbrite_handler.organization
SELECT * FROM my_eventbrite_handler.category
SELECT * FROM my_eventbrite_handler.subcategory
SELECT * FROM my_eventbrite_handler.formats

Run more advanced queries:

SELECT id, name
  FROM my_eventbrite_handler.category
  ORDER BY name ASC
  LIMIT 3
SELECT * FROM my_eventbrite_handler.user
WHERE event_id= "717926867587";
SELECT * FROM my_eventbrite_handler.events
WHERE organization_id = '1871338711793';