This action runs a JSONPath query on the contents of a request. With it, you can extract any data from a JSON document and store it in a variable, which can then be used in a downstream action.
JSONPath is very similar to the
jq commandline utility.
||author age of first book (bracket syntax can be useful for e.g. keys containing periods)|
||the authors of all books in the store|
||the price of everything in the store.|
||the third book|
||the last book in order.|
||the last book in order.|
||the first two books|
||the first two books|
||every second book starting from first one|
||every third book starting from 1 till 6|
||filter all books with isbn number|
||filter all books cheaper than 10|
||all elements in the data (recursively extracted)|
||The root object/element (not strictly necessary)|
||The current object/element|
||Wildcard. All child elements regardless their index.|
||Array indices as a set|
||Array slice operator borrowed from ES4/Python.|
||Filters a result set by a script expression|
||Uses the result of a "script" expression as the index|
For more details on what's possible with JSONPath, take a look at the docs.
As you start entering a JSONPath, the results are validated and shown next to the input field.
This action runs a Regex (regular expression) query on the contents of a request. With it, you can extract any data from a text document and store it in a variable, which can then be used in a downstream action.
As you start entering a Regex, the results are validated and shown next to the input field.
Similar to the Extract JSONPath Custom Action, Extract XPath lets you extract values from an XML or HTML document and save the result as a variable.
The following examples are based on this XML document:
||Finds all content within the organization element||Jack
||Get the "id" property of second employee element||2|
||Employee element with id property equal to "1"||Jack|
||Last employee element||Ann|
||Employee within any parent element where id contains "2"||Ann|
An action that allows replacing multiple inputs to a string with specified replacements. Additionally, Webhook.site will replace all variables in the source text as well as the text being replaced, and the replacement.
This will send a request with variable contents from the Webhook.site cloud. Per default, the request contents will be identical to what was sent to the URL originally.
Variables extracted previously can be used.
The response of the request is stored in a series of variable names prefixed with a value of your choosing. The following variables are set after the request has been fired:
$your_prefix.content$- response body content
$your_prefix.status$- response status code
$your_prefix.headers$- response headers
$your_prefix.url$- the URL the request was sent to
This will send a email with variable contents from the Webhook.site cloud. Variables extracted previously can be used.
Send Email (SMTP)¶
This will send a email with variable contents from your own email provider. Variables extracted previously can be used.
Gmail and Google Workspace¶
For Gmail, the following specific setup is required:
- Username: firstname.lastname@example.org or email@example.com (replace with your Gmail address)
- Password: You must create a Mail App Password
Run SSH Command¶
Allows you to run one or more SSH command on a server. Webhook.site captures the output (stdout), stderr and the command exit code as Variables that can be used in downstream actions:
Allows uploading a file to a FTP or FTPS (FTP with TLS/SSL) server, specifying a hostname, port, username, password, relative path to the file, whether to use SSL and whether to use passive mode. Finally, the file content can be specified, in which Variables are replaced.
We recommend storing the password as a Global Variable.
Allows running a database query, with support for fetching out data in a series of variables. We recommend storing the password as a Global Variable.
Supported Database Servers¶
Currently supported are:
If your database server is not on the list, please contact support.
When using e.g. INSERT or UPDATE statements, we strongly recommend using parameters for each column value. Doing this, you avoid SQL injection attacks and other issues when using user-submitted data (e.g. via Variables), or even just data containing special characters like quotes, that could otherwise break a query.
Each parameter name should start with a colon (:) and be a single word. You can then reference these parameters inside the query, like in the following example:
When fetching data using e.g. SELECT statements, Webhook.site automatically inserts data in a series of Custom Action Variables, which are then available to downstream actions.
For example, when fetching rows from the following table:
Using the following statement:
If the variable name prefix would be set to
output, the following variables would be created containing specific values:
Additionally, a variable would be created with the name
$output.json$ containing the data in JSON format:
Marks the request so it is not saved in Webhook.site, which is useful (especially in combination with Conditions) when receiving a large amount of requests.
Adds a custom log entry to the Request's action output.
This action can be used to modify the response of the Webhook.site URL based on the input.
This action can be used to allow a specific amount of requests in a specific amount of time per a given IP.
If the IP is rate limited, the URL will respond with a
HTTP 429, action execution is stopped, and the request is not saved in Webhook.site.
Immediately stops Custom Action execution and returns the default response.
Useful if you need to validate that the request does or does not conform to certain criteria, the Condition action will either stop or continue based on a condition.
In both the input and the value fields, variables will be replaced (including Global Variables from the Control Panel), so you can compare e.g. JSONPath or Regex values - or even values from a previous HTTP request that was sent.
Currently, two actions are provided: stop and continue. Stop will stop further action execution of the condition is a match. Continue will only continue further execution if the condition is a match, and otherwise stop.
The following "operators" are available:
- is equal to
- is not equal to
- starts with
- ends with
- does not contain
- is greater than
- is greater than or equal to
- is less than
- is less than or equal to
The "result" of the condition will be logged below the request details, so you can see what happened.
For more information about WebhookScript, see the dedicated page.
Set Runtime Variable¶
Defines (or overwrites) a variable that's available to downstream actions. The variable is not saved permanently as a Global Variable.
Store Global Variable¶
Saves (or overwrites) a Global Variable that's saved permanently and available to all URLs in your account. If you don't need to save the variable permanently, you should use the Set Runtime Variable instead.
Takes an image from either a URL or raw image data from e.g. a file upload, email attachment, request response or another action such as Dropbox.
You can enter both width and height to contrain the image in both dimensions, or enter a single dimension.
Check "Keep Aspect Ratio" so that the image keeps the aspect ratio, but doesn't exceed the height and width constraints.
Google Sheets should not be used as a database, and have low usage limits. If you need to import on the order of thousands of rows or make thousands of calls a day, Google Sheets cannot be used. We recommend using a database like Postgres in conjunction with the Database Query action.
Google Sheets Custom Actions lets you manipulate and retrieve values from a Google Sheet.
The following Google Sheets Custom Actions are available:
- Add Row - appends one or more new rows to an existing spreadsheet
- Update Row - updates one or more cells in an existing spreadsheet
- Get Values - retrieves one or more cell values from an existing spreadsheet
To start, you need to make sure that you have connected a Google account in the Control Panel, available here.
After that, you can select the account in the dropdown when creating the Custom Action.
It is important to note that Google will block Write requests (i.e. adding or updating rows) at 60 requests per minute. After that, the action will temporarily fail with the following error message:
Therefore, for importing mass amounts of data in a short timespan, Google Sheets is not recommended. Instead, we recommend using the Database Query action.
Additionally, Webhook.site will automatically disable Google Sheets actions that continously fail due to e.g. quota errors.
Specifying the spreadsheet¶
When specifying the spreadsheet, you can either just copy/paste the spreadsheet URL or enter the spreadsheet ID. Variables can be used to specify the spreadsheet.
All actions must specify a range, which behaves similar in all actions. For the Add Row action, Google Sheets will automatically find a "table" (e.g. a homogenous mass of data) and add the values at the bottom.
A range is the same query as in Google Sheets, e.g. to select A1-C3 in Worksheet "Example", enter
When inserting or updating values, you can either enter a value in the text field, or supply multiple cells and/or rows using JSON. To insert two rows, the JSON would be
["cell 1", "cell 2"].
The Get Values Action allows you to define variables based on the output. Since this action can return multiple pieces of data, multiple variables are created.
For example, if you select two columns and two rows, e.g.
A1:B2, four variables would be defined:
variable_name.0.0= value of A1
variable_name.0.1= value of A2
variable_name.1.0= value of B1
variable_name.1.1= value of B2
Additionally, the data is available in JSON, with the
variable_name.json variable being defined, and continuing with the example above, would contain the following JSON:
Amazon Web Services (AWS)¶
The following actions are available for AWS S3:
- Create Bucket
- Create Object
- Delete Object
- Get Object (retrieves object contents to a Variable)
In addition to the "official" Amazon endpoints, Webhook.site also supports S3-compatible storages like DigitalOcean, MinIO, Wasabi and more. The endpoint can be specified when setting up the account in Control Panel.
The "Create Invalidation" action allows you to dynamically create a CloudFront cache invalidation as a Custom Action. Both the Distribution ID and the paths to be invalidated are replaced with Webhook.site Variables.
With the Discord Custom Action, you can send messages to a specified channel (Each bot account uses a specific channel, so you can connect more accounts to send to different channels or servers.) In addition, you can choose a custom username and avatar image for the bot user.
With the Slack Custom Action, you can easily use Slack's Webhook URLs to send messages to a channel.
The Dropbox integration has access to the entire contents of your dropbox, and currently the following actions are available:
- Create Folder
- Download File
- Upload File
- Delete File
- Delete Folder
- Get Link - creates a temporary download link for any file in your Dropbox, and saves it in a variable.
The Twitter Integration supports the following actions using Twitter's API:
- Post Tweet
The RabbitMQ Integration allows you to publish and consume messages from a RabbitMQ queue by specifying the server connection details.
With the Send Push Notification action, you can easily send push notifications to your mobile devices using your Pushed.co account.
With a free Pushed.co account, you can send up to 1000 push notifications a month.