Skip to content

idloom + SQL Server

idloom + SQL Server

idloom + SQL Server integrations

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.

When this happens...
Attendee HooksTrigger when a attendee registers, is updated or deleted on your events, or when a custom menu function is called.
TriggerInstant
automatically do this!
ActionWrite

Start free with email

Start free with email

Start free with Google

Free forever for core features
14 day trial for premium features & apps

More things you can do with idloom and SQL Server

Discover other triggers and actions you can use with idloom and SQL Server

- Instant Event Trigger
  Required
- Allowed events
- Custom manual action name
Trigger
Instant
Try It
- Event UID
  Required
Trigger
Polling
Try It
- Instant Event Trigger
  Required
- Allowed events
- Custom manual action name
Trigger
Instant
Try It
- Event UID
  Required
Trigger
Polling
Try It
- Event UID
  Required
Trigger
Polling
Try It

- Event UID
  Required
- Last invoice number Retrieved
- Invoice Number Prefix
- Sort by
- Sort order
Trigger
Polling
Try It
- Attendee's UID
  Required
- Date from
- Type of transaction
Trigger
Polling
Try It

- Event uid
  Required
- Guest uid
  Required
- Type
- Timestamp
Action
Write
- Event uid
  Required
- 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?
Action
Write
- Attendee uid
- event uid
  Required
- Updated After Date
- Ignore Fields Mapping?
- Sort by
- Sort order
Action
Search
- Events Status
- Event Language
- Event UID
- Sort by
- Sort order
Action
Search
- Status
- Event Language
  Required
- Event UID
- Sort by
- Sort order
- Template event uid
- Profile uid
  Required
- Apply Automatic Configuration?
- Event Name
  Required
- Alias
- Event URL
  Required
- 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
  Required
- location Type
  Required
- Location name
- Street name
- Street Number
- Box
- Post code
- City
- State
- Country
  Required
- Latitude
- Longitude
- Timezone
  Required
- 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?
Action
Search or write
- Table/View
  Required
- Order_by
- Dedupe_key
Trigger
Polling
Try It
New Table
Triggers when you add a new table.
Trigger
Polling
Try It
- Query
  Required
Trigger
Polling
Try It
- Table
  Required
Action
Write
- Table
  Required
- Lookup Column
  Required
- Lookup_value
  Required
Action
Search
- Query
  Required
Action
Search

- Attendee uid
- event uid
  Required
- Updated After Date
- Ignore Fields Mapping?
- Sort by
- Sort order
Trigger
Polling
Try It
- Event UID
  Required
- Last invoice number Retrieved
- Invoice Number Prefix
- Sort by
- Sort order
- Show credit notes with negative amounts.
Trigger
Polling
Try It
- Events Status
- Event Language
- Event UID
- Sort by
- Sort order
Trigger
Polling
Try It
- Event UID
  Required
- Last invoice number Retrieved
- Invoice Number Prefix
- Sort by
- Sort order
Trigger
Polling
Try It
New Profile
Polls your account regularly to find new profiles.
Trigger
Polling
Try It
- Instant Event Trigger
  Required
- Allowed events
- Custom manual action name
Trigger
Instant
Try It
- Profile uid
  Required
- Event uid
  Required
- Anonymized At
- Registration Status
- Language
  Required
- Email Address
  Required
- 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 id
  Required
- 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
Action
Write
- Template event uid
- Profile uid
  Required
- Event Language
  Required
- Apply Automatic Configuration?
- Status
- Event Name
  Required
- Alias
- Event URL
  Required
- 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
  Required
- location Type
  Required
- Location name
- Street name
- Street Number
- Box
- Post code
- City
- State
- Country
  Required
- Latitude
- Longitude
- Timezone
  Required
- 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?
Action
Write
- Guest uid
  Required
- Invoice uid
- Payment date
  Required
- Amount paid
  Required
- Payment reference
- Payment method
Action
Write
- Event uid
  Required
Action
Search
- Attendee uid
- Event uid
  Required
- Updated After Date
- Ignore Fields Mapping?
- Sort by
- Sort order
- Profile uid
  Required
- Anonymized At
- Registration Status
- Language
  Required
- Email Address
  Required
- 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 id
  Required
- 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
Action
Search or write
- Table/View
  Required
Trigger
Polling
Try It
- Query
  Required
Trigger
Polling
Try It
- Table/View
  Required
- Primary_key
  Required
- Order_by
  Required
- Trigger_column
Trigger
Polling
Try It
- DisclaimerCopy
- Query
  Required
Action
Write
- Table
  Required
- ID Column
  Required
Action
Write
- Query
  Required
Action
Search

About idloom

idloom is a complete and professional tool that manages and automates all key aspects of event management.

Related categories

Event Management

About SQL Server

SQL server (or MS SQL) is a top of the line database geared for the cloud

Learn moreLearn moreHelpHelp

Related categories

Similar apps

MySQL

Databases

PostgreSQL

Databases

Firebase / Firestore

Databases