idloom + SQL Server
Create new SQL Server rows for idloom-events guests with webhook triggers
Effortlessly manage your event attendees by integrating idloom-events with SQL Server. This workflow activates when there's a new guest registration or check-in, instantly adding a new row to the desired table in your SQL Server database. Streamline your event organization process and keep your team up to date with the latest guest information.
Effortlessly manage your event attendees by integrating idloom-events with SQL Server. This workflow activates when there's a new guest registration or check-in, instantly adding a new row to the desired table in your SQL Server database. Streamline your event organization process and keep your team up to date with the latest guest information.
- When this happens...
Attendee HooksTrigger when a attendee registers, is updated or deleted on your events, or when a custom menu function is called.
TriggerInstantThis event starts a Zap instantly. - automatically do this!
ActionWriteCreate a new record or update an existing record in your app.
- Free forever for core features
- 14 day trial for premium features & apps
Instant Event TriggerRequired
Allowed events
Custom manual action name
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Instant Event TriggerRequired
Allowed events
Custom manual action name
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Event UIDRequired
Last invoice number Retrieved
Invoice Number Prefix
Sort by
Sort order
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planAttendee's UIDRequired
Date from
Type of transaction
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planEvent uidRequired
Guest uidRequired
Type
Timestamp
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Event uidRequired
Status
Event Name
Alias
Event URL
Organiser
Is Date Unknown?
Start Date
End Date
Is All Day Event?
has Registering period?
Registration start date
Registration end date
Enable "Notify Me" Feature?
Locale
location Type
Location name
Street name
Street Number
Box
Post code
City
State
Country
Latitude
Longitude
Timezone
Is Event Free?
Currency
is First steps inverted?
Skip step 2?
Skip step 3?
Skip step 4?
Display title on image?
Description
Display share?
Hide Event Address?
Map Zoom Level
Registration instructions
Tickets instructions
Hotels instructions
Check-out instructions
Show QR code on the confirmation page?
Display "Print your ticket" button on the confirmation page?
Display "Print summary" button on the confirmation page?
Display “Go to the Attendee Hub” button on the confirmation page?
Send confirmation email automatically?
Send confirmation email to accompanying person?
Be in BCC of automatic emails?
BCC email address
Override profile "Reply-to" email address
Display cover image in email?
Display full attendee's detail in email?
Display event location in email?
Display “Go to the Attendee Hub” button in email?
Include "Print Ticket" Button in Email?
Display QR code in email?
is Private?
is Domain redirection disabled?
Meta Title
Meta Description
Use specific content?
Social media Title
Social media Description
Attendee Hub & App Description
Force email uniqueness?
Activate captcha?
Allow attendees to resend themselves the confirmation email?
Allow attendees to modify their registration?
Allow ticket downgrades?
Allow attendees to cancel their registration?
Allow registrants to notify that they will not attend?
Activate restricted registration?
Pop-up text for restricted registration
Make the restricted code mandatory?
Use the same restricted code for all registrants?
Restricted code
Hide the event category?
Categories title
Activate stock management?
Sold-out label
Display remaining quantities when sold percentage reached
Hide sold-out items?
Activate waiting list for sold-out options?
Use global quantity for all categories?
Global quantity for all categories
Options title
Display filter by location for options?
Activate early bird prices for categories and/or options?
Allow registrants to select several of the same item?
Allow several consecutive registrations by the same attendee?
Activate specific dates for categories and options?
Create a QR code for categories and/or options?
Automatically generate invoice upon registration?
Generate and attach invoice to confirmation email?
Allow invoice updates?
Display generated invoices and credit notes on the Attendee Hub?
If invoicing address different from company address, display both on invoice?
Generate Belgian SEPA structured communication?
Activate CodaBox integration?
Attach receipt to confirmation email?
Display receipts in the Attendee Hub?
Activate Tax/VAT.?
Tax/VAT Label
Is Tax/VAT Included?
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Attendee uid
event uidRequired
Updated After Date
Ignore Fields Mapping?
Sort by
Sort order
ActionThis is an event a Zap performs.SearchFind existing data in your appEvents Status
Event Language
Event UID
Sort by
Sort order
ActionThis is an event a Zap performs.SearchFind existing data in your appStatus
Event LanguageRequired
Event UID
Sort by
Sort order
Template event uid
Profile uidRequired
Apply Automatic Configuration?
Event NameRequired
Alias
Event URLRequired
Organiser
Is Date Unknown?
Start Date
End Date
Is All Day Event?
has Registering period?
Registration start date
Registration end date
Enable "Notify Me" Feature?
LocaleRequired
location TypeRequired
Location name
Street name
Street Number
Box
Post code
City
State
CountryRequired
Latitude
Longitude
TimezoneRequired
Is Event Free?
Currency
is First steps inverted?
Skip step 2?
Skip step 3?
Skip step 4?
Display title on image?
Description
Display share?
Hide Event Address?
Map Zoom Level
Registration instructions
Tickets instructions
Hotels instructions
Check-out instructions
Show QR code on the confirmation page?
Display "Print your ticket" button on the confirmation page?
Display "Print summary" button on the confirmation page?
Display “Go to the Attendee Hub” button on the confirmation page?
Send confirmation email automatically?
Send confirmation email to accompanying person?
Be in BCC of automatic emails?
BCC email address
Override profile "Reply-to" email address
Display cover image in email?
Display full attendee's detail in email?
Display event location in email?
Display “Go to the Attendee Hub” button in email?
Include "Print Ticket" Button in Email?
Display QR code in email?
is Private?
is Domain redirection disabled?
Meta Title
Meta Description
Use specific content?
Social media Title
Social media Description
Attendee Hub & App Description
Force email uniqueness?
Activate captcha?
Allow attendees to resend themselves the confirmation email?
Allow attendees to modify their registration?
Allow ticket downgrades?
Allow attendees to cancel their registration?
Allow registrants to notify that they will not attend?
Activate restricted registration?
Pop-up text for restricted registration
Make the restricted code mandatory?
Use the same restricted code for all registrants?
Restricted code
Hide the event category?
Categories title
Activate stock management?
Sold-out label
Display remaining quantities when sold percentage reached
Hide sold-out items?
Activate waiting list for sold-out options?
Use global quantity for all categories?
Global quantity for all categories
Options title
Display filter by location for options?
Activate early bird prices for categories and/or options?
Allow registrants to select several of the same item?
Allow several consecutive registrations by the same attendee?
Activate specific dates for categories and options?
Create a QR code for categories and/or options?
Automatically generate invoice upon registration?
Generate and attach invoice to confirmation email?
Allow invoice updates?
Display generated invoices and credit notes on the Attendee Hub?
If invoicing address different from company address, display both on invoice?
Generate Belgian SEPA structured communication?
Activate CodaBox integration?
Attach receipt to confirmation email?
Display receipts in the Attendee Hub?
Activate Tax/VAT.?
Tax/VAT Label
Is Tax/VAT Included?
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundTable/ViewRequired
Order By
Dedupe Key
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free plan
New Table
Triggers when you add a new table.
Try ItTriggerThis is the start of your ZapPollingZapier 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 appQueryRequired
ActionThis is an event a Zap performs.SearchFind existing data in your app
Attendee uid
event uidRequired
Updated After Date
Ignore Fields Mapping?
Sort by
Sort order
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planEvent UIDRequired
Last invoice number Retrieved
Invoice Number Prefix
Sort by
Sort order
Show credit notes with negative amounts.
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planEvents Status
Event Language
Event UID
Sort by
Sort order
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planEvent UIDRequired
Last invoice number Retrieved
Invoice Number Prefix
Sort by
Sort order
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free plan
New Profile
Polls your account regularly to find new profiles.
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planInstant Event TriggerRequired
Allowed events
Custom manual action name
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Profile uidRequired
Event uidRequired
Anonymized At
Registration Status
LanguageRequired
Email AddressRequired
Title
First Name
Last Name
Phone Number
Mobile Phone Number
Confirmation Email Address
Has Accompanying Person?
Accompanying Person Title
Company Name
Job Title
Street Address
City
Postal code
Country
Check-ins
First check-in date
Paid by
Paying for
Comment
Notes
Hotel Notes
Coupon
Coupon Code
Coupon Discount
Category idRequired
Hotel
Total Price (taxes included)
Total Price (taxes excluded)
Amount of Taxes
Payment Status
Payment Method
Payment Date
Payment Amount
Last Invoice Number
Last Invoice Date
Last Invoice Due Date
Last proforma number
Last Proforma Date
Last Credit note number
Last credit Note Date
id
SKU
Name
Full Name
Location
Start Date
End Date
Available Quantity
Booked Quantity
Early Bird Booked Quantity
Total Booked Quantity
Is Sold Out?
Standard Price
Early Bird Price
Early Bird Deadline
Linked Option IDs
id
SKU
Name
Full Name
Description
Location
Start Date
End Date
Available Quantity
Booked Quantity
Early Bird Booked Quantity
Total Booked Quantity
Is Sold Out?
Standard Price
Early Bird Price
Early Bird Deadline
Linked Category ids
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Template event uid
Profile uidRequired
Event LanguageRequired
Apply Automatic Configuration?
Status
Event NameRequired
Alias
Event URLRequired
Organiser
Is Date Unknown?
Start Date
End Date
Is All Day Event?
has Registering period?
Registration start date
Registration end date
Enable "Notify Me" Feature?
LocaleRequired
location TypeRequired
Location name
Street name
Street Number
Box
Post code
City
State
CountryRequired
Latitude
Longitude
TimezoneRequired
Is Event Free?
Currency
is First steps inverted?
Skip step 2?
Skip step 3?
Skip step 4?
Display title on image?
Description
Display share?
Hide Event Address?
Map Zoom Level
Registration instructions
Tickets instructions
Hotels instructions
Check-out instructions
Show QR code on the confirmation page?
Display "Print your ticket" button on the confirmation page?
Display "Print summary" button on the confirmation page?
Display “Go to the Attendee Hub” button on the confirmation page?
Send confirmation email automatically?
Send confirmation email to accompanying person?
Be in BCC of automatic emails?
BCC email address
Override profile "Reply-to" email address
Display cover image in email?
Display full attendee's detail in email?
Display event location in email?
Display “Go to the Attendee Hub” button in email?
Include "Print Ticket" Button in Email?
Display QR code in email?
is Private?
is Domain redirection disabled?
Meta Title
Meta Description
Use specific content?
Social media Title
Social media Description
Attendee Hub & App Description
Force email uniqueness?
Activate captcha?
Allow attendees to resend themselves the confirmation email?
Allow attendees to modify their registration?
Allow ticket downgrades?
Allow attendees to cancel their registration?
Allow registrants to notify that they will not attend?
Activate restricted registration?
Pop-up text for restricted registration
Make the restricted code mandatory?
Use the same restricted code for all registrants?
Restricted code
Hide the event category?
Categories title
Activate stock management?
Sold-out label
Display remaining quantities when sold percentage reached
Hide sold-out items?
Activate waiting list for sold-out options?
Use global quantity for all categories?
Global quantity for all categories
Options title
Display filter by location for options?
Activate early bird prices for categories and/or options?
Allow registrants to select several of the same item?
Allow several consecutive registrations by the same attendee?
Activate specific dates for categories and options?
Create a QR code for categories and/or options?
Automatically generate invoice upon registration?
Generate and attach invoice to confirmation email?
Allow invoice updates?
Display generated invoices and credit notes on the Attendee Hub?
If invoicing address different from company address, display both on invoice?
Generate Belgian SEPA structured communication?
Activate CodaBox integration?
Attach receipt to confirmation email?
Display receipts in the Attendee Hub?
Activate Tax/VAT.?
Tax/VAT Label
Is Tax/VAT Included?
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Guest uidRequired
Invoice uid
Payment dateRequired
Amount paidRequired
Payment reference
Payment method
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Event uidRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appAttendee uid
Event uidRequired
Updated After Date
Ignore Fields Mapping?
Sort by
Sort order
Profile uidRequired
Anonymized At
Registration Status
LanguageRequired
Email AddressRequired
Title
First Name
Last Name
Phone Number
Mobile Phone Number
Confirmation Email Address
Has Accompanying Person?
Accompanying Person Title
Company Name
Job Title
Street Address
City
Postal code
Country
Check-ins
First check-in date
Paid by
Paying for
Comment
Notes
Hotel Notes
Coupon
Coupon Code
Coupon Discount
Category idRequired
Hotel
Total Price (taxes included)
Total Price (taxes excluded)
Amount of Taxes
Payment Status
Payment Method
Payment Date
Payment Amount
Last Invoice Number
Last Invoice Date
Last Invoice Due Date
Last proforma number
Last Proforma Date
Last Credit note number
Last credit Note Date
id
SKU
Name
Full Name
Location
Start Date
End Date
Available Quantity
Booked Quantity
Early Bird Booked Quantity
Total Booked Quantity
Is Sold Out?
Standard Price
Early Bird Price
Early Bird Deadline
Linked Option IDs
id
SKU
Name
Full Name
Description
Location
Start Date
End Date
Available Quantity
Booked Quantity
Early Bird Booked Quantity
Total Booked Quantity
Is Sold Out?
Standard Price
Early Bird Price
Early Bird Deadline
Linked Category ids
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundTable/ViewRequired
Primary KeyRequired
Order ByRequired
Trigger Column
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planDisclaimer Copy
QueryRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.TableRequired
ID ColumnRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.QueryRequired
ActionThis is an event a Zap performs.SearchFind existing data in your app
About idloom
Related categories
