How to connect Airtable + Webhooks by Zapier + Megaventory
Zapier lets you send info between Airtable and Webhooks by Zapier and Megaventory automatically—no code required. With 5,000+ supported apps, the possibilities are endless.
- Free forever for core features
- 14 day trial for premium features & apps
Do even more with Airtable + Webhooks by Zapier + Megaventory
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 Airtable, Webhooks by Zapier, and Megaventory. And don’t forget that you can add more apps and actions to create complex workflows.
BaseRequired
TableRequired
Limit to View
(Optional) Limit to records added to a specific View, and return records in the View order.
Include file contents?
Returns an extra File field with file contents. Set this field to Yes if you have trouble with Airtable file URLs expiring. File contents greater than 100MB will cause an error.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planBaseRequired
Base in which to create the record.
TableRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.BaseRequired
Pick the Airtable base containing the records you wish to update.
TableRequired
Pick the Airtable table containing the records you wish to update.
RecordRequired
Pick the Airtable record that you wish to update.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Api Docs Info
API docs for Airtable are located here https://airtable.com/api
HTTP MethodRequired
URLRequired
Requests can only be made to domains associated by this application.
Query String Parameters
These params will be URL-encoded and appended to the URL when making the request.
Headers
Authentication headers are included automatically
Additional Request Headers
Zapier will apply these optional headers and values to the request in addition to any headers created as part of the authentication mechanism.
Body
Zapier will pass this along raw. If you would like to provide complex JSON, try a "Code by Zapier" step to build the structure and pass it along here. For example,
{"foo": "bar"}
is perfectly valid.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.BaseRequired
Base to search for a record.
TableRequired
Pick an Airtable table that you want to search.
Search by Field
Pick a field from the base to match against the search value.
Search Value
The value of unique identifier for the record.
Search Formula
(ADVANCED) Alternatively, you can use an Airtable search formula to find records based on advanced conditions and any number of fields. Learn more.
Limit to View
You can optionally limit the search to a specific view id.
ActionThis is an event a Zap performs.SearchFind existing data in your appBaseRequired
Base in which to create the record.
TableRequired
Pick an Airtable table that you want to search.
Search by Field
Pick a field from the base to match against the search value.
Search Value
The value of unique identifier for the record.
Search Formula
(ADVANCED) Alternatively, you can use an Airtable search formula to find records based on advanced conditions and any number of fields. Learn more.
Limit to View
You can optionally limit the search to a specific view id.
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundCatch Raw Hook
Wait for a new POST, PUT, or GET to a Zapier URL. Gives the request body unparsed (max 2 MB) and also includes headers.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.MethodRequired
The HTTP method we'll use to perform the request.
URLRequired
Any URL with a querystring will be re-encoded properly.
Data Pass-Through?
If yes, request
data
below will be overridden with the raw data from the previous step (you are still responsible for headers though, likeContent-Type
). Defaults to no.Data
Place raw data for the request here. Could be JSON, XML, etc. Nothing is parsed for you here (including extra line breaks or spaces -- everything is sent verbatim). You probably need to define a header below corresponding to your data
Content-Type
. Reminder: data provided in this field is completely ignored if you chose "yes" to pass-through.Unflatten
By default we convert fields with double underscores into nested dictionaries. Select no here to turn this behavior off.
Basic Auth
A pipe (
|
) separated username, password combo for standard HTTP authentication.Headers
Key, value pairs to be added as headers in all requests.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.URLRequired
Any URL with a querystring will be re-encoded properly.
Payload Type
Pay special attention to the proper mapping of the data below.
Data
These are key-value pairs that will form the data portion of the request. If you leave these empty, all fields from the previous step will be used. If you want to send your own raw JSON or form-encoded values here, please use the Custom Request action instead.
Wrap Request In Array
Wraps the request in an array if that is something the service requires.
File
A file object to be attached to the request. The request will automatically be converted to
multipart/form-data
, with the above payload type defining the sub content-type for the data being passed.Unflatten
By default we convert fields with double underscores into nested dictionaries. Select no here to turn this behavior off.
Basic Auth
A pipe (
|
) separated username, password combo for standard HTTP authentication.Headers
Key, value pairs to be added as headers in all requests.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Delete Category
Triggers when a Category is deleted.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Delete Currency
Triggers when a Currency is Deleted.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Delete Document Type
Triggers when a Document Type gets deleted.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Delete Pricing Rule
Triggers when a Pricing Rule is deleted.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Delete Supplier
Triggers when a Supplier is deleted.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Document TypeRequired
Filter by Document Type
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Document TypeRequired
Filter by Document Type
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Document TypeRequired
Filter by Document Type
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Cancel Goods Transfer
Triggers when a Goods Transfer is cancelled
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Delete Goods Transfer
Triggers when a Goods Transfer is deleted
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Ship Goods Transfer Items
Triggers when Goods Transfer items are shipped
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Update Goods Transfer
Triggers when a Goods Tranfer is updated
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Category
Triggers when a new Category is created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Currency
Triggers when a new Currency is Created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Document TypeRequired
Filter by Document Type
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Goods Transfer
Triggers when a new Goods Transfer Document is created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Pricing Rule
Triggers when a new pricing rule is created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Supplier
Triggers when a new Supplier is created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Work Order
Triggers when a new Work Order is created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Sales Order
Triggers when new sales order is created in Pending state.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Approve Purchase Order
Triggers when a Purchase Order gets Approved
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Close Purchase Order
Triggers when a Purchase Order is closed
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Receive Purchase Order Items
Triggers when Purchase Order items are received
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Revert Purchase Order to Pending
Triggers when a Purchase Order is reverted to Pending
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Approve Sales Order
Triggers when a Sales Order gets Approved
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Close Sales Order
Triggers when a Sales Order is closed.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Ship Sales Order Items
Triggers when a Sales Order's items are shipped (either partially or fully)
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Revert Sales Order to Pending
Triggers when a Sales Order is reverted to Pending
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Approve Sales Quote
Triggers when a Sales Quote is approved
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Close Sales Quote
Triggers when a Sales Quote is closed
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Update Sales Quote
Triggers when a Sales Quote is updated
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Update Client
Triggers when a Client is updated.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Update Discount
Triggers when a Discount is Updated.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Update Inventory Location
Triggers when an Inventory Location is updated.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Update Product
Triggers when a Product is Updated.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Update Tax
Triggers when a Tax is updated.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Currency Description
Put the Description of your currency. i.e. "US Dollar".
Currency SymbolRequired
Put the Symbol of your Currency. i.e. "$".
Currency CodeRequired
Put the Code of your Currency. i.e. "USD".
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Document Type IDRequired
Document No
This is a required field only if you are using Manual Numbering in your Megaventory account
Document Reference No
Custom Document Date 1
Date should be either in ISO format (Example: 2020-04-22T09:07:12.000Z) -or- MM/dd/YYYY format
Custom Document Date 2
Date should be either in ISO format (Example: 2020-04-22T09:07:12.000Z) -or- MM/dd/YYYY format
Currency Code
Document Supplier/Client IDRequired
Document Billing Address
Document Address
Document Contact Person
Document Inventory Location ID
This is a required field only if you want to insert a new Document as Verified
Document StatusRequired
Custom Document Option 1
Custom Document Option 2
Custom Document Option 3
Custom Document Option 4
Custom Document Option 5
Custom Document Option 6
Custom Document Option 7
Custom Document Option 8
Custom Document Option 9
Custom Document Option 10
Shipping Provider ID
Document Tracking ID
Document Comments
Payment Terms
Document Tags
Parent Document ID
Document Total Quantity
Document Amount Subtotal Without Tax And Discount
Document Amount Shipping
Document Amount Total Discount
Document Amount Total Tax
Document Amount Grand Total
Auto Insert Bundled Products
Set to true if you wish to only enter Bundle SKUs in the document rows and have the app automatically append their included products when creating the document.
Document Row Product SKURequired
Document Row Product Description
Document Row Product QuantityRequired
Document Row Unit Price Without Tax Or Discount
Document Row Tax ID
Document Total Tax Amount
Document Row Discount ID
Document Row Total Discount Amount
Document Row Total Amount
Document Row Remarks
Document Row Serial Numbers
Billing Address - Organization
Billing Address - Tax ID Number
Billing Address - Line 1
Billing Address - Line 2
Billing Address - City
Billing Address - State
Billing Address - Country Code
Billing Address - Country Name
Billing Address - Zip / Postal Code
Shipping Address - Organization
Shipping Address - Tax ID Number
Shipping Address - Line 1
Shipping Address - Line 2
Shipping Address - City
Shipping Address - State
Shipping Address - Country Code
Shipping Address - Country Name
Shipping Address - Zip / Postal Code
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.AbbreviationRequired
Maximum 5 characters.
Full NameRequired
Address - Organization
Address - Line 1
Address - Line 2
Address - City
Address - State
Address - Country Code
In 'ISO 3166-1 Alpha-2' Format (Eg: "US" for United States of America)
Address - Country
Address - Zip / Postal Code
Addresses Note
Note: Single-Line addresses are obsolete, but the next field will still work. However, It would be preferable to use the multiple inputs above.
Inventory Location Address (Legacy)
Company
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.SkuRequired
Ean
Product DescriptionRequired
Product Version
Long Description
Product Category
Unit of Stock
Image (URL)
Comments
Weight
Product Length
Product Breadth
Product Height
Default Sales Price
Default Purchase Price
Main Supplier's Name
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Purchase Order IDRequired
Purchase Order Type ID
Purchase Order No
This is a required field only if you are using Manual Numbering in your Megaventory account
Purchase Order Reference No
Custom Order Date 1
Date should be either in ISO format (Example: 2020-04-22T09:07:12.000Z) -or- MM/dd/YYYY format
Custom Order Date 2
Date should be either in ISO format (Example: 2020-04-22T09:07:12.000Z) -or- MM/dd/YYYY format
Currency Code
Supplier IDRequired
Address
Pickup Address
Contact Person
Inventory Location ID
This is not a required field only if Order Status is Pending
ActionRequired
Order StatusRequired
Receive Document Type ID
This is a required field when Action is Receive Items or Invoice Items. Please make sure that you enter a Document Type ID related to these Actions
Custom Order Option 1
Custom Order Option 2
Custom Order Option 3
Custom Order Option 4
Custom Order Option 5
Custom Order Option 6
Custom Order Option 7
Custom Order Option 8
Custom Order Option 9
Custom Order Option 10
Comments
Tags
Payment Terms
Total Quantity
Amount Subtotal Without Tax And Discount
Amount Total DIscount
Amount Total Tax
Amount Grand Total
Expected Earliest Receiving Date
Date should be either in ISO format (Example: 2020-04-22T09:07:12.000Z) -or- MM/dd/YYYY format
Expected Latest Receiving Date
Date should be either in ISO format (Example: 2020-04-22T09:07:12.000Z) -or- MM/dd/YYYY format
Order Row Detail ID
This is a required field when Action is Receive Items or Invoice Items
Order Row Product ID
This is a required field when Action is Receive Items or Invoice Items
Order Row Product SKURequired
Order Row Product Description
Order Row QuantityRequired
Order Row Received Quantity
This is a required field when Action is Receive Items
Order Row Invoiced Quantity
This is a required field when Action is Invoice Items
Order Row Unit Price Without Tax Or Discount
Order Row Tax ID
Order Row Total Tax Amount
Order Row Discount ID
Order Row Total Discount Amount
Order Row Total Amount
Order Row Serial Numbers
Order Row Remarks
Order Row Expected Earliest Receiving Date
Date should be either in ISO format (Example: 2020-04-22T09:07:12.000Z) -or- MM/dd/YYYY format
Order Row Expected Latest Receiving Date
Date should be either in ISO format (Example: 2020-04-22T09:07:12.000Z) -or- MM/dd/YYYY format
Billing Address - Organization
Billing Address - Tax ID Number
Billing Address - Line 1
Billing Address - Line 2
Billing Address - City
Billing Address - State
Billing Address - Country Code
Billing Address - Country Name
Billing Address - Zip / Postal Code
Shipping Address - Organization
Shipping Address - Tax ID Number
Shipping Address - Line 1
Shipping Address - Line 2
Shipping Address - City
Shipping Address - State
Shipping Address - Country Code
Shipping Address - Country Name
Shipping Address - Zip / Postal Code
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Sales Order IDRequired
Sales Order Type ID
Sales Order No
This is a required field only if you are using Manual Numbering in your Megaventory account
Sales Order Reference No
Custom Order Date 1
Date should be either in ISO format (Example: 2020-04-22T09:07:12.000Z) -or- MM/dd/YYYY format
Custom Order Date 2
Date should be either in ISO format (Example: 2020-04-22T09:07:12.000Z) -or- MM/dd/YYYY format
Currency Code
Client IDRequired
Billing Address
Shipping Address
Sales Order Contact Person
Inventory Location ID
This is not a required field only if Order Status is Pending
ActionRequired
Order StatusRequired
Ship Document Type ID
This is a required field when Action is ShipItems or InvoiceItems. Please make sure that you enter a Document Type ID related to these Actions
Custom Order Option 1
Custom Order Option 2
Custom Order Option 3
Custom Order Option 4
Custom Order Option 5
Custom Order Option 6
Custom Order Option 7
Custom Order Option 8
Custom Order Option 9
Custom Order Option 10
Comments
Sales Order Tags
Payment Terms
Total Quantity
Order Amount Subtotal Without Tax And Discount
Order Amount Shipping
Order Amount Total Discount
Order Amount Total Tax
Order Amount Grand Total
Order Row Product SKURequired
Order Row Product Description
Order Row Product QuantityRequired
Order Row Shipped Quantity
This is a required field when Action is Ship Items
Order Row Invoiced Quantity
This is a required field when Action is Invoice Items
Order Row Unit Price Without Tax Or Discount
Order Row Tax ID
Order Total Tax Amount
Order Row Discount ID
Order Row Total Discount Amount
Order Row Total Amount
Order Row Remarks
Order Row Serial Numbers
Order Row Detail ID
This is a required field when Action is Ship Items or Invoice Items
Order Row Product ID
This is a required field when Action is Ship Items or Invoice Items
Billing Address - Organization
Billing Address - Tax ID Number
Billing Address - Line 1
Billing Address - Line 2
Billing Address - City
Billing Address - State
Billing Address - Country Code
Billing Address - Country Name
Billing Address - Zip / Postal Code
Shipping Address - Organization
Shipping Address - Tax ID Number
Shipping Address - Line 1
Shipping Address - Line 2
Shipping Address - City
Shipping Address - State
Shipping Address - Country Code
Shipping Address - Country Name
Shipping Address - Zip / Postal Code
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Sales Quote IDRequired
Sales Quote No
This is a required field only if you are using Manual Numbering in your Megaventory account
Sales Quote Type ID
Sales Quote Reference No
Custom Quote Date 1
Date should be either in ISO format (Example: 2020-04-22T09:07:12.000Z) -or- MM/dd/YYYY format
Custom Quote Date 2
Date should be either in ISO format (Example: 2020-04-22T09:07:12.000Z) -or- MM/dd/YYYY format
Currency Code
Client IDRequired
Shipping Address
Billing Address
Sales Quote Contact Person
Inventory Location ID
This is a required field only if Quote Status is Closed
ActionRequired
Quote StatusRequired
Comments
Sales Quote Tags
Payment Terms
Total Quantity
Quote Amount Subtotal Without Tax And Discount
Quote Amount Total Discount
Quote Amount Total Tax
Quote Amount Grand Total
Quote Amount Shipping
Quote Row Product SKURequired
Quote Row Product Description
Quote Row Product QuantityRequired
Quote Row Unit Price Without Tax Or Discount
Quote Row Tax ID
Quote Row Total Tax Amount
Quote Row Discount ID
Quote Row Total Discount Amount
Quote Row Total Amount
Quote Row Remarks
Billing Address - Organization
Billing Address - Tax ID Number
Billing Address - Line 1
Billing Address - Line 2
Billing Address - City
Billing Address - State
Billing Address - Country Code
Billing Address - Country Name
Billing Address - Zip / Postal Code
Shipping Address - Organization
Shipping Address - Tax ID Number
Shipping Address - Line 1
Shipping Address - Line 2
Shipping Address - City
Shipping Address - State
Shipping Address - Country Code
Shipping Address - Country Name
Shipping Address - Zip / Postal Code
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Tax Description
Example: US Dollar (USD).
Show in Reports
Tax NameRequired
PercentRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.IdRequired
Fetches the client from the client id (integer).
ActionThis is an event a Zap performs.SearchFind existing data in your appCodeRequired
Fetches the currency from the code.
ActionThis is an event a Zap performs.SearchFind existing data in your appIdRequired
Fetchets the Discount from the Discount Id(integer).
ActionThis is an event a Zap performs.SearchFind existing data in your appDocument IdRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appIdRequired
Fetches the location from the product location id (integer).
ActionThis is an event a Zap performs.SearchFind existing data in your appPricing Rule IdRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appNameRequired
Fetches the product category from the product category name.
ActionThis is an event a Zap performs.SearchFind existing data in your appProduct SKURequired
Fetches the product from the SKU.
ActionThis is an event a Zap performs.SearchFind existing data in your appPurchase Order NoRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appSales Order NoRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appSales Quote NoRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appNameRequired
Fetchers the Shipping Provider from the Shipping Provider name.
ActionThis is an event a Zap performs.SearchFind existing data in your appNameRequired
Fetches the supplier from the supplier name.
ActionThis is an event a Zap performs.SearchFind existing data in your appNameRequired
Fetches the tax from the tax name.
ActionThis is an event a Zap performs.SearchFind existing data in your appNoRequired
Fetches the work order from the work order No(string).
ActionThis is an event a Zap performs.SearchFind existing data in your app
BaseRequired
TableRequired
Help Text
You must have at least one "Last Modified Time" type column in your Table in order to use this Trigger. Learn more about those here.
Which timestamp field should this Zap use to check for updates?Required
When this column changes to a new timestamp, your Zap will trigger on the corresponding record. Note: Must be a Last Modified Time column type.
Limit to View
Filter on updates to a specific View in your Table.
Include file contents?
Returns an extra File field with file contents. Set this field to Yes if you have trouble with Airtable file URLs expiring. File contents greater than 100MB will cause an error.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planBaseRequired
Base in which to create the record.
TableRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Owner
Determines which App Extensions will appear in the dropdown below.
App ExtensionRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.BaseRequired
Base to search for a record.
TableRequired
Pick an Airtable table that you want to search.
Search by Field
Pick a field from the base to match against the search value.
Search Value
The value of unique identifier for the record.
Search Formula
(ADVANCED) Alternatively, you can use an Airtable search formula to find records based on advanced conditions and any number of fields. Learn more.
Limit to View
Limit the search to a specific view. Useful for sorting results.
Include file contents?
Returns an extra File field with file contents. Set this field to Yes if you have trouble with Airtable file URLs expiring. File contents greater than 100MB will cause an error.
ActionThis is an event a Zap performs.SearchFind existing data in your appBaseRequired
Base in which to create the record.
TableRequired
Pick an Airtable table that you want to search.
Search by Field
Pick a field from the base to match against the search value.
Search Value
The value of unique identifier for the record.
Search Formula
(ADVANCED) Alternatively, you can use an Airtable search formula to find records based on advanced conditions and any number of fields. Learn more.
Limit to View
Limit the search to a specific view. Useful for sorting results.
Include file contents?
Returns an extra File field with file contents. Set this field to Yes if you have trouble with Airtable file URLs expiring. File contents greater than 100MB will cause an error.
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundURLRequired
This should return a list of dictionaries of content type JSON in reverse chronological order. For example:
[{"id":1234},{"id":1235}]
Key
If the returned JSON is not a list and is instead an object (maybe paginated), enter the key that contains the results. Example: "results", "items", "objects", etc... (children via dot syntax supported)
Deduplication Key
Zapier deduplicates the array we see each poll against the
id
key. If theid
key does not exist, you should specify an alternative unique key to deduplicate off of. If neither are supplied, we fallback to looking for the shortest key withid
in it otherwise we will raise an error.Xpath
If the content fetched is XML or HTML, optionally define an xpath to extract data from the content. Will trigger whenever the content at the xpath changes!
Basic Auth
A pipe (
|
) separated username, password combo for standard HTTP authentication.Headers
Key, value pairs to be added as headers in all requests.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planPick off a Child Key
By default, Zapier gives you the entire payload of the webhook. If this is specified, Zapier will only grab the child key from the object(s) sent to Zapier. For example, given
{"contact": {"name": "Mike"}}
, add "contact" here to only return{"name": "Mike"}
. Traverse more deeply nested children by using dot-separated syntax. Line item payloads will run your Zap for each instance of the child key.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.URLRequired
We recommend not putting any query string arguments in the URL (use "Query String Params" below).
Query String Params
These params will be URL-encoded and appended to the URL when making the request. Note: If you specify nothing for this field, we will automatically encode and include every field from the previous step in the query string. If you don't want this, use the "Custom Request" action.
Send As JSON
If "yes", this dumps the results directly to a key (set below) as JSON. If "no", we simulate a form.
JSON key
Only used if As JSON.
Unflatten
By default we convert fields with double underscores into nested dictionaries. Select no here to turn this behavior off.
Basic Auth
A pipe (
|
) separated username, password combo for standard HTTP authentication.Headers
Key, value pairs to be added as headers in all requests.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.URLRequired
Any URL with a querystring will be re-encoded properly.
Payload Type
Pay special attention to the proper mapping of the data below.
Data
These are key-value pairs that will form the data portion of the request. If you leave these empty, all fields from the previous step will be used. If you want to send your own raw JSON or form-encoded values here, please use the Custom Request action instead.
Wrap Request In Array
Wraps the request in an array if that is something the service requires.
File
A file object to be attached to the request. The request will automatically be converted to
multipart/form-data
, with the above payload type defining the sub content-type for the data being passed.Unflatten
By default we convert fields with double underscores into nested dictionaries. Select no here to turn this behavior off.
Basic Auth
A pipe (
|
) separated username, password combo for standard HTTP authentication.Headers
Key, value pairs to be added as headers in all requests.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Delete Client
Triggers when a Client is deleted.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Delete Discount
Triggers when a Discount is Deleted.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Delete Inventory Location
Triggers when an Inventory Location is deleted.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Delete Product
Triggers when a Product is Deleted.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Delete Tax
Triggers when a Tax is deleted.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Document TypeRequired
Filter by Document Type
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Document TypeRequired
Filter by Document Type
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Document TypeRequired
Filter by Document Type
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Close Goods Transfer
Triggers when a Goods Transfer is closed
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Receive Goods Transfer Items
Triggers when Goods Transfer items are received
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Reopen Goods Transfer
Triggers when a Goods Transfer is Reopened
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Low Stock Product
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Client
Triggers when a new Client is created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Discount
Triggers when a new Discount is created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Document Type
Triggers when a new Document Type gets inserted.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Inventory Location
Triggers when a new Inventory Location is created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Sales Quote
Triggers when a new Sales Quote is created
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Tax
Triggers when a new Tax is created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Purchase Order
Triggers when a Purchase Order is created in Pending state.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Product
Triggers when a new Product is created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Cancel Purchase Order
Triggers when a Purchase Order is cancelled
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Invoice Purchase Order Items
Triggers when a Purchase Order's items are invoiced (either partially or fully)
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Reopen Purchase Order
Triggers when a Purchase Order is reopened
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Update Purchase Order
Triggers when a Purchase Order is updated
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Cancel Sales Order
Triggers when a Sales Order is Cancelled
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Invoice Sales Order Items
Triggers when a Sales Order's items are invoiced (either partially or fully)
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Reopen Sales Order
Triggers when a Sales Order is Reopened
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Update Sales Order
Triggers when a Sales Order is Updated
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Cancel Sales Quote
Triggers when a Sales Quote is cancelled
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Revert Sales Quote to Pending
Triggers when a Sales Quote is reverted to Pending
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Update Category
Triggers when a Category is Updated.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Update Currency
Triggers when a Currency is updated.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Update Document Type
Triggers when a Document Type gets Updated.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Update Pricing Rule
Triggers when a Pricing Rule is updated.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Update Supplier
Triggers when a Supplier is updated.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.NameRequired
Client Comments
Phone
Phone 2
Tax ID
E-Mail
Supplier or Client?
Billing Address - Organization
Billing Address - Line 1
Billing Address - Line 2
Billing Address - City
Billing Address - State
Billing Address - Country Code
Billing Address - Country
Billing Address - Zip / Postal Code
Shipping Address - Organization
Shipping Address - Line 1
Shipping Address - Line 2
Shipping Address - City
Shipping Address - State
Shipping Address - Country Code
In 'ISO 3166-1 Alpha-2' Format (Eg: "US" for United States of America)
Shipping Address - Country
Shipping Address - Zip / Postal Code
AddressesNote
Note: Single-Line addresses are obsolete, but the fields below will still work. However, It would be preferable to use the multiple inputs above.
Billing Address (Legacy)
Shipping Address (Legacy)
Shipping Address 2 (Legacy)
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Discount NameRequired
PercentRequired
Discount Description
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Document IDRequired
Document Type IDRequired
Document No
This is a required field only if you are using Manual Numbering in your Megaventory account
Document Reference No
Custom Document Date 1
Date should be either in ISO format (Example: 2020-04-22T09:07:12.000Z) -or- MM/dd/YYYY format
Custom Document Date 2
Date should be either in ISO format (Example: 2020-04-22T09:07:12.000Z) -or- MM/dd/YYYY format
Currency Code
Document Supplier/Client IDRequired
Document Billing Address
Document Address
Document Contact Person
Document Inventory Location ID
This is not a required field only if Document's Status is Pending
Document StatusRequired
Please make sure that you enter a valid Document Status. For example, you can Update a Document to Closed or Cancelled only if its current Status is Verified. You can Update a Document to ReOpened only if it is Closed, etc.
ActionRequired
Please make sure that you enter a valid Action. For example, you can Delete a document only when its Status is Pending
Custom Document Option 1
Custom Document Option 2
Custom Document Option 3
Custom Document Option 4
Custom Document Option 5
Custom Document Option 6
Custom Document Option 7
Custom Document Option 8
Custom Document Option 9
Custom Document Option 10
Shipping Provider ID
Document Tracking ID
Document Comments
Payment Terms
Document Tags
Parent Document ID
Document Total Quantity
Document Amount Subtotal Without Tax And Discount
Document Amount Shipping
Document Amount Total Discount
Document Amount Total Tax
Document Amount Grand Total
Document Row Product SKURequired
Document Row Product Description
Document Row Product QuantityRequired
Document Row Unit Price Without Tax Or Discount
Document Row Tax ID
Document Total Tax Amount
Document Row Discount ID
Document Row Total Discount Amount
Document Row Total Amount
Document Row Remarks
Document Row Serial Numbers
Billing Address - Organization
Billing Address - Tax ID Number
Billing Address - Line 1
Billing Address - Line 2
Billing Address - City
Billing Address - State
Billing Address - Country Code
Billing Address - Country Name
Billing Address - Zip / Postal Code
Shipping Address - Organization
Shipping Address - Tax ID Number
Shipping Address - Line 1
Shipping Address - Line 2
Shipping Address - City
Shipping Address - State
Shipping Address - Country Code
Shipping Address - Country Name
Shipping Address - Zip / Postal Code
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Category Description
Category NameRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Purchase Order Type ID
Purchase Order No
This is a required field only if you are using Manual Numbering in your Megaventory account
Purchase Order Reference No
Custom Order Date 1
Date should be either in ISO format (Example: 2020-04-22T09:07:12.000Z) -or- MM/dd/YYYY format
Custom Order Date 2
Date should be either in ISO format (Example: 2020-04-22T09:07:12.000Z) -or- MM/dd/YYYY format
Currency Code
Supplier IDRequired
Address
Pickup Address
Purchase Order Contact Person
Inventory Location ID
This is a required field only if you want to insert a new Purchase Order as Verified
Order StatusRequired
Custom Order Option 1
Custom Order Option 2
Custom Order Option 3
Custom Order Option 4
Custom Order Option 5
Custom Order Option 6
Custom Order Option 7
Custom Order Option 8
Custom Order Option 9
Custom Order Option 10
Comments
Order Tags
Payment Terms
Total Quantity
Order Amount Subtotal Without Tax And Discount
Order Amount Total Discount
Order Amount Total Tax
Order Amount Grand Total
Order Expected Receiving Date Earliest
Date should be either in ISO format (Example: 2020-04-22T09:07:12.000Z) -or- MM/dd/YYYY format