My workflows page
Available options after your trigger step
Here's what displays when selecting Action
Date
* **Add time:** Adds a specified amount of time to a date. * **Format:** Converts a date into a different format. * **Start of day:** Converts a date to the start of the day (00:00:00). * **End of day:** Converts a date to the end of the day (23:59:59). * **Subtract time:** Subtracts a specified amount of time from a date. * **Time between:** Calculates the time difference between two dates. * **Time since:** Calculates the time difference from a date to now.String
* **Append:** Adds text to the end of a string. * **Capitalize:** Capitalizes the first word in a string and downcases the remaining characters. * **Downcase:** Converts all letters to lowercase. * **Prepend:** Adds text to the beginning of a string. * **Remove last:** Removes the last instance of a substring inside a string. * **Replace:** Replaces all occurrences of specific text within a string. * **Replace last:** Replaces only the last occurrence of specific text within a string. * **Split:** Breaks a string into an array based on a separator. * **Strip:** Removes spaces from the beginning and end of a string. * **Strip HTML:** Removes all HTML tags from a string. * **Upcase:** Converts all letters to uppercase.Math
* **At least:** Ensures a number is no smaller than a set minimum. * **At most:** Ensures a number is no larger than a set maximum. * **Divided by:** Divides a number and keeps the same type (integer or decimal). * **Minus:** Subtracts one number from another. * **Plus:** Adds two numbers. * **Round:** Rounds a number to the nearest whole number. * **Times:** Multiplies a number by another number.Array
* **Compact:** Removes empty values from an array. * **Concat:** Combines two arrays into one. * **First:** Retrieves the first item in an array. * **Join:** Combines all of the items in an array into a single string, separated by a space. * **Last:** Retrieves the last item in an array. * **Map:** Extracts values from a specific property in an array of objects. * **Size:** Returns the length of a string or the number of items in an array. * **Sort by an array item property:** Sorts the items in an array in case-insensitive alphabetical order. * **Sum:** Adds up all numbers in an array.`) in front of each newline () in a string. ### plus Adds a number to another number. ### prepend Adds the specified string to the beginning of another string. ### remove Removes every occurrence of the specified substring from a string. ### remove\_first Removes only the first occurrence of the specified substring from a string. ### replace Replaces every occurrence of the first argument in a string with the second argument. ### replace\_first Replaces only the first occurrence of the first argument in a string with the second argument. ### reverse Reverses the order of the items in an array. `reverse` cannot reverse a string. ### round Rounds a number to the nearest integer or, if a number is passed as an argument, to that number of decimal places. ### rstrip Removes all whitespace (tabs, spaces, and newlines) from the **right** side of a string. It does not affect spaces between words. ### size Returns the number of characters in a string or the number of items in an array. ### slice Returns a substring of one character or series of array items beginning at the index specified by the first argument. An optional second argument specifies the length of the substring or number of array items to be returned. String or array indices are numbered starting from 0. If the first argument is a negative number, the indices are counted from the end of the string. ### sort Sorts items in an array in case-sensitive order. ### split Divides a string into an array using the argument as a separator. `split` is commonly used to convert comma-separated items from a string to an array. ### strip Removes all whitespace (tabs, spaces, and newlines) from both the left and right sides of a string. It does not affect spaces between words. ### strip\_html Removes any HTML tags from a string. ### strip\_newlines Removes any newline characters (line breaks) from a string. ### times Multiplies a number by another number. ### truncate Shortens a string down to the number of characters passed as an argument. If the specified number of characters is less than the length of the string, an ellipsis (…) is appended to the string and is included in the character count. `truncate` takes an optional second argument that specifies the sequence of characters to be appended to the truncated string. By default this is an ellipsis (…), but you can specify a different sequence. ### truncatewords Shortens a string down to the number of words passed as an argument. If the specified number of words is less than the number of words in the string, an ellipsis (…) is appended to the string. `truncatewords` takes an optional second argument that specifies the sequence of characters to be appended to the truncated string. By default this is an ellipsis (…), but you can specify a different sequence. ### uniq Removes any duplicate items in an array. ### upcase Makes each character in a string uppercase. It has no effect on strings which are already all uppercase. ### url\_decode Decodes a string that has been encoded as a URL. ### url\_encode Converts any URL-unsafe characters in a string into percent-encoded characters. Note that `url_encode` will turn a space into a `+` sign instead of a percent-encoded character. ### where Creates an array including only the objects with a given property value, or any truthy value by default. # Manual Runs Run some checks and give your workflow a manual run before enabling! Manually running your workflow in MESA is an important final check of your automation setup. It allows you to see how your workflow will behave before going live with automatic runs. You can (and should) manually run your workflow steps to confirm each one is working properly as you build. Manually running automations on a per-step basis doesn't impact the rest of the workflow and provides clarity on the order of operations as you go. When you complete your workflow, you can manually run it from beginning to end as a final sanity check. With access to live, example, or custom data, MESA allows you to manually run the workflow with real results directly in the builder. ## Manually Run When No Data is Available Sometimes, you will not have any data available for the trigger you're using. If that's the case, you'll see the following message in the Manual run submenu of an open trigger: *"**Records are required to run your workflow**"*
Target logs by date and time.
Several options to drill into your logs.
Don't worry, it's not the eye of Sauron.
Thanks, logs! We're heading back to activity.
Uh oh, how do I make it stop?!
Now I know that MESA has updated the product!
FTP file size
10 MB
Virtual Output items
10,000
Payload size
1 MB
Log message size
100 KB
Storage size
100 KB
Script file size
2 MB
Scripts
100
Outputs
100
Storage & Secrets
10,000
Secret size
1 KB
```json { "mcpServers": { "mesa": { "command": "npx", "args": [ "mcp-remote", "https://mcp-server.getmesa.com/sse/ID/KEY" ], "env": {} } } } ``` 4. Save the file and restart Claude Desktop. > Note: you only need to configure Claude or other AI tools to connect to your MESA MCP server once. ### **Call MESA MCP workflows in Claude** Upon restarting, you should see a hammer icon in or near the input box. Clicking that hammer will show your Available MESA MCP workflows! > Not seeing the hammer icon? Take a look at [Claude's MCP troubleshooting section](https://modelcontextprotocol.io/quickstart/user#server-not-showing-up-in-claude-hammer-icon-missing). Try asking Claude something that would require information provided by your workflow eg. "Find Shopify Orders from March 2025". If Claude decides that it needs to run your workflow, you will be prompted for your approval to use the tool. ## Technical Notes * Treat your MCP Configuration JSON like a password. It can be used to access and update your data. * The maximum request time is limited based on the [Task compute](/going-further/platform-thresholds-and-limits#limits) limit of your plan. There is also a limit of 60 seconds per request, even if your plan allows longer requests. Requests that take more time to execute will be timed out, and no response will be returned. * Requests are rate-limited based on the [Incoming rate limit](/going-further/platform-thresholds-and-limits#limits) of your plan. ### Common Issues Getting Claude Desktop running can be difficult, and the error messages can be unhelpful. Here are some solutions to common issues we have encountered. #### Claude's "response was interrupted"
echo $PATH
| Property | Type | Description |
|---|---|---|
| steps | Object | An object containing the variables for each step that has been run so far, named with the step's unique key. For example, to access a step with a key of "shopify" use: |
| trigger | Trigger | This object is the configuration of the current step being run. |
| task | Task | This object is information about the current task's execution. |
| Property | Type | Description |
|---|---|---|
| metadata | Object | The values entered in configuration fields, with variable replacements. |
| raw_metadata | Object | The values entered in configuration fields, without variable replacements. |
| fields | Object | An object of the configuration fields from the UI. |
| Property | Type | Description |
|---|---|---|
| context.headers | Object | A key-value object of the HTTP headers passed to this task. |
| is_test | Object | Is the current task being run as a test? |
| Type | SQL Type | When to use | Example |
|---|---|---|---|
| Text | varchar(255) | Ideal for most text strings (keys, titles, names, etc). Maximum length: 255 characters. | Jannette Parks |
| Long Text | text | For free-form text and JSON blobs. | Jannette Parks likes to go to the park and play on the swings, the merry-go-round, and the super-duper play structure. She's an adventurer and she likes the thrill. She would stay at the park all day long, every day in fact, if she had the chance, and play with her yeti friend, Yedric. |
| Integer | int8 | For integers and numeric IDs. Supports numbers between -9223372036854775808 and 9223372036854775807. | 13 |
| Number | numeric | For numbers with decimal-point precision. | 13.99 |
| Date | date | For dates | 2024-11-30 |
| Date and time | timestamptz | For date and times, with timezone information. | 2024-11-30 13:24:00-07 |
| Boolean | bool | Values that are either true or false | True |
| Condition | Description | Example |
|---|---|---|
| Equals | A specified field matches an exact value provided | The number of line items in an order is equal to 2 |
| Does not equal | A specified field does not match an exact value provided | The number of line items in an order is not equal to 2 |
| Contains | A specified field includes a certain value within its content, regardless of its position in the text | An order's tags contains a "VIP" tag |
| Does not contain | A specified field does not include a certain value within its content, regardless of its position in the text | An order's tags does not contain a "VIP" tag |
| Is empty | A specified field has no data, meaning it is blank or null | An order's tags are empty |
| Is not empty | A specified field has data, meaning it is not blank or null | An order's tags are not empty |
| Is greater than | A specified field is numerically higher than a given value | A customer's order count is more than 2 |
| Is less than | A specified field is numerically lower than a given value | A customer's order count is less than 2 |
| Is less than or equal to | A specified field is numerically lower than or exactly equal to a given value | A customer's order count is less than or equal to 2 |
| Is greater than or equal to | A specified field is numerically higher than or exactly equal to a given value | A customer's order count is greater than or equal to 2 |
| Is in | A specified field matches any one of the values within a defined list or content | US is in a customer's country code address |
| Is not in | A specified field does not match any one of the values within a defined list or content | US is not in a customer's country code address |
| Starts with | A specified field value starts with a specific, or sequential, numbers or characters | A product's SKU starts with 123 |
| Does not start with | A specified field value does not start with a specific, or sequential, numbers or characters | A product's SKU does not start with 123 |
| Ends with | A specified field value ends with a specific, or sequential, numbers or characters | A product's SKU ends with XYZ |
| Does not end with | A specified field value does not end with a specific, or sequential, numbers or characters | A product's SKU does not end with XYZ |
| Is after [date/time] | A specified date/time value falls later than a given date or time | An order was created after 10/24/24 12:00AM |
| Is before [date/time] | A specified date/time value is earlier than a given date or time | An order was created before 10/24/24 12:00AM |
| Is on [date] | A specified date value matches exactly with a given date | An order was created on 10/24/24 |
# FTP The **FTP (File Transfer Protocol)** tool allows you to download and upload files to a specified FTP server. With MESA, you can map the data to a format that Shopify or another system expects and pass it along to the next step. Sharing CSV and other files via FTP servers is a great choice to connect your fulfillment service, product manager, or another third-party system to Shopify. MESA supports both FTP and SFTP (secure FTP) protocols. {% hint style="info" %} **Please note**: At this time, MESA does not support SSH keys for FTP. {% endhint %} ## Connection Your hosting service should have details for all fields required to [connect your FTP with MESA](/going-further/credentials).