# Synatic Help Center

> Help Articles From The Synatic Team

## Getting Started

- [Welcome to Synatic](http://help.synatic.com/en/articles/4175316-welcome-to-synatic.md): Introduction and overview of Synatic
- [Introduction](http://help.synatic.com/en/articles/4567745-introduction.md): What is Synatic? How can I get value from using Synatic?
- [Setting up your account](http://help.synatic.com/en/articles/4619382-setting-up-your-account.md): How to create an account on Synatic
- [The Synatic Web Interface](http://help.synatic.com/en/articles/4568526-the-synatic-web-interface.md): The basics of the web interface
- [Create Your First Flow](http://help.synatic.com/en/articles/4621259-create-your-first-flow.md): Read data from Google Sheets, map it to different fields and insert in a buffer
- [Adding a trigger to your flow](http://help.synatic.com/en/articles/4628974-adding-a-trigger-to-your-flow.md): Triggers can start flows based on an event or schedule
- [Menu Bar - Dashboard](http://help.synatic.com/en/articles/9292326-menu-bar-dashboard.md): Monitor various aspects through the Dashboard when you login.
- [Menu Bar - Flow Triggers](http://help.synatic.com/en/articles/4717410-menu-bar-flow-triggers.md): Monitor all Trigger steps added to your Synatic Flows
- [Menu Bar – Relays](http://help.synatic.com/en/articles/9292407-menu-bar-relays.md): Monitor Relays created in Synatic.
- [Menu Bar – Runs](http://help.synatic.com/en/articles/9292254-menu-bar-runs.md): Monitor Runs in Synatic.
- [Menu Bar - Run Analysis](http://help.synatic.com/en/articles/9292457-menu-bar-run-analysis.md): Analyze Runs and see details in graph form.
- [Menu Bar - Search Bar](http://help.synatic.com/en/articles/9292294-menu-bar-search-bar.md): Search for flows, solutions etc.
- [Account Menu - Your Profile](http://help.synatic.com/en/articles/8040043-account-menu-your-profile.md)
- [Account Menu - Settings](http://help.synatic.com/en/articles/4717364-account-menu-settings.md): Manage organization settings for your Synatic account
- [Account Menu - Storage Stats](http://help.synatic.com/en/articles/8040004-account-menu-storage-stats.md)
- [Account Menu - User Groups](http://help.synatic.com/en/articles/8015883-account-menu-user-groups.md)
- [Account Menu - Users](http://help.synatic.com/en/articles/4717343-account-menu-users.md): Manage users for your Synatic organization
- [Account Menu - Deactivated Users](http://help.synatic.com/en/articles/7990496-account-menu-deactivated-users.md)
- [Account Menu - Event Log](http://help.synatic.com/en/articles/4717374-account-menu-event-log.md): Monitor the events occurring in your Synatic organization
- [Account Menu - Change Log](http://help.synatic.com/en/articles/4717379-account-menu-change-log.md): Monitor all changes that are made to your Synatic organization
- [Account Menu - Ops Portal](http://help.synatic.com/en/articles/9121950-account-menu-ops-portal.md): The Ops Portal tab is used to access ops views that a user has been added to.
- [Reactivate User](http://help.synatic.com/en/articles/7994757-reactivate-user.md): How to reactivate a user
- [Organization Name Recovery & Password Recovery](http://help.synatic.com/en/articles/7994792-organization-name-recovery-password-recovery.md): How to recover forgotten organization name and password
- [Account Menu - Linked Orgs](http://help.synatic.com/en/articles/8967073-account-menu-linked-orgs.md): The Linked Orgs tab is used to create and manage linked organizations.
- [Organization Linking](http://help.synatic.com/en/articles/5252858-organization-linking.md): A tutorial on creating Org Links/sync between Synatic instances.

## Common Errors

- [INSUFFICIENT\_ACCESS\_ON\_CROSS\_REFERENCE\_ENTITY](http://help.synatic.com/en/articles/10228296-insufficient_access_on_cross_reference_entity.md): Step: Salesforce Content Version Destination
- [Ns not found](http://help.synatic.com/en/articles/10300010-ns-not-found.md): Step: Buffer Source / Buffer Query / Buffer Lookup
- [Cursor\_Not\_Found](http://help.synatic.com/en/articles/10300023-cursor_not_found.md): Step: Buffer Steps
- [Error\_During\_getMore](http://help.synatic.com/en/articles/10300055-error_during_getmore.md): All buffer source steps.
- [Connection\_Closed](http://help.synatic.com/en/articles/10300069-connection_closed.md): Connection error.
- [Connection\_to\_Mongodb\_Interrupted](http://help.synatic.com/en/articles/10300098-connection_to_mongodb_interrupted.md): Mongodb connection
- [Upsert sObject HTTP Error](http://help.synatic.com/en/articles/10410418-upsert-sobject-http-error.md): Upsert Error on Salesforce Destination Step.
- [Socket 'secureConnect' timed out](http://help.synatic.com/en/articles/10410453-socket-secureconnect-timed-out.md): This error can occur on any step that connects to an API via HTTPS.
- [Mercantile Web Service Destination Step Error](http://help.synatic.com/en/articles/10455219-mercantile-web-service-destination-step-error.md): How to fix the Mercantile Web Service Destination Step Error
- [Salesforce Token Refresh](http://help.synatic.com/en/articles/10455236-salesforce-token-refresh.md): Details about the Salesforce Token Refresh Error on the Salesforce Lookup Mapper Step
- [OCR Form page does not have a model attached](http://help.synatic.com/en/articles/10455246-ocr-form-page-does-not-have-a-model-attached.md): Details on the OCR Form Error.
- [URL encoding - Error: "Invalid URL"](http://help.synatic.com/en/articles/10473404-url-encoding-error-invalid-url.md): "Invalid URL"\` when trying to parse a parameter as part of a URL
- [Flow Timed Out Error](http://help.synatic.com/en/articles/10473344-flow-timed-out-error.md): Flow Timed Out Error Explained
- [Connection to xxxxxxxx.mongodb.net:27017 interrupted](http://help.synatic.com/en/articles/10490140-connection-to-xxxxxxxx-mongodb-net-27017-interrupted.md): Mongodb Connection on Buffer Source/Buffer Query/Buffer Lookup/Buffer Destination error explained.
- [Cannot index parallel arrays](http://help.synatic.com/en/articles/10490207-cannot-index-parallel-arrays.md): Parallel arrays error explained.
- [SQL Transaction Deadlock Error](http://help.synatic.com/en/articles/10490262-sql-transaction-deadlock-error.md): SQL Transaction deadlock error explained.
- [Error Connecting to Relay](http://help.synatic.com/en/articles/10490294-error-connecting-to-relay.md): Connection to Relay on SQL steps error explained.
- [ECONNRESET Error](http://help.synatic.com/en/articles/10515693-econnreset-error.md): ECONNRESET Error explained.
- [Error on Action Request - Acumatica Step](http://help.synatic.com/en/articles/10515706-error-on-action-request-acumatica-step.md): Error on Action Request \(on Acumatica steps\) explained.
- [Buffer Query Error](http://help.synatic.com/en/articles/10515711-buffer-query-error.md): Buffer Query Error explained.
- [Error Retrieving Array Value](http://help.synatic.com/en/articles/10515729-error-retrieving-array-value.md): Error retrieving array value error explained on Split and ForEach steps.
- [Unable to call service \`ETIMEDOUT\`](http://help.synatic.com/en/articles/10515736-unable-to-call-service-etimedout.md): Unable to call service \`ETIMEDOUT\` on HTTP Step explained.
- [Error Executing SQL Command](http://help.synatic.com/en/articles/10515748-error-executing-sql-command.md): Error Executing SQL Command explained on the SQL server.
- [Salesforce Content Version Error](http://help.synatic.com/en/articles/10550409-salesforce-content-version-error.md): Salesforce Content Version error explained.
- [Relay Polling Timed Out Error](http://help.synatic.com/en/articles/10550451-relay-polling-timed-out-error.md): Relay Polling Timed Out error explained.
- [Error Encrypting-ERR\_CRYPTO\_INVALID\_IV](http://help.synatic.com/en/articles/10550467-error-encrypting-err_crypto_invalid_iv.md): Error Encrypting explained.
- [Error Encrypting - ERR\_CRYPTO\_INVALID\_KEYLEN](http://help.synatic.com/en/articles/10550492-error-encrypting-err_crypto_invalid_keylen.md): Error Encrypting - Invalid key error explained.
- [Salesforce ClientInputError](http://help.synatic.com/en/articles/10550508-salesforce-clientinputerror.md): ClientInputError in the Salesforce Bulk V2 Destination step explained.
- [HTTP Error Response](http://help.synatic.com/en/articles/10750213-http-error-response.md): HTTP Error Response Explained
- [Error with oAuth refresh token request](http://help.synatic.com/en/articles/10851768-error-with-oauth-refresh-token-request.md): oAuth refresh token request error on Salesforce.
- [Error executing SQL command - Could not find stored procedure](http://help.synatic.com/en/articles/10851854-error-executing-sql-command-could-not-find-stored-procedure.md): Executing SQL command error explained.
- [Error running calculation](http://help.synatic.com/en/articles/10852035-error-running-calculation.md): Error running calculation explained.
- [SQL Server Unable to Load Subflow](http://help.synatic.com/en/articles/10852262-sql-server-unable-to-load-subflow.md): SQL Server Unable to Load Subflow error explained.
- [Connection Timeout Error.](http://help.synatic.com/en/articles/10852337-connection-timeout-error.md): Connection to {IP Address}:27017 timed out error explained.
- [Hubspot Service Error](http://help.synatic.com/en/articles/11001330-hubspot-service-error.md): Hubspot Service Error explained: Unable to parse objectId NaN
- [Error with oAuth refresh token](http://help.synatic.com/en/articles/11001388-error-with-oauth-refresh-token.md): Error with oAuth refresh token explained.
- [Hubspot Service Error - Contact already exists](http://help.synatic.com/en/articles/11001425-hubspot-service-error-contact-already-exists.md): Hubspot Service Error explained - Contact already exists
- [Hubspot Service Error - Invalid input JSON](http://help.synatic.com/en/articles/11001484-hubspot-service-error-invalid-input-json.md): Hubspot Service Error explained - Invalid input JSON
- [Error getting lock for oAuth request](http://help.synatic.com/en/articles/11001534-error-getting-lock-for-oauth-request.md): Error getting lock for oAuth request explained.
- [S3 Bucket Timeouts Error](http://help.synatic.com/en/articles/11001581-s3-bucket-timeouts-error.md): S3 Bucket Timeouts Error explained.
- [Vend Error connecting - Invalid grant](http://help.synatic.com/en/articles/11051711-vend-error-connecting-invalid-grant.md): Vend connection error explained.
- [Connection Timeout Error](http://help.synatic.com/en/articles/11051717-connection-timeout-error.md): Connection Timeout Error explained.
- [API Key Authorization Error](http://help.synatic.com/en/articles/11051728-api-key-authorization-error.md): API Key Authorization Error explained.
- [Invalid Array Value Error](http://help.synatic.com/en/articles/11051752-invalid-array-value-error.md): Invalid Array Value Error explained.
- [Error Running Calculation - Unidentified Variables](http://help.synatic.com/en/articles/11051768-error-running-calculation-unidentified-variables.md): Error running calculation: Cannot read properties of undefined \(Reading '{someVariable}'\)
- [Buffer Query Error](http://help.synatic.com/en/articles/11064807-buffer-query-error.md): Buffer Query Error explained.
- [Error running calculation - Invalid condition result \(Boolean\)](http://help.synatic.com/en/articles/11064839-error-running-calculation-invalid-condition-result-boolean.md): Error running calculation - Invalid condition result. Must be Boolean
- [Error connecting to SFTP server](http://help.synatic.com/en/articles/11064853-error-connecting-to-sftp-server.md): Connecting to SFTP server error explained.
- [Upload Listings to Findigs Failed](http://help.synatic.com/en/articles/11064876-upload-listings-to-findigs-failed.md): Upload Listings to Findigs Failed error explained.
- [SOQL Query HTTP Error](http://help.synatic.com/en/articles/11064905-soql-query-http-error.md): SOQL Query HTTP Error explained.
- [E11000 Duplicate Key Error](http://help.synatic.com/en/articles/11388862-e11000-duplicate-key-error.md): E11000 duplicate key error collection explained
- [Calculator Validation Error - Unexpected Token](http://help.synatic.com/en/articles/11388886-calculator-validation-error-unexpected-token.md): Calculator Validation Error \(Unexpected Token\) explained.
- [Invalid Column Type Error](http://help.synatic.com/en/articles/11388950-invalid-column-type-error.md): Invalid Column Type Error explained.
- [Error Parsing Record to Row](http://help.synatic.com/en/articles/11388984-error-parsing-record-to-row.md): Error Parsing record to row: Cannot convert string to number explained.
- [Executor error during getMore](http://help.synatic.com/en/articles/11477950-executor-error-during-getmore.md): Executor error during getMore explained
- [Error Querying Acumatica](http://help.synatic.com/en/articles/11477959-error-querying-acumatica.md): Error Querying Acumatica explained.
- [Buffer Object Error](http://help.synatic.com/en/articles/11477996-buffer-object-error.md): Buffer Object Error explained.
- [Error connecting to SQL Server](http://help.synatic.com/en/articles/11478024-error-connecting-to-sql-server.md): Error connecting to SQL server explained
- [Relay Based File System Error](http://help.synatic.com/en/articles/11689139-relay-based-file-system-error.md): File Does Not Exist on Relay Based File System explained.
- [Error Querying Acumatica](http://help.synatic.com/en/articles/11689158-error-querying-acumatica.md): Error Querying Acumatica explained.
- [Unable to Initialize Step Error](http://help.synatic.com/en/articles/11689181-unable-to-initialize-step-error.md): Unable to Initialize Step Error explained.
- [Error Executing SQL Command](http://help.synatic.com/en/articles/11689259-error-executing-sql-command.md): Error Executing SQL Command explained.
- [Error Retrieving Array Value](http://help.synatic.com/en/articles/12008111-error-retrieving-array-value.md): Error Retrieving Array Value explained.
- [Lookup Value Not Found Error](http://help.synatic.com/en/articles/12008159-lookup-value-not-found-error.md): Lookup value not found error explained.
- [Error Parsing SQL Statement Error](http://help.synatic.com/en/articles/12008177-error-parsing-sql-statement-error.md): Error parsing SQL statement error explained.
- [NS Does Not Exist Error](http://help.synatic.com/en/articles/12008211-ns-does-not-exist-error.md): NS does not exist error.

## Solutions

- [About Solutions](http://help.synatic.com/en/articles/4175348-about-solutions.md): Solutions logically group parts of your project

## Entities

- [Flows](http://help.synatic.com/en/articles/4170597-flows.md): Flows model data processing pipelines and are the core building block of Synatic
- [Exporting & Importing a Flow](http://help.synatic.com/en/articles/4354597-exporting-importing-a-flow.md): How to Export and Import a Flow
- [Flow Versioning](http://help.synatic.com/en/articles/7979895-flow-versioning.md): Different versions of a flow can be created and modified while one version is used as the executable version.
- [Connections](http://help.synatic.com/en/articles/4301065-connections.md): Connections provide secure storage for connection strings to services and systems.
- [Connecting to Microsoft SQL Server](http://help.synatic.com/en/articles/4656923-connecting-to-microsoft-sql-server.md): Connecting Synatic to SQL
- [Connecting to Xero](http://help.synatic.com/en/articles/4667561-connecting-to-xero.md): Connecting Synatic to Xero
- [Connecting to Salesforce](http://help.synatic.com/en/articles/4667318-connecting-to-salesforce.md): Connecting Synatic to Salesforce
- [Creating a connection to Salesforce](http://help.synatic.com/en/articles/4378108-creating-a-connection-to-salesforce.md): Create a connection that will allow extracting Salesforce data into Synatic.
- [1. Relays Overview](http://help.synatic.com/en/articles/5102156-1-relays-overview.md): Relaying on-premise data to Synatic
- [2. Relays](http://help.synatic.com/en/articles/5115227-2-relays.md): Relays provide secure communication between a customer's on-premise data endpoints to Synatic without opening firewall ports.
- [3. Installing the New Relay Manager](http://help.synatic.com/en/articles/11326064-3-installing-the-new-relay-manager.md): Installing Synatic's New Relay Manager
- [4. Installing Relay Manager on Windows OS](http://help.synatic.com/en/articles/5129713-4-installing-relay-manager-on-windows-os.md): The Relay Manager is used to provide access to the Relay's endpoint data on an on-premise legacy system.
- [5. Installing a Relay on Linux OS](http://help.synatic.com/en/articles/9925102-5-installing-a-relay-on-linux-os.md): How to install a relay on Linux OS
- [6. Installing the MySQL Server Relay](http://help.synatic.com/en/articles/4742793-6-installing-the-mysql-server-relay.md): The MySQL Server Relay provides access to a MySQL Server on-premise system .
- [7. Troubleshooting a Relay](http://help.synatic.com/en/articles/8799328-7-troubleshooting-a-relay.md): This article shows the instructions to follow to troubleshoot a Relay.
- [1. What is a Buffer?](http://help.synatic.com/en/articles/4757254-1-what-is-a-buffer.md): A buffer is a holding area/storing or super cache for data.
- [2. Creating a Buffer](http://help.synatic.com/en/articles/4757274-2-creating-a-buffer.md): Create a standard Buffer for your requirements.
- [3. Configuring the Buffer](http://help.synatic.com/en/articles/4757442-3-configuring-the-buffer.md): Configure the buffer to conform to operational requirements.
- [4. Managing Buffer Values](http://help.synatic.com/en/articles/4757607-4-managing-buffer-values.md): Modify and maintain data values in a Buffer.
- [5. Buffer Indexing](http://help.synatic.com/en/articles/8850956-5-buffer-indexing.md): Buffer indexes are used to optimize a buffer’s performance.
- [6. Query the Buffer data](http://help.synatic.com/en/articles/4758875-6-query-the-buffer-data.md): Use the Query Builder to debug or interrogate the Buffer data.
- [Buffer Source Step](http://help.synatic.com/en/articles/4761834-buffer-source-step.md): The Buffer Source Step is used to retrieve data from a Buffer.
- [Buffer Query Source Step](http://help.synatic.com/en/articles/8894856-buffer-query-source-step.md): The Buffer Query Source step is used to query a buffer using SQL \(NoQL\).
- [Buffer Lookup Mapper step](http://help.synatic.com/en/articles/8911710-buffer-lookup-mapper-step.md): The Buffer Lookup Mapper step is used to reference data that is stored in a buffer.
- [Buffer Query Lookup Mapper Step](http://help.synatic.com/en/articles/8894869-buffer-query-lookup-mapper-step.md): The Buffer Query Lookup Mapper step is used to query multiple buffer lookups in one step.
- [Buffer Lookup Mapper Types](http://help.synatic.com/en/articles/8911764-buffer-lookup-mapper-types.md): The Buffer Lookup Mapper step is used to reference data that is stored in a buffer based on the selected lookup type.
- [Buffer Destination Step](http://help.synatic.com/en/articles/4752057-buffer-destination-step.md): A buffer destination step is used to store data in the Synatic platform.
- [Solution Parameters](http://help.synatic.com/en/articles/4301056-solution-parameters.md): Reusing configuration with Parameters
- [Input Flow Parameters](http://help.synatic.com/en/articles/4354584-input-flow-parameters.md): Input parameters allow for data to be passed to a Flow
- [Calculator Parameters - Designer Web](http://help.synatic.com/en/articles/9026697-calculator-parameters-designer-web.md): Creating and referencing parameters in a Calculator mapper step.

## Steps

- [HTTP Service Source Step](http://help.synatic.com/en/articles/4719865-http-service-source-step.md): An HTTP Service commonly provides communication with a web-based application server to retrieve data from it.
- [HTTP Service Source Step – Paging Options](http://help.synatic.com/en/articles/8957283-http-service-source-step-paging-options.md): Paging Options for the HTTP Service Source Step.
- [Salesforce Source Step](http://help.synatic.com/en/articles/10419577-salesforce-source-step.md): Salesforce Source step explained.
- [Salesforce Bulk V2 Source Step](http://help.synatic.com/en/articles/10419586-salesforce-bulk-v2-source-step.md): Salesforce Bulk V2 Source step
- [Pass Through Reader Step](http://help.synatic.com/en/articles/8193566-pass-through-reader-step.md): The Pass Through Reader Step is used to pass data from a source to the other steps in the flow.
- [JSON Reader Step](http://help.synatic.com/en/articles/5161636-json-reader-step.md): The JSON Reader step instructs Synatic to process the incoming data in JSON notation.
- [CSV Reader Step](http://help.synatic.com/en/articles/8223895-csv-reader-step.md): The CSV Reader Step is used to read CSV files.
- [Excel Reader Step](http://help.synatic.com/en/articles/8223857-excel-reader-step.md): The Excel Reader step is used to read data from a specified worksheet in an Excel file.
- [Excel Raw Reader Step](http://help.synatic.com/en/articles/8182080-excel-raw-reader-step.md): The Excel Raw Reader step is used to read data from all the worksheets in an Excel file and it also shows the worksheet/s name.
- [XML Reader Step](http://help.synatic.com/en/articles/8267244-xml-reader-step.md): The XML Reader step is used to analyze an XML file and convert it into JSON.
- [XML to JSON Reader Step](http://help.synatic.com/en/articles/8255454-xml-to-json-reader-step.md): The XML to JSON Reader step is used to convert XML files into JSON data.
- [Multipart Form Reader Step](http://help.synatic.com/en/articles/8267259-multipart-form-reader-step.md): The Multipart Form Reader step is used to read data from a multipart/form.
- [Fixed Width with ID Reader Step](http://help.synatic.com/en/articles/8267368-fixed-width-with-id-reader-step.md): The Fixed Width with ID Reader step is used to read records with an identification field from a fixed width file.
- [Fixed Width Reader Step](http://help.synatic.com/en/articles/8267383-fixed-width-reader-step.md): The Fixed Width Reader step is used to read records from a Fixed Width file.
- [Header Picker Reader Step](http://help.synatic.com/en/articles/8267435-header-picker-reader-step.md): The Header Picker reader step is used to read headers from a file.
- [TAR GZ Reader Step](http://help.synatic.com/en/articles/8282294-tar-gz-reader-step.md): The TAR GZ Reader step is used to read tar.gz files.
- [GZ Reader Step](http://help.synatic.com/en/articles/8282306-gz-reader-step.md): The GZ Reader step is used to read .gz zip files.
- [Zip Reader Step](http://help.synatic.com/en/articles/8282318-zip-reader-step.md): The ZIP Reader step is used to read .zip files.
- [Zip List Reader Step](http://help.synatic.com/en/articles/8282329-zip-list-reader-step.md): The Zip List Reader step is used to unzip a folder that contains multiple files.
- [JSON Sax Reader Step](http://help.synatic.com/en/articles/8286873-json-sax-reader-step.md): The JSON Sax reader step is used to read and filter selected parts of large data sets.
- [X12 Reader Step](http://help.synatic.com/en/articles/8282338-x12-reader-step.md): The X12 Reader step is used to read and translate EDI files.
- [AVRO Reader Step](http://help.synatic.com/en/articles/8286893-avro-reader-step.md): The Avro Reader step is used to convert Avro data to JSON format.
- [Mercantile Reader Step](http://help.synatic.com/en/articles/8286908-mercantile-reader-step.md): The Mercantile Reader step is used to read Mercantile files and turn them into records.
- [Typeform Reader Step](http://help.synatic.com/en/articles/8286917-typeform-reader-step.md): The Typeform Reader step is used to read data from Typeform.
- [AL3 Reader Step](http://help.synatic.com/en/articles/8447722-al3-reader-step.md): The AL3 Reader step is used to read an Acord AL3 file.
- [Split Mapper Step](http://help.synatic.com/en/articles/5187611-split-mapper-step.md): Configuring the Split step to denormalize a dataset
- [Group Mapper Step](http://help.synatic.com/en/articles/5166290-group-mapper-step.md): Configuring the Group step to organize records into logical groups.
- [Super Mapper Step](http://help.synatic.com/en/articles/5144773-super-mapper-step.md): The Super Mapper step is used to map source data to destination data and convert field value types with advanced functions.
- [Field Mapper Step](http://help.synatic.com/en/articles/4535506-field-mapper-step.md): The Field Mapper maps source data to destination data and convert field value types with advanced functions.
- [Calculator Mapper Step](http://help.synatic.com/en/articles/4521898-calculator-mapper-step.md): The calculator is used for custom JavaScript code to manipulate or transform records.
- [Filter Mapper Step](http://help.synatic.com/en/articles/4507629-filter-mapper-step.md): Filters remove records that do not match a selection function.
- [Sort Mapper Step](http://help.synatic.com/en/articles/4526504-sort-mapper-step.md): Sort records by one or more fields.
- [Geocode Lookup Mapper Step](http://help.synatic.com/en/articles/8611273-geocode-lookup-mapper-step.md): The Geocode Lookup Mapper step is used to look up and validate a property address from a record.
- [LLM Mapper Step](http://help.synatic.com/en/articles/8617208-llm-mapper-step.md): The LLM Mapper step is to get Large Language Model results based on the prompt provided.
- [Generate Embedding Mapper Step](http://help.synatic.com/en/articles/9013894-generate-embedding-mapper-step.md): The Generate Embedding Mapper Step is used to generate embeddings for any value in a record.
- [Vector Search Mapper Step](http://help.synatic.com/en/articles/9013903-vector-search-mapper-step.md): The Vector Search Mapper Step is used to look up and match from a buffer containing an embedding vector.
- [Ops Portal Matcher Mapper Step](http://help.synatic.com/en/articles/9013944-ops-portal-matcher-mapper-step.md): Looks up results from a buffer containing an embedding vector and automatically matches the results to a valid Ops Portal structure.
- [Data Cleanser Mapper Step](http://help.synatic.com/en/articles/9112192-data-cleanser-mapper-step.md): The Data Cleanser mapper step is used if you require to manipulate and clean records/data.
- [SQL Server Destination](http://help.synatic.com/en/articles/4354703-sql-server-destination.md): Using a SQL Server Destination Step
- [Synchronous Flow Destination Step](http://help.synatic.com/en/articles/4631146-synchronous-flow-destination-step.md): Used in a flow to execute another flow/process consecutively.
- [Asynchronous Flow](http://help.synatic.com/en/articles/4643359-asynchronous-flow.md): Add an Asynchronous Flow step to any flow and use it to call another flow.
- [HTTP Service Destination Step](http://help.synatic.com/en/articles/4720128-http-service-destination-step.md): An HTTP Service sends output to an HTTP endpoint and web-based application servers to send or update data from it.
- [HTTP Async Service](http://help.synatic.com/en/articles/4720154-http-async-service.md): An HTTP Service commonly provides asynchronous communication with a web-based application server.
- [ACORD OCR Destination Step](http://help.synatic.com/en/articles/8722439-acord-ocr-destination-step.md): The OCR step is used to perform OCR on a trained ACORD document.
- [OCR Analyze Destination Step](http://help.synatic.com/en/articles/8722404-ocr-analyze-destination-step.md): The OCR Analyze step is used to analyze a document given a set of prebuilt models.
- [OCR Destination Step](http://help.synatic.com/en/articles/8722599-ocr-destination-step.md): The OCR step is used to perform OCR on a trained document.
- [PostgresSQL Destination Step](http://help.synatic.com/en/articles/8943089-postgressql-destination-step.md): The PostgresSQL Destination step is used to run query against PostgresSQL for each record being processed.
- [Run File Destination Step](http://help.synatic.com/en/articles/9183956-run-file-destination-step.md): The Run File Destination step is used to deliver an output file once a Run is executed.
- [Asynchronous Flow Destination Step](http://help.synatic.com/en/articles/9203077-asynchronous-flow-destination-step.md): Used in a flow to execute another flow/process at the same time/concurrently.
- [Decryption Destination Step](http://help.synatic.com/en/articles/10384120-decryption-destination-step.md): The Decryption Destination step explained.
- [Encryption Destination Step](http://help.synatic.com/en/articles/10383248-encryption-destination-step.md): The Encryption Destination step explained.
- [AL3 Writer Step](http://help.synatic.com/en/articles/8403464-al3-writer-step.md): The AL3 Writer step is used to create an Acord AL3 file.
- [Text Template Writer Step](http://help.synatic.com/en/articles/8306551-text-template-writer-step.md): The Text Template Writer step uses handlebars to create a text file.
- [CMSMTF Writer Step](http://help.synatic.com/en/articles/8556340-cmsmtf-writer-step.md): The CMSMTF Writer step uses handlebars to create a text file.
- [JSON Writer Step](http://help.synatic.com/en/articles/8306568-json-writer-step.md): The JSON Writer step is used to create a JSON file.
- [PDF Writer Step](http://help.synatic.com/en/articles/8306593-pdf-writer-step.md): The PDF Writer step is used to create a PDF file.
- [Word Writer Step](http://help.synatic.com/en/articles/8306633-word-writer-step.md): The Word Writer step is used to create a Word document using an HTML template.
- [Merge PDF Fields Writer Step](http://help.synatic.com/en/articles/8442488-merge-pdf-fields-writer-step.md): The Merge PDF Fields Writer step is used to integrate values from a source into a PDF file which is in a Base64 string.
- [XML Writer Step](http://help.synatic.com/en/articles/8153116-xml-writer-step.md)
- [Excel Writer Step](http://help.synatic.com/en/articles/8360278-excel-writer-step.md): The Excel Writer step is used to create an Excel document.
- [CSV Writer Step](http://help.synatic.com/en/articles/8360347-csv-writer-step.md): The CSV Writer step is used to create a CSV file.
- [Zip Writer Step](http://help.synatic.com/en/articles/8360378-zip-writer-step.md): The Zip Writer step is used to create a ZIP file with records or with ONE file.
- [Multi File Zip Writer Step](http://help.synatic.com/en/articles/8830238-multi-file-zip-writer-step.md): The Multi File Zip Writer step is used to create a ZIP \(compressed\) file with multiple records or files in it.
- [Base64 Writer Step](http://help.synatic.com/en/articles/8394899-base64-writer-step.md): The Base64 Writer step is used to convert records to a Base64 encoded string.
- [Word to PDF Writer Step](http://help.synatic.com/en/articles/8373661-word-to-pdf-writer-step.md): The Word to PDF Writer step is used to convert a Word document to PDF file.
- [Word Merge to PDF Writer Step](http://help.synatic.com/en/articles/8424462-word-merge-to-pdf-writer-step.md): The Word Merge to PDF Writer step is used to merge values to fields from any source to an existing Word template & create a new PDF file.
- [Word Merge to Word Writer Step](http://help.synatic.com/en/articles/8321092-word-merge-to-word-writer-step.md): The Word Merge to Word Writer step is used to merge values to fields from any source to an existing Word template & create a new Word doc.
- [Word Add ToC Writer Step](http://help.synatic.com/en/articles/8373704-word-add-toc-writer-step.md): The Word Add ToC Writer step is used to create a Table of Contents page to a Word document that has headings.
- [Merge PDF Writer Step](http://help.synatic.com/en/articles/8394879-merge-pdf-writer-step.md): The Merge PDF Writer step is used to merge a number of PDF pages into one PDF file.
- [Split PDF Writer Step](http://help.synatic.com/en/articles/8394925-split-pdf-writer-step.md): The Split PDF Writer step is used to split a PDF document into separate PDF files based on the number of pages in the original file.
- [Mercantile Credit Card File Writer Step](http://help.synatic.com/en/articles/8428442-mercantile-credit-card-file-writer-step.md): The Mercantile Credit Card File Writer step is used to create a Mercantile credit card file.
- [Mercantile EFT File Writer Step](http://help.synatic.com/en/articles/8428482-mercantile-eft-file-writer-step.md): The Mercantile EFT File Writer step is used to create a Mercantile EFT file.
- [HTTP Trigger Step](http://help.synatic.com/en/articles/8455955-http-trigger-step.md): The HTTP Trigger step is used to trigger a flow using a URL.
- [Schedule Trigger Step](http://help.synatic.com/en/articles/8489137-schedule-trigger-step.md): The Schedule Trigger step is used to set up the flow to run at a regular pre-determined time.
- [Email Trigger Step](http://help.synatic.com/en/articles/8455968-email-trigger-step.md): The Email Trigger step is used to trigger a flow by sending an email to a specific email address created by the Email Trigger step.
- [Salesforce Platform Event Trigger Step](http://help.synatic.com/en/articles/8469375-salesforce-platform-event-trigger-step.md): The Salesforce Platform Event Trigger step is used to trigger a flow using a Salesforce Platform Event.
- [AMS360 Trigger Step](http://help.synatic.com/en/articles/8484830-ams360-trigger-step.md): The AMS360 Trigger step is used to trigger a flow using AMS360 Notification Service Messages.
- [SFTP Server Trigger Step](http://help.synatic.com/en/articles/8490206-sftp-server-trigger-step.md): The SFTP Server Trigger step is used to trigger a flow in the SFTP Server.
- [Combine Step](http://help.synatic.com/en/articles/8607864-combine-step.md): The Combine step is used to combine records into a single output for a Writer or Destination step.
- [Run Event Email Step](http://help.synatic.com/en/articles/8735402-run-event-email-step.md): The Run Event Email step is used to send an email on the status of a processed run.
- [Run Event SyncFlow Step](http://help.synatic.com/en/articles/8773395-run-event-syncflow-step.md): This step is used to execute a second flow based on the selected processed status of the run in the current flow.
- [Run Event AsyncFlow Step](http://help.synatic.com/en/articles/8773459-run-event-asyncflow-step.md): An AsyncFlow is used to execute a second flow concurrently based on the selected processing status of the run in the current flow.
- [Run Event File System Actions Step](http://help.synatic.com/en/articles/8773479-run-event-file-system-actions-step.md): The File System Actions Run Event step is used to action a local file based on the status of a processed run in a flow.
- [Record Event Buffer Step](http://help.synatic.com/en/articles/8731176-record-event-buffer-step.md): The Record Event Buffer step is used to log record information for a processed run.
- [Record Event Log Step](http://help.synatic.com/en/articles/8731185-record-event-log-step.md): The Record Event Log step is used to log record information for a processed run.
- [Subflow Control Step](http://help.synatic.com/en/articles/8517241-subflow-control-step.md): The Subflow Control step is used to pull data from a 2nd source step in a flow.
- [Condition Control Step](http://help.synatic.com/en/articles/8596955-condition-control-step.md): The Condition Control step is used to filter data in 2 separate subflows based on a specific condition.
- [Parallel Control Step](http://help.synatic.com/en/articles/8597018-parallel-control-step.md): The Parallel Control step is used to run a set of subflows in parallel/simultaneously.
- [Series Control Step](http://help.synatic.com/en/articles/8597071-series-control-step.md): The Series Control step is used to run a set of subflows in a consecutive/synchronous manner.
- [ForEach Control Step](http://help.synatic.com/en/articles/8517230-foreach-control-step.md): The ForEach Control step is used to view or manipulate each element in an array which is in a record.

## Operations Portal

- [1. Introduction - Building the basic Operations Portal](http://help.synatic.com/en/articles/5037221-1-introduction-building-the-basic-operations-portal.md): Create and configure the basic Operations Portal.
- [2. Ops Portal View - AsyncFlow Control](http://help.synatic.com/en/articles/5036532-2-ops-portal-view-asyncflow-control.md): Creating a view to monitor all flows in Asynchronous Mode.
- [3. Ops Portal View - SyncFlow Control](http://help.synatic.com/en/articles/5020656-3-ops-portal-view-syncflow-control.md): Creating a view to monitor all flows in Synchronous Mode.
- [4. Ops Portal View - Buffer Control](http://help.synatic.com/en/articles/5024275-4-ops-portal-view-buffer-control.md): Creating a view to monitor all Buffers.
- [5. Ops Portal View - Runs Control](http://help.synatic.com/en/articles/5024695-5-ops-portal-view-runs-control.md): Creating a view to monitor all execution Runs for a specific flow.
- [6. Ops Portal View - Run Control](http://help.synatic.com/en/articles/5033019-6-ops-portal-view-run-control.md): Creating a view to display the details of a specific flow run.
- [7. Ops Portal View - HTML Control](http://help.synatic.com/en/articles/5033782-7-ops-portal-view-html-control.md): Creating a view to display data in an HTML formatted page.
- [8. Ops Portal View – Validator Control](http://help.synatic.com/en/articles/9112427-8-ops-portal-view-validator-control.md): Creating a view to monitor and validate data stored in a buffer.
- [9. Ops Portal View – Deduplicator Control](http://help.synatic.com/en/articles/9112458-9-ops-portal-view-deduplicator-control.md): Creating a view to monitor and validate duplicated records stored in a buffer.
- [10. Ops Portal View – Matcher Control](http://help.synatic.com/en/articles/9112492-10-ops-portal-view-matcher-control.md): Creating a view to monitor and validate matched records stored in buffers.

## Gateway \(API Builder\)

- [1. Building a basic API](http://help.synatic.com/en/articles/4801613-1-building-a-basic-api.md): This tutorial will help with creating an API.
- [2. SQL Server connection](http://help.synatic.com/en/articles/4802996-2-sql-server-connection.md): Create a connection to a SQL Server data source.
- [3. Info](http://help.synatic.com/en/articles/4801779-3-info.md): Configure the API service URLs in the Info tab.
- [4. Tags](http://help.synatic.com/en/articles/4801824-4-tags.md): Add Tags to organize API operations.
- [5. Security Scheme](http://help.synatic.com/en/articles/4803041-5-security-scheme.md): Create a security scheme for authentication and authorization.
- [6. IP Whitelist](http://help.synatic.com/en/articles/4803088-6-ip-whitelist.md): Grant access to specific IP addresses only.
- [7. Paths](http://help.synatic.com/en/articles/4803178-7-paths.md): Assign Paths and Routes to the API.
- [8. Schema](http://help.synatic.com/en/articles/4803144-8-schema.md): A schema is metadata that describes how data is structured.
- [How to pass parameters in the Gateway](http://help.synatic.com/en/articles/9070747-how-to-pass-parameters-in-the-gateway.md): Passing parameters in the Gateway.
- [How to send data to Power BI using the Data Gateway](http://help.synatic.com/en/articles/8052556-how-to-send-data-to-power-bi-using-the-data-gateway.md): A guide on how to send data to Power BI using the Data Gateway

## Tutorials

- [Importing data from Google Sheets to Microsoft SQL using Synatic](http://help.synatic.com/en/articles/4477139-importing-data-from-google-sheets-to-microsoft-sql-using-synatic.md): Connecting Google Sheets with other systems is simple using Synatic
- [Creating a Salesforce to SQL Server flow](http://help.synatic.com/en/articles/4656271-creating-a-salesforce-to-sql-server-flow.md): Create a flow to read data from Salesforce accounts object, map and insert this data into a SQL Server DB.
- [Import a CSV file from SFTP to Postgres](http://help.synatic.com/en/articles/4467221-import-a-csv-file-from-sftp-to-postgres.md): This tutorial shows an end-to-end flow, picking up a file from SFTP, reading it, perform mapping, and inserting the results into Postgres
- [Decoding a JWT Token](http://help.synatic.com/en/articles/5352256-decoding-a-jwt-token.md): Verifying the integrity of a claim contained in a JWT Token
- [Connecting an HTTP Service to Facebook using OAuth 2.0](http://help.synatic.com/en/articles/4945930-connecting-an-http-service-to-facebook-using-oauth-2-0.md): Learn how to connect using Facebook OAuth 2.0 with Synatic
- [Connecting an HTTP Service to QuickBooks using OAuth 2.0](http://help.synatic.com/en/articles/4947005-connecting-an-http-service-to-quickbooks-using-oauth-2-0.md): Learn how to connect using QuickBooks OAuth 2.0 with Synatic
- [AgencySync Setup](http://help.synatic.com/en/articles/11172792-agencysync-setup.md): Setting up AgencySync
- [2. AsyncFlow Control](http://help.synatic.com/en/articles/5040622-2-asyncflow-control.md): Configure the AsyncFlow Control
- [3. SyncFlow Control](http://help.synatic.com/en/articles/5041371-3-syncflow-control.md): Configure the SyncFlow Control
- [4. Buffer Control](http://help.synatic.com/en/articles/5044556-4-buffer-control.md): Configure the Buffer Control
- [5. Runs Control](http://help.synatic.com/en/articles/5044767-5-runs-control.md): Configure the Runs Control
- [6. Run Control](http://help.synatic.com/en/articles/5044931-6-run-control.md): Configure the Run Control
- [7. HTML Control](http://help.synatic.com/en/articles/5045728-7-html-control.md): Configure the HTML Control
- [8. Graph Control](http://help.synatic.com/en/articles/5045824-8-graph-control.md): Configure the Graph Control
- [1. API Builder Tutorial - Introduction](http://help.synatic.com/en/articles/4780298-1-api-builder-tutorial-introduction.md): Design and create an API directly in Synatic using the API Builder
- [2. API Tutorial - Route to Get All Books](http://help.synatic.com/en/articles/4836037-2-api-tutorial-route-to-get-all-books.md): Create an API Route to list all books in our BookStore database
- [3. API Tutorial - Route to Get a Book by ID](http://help.synatic.com/en/articles/4837903-3-api-tutorial-route-to-get-a-book-by-id.md): Create an API Route to extract a book from our database
- [4. API Tutorial - Route to Post New Book](http://help.synatic.com/en/articles/4838368-4-api-tutorial-route-to-post-new-book.md): Create an API Route to POST a new book to the database
- [5. API Tutorial - Route to Update a Book by ID](http://help.synatic.com/en/articles/4841377-5-api-tutorial-route-to-update-a-book-by-id.md): Create an API Route to update a book in our database
- [6. API Tutorial - Route to Delete a Book by ID](http://help.synatic.com/en/articles/4845178-6-api-tutorial-route-to-delete-a-book-by-id.md): Create an API Route to delete a book from our database

## Supporting Information

- [Handlebars](http://help.synatic.com/en/articles/4301055-handlebars.md): Using Handlebars in Synatic
- [Processing Object](http://help.synatic.com/en/articles/4354606-processing-object.md): The Processing Object contains the current state of a Run and the current Record
- [1. About testing and debugging](http://help.synatic.com/en/articles/5326384-1-about-testing-and-debugging.md): Methods to resolve anomalies during Synatics' flow development
- [2. Settings in the Run Test dialog](http://help.synatic.com/en/articles/5326586-2-settings-in-the-run-test-dialog.md): These settings can be used help control how the test is executed..
- [3. Step Debug Dialog](http://help.synatic.com/en/articles/5326595-3-step-debug-dialog.md): This dialog displays different views of resulting data following a test run
- [4. How to validate JavaScript code in a Calculator step](http://help.synatic.com/en/articles/9196457-4-how-to-validate-javascript-code-in-a-calculator-step.md): Validating the JSON code in the Calculator step or the Calculator steps in the flow.
- [5. Debug a Calculator code error](http://help.synatic.com/en/articles/5326569-5-debug-a-calculator-code-error.md): Debugging errors introduced in the Calculator step configuration
- [6. Debug/Troubleshoot A Run](http://help.synatic.com/en/articles/4354612-6-debug-troubleshoot-a-run.md): Flows have several debugging features that help in tracking down problems during development.
- [7. Debug a SQL Server connection error](http://help.synatic.com/en/articles/5332327-7-debug-a-sql-server-connection-error.md): Debugging an error introduced in the SQL server connection configuration.
- [8. View Record Logging Events](http://help.synatic.com/en/articles/5341384-8-view-record-logging-events.md): View the record details of flow events
- [9. Configuring the Log Record Error step](http://help.synatic.com/en/articles/5339167-9-configuring-the-log-record-error-step.md): Configure a log to record completion and error events
- [How to validate JavaScript code in a Calculator step - Designer Web](http://help.synatic.com/en/articles/10660656-how-to-validate-javascript-code-in-a-calculator-step-designer-web.md): Validating the JSON code in the Calculator step or the Calculator steps in the flow.