# \#flows **URL:** https://community.synatic.com/tag/flows/18.md [Latest](https://community.synatic.com/latest.md) · [Categories](https://community.synatic.com/categories.md) · [Tags](https://community.synatic.com/tags.md) --- ## [How do I send an EXCEL file as an e-mail attachment?](https://community.synatic.com/t/how-do-i-send-an-excel-file-as-an-e-mail-attachment/428)
**Author:** [@jacobin](https://community.synatic.com/u/jacobin)\ **Replies:** 3\ **Last updated:** [August 5, 2024, 8:11am UTC](https://community.synatic.com/t/how-do-i-send-an-excel-file-as-an-e-mail-attachment/428 "2024-08-05T08:11:04Z")
I’m working on a flow that has to make calculations, at the end of these calculations export the combined results in Excel and send them by email. Except that when the email is sent, the content of the attachment is emp… --- ## [How to send multiple attachments in a single email using Email V2](https://community.synatic.com/t/how-to-send-multiple-attachments-in-a-single-email-using-email-v2/431)
**Author:** [@Faizel](https://community.synatic.com/u/Faizel)\ **Replies:** 0\ **Last updated:** [June 24, 2024, 1:10pm UTC](https://community.synatic.com/t/how-to-send-multiple-attachments-in-a-single-email-using-email-v2/431 "2024-06-24T13:10:02Z")
If you require to send multiple file attachments in a single email, please follow the instructions below: Illustrated in the image below is an example of a flow that queries three error logging buffers, generates an Exc… --- ## [How to Post a PDF to an API Endpoint](https://community.synatic.com/t/how-to-post-a-pdf-to-an-api-endpoint/421)
**Author:** [@Faizel](https://community.synatic.com/u/Faizel)\ **Replies:** 0\ **Last updated:** [May 4, 2024, 7:43am UTC](https://community.synatic.com/t/how-to-post-a-pdf-to-an-api-endpoint/421 "2024-05-04T07:43:38Z")
If you require to generate a PDF document and send it to an API endpoint, please follow the instructions below: Illustrated below is an overview of the process, We generate a PDF document and send it to a REST API, The … --- ## [How to Port Buffers between Orgs](https://community.synatic.com/t/how-to-port-buffers-between-orgs/418)
**Author:** [@Faizel](https://community.synatic.com/u/Faizel)\ **Replies:** 0\ **Last updated:** [April 18, 2024, 2:12pm UTC](https://community.synatic.com/t/how-to-port-buffers-between-orgs/418 "2024-04-18T14:12:12Z")
If required to transfer Buffers with data and indexes for particular solutions between Orgs, please follow the instructions below: Illustrated below is an overview of the process, We have two orgs, source and target or … --- ## [How to upload an HTML file via a REST API](https://community.synatic.com/t/how-to-upload-an-html-file-via-a-rest-api/393)
**Author:** [@Faizel](https://community.synatic.com/u/Faizel)\ **Replies:** 0\ **Last updated:** [November 21, 2023, 10:17am UTC](https://community.synatic.com/t/how-to-upload-an-html-file-via-a-rest-api/393 "2023-11-21T10:17:11Z")
If required to post a file via a REST gateway and send it to a destination, please follow the instructions below: Illustrated in the image below is an example of a flow that is triggered via a REST gateway to post a fil… --- ## [How to retrieve a list of relays to swap at runtime](https://community.synatic.com/t/how-to-retrieve-a-list-of-relays-to-swap-at-runtime/399)
**Author:** [@Faizel](https://community.synatic.com/u/Faizel)\ **Replies:** 0\ **Last updated:** [January 8, 2024, 11:08am UTC](https://community.synatic.com/t/how-to-retrieve-a-list-of-relays-to-swap-at-runtime/399 "2024-01-08T11:08:16Z")
If required to retrieve a list of relays to swap at runtime, please follow the instructions below: Illustrated below is an example of a flow that gets specific information about relays within an organization, organizes … --- ## [How to return an API response from a destination](https://community.synatic.com/t/how-to-return-an-api-response-from-a-destination/403)
**Author:** [@Faizel](https://community.synatic.com/u/Faizel)\ **Replies:** 0\ **Last updated:** [January 29, 2024, 11:25am UTC](https://community.synatic.com/t/how-to-return-an-api-response-from-a-destination/403 "2024-01-29T11:25:23Z")
If required to use an API that requires a body to be sent and a response to be received, please follow the instructions below: Illustrated in the image below is an example of a flow that prepares a JSON body to send to … --- ## [How to create a file with multiple objects and arrays in the dataset](https://community.synatic.com/t/how-to-create-a-file-with-multiple-objects-and-arrays-in-the-dataset/271)
**Author:** [@navessa](https://community.synatic.com/u/navessa)\ **Replies:** 0\ **Last updated:** [July 14, 2022, 2:19pm UTC](https://community.synatic.com/t/how-to-create-a-file-with-multiple-objects-and-arrays-in-the-dataset/271 "2022-07-14T14:19:44Z")
Illustrated below is an example of a partial flow where a csv file gets created with a data set. The below image is the data set that contains multiple objects and arrays. To create a file with the data, the data … --- ## [Need help interpreting an Excel file sent from K2 to Synatic](https://community.synatic.com/t/need-help-interpreting-an-excel-file-sent-from-k2-to-synatic/408)
**Author:** [@Flowfactory](https://community.synatic.com/u/Flowfactory)\ **Replies:** 1\ **Last updated:** [February 7, 2024, 12:36pm UTC](https://community.synatic.com/t/need-help-interpreting-an-excel-file-sent-from-k2-to-synatic/408 "2024-02-07T12:36:56Z")
Hello, I’m experiencing difficulties with interpreting an Excel file sent from K2 to Synatic. Although the file is received correctly, I’m encountering issues with interpreting its content once it arrives in our environ… --- ## [How to add static/hardcoded data in a flow](https://community.synatic.com/t/how-to-add-static-hardcoded-data-in-a-flow/392)
**Author:** [@Faizel](https://community.synatic.com/u/Faizel)\ **Replies:** 0\ **Last updated:** [November 13, 2023, 6:48pm UTC](https://community.synatic.com/t/how-to-add-static-hardcoded-data-in-a-flow/392 "2023-11-13T18:48:44Z")
If you need to add static or hardcoded data to a flow, please refer to the instructions provided below. There are multiple methods available to include static data within a flow. In the following example, we will explor… --- ## [How to send an Alert if a frequently running flow has an Error](https://community.synatic.com/t/how-to-send-an-alert-if-a-frequently-running-flow-has-an-error/391)
**Author:** [@Faizel](https://community.synatic.com/u/Faizel)\ **Replies:** 0\ **Last updated:** [November 13, 2023, 6:05pm UTC](https://community.synatic.com/t/how-to-send-an-alert-if-a-frequently-running-flow-has-an-error/391 "2023-11-13T18:05:49Z")
If a flow needs to be constantly running and want to create an alert to check if the flow stops processing, please follow the below instructions. The image below is an example of a flow that runs every 10 minutes to fet… --- ## [How to do additional grouping of flows/buffers/etc in a solution](https://community.synatic.com/t/how-to-do-additional-grouping-of-flows-buffers-etc-in-a-solution/184)
**Author:** [@navessa](https://community.synatic.com/u/navessa)\ **Replies:** 0\ **Last updated:** [February 14, 2022, 7:48am UTC](https://community.synatic.com/t/how-to-do-additional-grouping-of-flows-buffers-etc-in-a-solution/184 "2022-02-14T07:48:12Z")
To do additional grouping in a solution, follow the below instructions. Click on the flow/s you want to do additional grouping for. Click on Flow Details as highlighted in the below image. The below page will appear… --- ## [How to log a primary/ main flow's data in a secondary flow](https://community.synatic.com/t/how-to-log-a-primary-main-flows-data-in-a-secondary-flow/203)
**Author:** [@navessa](https://community.synatic.com/u/navessa)\ **Replies:** 0\ **Last updated:** [April 5, 2022, 12:12pm UTC](https://community.synatic.com/t/how-to-log-a-primary-main-flows-data-in-a-secondary-flow/203 "2022-04-05T12:12:52Z")
This feature is useful when debugging and building flows. The Log Input feature confirms if a sync flow, async flow or sub-flow is receiving the correct data from the primary/ main flow. NB: This feature works only if y… --- ## [How to map fields from a nested array into one array](https://community.synatic.com/t/how-to-map-fields-from-a-nested-array-into-one-array/343)
**Author:** [@Faizel](https://community.synatic.com/u/Faizel)\ **Replies:** 0\ **Last updated:** [April 25, 2023, 4:32pm UTC](https://community.synatic.com/t/how-to-map-fields-from-a-nested-array-into-one-array/343 "2023-04-25T16:32:44Z")
If you require to map fields from a nested array into a single array, please follow the instructions below: Illustrated in the image below is an example of a flow where a Record Generator is used as a source step, the p… --- ## [How to add a comment to a component in an organization](https://community.synatic.com/t/how-to-add-a-comment-to-a-component-in-an-organization/314)
**Author:** [@navessa](https://community.synatic.com/u/navessa)\ **Replies:** 0\ **Last updated:** [January 16, 2023, 4:11pm UTC](https://community.synatic.com/t/how-to-add-a-comment-to-a-component-in-an-organization/314 "2023-01-16T16:11:16Z")
You can now add a comment on any component (flow, buffer, connection, relay, parameter, API & operations view) to provide more details, including adding images/ diagrams and hyperlinks. The Comments page can be found by… --- ## [How to purge a buffer anywhere in a flow](https://community.synatic.com/t/how-to-purge-a-buffer-anywhere-in-a-flow/292)
**Author:** [@navessa](https://community.synatic.com/u/navessa)\ **Replies:** 0\ **Last updated:** [September 21, 2022, 1:05pm UTC](https://community.synatic.com/t/how-to-purge-a-buffer-anywhere-in-a-flow/292 "2022-09-21T13:05:40Z")
If you require to purge a buffer anywhere in a flow, use the Buffer Purge destination step. This step allows you to purge any buffer in any flow without creating a new flow or extra steps just to purge the buffer after … --- ## [How to re-order subflows in a control flow](https://community.synatic.com/t/how-to-re-order-subflows-in-a-control-flow/313)
**Author:** [@navessa](https://community.synatic.com/u/navessa)\ **Replies:** 0\ **Last updated:** [January 16, 2023, 11:42am UTC](https://community.synatic.com/t/how-to-re-order-subflows-in-a-control-flow/313 "2023-01-16T11:42:51Z")
If you require to re-order subflows in a control flow (series, parallel or condition flow), the following will assist: Illustrated in the image below is an example of a series control flow with 3 subflows. To re-ord… --- ## [How to read data from specific individual worksheets in an Excel file](https://community.synatic.com/t/how-to-read-data-from-specific-individual-worksheets-in-an-excel-file/276)
**Author:** [@navessa](https://community.synatic.com/u/navessa)\ **Replies:** 0\ **Last updated:** [July 28, 2022, 8:52pm UTC](https://community.synatic.com/t/how-to-read-data-from-specific-individual-worksheets-in-an-excel-file/276 "2022-07-28T20:52:11Z")
If you require to read data from specific individual worksheets in an Excel file, follow the below instructions: Illustrated below is an example of a flow where the SFTP Server source step is used and a Parallel control… --- ## [How to view the change log in a Calculator step and revert it to the previous/old change](https://community.synatic.com/t/how-to-view-the-change-log-in-a-calculator-step-and-revert-it-to-the-previous-old-change/178)
**Author:** [@navessa](https://community.synatic.com/u/navessa)\ **Replies:** 0\ **Last updated:** [January 27, 2022, 5:28pm UTC](https://community.synatic.com/t/how-to-view-the-change-log-in-a-calculator-step-and-revert-it-to-the-previous-old-change/178 "2022-01-27T17:28:23Z")
It allows you to view when a change was made to the step, see what the previous/old changes were and to revert the new change to a previous/ old change. This is a very helpful feature, especially when using the Calculato… --- ## [How to delay the number of requests when pulling records from an API](https://community.synatic.com/t/how-to-delay-the-number-of-requests-when-pulling-records-from-an-api/196)
**Author:** [@navessa](https://community.synatic.com/u/navessa)\ **Replies:** 0\ **Last updated:** [March 31, 2022, 9:48am UTC](https://community.synatic.com/t/how-to-delay-the-number-of-requests-when-pulling-records-from-an-api/196 "2022-03-31T09:48:03Z")
When transferring data from a source to a destination in our tool, records will go through one at a time. If there are a lot of requests from an API, there is a chance that the records could be overlapping and not pulli… --- ## [How to run multiple flows sequentially with one trigger](https://community.synatic.com/t/how-to-run-multiple-flows-sequentially-with-one-trigger/282)
**Author:** [@navessa](https://community.synatic.com/u/navessa)\ **Replies:** 0\ **Last updated:** [August 22, 2022, 5:33pm UTC](https://community.synatic.com/t/how-to-run-multiple-flows-sequentially-with-one-trigger/282 "2022-08-22T17:33:24Z")
If you require to run multiple flows sequentially with one trigger, a control/ master flow needs to be created. To do this, please follow the below instructions: Illustrated below is an example of how the control/ maste… --- ## [How to send multiple files from your local machine to an SFTP Server as a destination](https://community.synatic.com/t/how-to-send-multiple-files-from-your-local-machine-to-an-sftp-server-as-a-destination/277)
**Author:** [@navessa](https://community.synatic.com/u/navessa)\ **Replies:** 0\ **Last updated:** [August 2, 2022, 8:43am UTC](https://community.synatic.com/t/how-to-send-multiple-files-from-your-local-machine-to-an-sftp-server-as-a-destination/277 "2022-08-02T08:43:49Z")
If you require to send multiple files from your local machine to an SFTP Server as a destination, please follow the below instructions: Illustrated in the below images is an example of how your flow will look. A File Sy… --- ## [How to handle a large number of records](https://community.synatic.com/t/how-to-handle-a-large-number-of-records/273)
**Author:** [@navessa](https://community.synatic.com/u/navessa)\ **Replies:** 0\ **Last updated:** [July 22, 2022, 4:51pm UTC](https://community.synatic.com/t/how-to-handle-a-large-number-of-records/273 "2022-07-22T16:51:50Z")
For best practice of handling a large number of records, please follow the below instructions: NB: Please note that the Concurrency settings in the Sync Flow step and the Timeout of the flows are based on the number of … --- ## [How to add a new step](https://community.synatic.com/t/how-to-add-a-new-step/177)
**Author:** [@navessa](https://community.synatic.com/u/navessa)\ **Replies:** 0\ **Last updated:** [January 27, 2022, 2:41pm UTC](https://community.synatic.com/t/how-to-add-a-new-step/177 "2022-01-27T14:41:19Z")
Adding a new step in the new system has become a lot more efficient since the system will only show the applicable steps that you are allowed to add as you build your flow. To create a new flow in the new system, choose… --- ## [How to use the Buffer Query tab in a flow](https://community.synatic.com/t/how-to-use-the-buffer-query-tab-in-a-flow/174)
**Author:** [@navessa](https://community.synatic.com/u/navessa)\ **Replies:** 0\ **Last updated:** [January 27, 2022, 7:42am UTC](https://community.synatic.com/t/how-to-use-the-buffer-query-tab-in-a-flow/174 "2022-01-27T07:42:11Z")
The Buffer Query tab is similar to the buffer query step. It is used to query a buffer using SQL and the tab in a flow, makes it more convenient to query a buffer. It is a universal query page that can be used in any flo… --- ## [How to use the tabs feature](https://community.synatic.com/t/how-to-use-the-tabs-feature/176)
**Author:** [@navessa](https://community.synatic.com/u/navessa)\ **Replies:** 0\ **Last updated:** [January 27, 2022, 11:52am UTC](https://community.synatic.com/t/how-to-use-the-tabs-feature/176 "2022-01-27T11:52:36Z")
The tabs feature allows you to open multiple windows of flows/ connections/ buffers/ relays/ API builders/ operations views as tabs in the system. The tabs feature also allows you to come back to the tabs you had opened… --- ## [Query a buffer with 0, 1, or more parameters](https://community.synatic.com/t/query-a-buffer-with-0-1-or-more-parameters/261)
**Author:** [@mc\_lwcc](https://community.synatic.com/u/mc_lwcc)\ **Replies:** 2\ **Last updated:** [July 4, 2022, 10:39am UTC](https://community.synatic.com/t/query-a-buffer-with-0-1-or-more-parameters/261 "2022-07-04T10:39:25Z")
I have an interesting problem I am trying to solve. I set up an API that can handle 0, 1, or more parameter values. The data from the API will be used to query a buffer and return the results. I am trying to figure out h… --- ## [How to URL encode a field and pass it to an HTTP destination URL](https://community.synatic.com/t/how-to-url-encode-a-field-and-pass-it-to-an-http-destination-url/245)
**Author:** [@navessa](https://community.synatic.com/u/navessa)\ **Replies:** 0\ **Last updated:** [June 7, 2022, 12:14pm UTC](https://community.synatic.com/t/how-to-url-encode-a-field-and-pass-it-to-an-http-destination-url/245 "2022-06-07T12:14:02Z")
Illustrated in the below image are the steps that are used to do URL encoding for a field and pass it to an HTTP destination URL. The below image is the Calculator step where the field “name” is being encoded and conv… --- ## [How to temporarily store a record](https://community.synatic.com/t/how-to-temporarily-store-a-record/229)
**Author:** [@navessa](https://community.synatic.com/u/navessa)\ **Replies:** 0\ **Last updated:** [May 16, 2022, 4:30pm UTC](https://community.synatic.com/t/how-to-temporarily-store-a-record/229 "2022-05-16T16:30:10Z")
A buffer helps to store records but if you require to store a record temporarily, the Cache destination step and the Cache Lookup step are used. Illustrated below is an example of a flow where the Cache destination step… --- ## [How to receive a notification on an instant messaging platform for a failed run](https://community.synatic.com/t/how-to-receive-a-notification-on-an-instant-messaging-platform-for-a-failed-run/197)
**Author:** [@navessa](https://community.synatic.com/u/navessa)\ **Replies:** 0\ **Last updated:** [March 31, 2022, 1:54pm UTC](https://community.synatic.com/t/how-to-receive-a-notification-on-an-instant-messaging-platform-for-a-failed-run/197 "2022-03-31T13:54:25Z")
If you’re unable to access your email and an important run has failed, it is possible for you to receive a notification on an instant messaging platform such as Telegram, SMS, Whatsapp, etc by following the instructions … [Next page](https://community.synatic.com/tag/flows/18.md?match_all_tags=true&page=1&tags%5B%5D=flows)