# FAQs **URL:** https://community.synatic.com/c/faqs/6.md?page=2 [Latest](https://community.synatic.com/latest.md) · [Categories](https://community.synatic.com/categories.md) · [Tags](https://community.synatic.com/tags.md) **Page:** 3 --- ## [How to view the flows that are being used by a specific endpoint in a relay](https://community.synatic.com/t/how-to-view-the-flows-that-are-being-used-by-a-specific-endpoint-in-a-relay/327)
**Author:** [@navessa](https://community.synatic.com/u/navessa)\ **Replies:** 0\ **Last updated:** [March 10, 2023, 3:31pm UTC](https://community.synatic.com/t/how-to-view-the-flows-that-are-being-used-by-a-specific-endpoint-in-a-relay/327 "2023-03-10T15:31:55Z")
This feature assists when debugging a relay that is failing due to one of the endpoints losing connectivity (system issue or server issue where the system is installed on) and if you need to view the flows where the endp… --- ## [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 reference Javascript code (one static parameter) that can be used globally or in a specific solution in your organization](https://community.synatic.com/t/how-to-reference-javascript-code-one-static-parameter-that-can-be-used-globally-or-in-a-specific-solution-in-your-organization/281)
**Author:** [@navessa](https://community.synatic.com/u/navessa)\ **Replies:** 0\ **Last updated:** [August 8, 2022, 5:15pm UTC](https://community.synatic.com/t/how-to-reference-javascript-code-one-static-parameter-that-can-be-used-globally-or-in-a-specific-solution-in-your-organization/281 "2022-08-08T17:15:34Z")
To reference Javascript code that can be used globally or in a specific solution using a Calculator step, follow the below instructions: Create a parameter in the Global solution or in the required solution by clicking… --- ## [How to integrate buffer data from one organization to another organization](https://community.synatic.com/t/how-to-integrate-buffer-data-from-one-organization-to-another-organization/323)
**Author:** [@navessa](https://community.synatic.com/u/navessa)\ **Replies:** 0\ **Last updated:** [February 7, 2023, 6:49pm UTC](https://community.synatic.com/t/how-to-integrate-buffer-data-from-one-organization-to-another-organization/323 "2023-02-07T18:49:32Z")
Linking buffers when linking organizations does link the buffer schema but it does not integrate the buffer data/ values. In order to integrate the buffer data/ values, please follow the below instructions: NB: It cons… --- ## [How to add a token as a parameter and reference it in the HTTP Service destination step](https://community.synatic.com/t/how-to-add-a-token-as-a-parameter-and-reference-it-in-the-http-service-destination-step/321)
**Author:** [@navessa](https://community.synatic.com/u/navessa)\ **Replies:** 0\ **Last updated:** [February 7, 2023, 3:57pm UTC](https://community.synatic.com/t/how-to-add-a-token-as-a-parameter-and-reference-it-in-the-http-service-destination-step/321 "2023-02-07T15:57:56Z")
If you require to add a token as a parameter and reference it in the HTTP Service destination step, please follow the below instructions: The token is first added as a parameter using JSON code in the Calculator step a… --- ## [How to reference a record in the Text Template mapper step](https://community.synatic.com/t/how-to-reference-a-record-in-the-text-template-mapper-step/320)
**Author:** [@navessa](https://community.synatic.com/u/navessa)\ **Replies:** 0\ **Last updated:** [January 30, 2023, 7:47am UTC](https://community.synatic.com/t/how-to-reference-a-record-in-the-text-template-mapper-step/320 "2023-01-30T07:47:33Z")
If you are using the Text Template mapper step, you can reference your record by using the below syntax as shown in the image below: {{record.fieldName}} --- ## [How to connect to Sage 300 People](https://community.synatic.com/t/how-to-connect-to-sage-300-people/316)
**Author:** [@navessa](https://community.synatic.com/u/navessa)\ **Replies:** 0\ **Last updated:** [January 20, 2023, 11:17am UTC](https://community.synatic.com/t/how-to-connect-to-sage-300-people/316 "2023-01-20T11:17:41Z")
If you require to connect to Sage 300 People’s API, please follow the below instructions: Get the token by using the HTTP Service step and following the instructions in the below Sage 300 People API documentation link: … --- ## [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 action a file from an SFTP Server or an FTP Server](https://community.synatic.com/t/how-to-action-a-file-from-an-sftp-server-or-an-ftp-server/235)
**Author:** [@navessa](https://community.synatic.com/u/navessa)\ **Replies:** 0\ **Last updated:** [May 30, 2022, 11:57am UTC](https://community.synatic.com/t/how-to-action-a-file-from-an-sftp-server-or-an-ftp-server/235 "2022-05-30T11:57:43Z")
If you require to create a path, delete a path, delete a file, move a file or copy a file on the SFTP or FTP Server, the FTP or SFTP Actions destination step will be used. This step ensures that the function will work as… --- ## [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 encrypt an OpenPGP file](https://community.synatic.com/t/how-to-encrypt-an-openpgp-file/305)
**Author:** [@navessa](https://community.synatic.com/u/navessa)\ **Replies:** 0\ **Last updated:** [November 9, 2022, 1:12pm UTC](https://community.synatic.com/t/how-to-encrypt-an-openpgp-file/305 "2022-11-09T13:12:24Z")
If you require to encrypt an OpenPGP file , please follow the below instructions: Illustrated below is an example of a flow where data in a CSV file is being read, the CSV file is being created and then encrypted into a… --- ## [How to decrypt an OpenPGP file](https://community.synatic.com/t/how-to-decrypt-an-openpgp-file/297)
**Author:** [@navessa](https://community.synatic.com/u/navessa)\ **Replies:** 0\ **Last updated:** [October 12, 2022, 5:01pm UTC](https://community.synatic.com/t/how-to-decrypt-an-openpgp-file/297 "2022-10-12T17:01:06Z")
If you require to decrypt an OpenPGP file, please follow the below instructions: Illustrated below is how the flow will look to decrypt the OpenPGP file. The Record Generator is being used as a source step and is empty.… --- ## [How to action a file from your local machine/ a Relay Based File System source step](https://community.synatic.com/t/how-to-action-a-file-from-your-local-machine-a-relay-based-file-system-source-step/288)
**Author:** [@navessa](https://community.synatic.com/u/navessa)\ **Replies:** 0\ **Last updated:** [September 7, 2022, 2:10pm UTC](https://community.synatic.com/t/how-to-action-a-file-from-your-local-machine-a-relay-based-file-system-source-step/288 "2022-09-07T14:10:45Z")
If you require to create a path, delete a path, delete a file, move a file or copy a file on the SFTP or FTP Server, the Relay Based File System Actions destination step will be used. This step ensures that the function … --- ## [How to send data to Snowflake](https://community.synatic.com/t/how-to-send-data-to-snowflake/304)
**Author:** [@navessa](https://community.synatic.com/u/navessa)\ **Replies:** 0\ **Last updated:** [October 26, 2022, 7:11pm UTC](https://community.synatic.com/t/how-to-send-data-to-snowflake/304 "2022-10-26T19:11:49Z")
If you require to send data to Snowflake, there are 3 methods that can be used: Click on the highlighted plus icon in the Snowflake destination step as illustrated in the image below to create a connection. The belo… --- ## [How to use the Snowflake connection](https://community.synatic.com/t/how-to-use-the-snowflake-connection/215)
**Author:** [@navessa](https://community.synatic.com/u/navessa)\ **Replies:** 0\ **Last updated:** [April 21, 2022, 4:18pm UTC](https://community.synatic.com/t/how-to-use-the-snowflake-connection/215 "2022-04-21T16:18:19Z")
This feature is accessible by adding a new connection for a source step or destination step that connects to Snowflake . The below page is where you will fill your Snowflake credentials to establish a connection. This p… --- ## [How to change a connection at run time](https://community.synatic.com/t/how-to-change-a-connection-at-run-time/265)
**Author:** [@navessa](https://community.synatic.com/u/navessa)\ **Replies:** 3\ **Last updated:** [October 24, 2022, 1:59pm UTC](https://community.synatic.com/t/how-to-change-a-connection-at-run-time/265 "2022-10-24T13:59:20Z")
This feature is useful when using one connection with many user credentials in a flow. It has the ability to change the connection at run time. NB: Please note that the connections with the different user credentials ha… --- ## [How to connect to Sharepoint using the HTTP Service destination steps](https://community.synatic.com/t/how-to-connect-to-sharepoint-using-the-http-service-destination-steps/225)
**Author:** [@navessa](https://community.synatic.com/u/navessa)\ **Replies:** 0\ **Last updated:** [May 12, 2022, 12:27pm UTC](https://community.synatic.com/t/how-to-connect-to-sharepoint-using-the-http-service-destination-steps/225 "2022-05-12T12:27:16Z")
We currently do not have a Sharepoint connector available. To connect to Sharepoint, the following needs to be done: NB: Our developers are developing a Sharepoint connector. Once it is released, this article will no lo… --- ## [How to delete a duplicate record/ element in an array](https://community.synatic.com/t/how-to-delete-a-duplicate-record-element-in-an-array/294)
**Author:** [@navessa](https://community.synatic.com/u/navessa)\ **Replies:** 0\ **Last updated:** [October 7, 2022, 1:18pm UTC](https://community.synatic.com/t/how-to-delete-a-duplicate-record-element-in-an-array/294 "2022-10-07T13:18:22Z")
The below example is how to delete a duplicate record/ element in an array. Illustrated below is an example payload that is used in a Record Generator source step. As shown in the image, there are 2 records/ elements in… --- ## [How to move a specific file type from one path to another in your local machine](https://community.synatic.com/t/how-to-move-a-specific-file-type-from-one-path-to-another-in-your-local-machine/293)
**Author:** [@navessa](https://community.synatic.com/u/navessa)\ **Replies:** 0\ **Last updated:** [September 27, 2022, 5:13pm UTC](https://community.synatic.com/t/how-to-move-a-specific-file-type-from-one-path-to-another-in-your-local-machine/293 "2022-09-27T17:13:08Z")
If you require to move a specific file type from one path to another in your local machine, follow the below instructions: Illustrated in the images below is how the flow will look. The File System List source step is b… --- ## [Inserting a new line in a string](https://community.synatic.com/t/inserting-a-new-line-in-a-string/286)
**Author:** [@mc\_lwcc](https://community.synatic.com/u/mc_lwcc)\ **Replies:** 5\ **Last updated:** [September 2, 2022, 2:19pm UTC](https://community.synatic.com/t/inserting-a-new-line-in-a-string/286 "2022-09-02T14:19:51Z")
Is there a way to introduce a new line character in a string variable? I tried several variations on the new line character but they all resulted in errors. "\\n" "\\\\n" "\\\\\\\\n" I am trying insert a new line between two… --- ## [Azure DevOps Connector?](https://community.synatic.com/t/azure-devops-connector/284)
**Author:** [@mc\_lwcc](https://community.synatic.com/u/mc_lwcc)\ **Replies:** 3\ **Last updated:** [September 2, 2022, 7:53am UTC](https://community.synatic.com/t/azure-devops-connector/284 "2022-09-02T07:53:13Z")
I was wondering if there was a connector for Azure DevOps. If not, is there a way to do basic auth using only a password? I am trying to build out a flow to take records and post them to a DevOps board to create tasks. … --- ## [How to manipulate records in an array](https://community.synatic.com/t/how-to-manipulate-records-in-an-array/285)
**Author:** [@navessa](https://community.synatic.com/u/navessa)\ **Replies:** 0\ **Last updated:** [August 31, 2022, 8:47pm UTC](https://community.synatic.com/t/how-to-manipulate-records-in-an-array/285 "2022-08-31T20:47:09Z")
The below are examples of how you can manipulate records in an array. Illustrated below is an example of a JSON payload that has an array. To remove an email domain from the Email field (trim a field with a specific … --- ## [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 read an Excel attachment and email details/ file name from an email trigger](https://community.synatic.com/t/how-to-read-an-excel-attachment-and-email-details-file-name-from-an-email-trigger/279)
**Author:** [@navessa](https://community.synatic.com/u/navessa)\ **Replies:** 0\ **Last updated:** [August 4, 2022, 12:58pm UTC](https://community.synatic.com/t/how-to-read-an-excel-attachment-and-email-details-file-name-from-an-email-trigger/279 "2022-08-04T12:58:40Z")
If you require to read an Excel attachment and email details (file name) from an email trigger, please follow the below instructions: Illustrated below is an example of how the flow will look. It consists of an Email tr… --- ## [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 split values in a field and return the values as 2 separate records](https://community.synatic.com/t/how-to-split-values-in-a-field-and-return-the-values-as-2-separate-records/274)
**Author:** [@navessa](https://community.synatic.com/u/navessa)\ **Replies:** 0\ **Last updated:** [July 22, 2022, 5:30pm UTC](https://community.synatic.com/t/how-to-split-values-in-a-field-and-return-the-values-as-2-separate-records/274 "2022-07-22T17:30:05Z")
Illustrated below is an example of a flow where the Record Generator is used as a source step. The image below consists of the data that is in the Record Generator step. The output of the data in the Record Generat… --- ## [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 call the current date & change the date format](https://community.synatic.com/t/how-to-call-the-current-date-change-the-date-format/147)
**Author:** [@navessa](https://community.synatic.com/u/navessa)\ **Replies:** 0\ **Last updated:** [December 1, 2021, 2:23pm UTC](https://community.synatic.com/t/how-to-call-the-current-date-change-the-date-format/147 "2021-12-01T14:23:50Z")
In order to call/ reference the current date, you need to do the following. Add a Calculator step in your flow. You can customize your code to suit the required output. Below is the code that is used in the calculator… --- ## [How to send or retrieve/ get binary data from an API](https://community.synatic.com/t/how-to-send-or-retrieve-get-binary-data-from-an-api/270)
**Author:** [@navessa](https://community.synatic.com/u/navessa)\ **Replies:** 0\ **Last updated:** [July 14, 2022, 1:25pm UTC](https://community.synatic.com/t/how-to-send-or-retrieve-get-binary-data-from-an-api/270 "2022-07-14T13:25:48Z")
To send or retrieve/ get binary data from an API, you can add the below Content-Type as a header in the HTTP Service step. application/octet-stream The header in your HTTP Service step will look like the below image. … [Previous page](https://community.synatic.com/c/faqs/6.md?page=1) [Next page](https://community.synatic.com/c/faqs/6.md?page=3)