XLSX2JSON Component

Description: Convert an XLSX (Excel 2007+ XML format) file to JSON.

Input Parameters:

• fileId (string, required): The ID of the file to be converted.

Output Parameters:

• fileId (string): The unique ID of the converted JSON file.

• fileName (string): The name of the generated JSON file.

XLSX2HTML Component

Overview

The XLSX2HTML component converts an XLSX (Excel 2007+ XML) file into an HTML table format.

Input Parameters

Output Parameters

Instructions

1. Select the XLSX File

   • Choose an existing XLSX file by providing its fileId.

2. Processing

Overview

The DeleteColumns component removes specific columns from a CSV file. It allows users to define which columns to delete, using either column names (if headers exist) or column indices.

Usage

Input Parameters

Output Parameters

Instructions

1. Determine Column Identification Method

   • If the first row contains column names, set withHeaders to true. This ensures the correct columns are deleted based on their names.

   • If column names are not available, columns are identified by index.

Overview

The ImportCSV component allows users to import a CSV file into a workflow. It supports specifying a delimiter and can process files from user input.

Input Parameters

Output Parameters

Instructions

1. Select a CSV File

   • Use the file picker to choose a CSV file for import.

   • Alternatively, specify the file ID if it's already stored.

A universal guide outlining the common steps involved in setting up any OAuth2 application, including registering your application, obtaining client credentials, and defining redirect URIs.

Authentication

Lambda, S3 and SNS

To authenticate with AWS services Lambda, S3, and SNS, you need to provide Access Key Id and Secret Access Key. You can create a new user in the AWS IAM console (https://console.aws.amazon.com/iam/home) and assign the necessary permissions to that user.

The neccessary permissions depend on the services and components you want to use. For example, if you want to use the New S3 Object component, you need to assign the AmazonS3ReadOnlyAccess policy to your user. If you want to use the Send SNS Message component, you need to assign the AmazonSNSFullAccess policy.

HTML to JSON Converter

Description Convert an HTML table file into a JSON file.

Input Parameters

• fileId (string) - The ID of the file to be converted.

Output Parameters

• fileId (string) - The ID of the newly created JSON file.

• fileName (string) - The name of the converted JSON file.

• Sign-in to to your ActiveCampaign account. Once you are logged in, locate the "Settings" option. This can be found in the bottom left corner of the homepage.

• Within the settings page, you will see a section labeled 'Developer'. Click on this section to navigate to the Developer page. On the 'Developer' page, you will see your API URL and your API key.

• use the API Key to authenticate ActiveCampaign components in the Appmixer Designer.

In order to offer the Azure Cognitive Services components to your customers, you have to set an Azure key and endpoint through the Backoffice first.

Cloudflare WAF integrations allows you to actively block attacker IP by using Cloudflare WAF infrastructure.

Authentication

Cloudflare WAF connector support authentication via Account API Token or User API Token

Account API Token

To create the Account API Token, go to the Manage Accounts > Account API Tokens, click on "Create Token". On the next screen, select the "Create Custom Token" option.

Name the token and select the permission:

• Account | Rule Rulesets | Edit

User API Token

To create the User API Token, go to the Profile > API Tokens, click on "Create Token". On the next screen, select the "Create Custom Token" option.

Name the token and select the permission:

• Account | Rule Rulesets | Edit

In the Cloudflare connector authentication window, use your API Token to log in.

Sign-up at DeepAI

Visit https://deepai.org and sign-up:

Copy api-key from your profile dashboard:

Set the API key via the the Backoffice Connector Configuration page:

And then add you own apiKey value:

1. Create Freshdesk account

Sign up with Freshdesk: https://www.freshdesk.com

2. Obtain API key

Navigate to Profile Settings -> API. Copy the API token on the right side. If you don't see the API key, please refer to the for more information.

Use the copied token as API key along with Domain when connecting Freshdesk components in Appmixer. In this example the domain is acme-help and the API key is the copied token.

Unfortunately, since August 20, 2018 Highrise no longer accepts signups.

We keep the module in Appmixer for the older customers who have their Oauth2 application. If you are a new Appmixer customer, you won't be able to create the OAuth2 application and therefore use the Highrise module. In that case, you should remove it from the platform.

User-Agent

Requests to the Highrise API contain headers with User-Agent property. This is set by default to Appmixer, but it can be overwritten using Backoffice:

Log In to JotForm

• Go to the JotForm website.

• Log in with your JotForm account credentials.

Generate a New API Key

• Navigate to Account Settings: Click on your avatar/initials in the top right corner of the page. Choose "Settings" from the dropdown menu. Or go directly to the

• Here, you might see a list of existing API keys if you've created any before. To generate a new one, click the “Create New Key” button

Use the API key in the Appmixer

• In the authentication pop-up enter your API key.

• OpenAI Account: The first thing you need to do is have an OpenAI account. You can sign up for free.

• After signing up, go to https://platform.openai.com/api-keys.

• Create a New API Key: You would find a button or link labeled "Create a new key" or "Generate API keys". Click on it.

• Keep this key safe and secure. It should not be shared with anyone or exposed in client-side code, as it could be used to misuse your OpenAI services.

• use the API Key to authenticate OpenAI components in the Appmixer Designer.

1. Create Monday account

Sign up with Monday: https://auth.monday.com/users/sign_up_new

2. Obtain API key

Navigate to your Monday Developer Center -> My access tokens. Create a new token and copy it.

Use the copied token as apiKey when connecting Monday components in Appmixer.

You will need to create a new Redmine installation. Go to https://www.redmine.org/projects/redmine/wiki/RedmineInstall and follow the instructions. Alternatively, you can use a Docker image: https://hub.docker.com/_/redmine or a hosted solution.

Once you have your Redmine application make sure you have the REST API enabled. Go to Administration -> Settings -> API and check the "Enable REST web service" option.

After that, you will need to create a new API key. Go to Administration -> Users -> Edit user and create a new API key.

You will enter this API key and also the URL of your Redmine installation in when connecting each Redmine component.

Appmixer offers a built-in component for taking Screenshots.

It uses https://screenshotapi.net/ API. If you want to have this module on the platform you have to create your own Screenshot account and set the API token in the Backoffice.

Since version 4.2.1 you can configure the string that appears on the Trallo Oauth page.

If you don't do this, the Oauth page will show Appmixer by default.

• First, you'll need to create an account on the Twilio website.

• After signing up, go to https://console.twilio.com/

• Copy the Account SID and Auth Token from the "Account Info". Alternatively you can navigate to the "API Keys & Tokens" section, SID and Auth Token are available there.

• use the Auth Token and Account Token to authenticate the Twilio components in the Appmixer Designer.

When creating Typeform Oauth2 application (https://admin.typeform.com/account#/section/apps), you can choose between access tokens that do expire in a week and access tokens that do not expire.

The token expiration is new in Typeform. Appmixer components before version 4.2 cannot handle it.

If you're registering the Oauth application for version 4.2 or newer, you can decide if you want to use tokens that do expire or not. If you decide to go with Unlimited then you don't have to set anything in the Backoffice, it is the default behavior. On the other hand, if you want to use tokens that expire, you have to go to the Backoffice and set the useRefreshToken to true for the appmixer:typeform service.

Then you can use the One Week configuration.

1. Create Asana account

Sign up with Asana:

2. Register OAuth app

Cloudflare List Integrations allow you to manage IP lists efficiently. You can add or remove IPs from Cloudflare IP Lists and specify the TTL (Time To Live), which automatically removes the IP after a set time period.

Custom IPs list

You can access custom lists in your Cloudflare account by navigating to Manage Account > Configurations > Lists. Cloudflare Lists connector only supports IP lists.

Access the Dropbox App Console

• Open the .

Register OAuth app

You can find all the necessary information on how to register an OAuth app in Jira in their .

Access and create a new app. Click Create and select OAuth 2.0 integration.

Click on the "Register an app" button.

Register OAuth app

• You need to start by creating a new app on the LinkedIn Developer platform. Visit https://developer.linkedin.com/ and log into your account. Once logged in, navigate to "MyApps", then click on "Create App". Fill in all necessary information like app name, app logo, app description, app privacy policy URL etc. You also need to fill the "Associated LinkedIn page". This is the LinkedIn page that will be associated with the app. If you don't have a LinkedIn page, you can create one by clicking on the "Create a LinkedIn Page" link.

Setup Mailchimp account

Sign up with Mailchimp:

2. Register OAuth app

Register an OAuth2 application in a similar way as usual with few changes:

• you don't need to configure OneDrive file picker

• configure API permissions for Dynamics 365, see below

Go to the API permissions section:

First, you need to set an Quickbooks key and endpoint through the Backoffice in order to provide the Quickbooks components to your customers.

Go to the to create a new app.

Select the name and scope:

Then you receive your clientID and clientSecret.

Also add the redirect URL. Example: https://api.YOUR_SUBDOMAIN.appmixer.cloud/auth/quickbooks/callback.

Get your consumer key and secret

Log in to your Schoology server. Look at the top navigation bar and go to Tools > School Management.

In the new screen, click on Integrations in the left menu. Now click on the API tab. You should see your consumer key and secret. The secret is hidden, so you have to use the Reveal Existing Secret option.

Access the Twitter App Console

• Navigate to the and sign up if you haven't already.

Overview

The Join Component is used to merge multiple input connections. It forwards every received message to the output port without modification.

Usage

Overview

The OnStart Component is a trigger that fires once when the flow starts. It emits a timestamp indicating when the flow was initiated.

Usage

Overview

The SetVariable Component assigns variables dynamically based on input type and value. It allows storing values in various formats such as text, numbers, dates, booleans, and files.

Usage

Description

Convert a CSV file to XLSX (Excel 2007+ XML Format).

Input Parameters

Overview

The DataUri2File component converts a Data URI into a file. It extracts the file content and metadata from the Data URI and generates a downloadable file.

Input Parameters

Overview

The HTML to CSV Converter component allows you to transform an HTML table file into a CSV format. This is useful for extracting structured data from HTML documents into a tabular format.

Input Parameters

JSON2XLSX Component

Overview

The JSON2XLSX component converts a JSON file into an XLSX (Excel 2007+ XML Format) file.

Input Parameters

XLSX2CSV Component

Overview

The XLSX2CSV component converts an XLSX Excel 2007+ XML format file into a CSV file.

Description

Create a new CSV file with an initial text content.

Input Parameters

Setup the App and Administrator account

Sign up with Airtable:

Specify Base name

HTTP CONNECTOR

Controls

The Appmixer Azure DevOps connector uses Microsoft Entra ID (Azure AD) OAuth 2.0 for authentication. You need to register an application in the Azure portal.

1. Register an Application in Azure Portal

Go to the Azure portal - App registrations and click + New registration.

• Name: A name for your application (e.g. "Appmixer Azure DevOps").

• Supported account types: Select Accounts in any organizational directory (Any Microsoft Entra ID tenant - Multitenant).

• Redirect URI: Select Web and set it to your Appmixer callback URL, e.g. https://api.YOUR_SUBDOMAIN.appmixer.cloud/auth/azuredevops/callback.

Click Register.

2. Get Application (Client) ID

After registration, you will be taken to the app's Overview page. Copy the Application (client) ID - this is your clientId.

3. Create a Client Secret

1. In the left menu, go to Certificates & secrets.

2. Click + New client secret.

3. Add a description and select an expiration period (use the longest available).

4. Configure API Permissions

1. In the left menu, go to API permissions.

2. Click + Add a permission.

3. Select Azure DevOps.

The final set of permissions should include:

5. Configure Appmixer Backoffice

Go to the Connector Configuration section in the Appmixer Backoffice. Find or add the appmixer:azuredevops connector and set the following values:

• clientId: The Application (client) ID from the Azure portal.

• clientSecret: The Client Secret Value from the Azure portal.

Register OAuth2 app

Go to the Discord Developer Portal: https://discord.com/developers/applications and create a new Application.

1. Click “New Application”

2. Give it a name, accept their Terms of Service and click “Create”

3. Open your new application

Basic Information

To obtain your OAuth credentials, go to OAuth2 tab:

• Client ID: shown on the “Client information” card as “Client ID”

• Client Secret: click “Reset Secret” to generate a secret and copy it

You’ll paste these into the Appmixer Backoffice later.

OAuth2 & Redirect URL

You must add the redirect/callback URL so Discord can return users to Appmixer after authorization.

• Go to OAuth2 tab

• In “Redirects”, add your Appmixer URL. Example:

  https://api.YOUR_SUBDOMAIN.appmixer.cloud/auth/discord/callback

Note: Replace YOUR_SUBDOMAIN with your actual Appmixer subdomain. The path “/auth/discord/callback” follows the same pattern as other Appmixer connectors.

Add a Bot and get the Bot Token

To make the events (sending messages, reacting to events) be from a bot, add one:

• Click “Reset Token” to reveal the Bot Token and copy it

Keep the token secure. You’ll paste it in the Backoffice as well.

Check the settings below in Authorization Flow, recommended set up is:

• Public Bot: ON

• Requires OAuth2 Code Grant: ON

• Server Members Intent: ON

Rest can be turned off.

Scopes and Permissions

How you configure scopes:

• Installation → Default Install Settings:

  • User Install: applications.commands

  • Guild Install: applications.commands, bot

Backoffice (Appmixer admin)

Copy and paste the values into the Backoffice under the Discord connector configuration (appmixer:discord):

• clientId → "Client ID" from Discord

• clientSecret → “Client Secret” from Discord

• botToken → “Bot Token”

After saving, return to your flow in Appmixer. Click “Connect account” for the Discord connector, complete the authorization, and you’re ready to use Discord components in your flows.

Register OAuth2 app

You need to create a developer account first (more about different Hubspot accounts can be found herehttps://developers.hubspot.com/docs/api/account-types)

Create a new application.

In order to get rid of a warning that your users will see before installing Hubspot module, you have to verify your identity as an app provider.

You can manage the Contact & Support settings.

Or skip for now.

Set the application name, logo, and description.

Go to the Auth tab and copy&paste these values into the .

Create Hubspot configuration in the .

Go back to Hubspot and set the redirect URL, replace acme.com with your domain and keep the suffix /auth/hubspot/callback

Adding scopes.

Hit Save.

One more thing that you will need is the Hubspot, go back to the Apps page and hit the Get HubSpot API key button.

Then copy&paste the generated key and put it into the .

Hubspot App verification

Your domain is unverified Until your domain is set and verified, users will see a warning when installing your app.

Users will encounter this warning during the installation or management of the app. To eliminate this warning, the verification process must be completed. HubSpot mandates the configuration of a DNS TXT record as the sole method for verification.

To configure and verify a custom HubSpot app for a hosted instance of Appmixer, such as ACME.appmixer.cloud, you will need to establish a custom domain for the Appmixer instance (for example, ACME.com). Without this custom domain, domain verification will not be possible.

Setting Up a Shopify Partner Account

Sign Up or Log In: If you haven’t already, go to the Shopify Partners page and sign up for an account. If you have an account, just log in.

Create a New App

Create a New App: Once logged in, navigate to the "Apps" section using the dashboard menu. Click on "Create app" to get started, select the "Create app manually"

Note the clientId and clientSecret. Next, click on the "Choose distribution"

Select the "Public distribution" option

Go to the "Configuration" section from the main menu

• set the Redirect URI to https://[YOUR_API_BASE]/auth/twitter/callback, for example https://api.appmixer.com/auth/titter/callback

• event version to the latest (2024-01)

• Embed app in Shopify admin: false

Go to the "API Access" section from the main menu. In the "Access requests" request access for the "Protected customer data access" Fill details in the "Select your data use and reasons" section:

Fill the form in the "Provide your data protection details" section:

Configuration in the Backoffice

• Configure the App Key as clientId and the App Secret as clientSecret in the service settings within the Backoffice, under the configuration ID appmixer:shopify. Also, add the appStoreInstallRedirectUri pointing to your instance, for example https://my.master-hamster-87765.appmixer.cloud/

• To learn more about configuring connectors, please visit the section.

Please note that only a 'developer' shop instance can be authenticated with your OAuth application unless your app is verified. 'Production' shop instances cannot authenticate with an unverified app. This guide does not cover all the requirements for the app verification process.

Visit the Use App Events tutorial for more information.

Overview

The On App Event Component triggers when an event is received from an external application, allowing automation workflows to respond dynamically to incoming app events.

Usage

This component listens for app events and processes incoming data, making it ideal for integrating external systems and event-driven workflows.

Properties

Output Ports

Processing Logic

1. Registers Webhook: Subscribes to the specified event using the Appmixer API.

2. Receives Event Data: Waits for an event from the external system.

3. Processes Data:

Output Data Schema

Notes

• Webhook-Based Execution: Efficiently listens for app events using webhooks.

• Dynamic Event Handling: Supports various app events based on configurations.

• Ideal for Integrations: Enables event-driven automation between external apps and workflows.

This component is essential for workflows requiring real-time event processing and seamless app integration.

Overview

The Counter Component maintains an internal counter that increments with each received message. It can also be reset to a specified value.

Usage

Input Parameters

Input Ports

Output Ports

Instructions

1. Set Initial Value and Increment

   • Configure the count parameter for the starting value.

   • Set increment to define how much the counter increases or decreases.

Notes

• Supports both increment and decrement operations.

• State is maintained: The counter retains its value across executions until reset.

• Useful for tracking counts in loops, event occurrences, or rate-limiting scenarios.

Appmixer offers a built-in component for sending emails from the platform.

The SendEmail component uses our Mandrill API KEY by default. It is recommended to change that to your own Mandrill API KEY if you want to keep using Mandrill as the email service provider. You can do that from the Backoffice. The service ID is appmixer:utils:email in this case. You can also change the default from email address which is set to [email protected].

The SendEmail component is an example, how sending emails from Appmixer can be done. You can have your own mailing system which you would like to use or you would like to use a different third-party application. In such a case, you should remove the SendEmail component from the system and offer your users your own implementation.

Calendly – Connector Configuration

Step 1: Create a Developer Account & First Application

Create a Salesforce application

To integrate Appmixer with Salesforce, you are going to need an app in your Salesforce account. You can either create a new one or use one that already exists.

To create an app, you have to login into . Once logged in, on the left menu, look up Platform Tools -> Apps -> App Manager. This will show you a list of your existing apps and provide the option to create a new one via the New Connected App on the top right side:

Overview

The Switch component allows conditional branching of messages based on predefined expressions. It evaluates up to five conditions (out1 to out5) and routes messages accordingly. If none of the conditions match, the message is sent to the else output.

Overview

The Archive component allows you to create a ZIP or TAR archive from a set of files. You can also append files to an existing archive, provided it matches the specified format.

Input Parameters

Overview

The AddColumn component allows adding a new column to an existing dataset.

Input Parameters

Description: The DeleteRows component removes specific rows from a CSV file based on a defined filter.

Input Parameters

Create Facebook OAuth Application

1. Visit and create a new OAuth application (or use your existing one).

Account

You'll need a Snowflake account. If you don't have one, you can sign up for a free trial on the .

Obtain Credentials and Configuration

1. Create Pipedrive account

Sign up with Pipedrive:

2. Obtain API key

Overview

The Condition Component evaluates expressions and directs data to either the true or false output port based on the result. It supports logical conditions using multiple operators and can process complex logical groupings.

Usage

Input Parameters

Supported Operators

Output Ports

Instructions

1. Define Conditions

   • Create conditions using logical grouping (AND, OR).

   • Choose an operator and provide a comparison value.

Notes

• Logical Groups: Conditions can be grouped using AND and OR for flexible logic handling.

• Range Handling: Use rangeMin and rangeMax to check if a value is within a range.

Overview

The Digest Component collects incoming data entries and releases them as a batch based on a threshold, a schedule, or a manual trigger via a webhook. This component is useful for aggregating data over time and sending it at controlled intervals.

Usage

Input Parameters

Input Ports

Output Ports

Instructions

1. Set a Threshold (Optional)

   • Define the threshold parameter to release data when a certain number of entries are reached.

2. Schedule Batch Processing (Optional)

Notes

• Supports multiple trigger methods: Data is released either via count (threshold), time (schedule), or manually (webhook).

• Flexible scheduling: Uses cron-like syntax for precise control over execution times.

Overview

The RenameColumn component renames a column in a CSV file. This is useful for standardizing column names before processing or integrating CSV data with other systems.

Input Parameters

Output Parameters

Instructions

1. Specify CSV File and Delimiter

   • Provide the fileId of the CSV file containing the column to be renamed.

   • Set the correct delimiter (e.g., ,

Description: The ExportCSV component exports structured data into a CSV file.

Input Parameters

Output Parameters

Instructions

1. Define Data Source:

   • Provide structured data in an array format, ensuring proper key-value mapping.

2. Set Output File Name:

Create Blackboard App in the Developer portal

The first thing you need is an app created in the developer portal. Navigate to https://developer.blackboard.com and signup for an account. When you are logged in, you can see a dashboard with a list of your applications and a button to create a new one:

Note that listed applications have an Application ID. We will need it when we register our application in the blackboard instance. Click on the + button to create a new application. A simple form appears with your Application name and description inputs, and a domains input, for your domains. After you fill in the fields, create the new application.

Register your application on Blackboard

Self-managed instances

Log in with admin privileges, and go to the System Admin tab in the top menu. After that, look under Integrations for REST API Integrations:

Next, you will see a list with all your API Integrations. Click on Create Integration to add a new one:

After that, you will show a small form. One of the inputs is the Application ID which as we showed in the first step, is available in the applications list at the developer portal. Next, browse and select a user. We recommend using the same user you are logged in with. On the End User Access and Authorized To Act As User, select Yes in both options. After that click on Submit to finish the registration.

Configure the Backoffice

Finally, we need to set the OAuth clientId and clientSecret in the to finish the integration. To obtain these values, go to the applications list in the developer portal. Find your application and click on the 3 dots at the end of the row. Then click on the Manage Keys option:

After you will see a list of your application keys. Click on the + sign to create a new key. Your key will be created and its information will be shown to you:

Be sure to store this information somewhere safe, as you won't be able to get it again.

Next, log into the Backoffice and go to Services. Next create a configuration for appmixer:blackboard. Finally, add your Application ID as clientId and Secret as clientSecret. Also set serverUrl to your instance URL:

And you are done! You are ready to use the Blackboard module.

Authentication

To authenticate Imperva connector, an API Key is required. To obtain this key, log in to your Imperva account and navigate to Account > My Profile > API Keys. Click on "Add API Key" to generate a new key. Enter a name (and optionally otherparameters) for the API Key and click on "Create".

Take note of the API ID and API Key. You will need these to authenticate the connector.

You can also view the API Key details in the API Keys section.

In the Imperva connector authentication window, use your Imperva API ID and API Key to log in.

Configuration

There are three optional configuration parameters for the SetBlockIPRule action of the Imperva connector. See the table below for more information.

JSON2CSV Component

Overview

The JSON2CSV component converts a JSON file into a CSV format. This enables easier data handling for spreadsheet applications and data processing tools that require CSV input.

Input Parameters

• fileId (string, required): The ID of the JSON file to be converted.

Output Parameters

• fileId (string): The ID of the newly generated CSV file.

• fileName (string): The name of the generated CSV file.

Instructions

1. Upload JSON File: Provide the fileId of the JSON file you wish to convert.

2. Processing: The component processes the input JSON and converts it into a structured CSV format.

3. Retrieve Output: The resulting CSV file's fileId and fileName

Prerequisites

Before using GoHighLevel components in Appmixer, you need:

1. A GoHighLevel account with at least one Sub-Account (location)

Register OAuth2 app

Go to and create a new app.

Name your application and select a workspace.

Strava – Connector Configuration

Step 1: Create a Strava Account & Access API Settings

Overview

The Each Component iterates over a list and outputs a new message for each item. It allows processing list elements individually, enabling sequential execution of subsequent actions.

Usage

Overview

The HTTP DELETE component allows sending HTTP DELETE requests to external services, enabling users to remove resources via API calls. It provides response details, including body, headers, and status code.

Usage