# FAQs **URL:** https://community.synatic.com/c/faqs/6.md?page=1 [Latest](https://community.synatic.com/latest.md) · [Categories](https://community.synatic.com/categories.md) · [Tags](https://community.synatic.com/tags.md) **Page:** 2 --- ## [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 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 create a PDF file that contains tables and graphs](https://community.synatic.com/t/how-to-create-a-pdf-file-that-contains-tables-and-graphs/387)
**Author:** [@Faizel](https://community.synatic.com/u/Faizel)\ **Replies:** 0\ **Last updated:** [October 9, 2023, 7:43pm UTC](https://community.synatic.com/t/how-to-create-a-pdf-file-that-contains-tables-and-graphs/387 "2023-10-09T19:43:00Z")
If you require to create a PDF file that contains tables and graphs, please follow the below instructions: Illustrated in the image below is an example of a flow that utilizes static data to generate tables and graphs. … --- ## [How to reference a solution parameter in the Subject field of an Email destination step](https://community.synatic.com/t/how-to-reference-a-solution-parameter-in-the-subject-field-of-an-email-destination-step/385)
**Author:** [@Faizel](https://community.synatic.com/u/Faizel)\ **Replies:** 0\ **Last updated:** [October 9, 2023, 6:49pm UTC](https://community.synatic.com/t/how-to-reference-a-solution-parameter-in-the-subject-field-of-an-email-destination-step/385 "2023-10-09T18:49:33Z")
If you require to send emails to the same list of recipients in multiple flows, please follow the below instructions: Illustrated below is an example of how to create a solution parameter and populate the Email destinat… --- ## [How to setup and use Slack's API for reporting](https://community.synatic.com/t/how-to-setup-and-use-slacks-api-for-reporting/370)
**Author:** [@Faizel](https://community.synatic.com/u/Faizel)\ **Replies:** 0\ **Last updated:** [August 14, 2023, 10:23am UTC](https://community.synatic.com/t/how-to-setup-and-use-slacks-api-for-reporting/370 "2023-08-14T10:23:38Z")
How to setup and use Slack's API for reporting If you have access to a Slack account and would like to receive notifications from Synatic, please follow the below instructions: Illustrated below are the steps to setup S… --- ## [How to upload a PDF file to Salesforce](https://community.synatic.com/t/how-to-upload-a-pdf-file-to-salesforce/368)
**Author:** [@Faizel](https://community.synatic.com/u/Faizel)\ **Replies:** 0\ **Last updated:** [August 3, 2023, 11:47am UTC](https://community.synatic.com/t/how-to-upload-a-pdf-file-to-salesforce/368 "2023-08-03T11:47:49Z")
If you require to upload a PDF file to Salesforce, please follow the below instructions: Illustrated in the image below is an example of a flow that receives a PDF file via a REST API, converts it from byte data to byte… --- ## [How to retrieve specific files from an SFTP Server using a regex pattern](https://community.synatic.com/t/how-to-retrieve-specific-files-from-an-sftp-server-using-a-regex-pattern/372)
**Author:** [@Faizel](https://community.synatic.com/u/Faizel)\ **Replies:** 0\ **Last updated:** [August 15, 2023, 10:30am UTC](https://community.synatic.com/t/how-to-retrieve-specific-files-from-an-sftp-server-using-a-regex-pattern/372 "2023-08-15T10:30:59Z")
If you require to retrieve specific files based on the file name from an SFTP Server, please follow the below instructions: Illustrated in the image below is an example of how a regex pattern is used in a flow to search… --- ## [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 … --- ## [How to automatically create connections](https://community.synatic.com/t/how-to-automatically-create-connections/377)
**Author:** [@Faizel](https://community.synatic.com/u/Faizel)\ **Replies:** 0\ **Last updated:** [August 24, 2023, 3:03pm UTC](https://community.synatic.com/t/how-to-automatically-create-connections/377 "2023-08-24T15:03:37Z")
If you require to create a connection at run time (when executing the flow), please follow the below instructions: Obtain the name of Org and Synatic Admin API key. Click on the user menu which is located on the top ri… --- ## [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 convert a Word document to a PDF file and send it as an email](https://community.synatic.com/t/how-to-convert-a-word-document-to-a-pdf-file-and-send-it-as-an-email/336)
**Author:** [@Faizel](https://community.synatic.com/u/Faizel)\ **Replies:** 0\ **Last updated:** [April 6, 2023, 1:26pm UTC](https://community.synatic.com/t/how-to-convert-a-word-document-to-a-pdf-file-and-send-it-as-an-email/336 "2023-04-06T13:26:07Z")
If you require to convert a Word document to a PDF file and send it as an email, please follow the below instructions: Illustrated in the image below is an example of a flow where a Word document from a local machine is… --- ## [How to create one Excel file from multiple data sources](https://community.synatic.com/t/how-to-create-one-excel-file-from-multiple-data-sources/357)
**Author:** [@Faizel](https://community.synatic.com/u/Faizel)\ **Replies:** 0\ **Last updated:** [June 20, 2023, 1:51pm UTC](https://community.synatic.com/t/how-to-create-one-excel-file-from-multiple-data-sources/357 "2023-06-20T13:51:38Z")
If you require create one Excel file from multiple data sources, please follow the below instructions: Illustrated below is an example of a flow that return data from 2 sources. The first query will count the number of… --- ## [How to use the Rocket U2 relay](https://community.synatic.com/t/how-to-use-the-rocket-u2-relay/359)
**Author:** [@praise](https://community.synatic.com/u/praise)\ **Replies:** 0\ **Last updated:** [June 22, 2023, 2:00pm UTC](https://community.synatic.com/t/how-to-use-the-rocket-u2-relay/359 "2023-06-22T14:00:40Z")
Rocket U2 is an application platform that is used to interact with a Rocket database. This can be done by creating a relay. NB: Rocket U2 Relays will allow you to interact with the Rocket database using Rocket TCL comma… --- ## [How to save a list of file names from Google Drive](https://community.synatic.com/t/how-to-save-a-list-of-file-names-from-google-drive/350)
**Author:** [@Faizel](https://community.synatic.com/u/Faizel)\ **Replies:** 0\ **Last updated:** [May 10, 2023, 7:41am UTC](https://community.synatic.com/t/how-to-save-a-list-of-file-names-from-google-drive/350 "2023-05-10T07:41:14Z")
If you require to save a list of file names from Google Drive, please follow the below instructions Illustrated below is an example of a flow that returns a list of files from a Google Drive folder and then saves each f… --- ## [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 delete/remove duplicate records when inserting into a buffer](https://community.synatic.com/t/how-to-delete-remove-duplicate-records-when-inserting-into-a-buffer/353)
**Author:** [@Faizel](https://community.synatic.com/u/Faizel)\ **Replies:** 0\ **Last updated:** [May 17, 2023, 10:34am UTC](https://community.synatic.com/t/how-to-delete-remove-duplicate-records-when-inserting-into-a-buffer/353 "2023-05-17T10:34:43Z")
If you require to delete/remove duplicate records when inserting into a buffer, please follow the instructions below: Illustrated in the image below is an example of a flow that ingests an Excel file containing duplicat… --- ## [How to decode base64 string to text](https://community.synatic.com/t/how-to-decode-base64-string-to-text/347)
**Author:** [@Faizel](https://community.synatic.com/u/Faizel)\ **Replies:** 0\ **Last updated:** [May 3, 2023, 2:46pm UTC](https://community.synatic.com/t/how-to-decode-base64-string-to-text/347 "2023-05-03T14:46:37Z")
If you require to decode a base64 string to text, please follow the instructions below: Illustrated in the image below is an example of a flow where the payload is from a Record Generator source step which decodes the b… --- ## [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 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 rename buffer fields that contains special characters](https://community.synatic.com/t/how-to-rename-buffer-fields-that-contains-special-characters/342)
**Author:** [@Faizel](https://community.synatic.com/u/Faizel)\ **Replies:** 0\ **Last updated:** [April 24, 2023, 2:55pm UTC](https://community.synatic.com/t/how-to-rename-buffer-fields-that-contains-special-characters/342 "2023-04-24T14:55:50Z")
If you require to rename buffer fields that contains special characters, please follow the instructions below: Illustrated in the image below is an example of a flow that reads an Excel spreadsheet, fixes the invalid fi… --- ## [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 convert a Base64 string to a PDF file](https://community.synatic.com/t/how-to-convert-a-base64-string-to-a-pdf-file/339)
**Author:** [@Faizel](https://community.synatic.com/u/Faizel)\ **Replies:** 0\ **Last updated:** [April 6, 2023, 2:50pm UTC](https://community.synatic.com/t/how-to-convert-a-base64-string-to-a-pdf-file/339 "2023-04-06T14:50:44Z")
If you require to convert a Base64 string to a PDF file, please follow the below instructions: Illustrated in the below image is an example of a flow where a Record Generator is used as a source step to store the Base64… --- ## [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 send data to dynamic buffers at runtime](https://community.synatic.com/t/how-to-send-data-to-dynamic-buffers-at-runtime/331)
**Author:** [@navessa](https://community.synatic.com/u/navessa)\ **Replies:** 0\ **Last updated:** [March 14, 2023, 1:05pm UTC](https://community.synatic.com/t/how-to-send-data-to-dynamic-buffers-at-runtime/331 "2023-03-14T13:05:14Z")
If you require to send data to dynamic buffers, please follow the below instructions: NB: This works for all operations/ methods (inserting, upserting, updating and deleting) in a buffer. Illustrated in the image belo… --- ## [How to create a Buffer View](https://community.synatic.com/t/how-to-create-a-buffer-view/329)
**Author:** [@navessa](https://community.synatic.com/u/navessa)\ **Replies:** 0\ **Last updated:** [March 13, 2023, 6:20pm UTC](https://community.synatic.com/t/how-to-create-a-buffer-view/329 "2023-03-13T18:20:46Z")
This feature assists when you want to view specific data from a buffer. It works similar to a SQL View where a user will be able to customize what data they can view from a table in the database (buffer data gets stored … [Previous page](https://community.synatic.com/c/faqs/6.md) [Next page](https://community.synatic.com/c/faqs/6.md?page=2)