Joblogic + SQL Server
Joblogic + SQL Server
Joblogic + SQL Server integrations
Create new rows in SQL Server when new jobs are listed in Joblogic
Streamline your workflow with this seamless integration between Joblogic and SQL Server. When you add a new job list in Joblogic, a corresponding row will be created in SQL Server. Not only does this eliminate repetitive data entry, but it also ensures your records are always up-to-date and consistent across platforms. Improve your efficiency and accuracy with this simple yet effective automation.
- When this happens...
List Job (Beta)Triggers when a new job is created.TriggerPolling - automatically do this!
New RowTriggers when you add a new row.ActionWrite
- Free forever for core features
- 14 day trial for premium features & apps
More things you can do with Joblogic and SQL Server
Discover other triggers and actions you can use with Joblogic and SQL Server
- Customer IdRequired
- Site IdRequired
- Job IdRequired
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free plan- Customer Auto Id
- Site Auto Id
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free plan- Date RaisedRequired
- Raised By IdsRequired
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free plan
List Site (Beta)Triggers when there's a new site.
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free plan- Quote Unique IdRequired
- Approved By User Id
- Order Number
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Job Unique IdRequired
- Site Contact Level Ids
- Customer Contact Level Ids
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Purchase Order Line Unique IDRequired
- Complete DateRequired
- Set Job Complete?
- Add Job Line
- Completed By User ID
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Site Unique IdRequired
- First Warning Message
- First Warning Show
- Second Warning Message
- Second Warning Show
- Third Warning Message
- Third Warning Show
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- External IdRequired
- Site Unique IdRequired
- Equipment Class
- DescriptionRequired
- Number
- Notes
- Make
- Model
- Location
- Serial Number
- Installation Date
- Labour Warranty Expiry Date
- Asset Warranty Expiry Date
- Estimated Replacement Date
- QuantityRequired
- Reference Number
- Is Suspended
- Equipment Library
- QR Code
- Contain Refrigerant
- Total Charge
- Gas Type
- Budget Replacement Cost
- Asset Condition Unique Id
- System Id
- Tags
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- ConditionRequired
- Order
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Invoice Auto IdRequired
- Raised By User IdRequired
- Credit Reason
- Line DescriptionRequired
- Line PricePerUnitRequired
- Line QuantityRequired
- Line Tax Code Unique IdRequired
- Line Nominal Code Unique Id
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- DescriptionRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Invoice Auto IdRequired
- DescriptionRequired
- Price Per Unit
- Quantity
- Tax Code IdRequired
- Nominal Code Unique Id
- Discount Amount
- Discount Percentage
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- External IdRequired
- Customer Unique IdRequired
- Site Unique IdRequired
- DescriptionRequired
- StatusRequired
- Job TypeRequired
- Job Category
- Priority Level
- Order Number
- Reference Number
- Date LoggedRequired
- Preferred Appointment Date
- Target Completion Date
- Date Complete
- Tags
- Contact First Name
- Contact Last Name
- Contact Telephone
- Contact Email
- Contact Position
- Trade
- Owner User Id
- Next Contact Date
- Is Require Approval
- Quoted Value
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- CodeRequired
- Description
- Nominal Code Type
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- External IdRequired
- NumberRequired
- DescriptionRequired
- QuantityRequired
- Unit Of Measure
- Price Per UnitRequired
- Sell Per Unit
- Make
- Model
- Part Reference
- Part Library IdRequired
- Part Category Unique Id
- Tax Code Unique Id
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Supplier Unique IdRequired
- Job Unique IdRequired
- Account NumberRequired
- Estimated Delivery Date
- Delivery Address TypeRequired
- Delivery Name
- Delivery Address 1
- Delivery Address 2
- Delivery Address 3
- Delivery Address 4
- Delivery Postcode
- Delivery Telephone
- Reference Number
- Tags
- Line DescriptionRequired
- Line QuantityRequired
- Line Price Per UnitRequired
- Line TaxRateRequired
- Line Part Unique Id
- Line Number
- Line DiscountRequired
- Line Nominal Code
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Customer IdRequired
- Site IdRequired
- Contact
- Telephone
- Email Address
- Parent Job Id
- Job TypeRequired
- Job Category
- Assigned To User IdRequired
- Title
- DescriptionRequired
- Reference
- Priority Level
- Source Unique Id
- Trade Unique Id
- Chance Of Sale
- Expiry Date
- Sale Date
- Tags
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- DescriptionRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Job Unique IdRequired
- Sub Contractor Unique IdRequired
- Account NumberRequired
- Estimated Completion Date
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Invoice Unique IdRequired
- Price Per UnitRequired
- DescriptionRequired
- Tax Code Unique IdRequired
- Nominal Code Unique Id
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- External IdRequired
- NameRequired
- Address 1
- Address 2
- Address 3
- Address 4
- Postcode
- Account Number
- Reference Number
- Part Library ID
- Contact First Name
- Contact Last Name
- Contact Primary Telephone
- Contact Secondary Telephone
- Contact Email
- Contact Position
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- CodeRequired
- Value
- DescriptionRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Area unique IdRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Asset Class Unique IdRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Contact Unique IdRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Customer Unique IdRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Invoice Auto IdRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Job Unique idRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Nominal Code Unique IdRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Part Category Unique idRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Line Unique IdRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Site Unique IdRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Unique IdRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Invoice Unique IdRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Line Item Unique IdRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Invoice Unique IdRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Report Auto IdRequired
- Mark As Passed To Accounts
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Asset Auto IdRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Asset Class Unique IdRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Contact Unique IdRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Credit Unique IdRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Customer Unique IdRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Invoice Unique IdRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Engineer Auto IdRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Invoice Auto IdRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Invoice Payment Unique IdRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Job Unique IdRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Job Type Unique IdRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Part Auto IdRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Part Category Unique IdRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Unique Id of PriorityRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Quote Auto IdRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Site Unique IdRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Site Unique IdRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Subcontractor Unique IdRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Line Item Unique IdRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Purchase Order IdRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Unique Id of TaskRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Job Auto IdRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Quote Uniqiue IdRequired
- ReasonRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Keyword
- Include Inactive
- Include Contact Level
- Page Number
- OrderBy
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Keyword
- Include Inactive
- Page Number
- OrderBy
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- KeywordRequired
- Include Inactive
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Search Job Type
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Search Priority
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Search Reports
- Only Include Favourite
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Search Site Type
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Search Subcontractor Purchase Order
- PO Status
- Completion Status
- Date Raised StartRequired
- Date Raised End
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Search Tax Code
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Invoice Auto IdRequired
- Date RaisedRequired
- Date DueRequired
- Order Number
- Account Number
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Job Category Unique IdRequired
- DescriptionRequired
- Background Color
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Purchase Order Unique idRequired
- Account NumberRequired
- Estimated Delivery Date
- Reference Number
- Additional Instructions
- Tags
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Subcontractor Purchase Order Unique IdRequired
- Subcontractor Unique IdRequired
- Account NumberRequired
- Estimated Completion Date
- Additional Instructions
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- External IDRequired
- Supplier Unique IdRequired
- Supplier NameRequired
- Address1
- Address2
- Address3
- Address4
- Postcode
- Account Number
- Reference Number
- Part Library Id
- Contact First Name
- Contact Last Name
- Contact Primary Telephone
- Contact Secondary Telephone
- Contact Email
- Contact Position
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Asset Unique IdRequired
- Equipment Class
- DescriptionRequired
- Number
- Notes
- Make
- Model
- Location
- Serial Number
- Installation Date
- Labour Warranty Expiry Date
- Asset Warranty Expiry Date
- QuantityRequired
- Reference Number
- Is Suspended
- Tags
- Equipment Library
- QR Code
- Estimated Replacement Date
- Contain Refrigerant
- Total Charge
- Gas Type
- Budget Replacement Cost
- Asset Condition Unique Id
- System Id
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Asset Condition Unique IdRequired
- Condition
- Order
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Engineer Auto IdRequired
- Gas Registration Number
- Electrical Registration Number
- Oil Registration Number
- Fgas Registration Number
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Contact Unique IdRequired
- First Name
- Last Name
- Telephone
- Email
- Position
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Customer Unique IdRequired
- Customer Name
- Address1
- Address2
- Address3
- Address4
- Postcode
- Telephone
- Customer Type
- Reference Number
- Tags
- Account Number
- VAT Number
- Account Manager
- Enable Billing Address
- Billing Name
- Billing Address1
- Billing Address2
- Billing Address3
- Billing Address4
- Billing Postcode
- Billing Telephone
- Billing Email Address
- Billing Account Number
- Invoice Payment Due
- Invoice Payment Term
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Invoice Auto IdRequired
- Date Raised
- Date Due
- Order Number
- Account Number
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Payment Unique IdRequired
- Payment Date
- Payment Amount
- Payment Type
- Nominal Code UniqueId
- Payment Notes
- Payment Type Other Description
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Job Category Unique IdRequired
- Description
- Background Color
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Unique IdRequired
- Code
- Description
- Nominal Code Type
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Part Category Unique IdRequired
- DescriptionRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Purchase Order Unique idRequired
- Account Number
- Estimated Delivery Date
- Reference Number
- Additional Instructions
- Tags
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Quote IdRequired
- Date LoggedRequired
- Job TypeRequired
- Job Category
- Assigned To User IdRequired
- Title
- DescriptionRequired
- Reference
- Priority Level
- Source Unique Id
- Trade Unique Id
- Chance Of Sale
- Expiry Date
- Sale Date
- Tags
- Next Contact Date
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Site Unique IdRequired
- Site NameRequired
- Address1
- Address2
- Address3
- Address4
- Postcode
- Telephone
- Region
- Reference Number
- Tags
- Enable Billing Address
- Billing Name
- Billing Address1
- Billing Address2
- Billing Address3
- Billing Address4
- Billing Postcode
- Billing Telephone
- Billing Email Address
- Billing Account Number
- Account Number
- Account Manager
- Order Number
- Site Type Unique Id
- Preferred Engineer Id
- Selling Rate Id
- Parent Site Unique Id
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Unique IdRequired
- DescriptionRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Subcontractor Purchase Order Unique IdRequired
- Subcontractor Unique Id
- Account Number
- Estimated Completion Date
- Additional Instructions
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Invoice Line Unique IdRequired
- Price Per Unit
- Description
- Tax Code Unique Id
- Nominal Code Unique Id
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- External Id
- Supplier Unique IdRequired
- Supplier Name
- Address 1
- Address 2
- Address 3
- Address 4
- Postcode
- Account Number
- Reference Number
- Part Library ID
- Contact First Name
- Contact Last Name
- Contact Primary Telephone
- Contact Secondary Telephone
- Contact Email
- Contact Position
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Unique IdRequired
- Code
- Value
- Description
- IsDefault
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Table/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 TableTriggers when you add a new table.
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free plan- TableRequired
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 app- QueryRequired
ActionThis is an event a Zap performs.SearchFind existing data in your app
- List Contacts (Beta)
Triggers when there's a new contact.
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free plan - List Invoice (Beta)
Triggers when a new invoice ticket is created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly. - List Part (Beta)
Triggers when a new part is created.
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free plan - Customer Auto Id
- Site Auto Id
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free plan- List Supplier (Beta)
Triggers when a new supplier is created.
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free plan - List Customers (Beta)
Triggers when a new customer is created.
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free plan - Quote Unique IdRequired
- Site Contact Level Ids
- Customer Contact Level Ids
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Quote Uniqiue IdRequired
- Reason
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Line Unique IdRequired
- Delivery DateRequired
- Set Job as Part To Fit
- Pass Dicount
- Delivered By UserId
- Quantity
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- DescriptionRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- DescriptionRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Entity Unique IdRequired
- Entity TypeRequired
- Is Primary
- First NameRequired
- Last Name
- Telephone
- Email
- Position
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- External IdRequired
- Customer NameRequired
- Address 1
- Address 2
- Address 3
- Address 4
- Postcode
- Telephone
- Customer Type
- Reference Number
- Contact First Name
- Contact Last Name
- Contact Telephone
- Contact Email
- Contact Position
- Tags
- Account Number
- VAT Number
- Account Manager
- Enable Billing Address
- Billing Name
- Billing Address1
- Billing Address2
- Billing Address3
- Billing Address4
- Billing Postcode
- Billing Telephone
- Billing Email Address
- Billing Account Number
- Invoice Payment Due
- Invoice Payment Term
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Job IdRequired
- Tag
- Raised By User Id
- DescriptionRequired
- Price Per Unit
- Quantity
- Tax Code IdRequired
- Nominal Code Id
- Discount Amount
- Discount Percentage
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Invoice Unique IdRequired
- Payment DateRequired
- Payment AmountRequired
- Payment TypeRequired
- Nominal Code UniqueId
- Payment Notes
- Payment Type Other Description
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- DescriptionRequired
- Background ColorRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- EntityIdRequired
- Entity TypeRequired
- Note TextRequired
- Date Added
- IsPrivate
- Attachment Link
- Attachments Name
- Tags
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- DescriptionRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Purchase Order IdRequired
- DescriptionRequired
- QuantityRequired
- Price Per UnitRequired
- Tax Rate
- Part Unique Id
- Number
- Discount
- Nominal Code
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- External IdRequired
- Customer Unique IdRequired
- Site NameRequired
- Address 1
- Address 2
- Address 3
- Address 4
- Postcode
- Telephone
- Region
- Reference Number
- Contact First Name
- Contact Last Name
- Contact Telephone
- Contact Email
- Contact Position
- Tags
- Enable Billing Address
- Billing Name
- Billing Address1
- Billing Address2
- Billing Address3
- Billing Address4
- Billing Postcode
- Billing Telephone
- Billing Email Address
- Billing Account Number
- Account Number
- Account Manager
- Order Number
- Site Type Unique Id
- Preferred Engineer Id
- Selling Rate Id
- Parent Site Unique Id
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- NameRequired
- Email AddressRequired
- Address1
- Address2
- Address3
- Address4
- Postcode
- Telephone
- Account Number
- Tax Code Unique Id
- IsSendPO
- Subcontractor Template Unique Id
- Trade Unique Ids
- Area Unique Ids
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Purchase Order Unique IdRequired
- Attachment
- File Name
- Invoice NumberRequired
- Invoice DateRequired
- Reference Number
- Invoice Type
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Purchase Order Unique IdRequired
- Price Per UnitRequired
- Line Item DescriptionRequired
- Tax Code Unique IdRequired
- Nominal Code Unique Id
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Purchase Order IdRequired
- Base64 File
- File Name
- Invoice NumberRequired
- Invoice DateRequired
- Tax Rate
- Amount
- Discount
- Type
- Nominal Code
- Reference Number
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- External IdRequired
- Site Unique Id
- Equipment Class
- Description
- Number
- Notes
- Make
- Model
- Location
- Serial Number
- Installation Date
- Labour Warranty Expiry Date
- Asset Warranty Expiry Date
- Estimated Replacement Date
- Quantity
- Reference Number
- Is Suspended
- Equipment Library
- QR Code
- Contain Refrigerant
- Total Charge
- Gas Type
- Budget Replacement Cost
- Asset Condition
- System Id
- Tags
- Action TypeRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Asset Unique IdRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Asset Condition Unique IdRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Contact level unique IdRequired
- Entity IdRequired
- Entity TypeRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Customer Type Unique IdRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Invoice Line IdRequired
- Invoice idRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Job Category Unique IdRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Part Unique idRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Purchase Order Unique idRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Quote IdRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Site Type Unique IdRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Subcontractor PO Unique IdRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Invoice Line Unique IdRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Supplier Unique idRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Tax Code Unique IdRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Area Unique IdRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Asset Unique IdRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Asset Condition Unique IdRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Entity Unique IdRequired
- Entity TypeRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Customer Auto IdRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Credit Unique IdRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Customer Type Unique IdRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Export IdRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Purchase Order Unique IdRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Job Auto IdRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Job Category Unique IdRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Nominal Code Unique IdRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Part Unique IdRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Invoice Unique IdRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Purchase Order Unique IdRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Site Auto IdRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Site Type Unique IdRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Staff Unique IdRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Purchase Order Unique IdRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Supplier Unique IdRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Line Unique IdRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Tax Code Unique IdRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Visit Auto IdRequired
- Include Notes
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Quote Unique IdRequired
- Reverted By User Id
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Search Credit
- Start Date
- End Date
- Customer Auto Id
- Site Auto Id
- Job Auto Id
- PPM Contract Unique Id
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Search Customer Type
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Keyword
- Tag Unique Ids
- Start Date
- End Date
- Customer Auto Id
- Site Auto Id
- Job Auto Id
- PPM Contract Id
- Exclude Invoice Id
- Payment Statuses
- Get Summary
- Include Standard Invoices
- Include PPM Invoices
- Include Customer Grouped Invoices
- Include SOR Invoices
- Include Related Job Invoices
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Search Nominal Code
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Search Purchase Orders
- PO Type
- Date Raised Start DateRequired
- Date Raised End Date
- PO Status
- Delivery Status
- Invoice Status
- Tag Unique Id
- Owner Unique Id
- Raised By Id
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- KeywordRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Search Subcontractor
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Search TaskRequired
- Include Inactive
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Asset Condition Unique IdRequired
- ConditionRequired
- Order
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Payment Unique IdRequired
- Payment DateRequired
- Payment AmountRequired
- Payment TypeRequired
- Nominal Code UniqueId
- Payment Notes
- Payment Type Other Description
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Line Unique IdRequired
- DescriptionRequired
- QuantityRequired
- Price Per UnitRequired
- Tax Rate
- Part Unique Id
- Number
- Discount
- Nominal Code
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Unique IdRequired
- NameRequired
- EmailAddressRequired
- Address1
- Address2
- Address3
- Address4
- Postcode
- Telephone
- Account Number
- IsActive
- TaxCodeId
- IsSendPO
- Subcontractor TemplateId
- TradeI ds
- Area Ids
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Line Unique IdRequired
- Line Item DescriptionRequired
- Tax Code Unique IdRequired
- Nominal Code Unique Id
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Area Unique IdRequired
- DescriptionRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Asset Class Unique IdRequired
- DescriptionRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Asset Unique IdRequired
- Equipment Class
- Description
- Number
- Notes
- Make
- Model
- Location
- Serial Number
- Installation Date
- Labour Warranty Expiry Date
- Quantity
- Reference Number
- Is Suspended
- Tags
- Equipment Library
- QR Code
- Estimated Replacement Date
- Budget Replacement Cost
- Asset Condition Unique Id
- System Id
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Contact Unique IdRequired
- First NameRequired
- Last Name
- Telephone
- Email
- Position
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Customer Unique IdRequired
- Customer NameRequired
- Address1
- Address2
- Address3
- Address4
- Postcode
- Telephone
- Customer Type
- Reference Number
- Tags
- Account Number
- VAT Number
- Account Manager
- Enable Billing Address
- Billing Name
- Billing Address1
- Billing Address2
- Billing Address3
- Billing Address4
- Billing Postcode
- Billing Telephone
- Billing Email Address
- Billing Account Number
- Invoice Payment Due
- Invoice Payment Term
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Unique IdRequired
- DescriptionRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Invoice Line Auto IdRequired
- Invoice Auto IdRequired
- DescriptionRequired
- Price Per Unit
- Quantity
- Tax Code IdRequired
- Nominal Code Id
- Discount Amount
- Discount Percentage
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Job Unique IdRequired
- DescriptionRequired
- StatusRequired
- Job TypeRequired
- Job Category
- Priority Level
- Order Number
- Reference Number
- Date LoggedRequired
- Preferred Appointment Date
- Target Completion Date
- Date Complete
- Next Contact Date
- Tags
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Job Unique idRequired
- Description
- Status
- Job Type
- Job Category
- Priority Level
- Order Number
- Reference Number
- Date Logged
- Preferred Appointment Date
- Target Completion Date
- Date Complete
- Tags
- Next Contact Date
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Part Unique IdRequired
- NumberRequired
- DescriptionRequired
- QuantityRequired
- Unit Of Measure
- Price Per UnitRequired
- Sell Per Unit
- Make
- Model
- Part Reference
- Part Library Id
- Part Category Unique Id
- Tax Code Unique Id
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Part Unique IdRequired
- Part Number
- Part Description
- Quantity
- Unit Of Measure
- Price Per Unit
- Sell Per Unit
- Make
- Model
- Part Reference
- Part Library Auto Id
- Part Category Unique Id
- Tax Code Unique Id
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Line Unique IdRequired
- Description
- Quantity
- Price Per Unit
- Tax Rate
- Part Unique Id
- Number
- Discount
- Nominal Code
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Quote idRequired
- Date Logged
- Job TypeRequired
- Assigned To User IdRequired
- Job CategoryRequired
- Title
- Description
- Custom Reference
- Source IdRequired
- Priority LevelRequired
- Trade IdRequired
- Expiry Date
- Sale DateRequired
- Next Contact Date
- Chance Of SaleRequired
- Tags
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Site Unique IdRequired
- Site Name
- Address1
- Address2
- Address3
- Address4
- Postcode
- Telephone
- Region
- Reference Number
- Tags
- Enable Billing Address
- Billing Name
- Billing Address1
- Billing Address2
- Billing Address3
- Billing Address4
- Billing Postcode
- Billing Telephone
- Billing Email Address
- Billing Account Number
- Account Number
- Account Manager
- Order Number
- Site Type Unique Id
- Preferred Engineer Id
- Selling Rate Id
- Parent Site Unique Id
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Unique IdRequired
- Name
- Email Address
- Address1
- Address2
- Address3
- Address4
- Postcode
- Telephone
- Account Number
- Is Active
- Tax Code Unique Id
- IsSendPO
- Subcontractor Template Unique Id
- Trade Unique Ids
- Area Unique Ids
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Invoice Unique IdRequired
- Attachment
- File Name
- Invoice NumberRequired
- Invoice DateRequired
- Reference Number
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Line Unique IdRequired
- Line Item Description
- Tax Code Unique Id
- Nominal Code Unique Id
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Invoice IdRequired
- Base64 File
- File Name
- Invoice NumberRequired
- Invoice DateRequired
- Tax Rate
- Amount
- Discount
- Nominal Code
- Reference Number
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Table/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 plan- DisclaimerCopy
- 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
Related categories
SQL server (or MS SQL) is a top of the line database geared for the cloud
Similar apps
MySQL
Databases
PostgreSQL
Databases
Firebase / Firestore
Databases