Schedule by Zapier + Microsoft Excel + MyGadgetRepairs Integrations
How to connect Schedule by Zapier + Microsoft Excel + MyGadgetRepairs
Zapier lets you send info between Schedule by Zapier, Microsoft Excel, and MyGadgetRepairs automatically—no code required.
Do even more with Schedule by Zapier + Microsoft Excel + MyGadgetRepairs
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 Schedule by Zapier, Microsoft Excel, and MyGadgetRepairs. And don’t forget that you can add more apps and actions to create complex workflows.
Trigger on weekends?
Should this Zap trigger on Saturday and Sunday?
Time of DayRequired
Triggers relative to your timezone settings and defaults to UTC (GMT+00:00) if no preference is set. Note: You can also specify a time with a Custom Value in the formats "hh:mm aa", "hh:mm", or "hhhh" (e.g. "2:30pm", "14:30", or "1430").
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Day of the MonthRequired
Day of month this schedule should trigger on.
Time of DayRequired
Triggers relative to your timezone settings and defaults to UTC (GMT+00:00) if no preference is set. Note: You can also specify a time with a Custom Value in the formats "hh:mm aa", "hh:mm", or "hhhh" (e.g. "2:30pm", "14:30", or "1430").
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Storage Source
NOTE that this defaults to OneDrive. If Sharepoint is picked, subsequent folders that would be listed are ONLY folders in the default Sharepoint site. Other custom Sharepoint sites are currently not supported.
FolderRequired
SpreadsheetRequired
WorksheetRequired
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planStorage Source
NOTE that this defaults to OneDrive. If Sharepoint is picked, subsequent folders that would be listed are ONLY folders in the default Sharepoint site. Other custom Sharepoint sites are currently not supported.
Folder
NOTE that this defaults to the root of the drive.
SpreadsheetRequired
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planStorage Source
NOTE that this defaults to OneDrive. If Sharepoint is picked, subsequent folders that would be listed are ONLY folders in the default Sharepoint site. Other custom Sharepoint sites are currently not supported.
FolderRequired
SpreadsheetRequired
WorksheetRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Storage Source
NOTE that this defaults to OneDrive. If Sharepoint is picked, subsequent folders that would be listed are ONLY folders in the default Sharepoint site. Other custom Sharepoint sites are currently not supported.
Folder
NOTE that this defaults to the root of the drive.
TitleRequired
Column Headers
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Storage Source
NOTE that this defaults to OneDrive. If Sharepoint is picked, subsequent folders that would be listed are ONLY folders in the default Sharepoint site. Other custom Sharepoint sites are currently not supported.
FolderRequired
SpreadsheetRequired
WorksheetRequired
Lookup ColumnRequired
Let us know which column you want to search by with the value below. We will grab the first matching row and give you all of its values.
Lookup ValueRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appInvoice ID
Ticket invoice id or a list of invoice ids
Order ID
POS order id or a list of order ids
Filter
Possible options: pos, invoice, return. Ignored if {invoice_id}
Include Resource
Includes pos, invoice, or return object inside each payment object, if true.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planTicket UUID
Retrieve shipments related to this ticket. {id} in /tickets endpoint.
Customer UUID
Retrieve shipments related to this customer. {id} in /customers endpoint.
Tracking Number
Shipment or Return Shipment tracking number.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free plan
New Stock Count
Triggers when new stock count is created.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planTicket UUID
The ticket id of which the comments to be retrieved. {id} in /tickets endpoint.
Type
Valid options are public, private.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planKeyword
Ticket Reference
The ticket reference to to search for. Reference to {id} {ticket_ref} or {ticket_no} in /tickets endpoint.
Include Item Lines
Include Payments
include Custom Fields
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planKeyword
Include Item Lines
Include Payments
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planDate From
Date in format 'dd-mmm-yyyy'
Date To
Date in format 'dd-mmm-yyyy'
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planSubjectRequired
Appointment Subject. Maximum length is 100 characters.
Appointment Start Date and timeRequired
Appointment Date and time. Format: dd-mmm-yyyy HH:mm
Appointment DurationRequired
Appointment Duration (In Minutes)
Description
Appointment Description.
Type
Valid Options are: InShop,OnSite,PhoneCall
Color
Appointment Color in hex value.
Location
Appointment location.
Latitude
Longitude
Ticket ID
Valid {ticketId}. Get valid list of tickets via tickets/tickets endpoint
Create Ticket
Valid options are: True/False, Yes/No, 1/0
Preset ID
Get via /presets endpoint.
Customer ID
Valid {customer_id}. Get valid list of customers via customers/customers endpoint
Lead ID
Valid {leadId}. Get valid list of leads via leads/leads endpoint
Asset ID
Valid {assetId}. Get the valid list of assets via the customers/assets endpoint
Attendees
Valid {userId OR userIds (comma separated)}. Get a valid list of users via shop/user endpoint
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.NameRequired
Brand name. Maximum length is 100 characters.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.NameRequired
MobileRequired
Email Address
Address
Account Manager
Telephone
Referred By
GDPR Compliant
VAT Registration
Longitude
Latitude
Invoice Email
Comments
Company
Customer Group ID
City
Country Code ISO Format
Payment Term Days
Due Each Month
Payment Term (due on a fixed date each month) - A positive integer between 1 - 28. The value provided for {paymentTermDays} will be ignored.
Due Next Month
Payment Term (due on a fixed date of next month) - A positive integer between 1 - 28. The value provided for {paymentTermDays} and {dueEachMonth} will be ignored.
Gender
Opt-in for Print Media
Opt-in for Email Marketing
Opt-in for Email Notifications
Opt-in for SMS Messages
Intra-Community Supplies (ICS)
Valid options are: True/False, Yes/No, 1/0
VAT Exemption
Valid options are: True/False, Yes/No, 1/0
VAT/TAX Rate
Valid {taxId}. Get valid list of taxes via shop/taxRateCollection endpoint
Credit Limit
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.SubjectRequired
Referred By
Customer's NameRequired
Customer's MobileRequired
A valid phone/mobile number with country phonecode. e.g +44
Country Code
Customer country code in ISO 2 format. e.g. GB for the United Kingdom. If not provided along with the {mobile} field, the shop's country code will be used as default. see ISO 3166-1
Customer's Email
Company/Business Name
Telephone
A valid phone number with country phonecode. e.g +44
Address
Leads Detail
Issue Type
Valid {issueTypeId} or {issueTypeLabel}. In case of {issueTypeLabel}, value must be an exact match, otherwise the resource will return error. Get valid list of issue types via /issuetypes endpoint
Technician User ID
Get via /staffs endpoint
GDPR Compliant
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Invoice IDRequired
Ticket invoice id or a list of invoice ids
Payment Date
Provide the date in the following formats DD-MMM-YYYY HH:mm:ss (22-Jan-2006 23:04:05) YYYY-MM-DD HH:mm:ss (2006-01-22 23:04:05) MMMM DD YYYY HH:mm:ss (January 22 2006 23:04:05)
Invoice Note
AmountRequired
Payment MethodRequired
Payment Note
Is Advance
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.TypeRequired
Valid product types are: product, service
NameRequired
Product name. Maximum length is 100 characters.
Description
ConditionRequired
CodeRequired
Product code. Maximum length is 25 characters.
IMEI
Product imei. Maximum length is 20 characters.
Category
Valid {categoryId}.Get valid list of categories via /categories endpoint.
Brand
Valid {brandId}. Get valid list of brands via /brands endpoint
Model
Valid {modelId}. Get valid list of models via /models endpoint.
Additional Models
Valid Comma Separated models {modelIds}. Get valid list of models via /models endpoint
StatusRequired
Active,In active,Request
One Time Use
Valid options are: True/False, Yes/No, 1/0
inventory Control
Valid options are: True/False, Yes/No, 1/0
Tax Included In Cost
Valid options are: True/False, Yes/No, 1/0
CostRequired
Product purchase price
Tax Included In Price
Valid options are: True/False, Yes/No, 1/0
PriceRequired
Product sell/sold price
Enable Offer Price
Offer Start Date
Provide date in 'dd-mmm-yyyy hh:mm' format.
Offer Price
Tax
Valid {taxId}. Get valid list of taxes via shop/taxRateCollection endpoint
Alert Quantity
Discountable
Valid options are: True/False, Yes/No, 1/0
Supplier
Valid {supplierId}. Get valid list of suppliers via supplier/supplierCollection endpoint
Reorder Quantity
Supplier Item Code
Email To Supplier
Valid options are: True/False, Yes/No, 1/0
Physical Location
Warranty
Valid {warrantyId}. Get valid list of warranties via /warranties endpoint
Serialised Stock
Maintenance Plan
Plan Duration
Valid options are: 3,6,9,12,15,18,21,24,27,30,33,36
Service Schedule
Valid options are: 1,2,3,4,5,6,7,8,9,10,11,12
Stock Quantity
Stock COG Per Item
Product stock cog per item
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.ProductRequired
Valid {productId}.Get valid list of products via /products endpoint
Quantity
The actual quantity you want to add
COG Per Item
Expires On
Stock expired date in 'dd-mmm-yyyy hh:mm' format
Supplier
Supplier Item Code
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.TicketRequired
The ticket reference to which the comment is being posted. Reference to {id} {ticket_ref} or {ticket_no} in /tickets endpoint.
StatusRequired
Valid {statusId} or {statusLabel} of a type 'repair_notes'. In case of {statusLabel}, value must be an exact match, otherwise the resource will return error. Get valid list of statuses via /statuses endpoint.
TypeRequired
The type of comment. Valid options are 'Private', 'Public'
CommentRequired
The actual comment text.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Customer UUID or Customer NameRequired
A valid customer UUID, or a valid customer name.
Short InfoRequired
Status ID
Valid {statusId} or {statusLabel} of a type 'repair'. In case of {statusLabel}, value must be an exact match, otherwise the resource will return error. Get valid list of statuses via /statuses endpoint
Issue Description
Issue Type
Valid {issueTypeId} or {issueTypeLabel}. In case of {issueTypeLabel}, value must be an exact match, otherwise the resource will return error. Get valid list of issue types via /issuetypes endpoint
Priority
Device Model ID
Get via /models endpoint
Created Date
Provide the date in the following formats DD-MMM-YYYY (22-Jan-2006) YYYY-MM-DD (2006-01-22) MMMM DD YYYY (January 22 2006)
Due Date
Provide the date in the following formats DD-MMM-YYYY (22-Jan-2006) YYYY-MM-DD (2006-01-22) MMMM DD YYYY (January 22 2006)
Technician User ID
Get via /staffs endpoint
Work Approved?
Pre Diagnosed
Preset Id
Get via /presets endpoint. This parameter is ignored if {lines} parameter is specified.
Product Code
Description
Quantity
Price
Create Invoice
Sending True will create an invoice.
Invoice Date
Provide the date in the following formats DD-MMM-YYYY HH:mm:ss (22-Jan-2006 23:04:05) YYYY-MM-DD HH:mm:ss (2006-01-22 23:04:05) MMMM DD YYYY HH:mm:ss (January 22 2006 23:04:05)
Invoice Due Date
Provide the date in the following formats DD-MMM-YYYY HH:mm:ss (22-Jan-2006 23:04:05) YYYY-MM-DD HH:mm:ss (2006-01-22 23:04:05) MMMM DD YYYY HH:mm:ss (January 22 2006 23:04:05)
Print Invoice
If true, the invoice will be sent for printing over configured cloud printer(s).
Print Receipt
If true, the ticket/customer receipt will be sent for printing over configured cloud printer(s).
Print Label
If true, the ticket label will be sent for printing over configured cloud printer(s).
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Asset UUIDRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Category IDRequired
The category id you like to delete.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Lead UUIDRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Product UUIDRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Adjustment UUIDRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Ticket UUIDRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Time Clock IDRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Asset UUIDRequired
The asset id to search for. Reference to {id} in /assets endpoint.
Customer UUID or Customer Name
A valid customer UUID, or a valid customer name.
Asset Name
Asset Name. Maximum length is 50 characters.
Asset Identifier
Asset identifier. Maximum length is 100 characters.
Asset Tag
Asset tag. Maximum length is 50 characters.
Model ID
Get via /models endpoint
Asset Type
Valid {assetTypeId} or {assetTypeName}. In the case of {assetTypeName}, the value must be an exact match, otherwise, the resource will return an error. Get the valid list of asset types via /assetTypes endpoint.
Asset Location
Asset location. Maximum length is 50 characters.
Status
Active, Inactive are the valid options
Notes
Asset Notes will contain any additional information related to the asset
RMM Asset ID
RMM Integration Asset ID
RMM Asset Link
RMM Integration Asset Link
RMM Status
RMM Integration Status, please note that this field is managed via the RMM notifications.
RMM Current Status Date
Provide date in 'dd-mmm-yyyy' format, please note that this field is managed via the RMM notifications.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Category IDRequired
The ID of the category you want to update.
Name
Category name. The maximum length is 100 characters.
Profit Margin
Parent Category ID
Valid {categoryId}. Get valid list of categories via /categories endpoint
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Lead UUIDRequired
Subject
Referred By
Customer's Name
Customer's Mobile
A valid phone/mobile number with country phonecode. e.g +44
Country Code
Customer country code in ISO 2 format. e.g. GB for the United Kingdom. If not provided along with the {mobile} field, the shop's country code will be used as default. see ISO 3166-1
Customer's Email
Company/Business Name
Telephone
A valid phone number with country phonecode. e.g +44
Address
Leads Detail
Issue Type
Technician User ID
Get via /staffs endpoint
GDPR Compliant
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Product UUIDRequired
Type
Name
Description
Condition
Code
IMEI
Category
Valid {categoryId}.Get valid list of categories via /categories endpoint
Brand
Valid {brandId}. Get valid list of brands via /brands endpoint
Model
Valid {modelId}. Get valid list of models via /models endpoint
Additional Models
Valid Comma Separated models {modelIds}. Get valid list of models via /models endpoint
Status
One Time Use
Inventory Control
Tax Included In Cost
Valid options are: True/False, Yes/No, 1/0
Cost
Tax Included In Price
Valid options are: True/False, Yes/No, 1/0
Price
Enable Offer Price
Offer Start
Offer End
offer Price
Tax
Valid {taxId}. Get valid list of taxes via shop/taxRateCollection endpoint.
Alert Quantity
Discountable
Supplier
Valid {supplierId}. Get valid list of suppliers via supplier/supplierCollection endpoint.
Rreorder Quantity
Supplier Item Code
Email To Supplier
Physical Location
Warranty
Valid {warrantyId}. Get valid list of warranties via /warranties endpoint.
Serialised Stock
Maintenance Plan
Plan Duration
Valid options are: 3,6,9,12,15,18,21,24,27,30,33,36
Service Schedule
Valid options are: 1,2,3,4,5,6,7,8,9,10,11,12
Stock Quantity
Product stock quantity if you want to add stock (Must be greater than 0)
Stock COG Per Item
Product stock cog per item
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Adjustment UUIDRequired
Adjustment Date
Provide adjustment date in 'dd-mmm-yyyy hh:mm' format
Reference No
Adjustment Reference Number. Maximum length is 50 characters.
Notes
Notes related to Stock Adjustment
Product UUID
Quantity
Type
Internal Use
Breakage
Stock UUID
Quantity
Type
Internal Use
Breakage
Stock UUID
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.TicketRequired
The ticket reference to to search for. Reference to {id} {ticket_ref} or {ticket_no} in /tickets endpoint.
Customer ID
Short Info
Status
Issue Type
Priority
Device Model ID
Due Date
Technician User Id
Create Invoice
If true, the invoice will be created if it does not exist already or will be updated if it exists.
Invoice Date
Provide the date in the following formats DD-MMM-YYYY HH:mm:ss (22-Jan-2006 23:04:05) YYYY-MM-DD HH:mm:ss (2006-01-22 23:04:05) MMMM DD YYYY HH:mm:ss (January 22 2006 23:04:05)
Invoice Due Date
Provide the date in the following formats DD-MMM-YYYY HH:mm:ss (22-Jan-2006 23:04:05) YYYY-MM-DD HH:mm:ss (2006-01-22 23:04:05) MMMM DD YYYY HH:mm:ss (January 22 2006 23:04:05)
Print Invoice
If true, the invoice will be sent for printing over configured cloud printer(s).
Print Receipt
If true, the ticket/customer receipt will be sent for printing over configured cloud printer(s).
Print Label
If true, the ticket label will be sent for printing over configured cloud printer(s).
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Time Clock IDRequired
User UUID
Shift Start Time
Shift Start Notes
Shift End Time
Shift End Notes
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Keyword
Searches in the Name, Identifier, Tag, Location and Notes
Created Date From
Format needs to be as dd-mmm-yyyy
Created Date To
Format needs to be as dd-mmm-yyyy
Asset Name
Asset Identifier
Asset Tag
Asset Location
Notes
Asset Type
RMM Asset ID
RMM Integration Asset ID
RMM Asset Link
RMM Status
includeCustomFields
ActionThis is an event a Zap performs.SearchFind existing data in your appKeywordRequired
Search in Category,Created Date
Created Date From
Format - dd-mmm-yyyy
Created Date To
Format - dd-mmm-yyyy
Page
Sort
ActionThis is an event a Zap performs.SearchFind existing data in your appsearchKeyword
Search in Name,Billing Name,Billing Mobile,Billing Email,Date_Created
Created Date From
Date format: dd-mmm-yyyy
Created Date To
Date format: dd-mmm-yyyy
Name
Customer's Group Name
Billing Name
Billing Mobile
Billing Email
Page
Sort
ActionThis is an event a Zap performs.SearchFind existing data in your appDate From
Date in format 'dd-mmm-yyyy'
Date To
Date in format 'dd-mmm-yyyy'
ActionThis is an event a Zap performs.SearchFind existing data in your appKeyword
Created Date From
Created Date To
Page
Sort
ActionThis is an event a Zap performs.SearchFind existing data in your appYear
Year in format 'yyyy'
ActionThis is an event a Zap performs.SearchFind existing data in your appKeyword
Created Date From
Created Date To
Updated Date From
Updated Date To
Brand
Type
Condition
Category
code
Model
Status
page
sort
include Custom Fields
include Xsell Upsell
ActionThis is an event a Zap performs.SearchFind existing data in your appKeyword
Search in Reference Number,Note,Created Date,Adjusment Date
Created Date From
Created Date To
Adjustment Date From
Adjustment Date To
Internal Use
Internal Use: Valid options are: True/False, Yes/No, 1/0
Breakage
Breakage: Valid options are: True/False, Yes/No, 1/0
Page
Sort
ActionThis is an event a Zap performs.SearchFind existing data in your appKeyword
Ticket
The ticket reference to to search for. Reference to {id} {ticket_ref} or {ticket_no} in /tickets endpoint.
Created Date From
format - dd-mmm-yyyy
Created Date To
format - dd-mmm-yyyy
Updated Date From
format - dd-mmm-yyyy
Updated Date To
format - dd-mmm-yyyy
Customer Name
Company
Issue - Short Info
Issue Type ID
Status ID
Priority
Page
Sort
Include Item Lines
Ticket item lines will be included if set to true. (default: false)
Include Payments
Payments object will be included if a ticket has an invoice paid fully or partially. (default: false)
include Custom Fields
Custom fields object will be included if the ticket has data for at least one custom field. (default: false)
Issue Type Condition
Valid options EQUAL, NOT-EQUAL. Default is EQUAL
Status Condition
Valid options EQUAL, NOT-EQUAL. Default is EQUAL
Priority Condition
Valid options EQUAL, NOT-EQUAL. Default is EQUAL
ActionThis is an event a Zap performs.SearchFind existing data in your appKeyword
Search in the preset name
Created Date From
Created Date To
Category ID / Name
Valid {presetCategoryId} or {presetCategoryName}. In case of {presetCategoryName}, value must be an exact match. Get valid list of preset categories via /presetCategories endpoint
Brand ID / Name
Valid {brandId} or {brandName}. In case of {brandName}, value must be an exact match. Get valid list of issue types via /brands endpoint
Model ID / Name
Valid {modelId} or {modelName}. In case of {modelName}, value must be an exact match. Get valid list of issue types via /models endpoint
Issue Type ID / Label
Valid {issueTypeId} or {issueTypeLabel}. In case of {issueTypeLabel}, value must be an exact match. Get valid list of issue types via /issueTypes endpoint
Legal document ID
Legal Document Id here
Page
Sort
ActionThis is an event a Zap performs.SearchFind existing data in your appKeyword
Search in Notes In, Notes Out, Created Date
Created Date From
format - dd-mmm-yyyy
Created Date To
format - dd-mmm-yyyy
User UUID
Get via /staffs endpoint
Page
Sort
ActionThis is an event a Zap performs.SearchFind existing data in your appKeywordRequired
Search in Brand,Created Date
Created Date From
format - dd-mmm-yyyy
Created Date To
format - dd-mmm-yyyy
Page
Sort
NameRequired
Brand name. Maximum length is 100 characters.
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundKeyword
Created Date From
Created Date To
NameRequired
MobileRequired
Phone
Company
Email Address
Invoice Email
Address
City
Customer Group ID
Gender
Type
Page
Sort
include Custom Fields
Account Manager
Telephone
Referred By
GDPR Compliant
VAT Registration
Longitude
Latitude
Comments
Country Code ISO Format
Payment Term Days
Due Each Month
Payment Term (due on a fixed date each month) - A positive integer between 1 - 28. The value provided for {paymentTermDays} will be ignored.
Due Next Month
Payment Term (due on a fixed date of next month) - A positive integer between 1 - 28. The value provided for {paymentTermDays} and {dueEachMonth} will be ignored.
Opt-in for Print Media
Opt-in for Email Marketing
Opt-in for Email Notifications
Opt-in for SMS Messages
Intra-Community Supplies (ICS)
Valid options are: True/False, Yes/No, 1/0
VAT Exemption
Valid options are: True/False, Yes/No, 1/0
VAT/TAX Rate
Valid {taxId}. Get valid list of taxes via shop/taxRateCollection endpoint
Credit Limit
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundKeyword
Ticket
The ticket reference to to search for. Reference to {id} {ticket_ref} or {ticket_no} in /tickets endpoint.
Created Date From
format - dd-mmm-yyyy
Created Date To
format - dd-mmm-yyyy
Updated Date From
format - dd-mmm-yyyy
Updated Date To
format - dd-mmm-yyyy
Customer Name
Company
Issue - Short Info
Issue Type ID
Status ID
Valid {statusId} or {statusLabel} of a type 'repair'. In case of {statusLabel}, value must be an exact match, otherwise the resource will return error. Get valid list of statuses via /statuses endpoint
Priority
Page
Sort
Include Item Lines
Ticket item lines will be included if set to true. (default: false)
Include Payments
Payments object will be included if a ticket has an invoice paid fully or partially. (default: false)
include Custom Fields
Custom fields object will be included if the ticket has data for at least one custom field. (default: false)
Issue Type Condition
Valid options EQUAL, NOT-EQUAL. Default is EQUAL
Status Condition
Valid options EQUAL, NOT-EQUAL. Default is EQUAL
Priority Condition
Valid options EQUAL, NOT-EQUAL. Default is EQUAL
Customer UUID or Customer NameRequired
A valid customer UUID, or a valid customer name.
Short InfoRequired
Issue Description
Issue Type
Valid {issueTypeId} or {issueTypeLabel}. In case of {issueTypeLabel}, value must be an exact match, otherwise the resource will return error. Get valid list of issue types via /issuetypes endpoint
Device Model ID
Get via /models endpoint
Created Date
Provide the date in the following formats DD-MMM-YYYY (22-Jan-2006) YYYY-MM-DD (2006-01-22) MMMM DD YYYY (January 22 2006)
Due Date
Provide the date in the following formats DD-MMM-YYYY (22-Jan-2006) YYYY-MM-DD (2006-01-22) MMMM DD YYYY (January 22 2006)
Technician User ID
Get via /staffs endpoint
Work Approved?
Pre Diagnosed
Preset Id
Get via /presets endpoint. This parameter is ignored if {lines} parameter is specified.
Product Code
Description
Quantity
Price
Create Invoice
Sending True will create an invoice.
Invoice Date
Provide the date in the following formats DD-MMM-YYYY HH:mm:ss (22-Jan-2006 23:04:05) YYYY-MM-DD HH:mm:ss (2006-01-22 23:04:05) MMMM DD YYYY HH:mm:ss (January 22 2006 23:04:05)
Invoice Due Date
Provide the date in the following formats DD-MMM-YYYY HH:mm:ss (22-Jan-2006 23:04:05) YYYY-MM-DD HH:mm:ss (2006-01-22 23:04:05) MMMM DD YYYY HH:mm:ss (January 22 2006 23:04:05)
Print Invoice
If true, the invoice will be sent for printing over configured cloud printer(s).
Print Receipt
If true, the ticket/customer receipt will be sent for printing over configured cloud printer(s).
Print Label
If true, the ticket label will be sent for printing over configured cloud printer(s).
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is found
Trigger on weekends?
Should this Zap trigger on Saturday and Sunday?
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Day of the WeekRequired
Time of DayRequired
Triggers relative to your timezone settings and defaults to UTC (GMT+00:00) if no preference is set. Note: You can also specify a time with a Custom Value in the formats "hh:mm aa", "hh:mm", or "hhhh" (e.g. "2:30pm", "14:30", or "1430").
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Storage Source
NOTE that this defaults to OneDrive. If Sharepoint is picked, subsequent folders that would be listed are ONLY folders in the default Sharepoint site. Other custom Sharepoint sites are currently not supported.
FolderRequired
SpreadsheetRequired
WorksheetRequired
TableRequired
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planStorage Source
NOTE that this defaults to OneDrive. If Sharepoint is picked, subsequent folders that would be listed are ONLY folders in the default Sharepoint site. Other custom Sharepoint sites are currently not supported.
FolderRequired
SpreadsheetRequired
WorksheetRequired
Trigger Column
Trigger on changes to cells in this column only.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planStorage Source
NOTE that this defaults to OneDrive. If Sharepoint is picked, subsequent folders that would be listed are ONLY folders in the default Sharepoint site. Other custom Sharepoint sites are currently not supported.
FolderRequired
SpreadsheetRequired
WorksheetRequired
TableRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Storage Source
NOTE that this defaults to OneDrive. If Sharepoint is picked, subsequent folders that would be listed are ONLY folders in the default Sharepoint site. Other custom Sharepoint sites are currently not supported.
FolderRequired
SpreadsheetRequired
WorksheetRequired
RowRequired
We will only update columns you provide, leaving all others untouched.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Storage Source
NOTE that this defaults to OneDrive. If Sharepoint is picked, subsequent folders that would be listed are ONLY folders in the default Sharepoint site. Other custom Sharepoint sites are currently not supported.
FolderRequired
SpreadsheetRequired
WorksheetRequired
Lookup ColumnRequired
Let us know which column you want to search by with the value below. We will grab the first matching row and give you all of its values.
Lookup ValueRequired
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundKeyword
Filter by Keyword (Searches in Name, Company, Mobile, Telephone, Address, City, Date Created)
include Custom Fields
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planKeyword
Search in Detail, Company, Mobile, Telephone, Address
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planKeyword
include Custom Fields
include Xsell Upsell
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planKeyword
Search in Serial,Created Date
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planKeyword
Include Item Lines
Include Payments
include Custom Fields
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planKeyword
include Custom Fields
When true, custom fields object will be included if the product has data for at least one custom field.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planDate From
Date in format 'dd-mmm-yyyy'
Date To
Date in format 'dd-mmm-yyyy'
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planKeyword
Include Item Lines
Include Payments
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planCustomer UUID or Customer NameRequired
A valid customer UUID, or a valid customer name.
Asset NameRequired
Asset Name. Maximum length is 50 characters.
Asset IdentifierRequired
Asset identifier. Maximum length is 100 characters.
Asset Tag
Asset tag. Maximum length is 50 characters.
Model ID
Get via /models endpoint
Asset Type
Valid {assetTypeId} or {assetTypeName}. In the case of {assetTypeName}, the value must be an exact match, otherwise, the resource will return an error. Get the valid list of asset types via /assetTypes endpoint.
Asset Location
Asset location. Maximum length is 50 characters.
StatusRequired
Active, Inactive are the valid options
Notes
Asset Notes will contain any additional information related to the asset
RMM Asset ID
RMM Integration Asset ID
RMM Asset Link
RMM Integration Asset Link
RMM Status
RMM Integration Status, please note that this field is managed via the RMM notifications.
RMM Current Status Date
Provide date in 'dd-mmm-yyyy' format, please note that this field is managed via the RMM notifications.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.NameRequired
Category name. The maximum length is 100 characters.
Profit Margin
Parent Category ID
Valid {categoryId}. Get valid list of categories via /categories endpoint
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Inbound NumberRequired
Inbound number of the customer in the International phone number format.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Brand IDRequired
Valid {brandId}. Get the valid list of brands via /brands endpoint
NameRequired
Model name. The maximum length is 100 characters.
Model Group ID
Valid {groupId}. Get valid list of model groups via /modelGroups endpoint
StatusRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Customer UUID or Customer NameRequired
A valid customer UUID, or a valid customer name.
User IDRequired
Get via /staffs endpoint
order Date
Provide the date in the following formats DD-MMM-YYYY HH:mm:ss (22-Jan-2006 23:04:05) YYYY-MM-DD HH:mm:ss (2006-01-22 23:04:05) MMMM DD YYYY HH:mm:ss (January 22 2006 23:04:05)
Tax
Zero or any positive number.
Discount
Zero or any positive number.
Discount Level
Valid options are: gross, grand.
Customer Group Discount
Override custom group discount if it's present. True: works just like default, if the customer group discount is applicable by ignoring the supplied {discount} and {discountLevel} values. False: will ignore customer group discount and instead use the supplied {discount} and {discountLevel} value.
Delivery Method Id
Delivery method id if a shipping cost is being applied.
Notes
Notes about the POS order
Print Receipt
Product CodeRequired
Description
QuantityRequired
Price
AmountRequired
Payment MethodRequired
Payment Note
Is Advance
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.RMM Asset IDRequired
This is the RMM Asset id stored in MGR in the RMM Integration Tab as "RMM Asset ID".
Alert DateRequired
Provide date in 'dd-mmm-yyyy' format
Alert TextRequired
Detail about the alert.
Alert SeverityRequired
Alert severity, please choose one.
Current Status
E.g Online, offline etc
Alert Link
RMM software links to the alert detail to display additional information.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Adjustment DateRequired
Provide adjustment date in 'dd-mmm-yyyy hh:mm' format
Reference No
Adjustment Reference Number. The maximum length is 50 characters.
Notes
Notes related to stock adjustment
Product UUIDRequired
QuantityRequired
Type
The default value is Subtraction
Internal Use
Breakage
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Ticket UUIDRequired
The ticket reference to which the timer is being posted. Reference to {id} {ticket_ref} or {ticket_no} in /tickets endpoint.
Start DateRequired
Provide date in 'dd-mmm-yyyy hh:mm:ss' format
End DateRequired
Provide date in 'dd-mmm-yyyy hh:mm:ss' format
User IDRequired
Get via /staffs endpoint
Notes
Any additional information goes in the notes.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Staff UUIDRequired
Get via /staffs endpoint
Shift Start TimeRequired
Provide date in 'dd-mmm-yyyy hh:mm:ss' format
Shift Start NotesRequired
Shift End Time
Provide date in 'dd-mmm-yyyy hh:mm:ss' format
Shift End Notes
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Brand IDRequired
Brand id which you want to delete
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Customer UUIDRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Model IDRequired
The model id you like to delete.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Stock UUIDRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.serial UUIDRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Timer IDRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Appointment UUIDRequired
Appointment Start Date and time
Appointment Duration
Subject
Description
Type
Valid Options are: InShop,OnSite,PhoneCall
Color
Appointment Color in hex value.
Location
Appointment location.
Latitude
Longitude
Ticket ID
Customer ID
Lead ID
Asset ID
Valid {assetId}. Get the valid list of assets via the customers/assets endpoint
Attendees
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Brand IDRequired
Brand ID you want to update
NameRequired
Brand name. The maximum length is 100 characters.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.