# \#helper-functions **URL:** https://community.synatic.com/tag/helper-functions/22.md [Latest](https://community.synatic.com/latest.md) · [Categories](https://community.synatic.com/categories.md) · [Tags](https://community.synatic.com/tags.md) --- ## [Synatic's public outgoing IP address based on the region](https://community.synatic.com/t/synatics-public-outgoing-ip-address-based-on-the-region/189)
**Author:** [@navessa](https://community.synatic.com/u/navessa)\ **Replies:** 0\ **Last updated:** [March 8, 2022, 6:35am UTC](https://community.synatic.com/t/synatics-public-outgoing-ip-address-based-on-the-region/189 "2022-03-08T06:35:13Z")
The following are the IP addresses of Synatic which are based on the region. You can copy the IP address according to your region and whitelist it to establish a public connection to Synatic. US: 23.21.172.5 54.85.11… --- ## [How to use the Sage Intacct Service Steps](https://community.synatic.com/t/how-to-use-the-sage-intacct-service-steps/219)
**Author:** [@navessa](https://community.synatic.com/u/navessa)\ **Replies:** 0\ **Last updated:** [May 5, 2022, 2:05pm UTC](https://community.synatic.com/t/how-to-use-the-sage-intacct-service-steps/219 "2022-05-05T14:05:23Z")
This feature is accessible by adding a new connection, a source step or a destination step that connects to Sage Intacct. It is useful when sending or reading explicit data to/ from Sage Intacct. More functions can be do… --- ## [How to group API paths together in the Gateway](https://community.synatic.com/t/how-to-group-api-paths-together-in-the-gateway/310)
**Author:** [@navessa](https://community.synatic.com/u/navessa)\ **Replies:** 0\ **Last updated:** [November 29, 2022, 3:19pm UTC](https://community.synatic.com/t/how-to-group-api-paths-together-in-the-gateway/310 "2022-11-29T15:19:26Z")
If you require to group paths together in the Gateway, please follow the below instructions: Click on Tags in your API configuration setting and add a tag by clicking on the highlighted plus icon. Input a tag name, cli… --- ## [How to reference a parameter in a SQL Server source step](https://community.synatic.com/t/how-to-reference-a-parameter-in-a-sql-server-source-step/241)
**Author:** [@navessa](https://community.synatic.com/u/navessa)\ **Replies:** 0\ **Last updated:** [June 1, 2022, 3:14pm UTC](https://community.synatic.com/t/how-to-reference-a-parameter-in-a-sql-server-source-step/241 "2022-06-01T15:14:47Z")
Illustrated below is an example of a Buffer as a source step, a Calculator step and SQL Server as a source step in a sub-flow. In this example, the data in the buffer are table names that will be used in the SQL Server s… --- ## [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 use the Oracle NetSuite SuiteTalk connection](https://community.synatic.com/t/how-to-use-the-oracle-netsuite-suitetalk-connection/200)
**Author:** [@navessa](https://community.synatic.com/u/navessa)\ **Replies:** 0\ **Last updated:** [April 4, 2022, 4:01pm UTC](https://community.synatic.com/t/how-to-use-the-oracle-netsuite-suitetalk-connection/200 "2022-04-04T16:01:12Z")
This feature is accessible by adding a new connection, a source step or a destination step that connects to Oracle NetSuite SuiteTalk. The below page is where you will fill your NetSuite SuiteTalk credentials to establi… --- ## [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 schedule a flow to run every last day of the month](https://community.synatic.com/t/how-to-schedule-a-flow-to-run-every-last-day-of-the-month/198)
**Author:** [@navessa](https://community.synatic.com/u/navessa)\ **Replies:** 2\ **Last updated:** [August 30, 2023, 4:02pm UTC](https://community.synatic.com/t/how-to-schedule-a-flow-to-run-every-last-day-of-the-month/198 "2023-08-30T16:02:48Z")
Since the last day of the month differs every month, we have found a solution to resolve this issue. NB: Please note that this solution does not accommodate for leap years. Our development team is working on a fix befo… --- ## [How to schedule a flow to run fortnightly](https://community.synatic.com/t/how-to-schedule-a-flow-to-run-fortnightly/369)
**Author:** [@Faizel](https://community.synatic.com/u/Faizel)\ **Replies:** 0\ **Last updated:** [August 3, 2023, 4:17pm UTC](https://community.synatic.com/t/how-to-schedule-a-flow-to-run-fortnightly/369 "2023-08-03T16:17:34Z")
If you require to schedule a flow to run/execute on a specific day every alternative week (fortnightly), please follow the instructions below: Illustrated in the image below is an example of a flow that will get a date … --- ## [Salesforce In step](https://community.synatic.com/t/salesforce-in-step/137)
**Author:** [@navessa](https://community.synatic.com/u/navessa)\ **Replies:** 0\ **Last updated:** [November 17, 2021, 3:36pm UTC](https://community.synatic.com/t/salesforce-in-step/137 "2021-11-17T15:36:21Z")
The Salesforce In step is used as a source step if you want to put an array/ list of data in a field on Salesforce. To create a connection to Salesforce, you must have an account on Salesforce first. To create a connec… --- ## [How to use the HubSpot connection](https://community.synatic.com/t/how-to-use-the-hubspot-connection/221)
**Author:** [@navessa](https://community.synatic.com/u/navessa)\ **Replies:** 0\ **Last updated:** [May 6, 2022, 5:57pm UTC](https://community.synatic.com/t/how-to-use-the-hubspot-connection/221 "2022-05-06T17:57:29Z")
This feature is accessible by adding a new connection, a source step, a lookup step or a destination step that connects to HubSpot. The below page is where you will create a connection by logging into HubSpot to retriev… --- ## [Using utility methods in Calculators](https://community.synatic.com/t/using-utility-methods-in-calculators/185)
**Author:** [@navessa](https://community.synatic.com/u/navessa)\ **Replies:** 0\ **Last updated:** [February 17, 2022, 12:41pm UTC](https://community.synatic.com/t/using-utility-methods-in-calculators/185 "2022-02-17T12:41:25Z")
The below are some utils methods that can be used in a Calculator step. Datatype conversion You can convert a value to a different datatype: let newValue = utils.convert(val, toType, format); Objects You can copy … --- ## [How to call/reference parameters in an API URL](https://community.synatic.com/t/how-to-call-reference-parameters-in-an-api-url/148)
**Author:** [@navessa](https://community.synatic.com/u/navessa)\ **Replies:** 0\ **Last updated:** [December 1, 2021, 2:48pm UTC](https://community.synatic.com/t/how-to-call-reference-parameters-in-an-api-url/148 "2021-12-01T14:48:44Z")
In order to reference or call a parameter value from your API, you need to add the highlighted code in your Calculator step as shown below. This code is used to reference the parameter in your API URL in the HTTP Service… --- ## [How to reference a solution/ global parameter (many static parameters) in a Calculator step & send an email notification](https://community.synatic.com/t/how-to-reference-a-solution-global-parameter-many-static-parameters-in-a-calculator-step-send-an-email-notification/280)
**Author:** [@navessa](https://community.synatic.com/u/navessa)\ **Replies:** 0\ **Last updated:** [August 8, 2022, 4:41pm UTC](https://community.synatic.com/t/how-to-reference-a-solution-global-parameter-many-static-parameters-in-a-calculator-step-send-an-email-notification/280 "2022-08-08T16:41:00Z")
If you require to reference a solution/ global parameter in a Calculator step, follow the below instructions: Illustrated below is an example of a flow where a file is being retrieved from an SFTP Server source step and… --- ## [How to move a file/image from a local machine to Google Drive](https://community.synatic.com/t/how-to-move-a-file-image-from-a-local-machine-to-google-drive/334)
**Author:** [@Faizel](https://community.synatic.com/u/Faizel)\ **Replies:** 0\ **Last updated:** [April 4, 2023, 7:30pm UTC](https://community.synatic.com/t/how-to-move-a-file-image-from-a-local-machine-to-google-drive/334 "2023-04-04T19:30:00Z")
If you require to move a file or image from a local machine to Google Drive, please follow the below instructions: Illustrated below is an example of a flow where a file is moved from a local machine to Google Drive. … --- ## [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 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 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 pin an opened flow tab in your organization](https://community.synatic.com/t/how-to-pin-an-opened-flow-tab-in-your-organization/295)
**Author:** [@navessa](https://community.synatic.com/u/navessa)\ **Replies:** 0\ **Last updated:** [October 7, 2022, 3:03pm UTC](https://community.synatic.com/t/how-to-pin-an-opened-flow-tab-in-your-organization/295 "2022-10-07T15:03:04Z")
If you require to pin an opened flow tab in your organization, click on the highlighted 3 dots in the tab as illustrated in the image below. This feature is helpful when you want to keep referring to one or more flows w… --- ## [How to export specific records from a run](https://community.synatic.com/t/how-to-export-specific-records-from-a-run/306)
**Author:** [@navessa](https://community.synatic.com/u/navessa)\ **Replies:** 0\ **Last updated:** [November 9, 2022, 1:37pm UTC](https://community.synatic.com/t/how-to-export-specific-records-from-a-run/306 "2022-11-09T13:37:21Z")
If you require to export specific records from a run, please follow the below instructions: NB: Please ensure that the records you require to export (completed, errors or skipped) is being logged using the Log Record E… --- ## [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.… [Next page](https://community.synatic.com/tag/helper-functions/22.md?match_all_tags=true&page=1&tags%5B%5D=helper-functions)