MySQL + Webhooks by Zapier + MemberPress Integrations
How to connect MySQL + Webhooks by Zapier + MemberPress
Zapier lets you send info between MySQL, Webhooks by Zapier, and MemberPress automatically—no code required.
- Free forever for core features
- 14 day trial for premium features & apps
Do even more with MySQL + Webhooks by Zapier + MemberPress
With Zapier, you can do more than just connect your apps - you can automate entire processes from beginning to end! Check out the following list of triggers and actions you can use with MySQL, Webhooks by Zapier, and MemberPress. And don’t forget that you can add more apps and actions to create complex workflows.
QueryRequired
Query results must have a unique
idfield so we can deduplicate records properly! Otherwise we will make a best guess. You must also include desired ordering and limiting in the query.Note: This query must run in less than 30 seconds and it is recommended that you return no more than 5,000 rows
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planTable/ViewRequired
Primary KeyRequired
Usually something auto-incremented like
id. Must be unique. Column names that contain a space must be enclosed within brackets[ ].Order ByRequired
Usually something like
date_updatedorlast_modified. This should ideally be a datetime column that is set to the current datetime whenever a row is updated.Trigger Column
Trigger on changes to cells in this column only. Leave blank if you want to trigger on changes to cells in all columns.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planTableRequired
ID ColumnRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.QueryRequired
You should include desired ordering and limiting (usually to 1 record) in the query.
This query must run in less than ~30 seconds.
ActionThis is an event a Zap performs.SearchFind existing data in your app
Catch Raw Hook
Wait for a new POST, PUT, or GET to a Zapier URL. Gives the request body unparsed (max 2 MB) and also includes headers.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.MethodRequired
The HTTP method we'll use to perform the request.
URLRequired
Any URL with a querystring will be re-encoded properly.
Data Pass-Through?
If yes, request
databelow will be overridden with the raw data from the previous step (you are still responsible for headers though, likeContent-Type). Defaults to no.Data
Place raw data for the request here. Could be JSON, XML, etc. Nothing is parsed for you here (including extra line breaks or spaces -- everything is sent verbatim). You probably need to define a header below corresponding to your data
Content-Type. Reminder: data provided in this field is completely ignored if you chose "yes" to pass-through.Unflatten
By default we convert fields with double underscores into nested dictionaries. Select no here to turn this behavior off.
Basic Auth
A pipe (
|) separated username, password combo for standard HTTP authentication.Headers
Key, value pairs to be added as headers in all requests.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.URLRequired
Any URL with a querystring will be re-encoded properly.
Payload Type
Pay special attention to the proper mapping of the data below.
Data
These are key-value pairs that will form the data portion of the request. If you leave these empty, all fields from the previous step will be used. If you want to send your own raw JSON or form-encoded values here, please use the Custom Request action instead.
Wrap Request In Array
Wraps the request in an array if that is something the service requires.
File
A file object to be attached to the request. The request will automatically be converted to
multipart/form-data, with the above payload type defining the sub content-type for the data being passed.Unflatten
By default we convert fields with double underscores into nested dictionaries. Select no here to turn this behavior off.
Basic Auth
A pipe (
|) separated username, password combo for standard HTTP authentication.Headers
Key, value pairs to be added as headers in all requests.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.
Course Completed
Triggers when a course is completed in MemberPress.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Member Deleted
Triggers when a member is deleted from the system.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Quiz Attempted
Triggers when a quiz is attempted on a MemberPress course.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Subscription Expired
Triggers when a subscription expires.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Transaction Completed
Triggers when a transaction has completed on MemberPress.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Transaction Refunded
Triggers when any transaction is refunded.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.EmailRequired
The User's Email Address.
UsernameRequired
If you are using email addresses as the Username, then both username and email should be set to the same string.
First Name
The User's First Name.
Last Name
The User's Last Name.
Password
A plaintext password that will be hashed and stored with this user. If a member is created and a password is not provided then a random password will be automatically generated for the member on creation.
Transaction
Works only when creating a new Member. This is an array conforming to the documentation for the "Create Transaction" API route (except the "member" parameter will be ignored in favor of the id of the newly created member). This will create an initial transaction for the member to add them to a specific membership.
Send Welcome Email
Works only when creating a new Member and if a transaction has been specified. When set to true this will trigger a welcome email to send to the new member. If the user has already received a welcome email, and the membership this transaction is for does not have its own welcome email configured, then no email will be sent.
Send Password Email
When set to true this will trigger a standard WordPress password recovery email to be sent to the new member.
Address 1
The address street line 1 of the user.
Address 2
The address street line 2 of the user.
City
The address city of the user.
State
The address state of the user.
Zip
The address zip code of the user.
Country
The address country code of the user.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.MemberRequired
The Member's WordPress User ID.
MembershipRequired
The Membership ID associated with this Transaction.
Transaction Number
The unique Transaction Number.
Amount
The base price for the Transaction (not including tax)
Total
The total price for this Transaction (including tax)
Tax Amount
Use this to manually set the tax amount for this Transaction
Tax Rate
Use this to manually set the tax rate for this Transaction. Can use up to 3 decimal places.
Tax Description
A brief description of the tax applied. Example: UK VAT (20%)
Coupon
The Coupon ID associated with this Transaction.
Status
The status of this Transaction. Can be "pending", "complete", "failed", or "refunded". Must be set to "complete" for the member to be considered active on the Membership.
Response
A place where you can store Payment Gateway POST or GET responses for later reference.
Gateway
The Payment Gateway to use for this Transaction.
Subscription
The ID of the Recurring Subscription CPT associated with this Transaction.
Created At
The date the Transaction was created. This should be in a MySQL datetime format. All dates stored in the database should be in UTC timezone.
Expires At
The date the Transaction will expire on. This should be in a MySQL datetime format. All dates stored in the database should be in UTC timezone. Note: Leave at default to create a Transaction that last's a lifetime (aka never expires).
Send Welcome Email
When set to true this will trigger a welcome email to send to the new member. If the user has already received a welcome email, and the membership this transaction is for does not have its own welcome email configured, then no email will be sent.
Send Receipt Email
When set to true this will trigger a transaction receipt email to be sent.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Subscription IDRequired
The ID of the subscription to delete in MemberPress.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Member IDRequired
The ID of the member to update in MemberPress.
EmailRequired
The User's Email Address.
UsernameRequired
The username for this User. If you're using email addresses as the Username, then both username and email should be set to the same string.
First Name
The User's First Name.
Last Name
The User's Last Name.
Send Password Email
When selected, the member being updated will receive an email allowing them to set their password.
Address 1
The address street line 1 of the user.
Address 2
The address street line 2 of the user.
City
The address city of the user.
State
The address state of the user.
Zip
The address zip code of the user.
Country
The address country code of the user.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Transaction IDRequired
The ID of the transaction to update in MemberPress.
MemberRequired
The Member's WordPress User ID.
MembershipRequired
The Membership ID associated with this Transaction.
Transaction Number
The unique Transaction Number.
Amount
The base price for the Transaction (not including tax)
Total
The total price for this Transaction (including tax)
Tax Amount
Use this to manually set the tax amount for this Transaction
Tax Rate
Use this to manually set the tax rate for this Transaction. Can use up to 3 decimal places.
Tax Description
A brief description of the tax applied. Example: UK VAT (20%)
Coupon
The Coupon ID associated with this Transaction.
Status
The status of this Transaction. Can be "pending", "complete", "failed", or "refunded". Must be set to "complete" for the member to be considered active on the Membership.
Response
A place where you can store Payment Gateway POST or GET responses for later reference.
Gateway
The Payment Gateway to use for this Transaction.
Subscription
The ID of the Recurring Subscription CPT associated with this Transaction.
Created At
The date the Transaction was created. This should be in a MySQL datetime format. All dates stored in the database should be in UTC timezone.
Expires At
The date the Transaction will expire on. This should be in a MySQL datetime format. All dates stored in the database should be in UTC timezone. Note: Leave at default to create a Transaction that last's a lifetime (aka never expires).
Send Welcome Email
When set to true this will trigger a welcome email to send to the new member. If the user has already received a welcome email, and the membership this transaction is for does not have its own welcome email configured, then no email will be sent.
Send Receipt Email
When set to true this will trigger a transaction receipt email to be sent.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Subscription NumberRequired
The subscription number of the subscription to be retrieved in MemberPress.
ActionThis is an event a Zap performs.SearchFind existing data in your app
Table/ViewRequired
We expect at least one unique (and usually autoincrement) primary key column so we can deduplicate records properly! Otherwise we will make a best guess on a random column to use to deduplicate.
Order By
Highly recommended! Usually you want the results to be most recent first so we can skim off only new results, so choose something like
date_createdor your autoincrementid. Column names that contain a space must be enclosed within brackets[ ].Dedupe Key
We default to what the primary key is on the table as the unique key to deduplicate on. If you prefer another field, select it here.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free plan
New Table
Triggered when you add a new table.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planTableRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.TableRequired
Lookup ColumnRequired
Lookup ValueRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appURLRequired
This should return a list of dictionaries of content type JSON in reverse chronological order. For example:
[{"id":1234},{"id":1235}]Key
If the returned JSON is not a list and is instead an object (maybe paginated), enter the key that contains the results. Example: "results", "items", "objects", etc... (children via dot syntax supported)
Deduplication Key
Zapier deduplicates the array we see each poll against the
idkey. If theidkey does not exist, you should specify an alternative unique key to deduplicate off of. If neither are supplied, we fallback to looking for the shortest key withidin it otherwise we will raise an error.Xpath
If the content fetched is XML or HTML, optionally define an xpath to extract data from the content. Will trigger whenever the content at the xpath changes!
Basic Auth
A pipe (
|) separated username, password combo for standard HTTP authentication.Headers
Key, value pairs to be added as headers in all requests.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planPick off a Child Key
By default, Zapier gives you the entire payload of the webhook. If this is specified, Zapier will only grab the child key from the object(s) sent to Zapier. For example, given
{"contact": {"name": "Mike"}}, add "contact" here to only return{"name": "Mike"}. Traverse more deeply nested children by using dot-separated syntax. Line item payloads will run your Zap for each instance of the child key.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.URLRequired
We recommend not putting any query string arguments in the URL (use "Query String Params" below).
Query String Params
These params will be URL-encoded and appended to the URL when making the request. Note: If you specify nothing for this field, we will automatically encode and include every field from the previous step in the query string. If you don't want this, use the "Custom Request" action.
Send As JSON
If "yes", this dumps the results directly to a key (set below) as JSON. If "no", we simulate a form.
JSON key
Only used if As JSON.
Unflatten
By default we convert fields with double underscores into nested dictionaries. Select no here to turn this behavior off.
Basic Auth
A pipe (
|) separated username, password combo for standard HTTP authentication.Headers
Key, value pairs to be added as headers in all requests.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.URLRequired
Any URL with a querystring will be re-encoded properly.
Payload Type
Pay special attention to the proper mapping of the data below.
Data
These are key-value pairs that will form the data portion of the request. If you leave these empty, all fields from the previous step will be used. If you want to send your own raw JSON or form-encoded values here, please use the Custom Request action instead.
Wrap Request In Array
Wraps the request in an array if that is something the service requires.
File
A file object to be attached to the request. The request will automatically be converted to
multipart/form-data, with the above payload type defining the sub content-type for the data being passed.Unflatten
By default we convert fields with double underscores into nested dictionaries. Select no here to turn this behavior off.
Basic Auth
A pipe (
|) separated username, password combo for standard HTTP authentication.Headers
Key, value pairs to be added as headers in all requests.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Lesson Completed
Triggers when a lesson is completed on a MemberPress course.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Member Signup Completed
Triggers when a new member completes the signup and their payment is accepted.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Subscription Created
Triggers when a subscription is created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Subscription Stopped
Triggers when a subscription is canceled.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Transaction Expired
Triggers when any transaction expires.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Valid MembershipsRequired
You can set an array of membership ids here that the coupon will apply to.
Should Expire
Set this to true if you want the coupon to expire sometime in the future.
Should Start
Set this to true if you want the coupon to start sometime in the future.
Expires On (required if 'Should Expire' is true)
Set this to the unix timestamp of when you'd like the coupon to expire.
Starts On (required if 'Should Start' is true)
Set this to the unix timestamp of when you'd like the coupon to start.
Coupon Code
This is the coupon code to be associated with the coupon. This should be a unique code with no spaces or special characters other than '-'. If spaces are present the value will be accepted but MemberPress will replace them with dashes. Also, if this value is left blank, MemberPress will automatically generate a unique code for this coupon.
Description
This is the coupon description. This field can be used to add notes to the coupon so the admin can have an idea of what this coupon offers.
Use On Upgrades
If this is enabled, this coupon may be used on Subscription Upgrades within an upgrade path Group.
Usage Amount
Set this to a number greater than zero if you want to limit the number of times the coupon can be used.
Discount Type
This will alter the way MemberPress interprets the 'discount_amount' to either be a percentage or fixed amount.
Discount Amount
The amount of the discount. Depending on what 'discount_type' is set to, this can either be a fixed amount or a percentage.
Discount Mode
Set the discount type. Can be set to standard, trial-override, or first-payment. If set to standard, the discount will apply to all payments for the life of the subscription. If set to first-payment, the discount will apply only to the first payment in an automatically recurring subscription -- this is accomplished by overriding the trial period on the membership. If set to trial-override, it will also override the trial period on recurring membership subscriptions.
First Payment Discount Type
This value is ignored if the discount_mode is anything other than "first-payment". This will alter the way MemberPress interprets the "first_payment_discount_amount" to either be a percentage or fixed amount. Only applies to recurring subscriptions.
First Payment Discount Amount
This value is ignored if the discount_mode is anything other than "first-payment". The amount of the discount for the first payment of a recurring subscription. Depending on what 'discount_type' is set to, this can either be a fixed amount or a percentage.
Trial Days
Set the number of trial days. Only used for recurring subscriptions and if discount_mode is set to trial-override.
Trial Amount
Set the amount of the trial period. Only used for recurring subscriptions and if discount_mode is set to trial-override.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.MemberRequired
The Member's WordPress User ID.
MembershipRequired
The ID of the Membership this Subscription is for.
StatusRequired
The Subscription's current billing status. This can be set to "active", "cancelled", "suspended", or "pending"
Created AtRequired
The date the Subscription was created. This should be in a MySQL datetime format or PHP's date('c') format. All dates stored in the database should be in UTC timezone.
Subscription ID
The Recurring Subscription Number. In order for recurring billings to be tracked, this should be the exact Subsription Number generated by the Payment Gateway for this Subscription.
Response
A place where you can store Payment Gateway POST or GET responses for later reference.
Gateway
The Payment Gateway to use for this Subscription.
Coupon
The ID of the Coupon used on this Subscription.
Price
The Subscription Sub-Total Amount.
Tax Amount
The Subscription Tax Amount.
Tax Rate
The Subscription Tax Rate. Up to 3 decimal points allowed.
Tax Description
A brief description of the tax applied. Example: UK VAT (20%)
Period
The Period for the Subscription billing cycles. See Memberships documentation for more info.
Period Type
The billing period type. See Memberships documentation for more info.
Limit Cycles
Whether or not to limit the billing cycles for recurring membership payments. If set to true, MemberPress will cancel the recurring payments after the limit_cycles_num amount has been reached.
Limit Cycles Num
If limit_cycles is true, then this number is used to determine how many recurring billings should happen before MemberPress automatically cancels the Subscription. If set to 1, the Subscription will be cancelled immediately after the first payment has come through, however the member will maintain access until their Transaction has expired.
Limit Cycles Action
If limit_cycles is enabled, then this will determine the Member's access after their Subscription has reached its limit_cycles_num limit and has been cancelled. If set to "expire" then the Member will lose access after their last Transaction expires. If set to "lifetime", the Member will be granted lifetime access.
Trial
Whether or not there is a trial period on this Subscription. Trial periods ONLY work on auto-recurring payments.
Trial Days
How many days the trial period should last before the regular billing cycles begin.
Trial Amount
If a trial period is enabled, this specifies how much the user paid for the trial period.
Total
The Subscription's Total Amount (including taxes).
CC Last 4
The last four digits of the Member's Credit Card associated with this Recurring Subscription.
CC Exp Month
The Month (0-12) which the Credit Card expires.
CC Exp Year
The 4 digit Year which the Credit Card expires.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Coupon IDRequired
The ID of the coupon to delete in MemberPress.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Transaction IDRequired
The ID of the transaction to delete in MemberPress.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Subscription IDRequired
The ID of the subscription to update in MemberPress.
MemberRequired
The Member's WordPress User ID.
MembershipRequired
The ID of the Membership this Subscription is for.
StatusRequired
The Subscription's current billing status. This can be set to "active", "cancelled", "suspended", or "pending"
Created AtRequired
The date the Subscription was created. This should be in a MySQL datetime format or PHP's date('c') format. All dates stored in the database should be in UTC timezone.
Subscription ID
The Recurring Subscription Number. In order for recurring billings to be tracked, this should be the exact Subsription Number generated by the Payment Gateway for this Subscription.
Response
A place where you can store Payment Gateway POST or GET responses for later reference.
Gateway
The Payment Gateway to use for this Subscription.
Coupon
The ID of the Coupon used on this Subscription.
Price
The Subscription Sub-Total Amount.
Tax Amount
The Subscription Tax Amount.
Tax Rate
The Subscription Tax Rate. Up to 3 decimal points allowed.
Tax Description
A brief description of the tax applied. Example: UK VAT (20%)
Period
The Period for the Subscription billing cycles. See Memberships documentation for more info.
Period Type
The billing period type. See Memberships documentation for more info.
Limit Cycles
Whether or not to limit the billing cycles for recurring membership payments. If set to true, MemberPress will cancel the recurring payments after the limit_cycles_num amount has been reached.
Limit Cycles Num
If limit_cycles is true, then this number is used to determine how many recurring billings should happen before MemberPress automatically cancels the Subscription. If set to 1, the Subscription will be cancelled immediately after the first payment has come through, however the member will maintain access until their Transaction has expired.
Limit Cycles Action
If limit_cycles is enabled, then this will determine the Member's access after their Subscription has reached its limit_cycles_num limit and has been cancelled. If set to "expire" then the Member will lose access after their last Transaction expires. If set to "lifetime", the Member will be granted lifetime access.
Trial
Whether or not there is a trial period on this Subscription. Trial periods ONLY work on auto-recurring payments.
Trial Days
How many days the trial period should last before the regular billing cycles begin.
Trial Amount
If a trial period is enabled, this specifies how much the user paid for the trial period.
Total
The Subscription's Total Amount (including taxes).
CC Last 4
The last four digits of the Member's Credit Card associated with this Recurring Subscription.
CC Exp Month
The Month (0-12) which the Credit Card expires.
CC Exp Year
The 4 digit Year which the Credit Card expires.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.EmailRequired
Member's email address.
ActionThis is an event a Zap performs.SearchFind existing data in your appTransaction NumberRequired
The transaction number of the transaction to be retrieved in MemberPress.
ActionThis is an event a Zap performs.SearchFind existing data in your app
Top companies trust Zapier to automate work and free up time
Connect your apps and automate workflows
Easy automation for busy people. Zapier moves info between your web apps automatically, so you can focus on your most important work.
How MySQL + Webhooks by Zapier + MemberPress Integrations Work
- Step 1: Authenticate MySQL, Webhooks by Zapier, and MemberPress.30 seconds
- Step 2: Pick one of the apps as a trigger, which will kick off your automation.15 seconds
- Step 3: Choose a resulting action from the other app.15 seconds
- Step 4: Select the data you want to send from one app to the other.2 minutes
- That’s it! More time to work on other things.
About MySQL
Related categories
Similar apps
SQL Server
Databases
Quick Base
Databases
Firebase / Firestore
Databases
About Webhooks by Zapier
Related categories
About MemberPress
Related categories
Get started for free
You can't add more hours to the day. Zapier is the next best thing.
Other MySQL + Webhooks by Zapier Integrations
- airtable
- twilio
- facebook-lead-ads
- keap-max-classic
- google-drive
- typeform
- activecampaign
- email-parser
- schedule
- salesforce
- mailchimp
- quickbooks
- zapier-chrome-extension
- rd-station
- monday
- zoho-crm
- mandrill
- acuity-scheduling
- streak
- pipelinedeals
- wordpress
- url-shortener
- sql-server
- sendgrid
- looping
- gravity-forms
- google-calendar
- aws-lambda
- asana
- sub-zap-by-zapier
- jira-software
- pipefy
- hubspot
- mautic
- kajabi
- dropbox
- storage
- zoom
- zengine
- zendesk
- xero
- wpforms
- woodpecker
- trello
- translate
- sugarcrm
- stripe
- smtp
- shift4shop
- quora-lead-gen-forms
- pipedrive
- pdfco
- ninjaforms
- mingdao
- marketo
- mailjet
- instagram-for-business
- google-lead-form-extension
- google-forms
- formidable
- facebook-conversions
- chargebee
- brick-ftp
- bitly
- basecamp3
- bark
- autopilot
- amazon-ses
- agile-crm
- woocommerce
- surveymonkey
- rocketchat
- podio
- microsoft-outlook
- leadconnector
- facebook-pages
- copper
- clickup
- anapro-maxvendas
- leadpages
- knack
- formstack
- bmby-crm
- klaviyo
- pushover
- dotdigital
- unbounce
- linkedin-lead-gen-forms
- untappd
- process-street
- webflow