### Install and start n8n globally

Source: https://support.dropsolid.io/troubleshooting-and-support/integrations/n8n/installing-n8n-locally

Commands to install n8n via npm and start the service.

```bash
npm install n8n -g
```

```bash
n8n
# or
n8n start
```

--------------------------------

### Start Docker containers

Source: https://support.dropsolid.io/troubleshooting-and-support/integrations/n8n/installing-n8n-locally

Command to start the defined Docker services.

```bash
docker-compose up -d
```

--------------------------------

### Install n8n-node-dev

Source: https://support.dropsolid.io/troubleshooting-and-support/integrations/n8n/extending-with-custom-n8n-nodes

Global installation command for the n8n development toolset.

```bash
npm install n8n-node-dev -g
```

--------------------------------

### Install Langfuse SDK

Source: https://support.dropsolid.io/user-guides/ai-gateway-user-guides/observability-traceability-langfuse/setup-how-to-set-up-and-connect

Use pip to install the required Langfuse package.

```bash
pip install langfuse
```

--------------------------------

### Example URLs with UTM parameters

Source: https://support.dropsolid.io/user-guides/mautic-user-guides/how-to-mautic-components/landing-pages/how-utm-tags-are-captured-from-landing-pages-and-website-pages

These examples demonstrate the format of URLs containing UTM parameters that Mautic will automatically parse.

```text
https://yoursite.com/promo-page?utm_source=newsletter&utm_medium=email&utm_campaign=spring_sale_2026
https://your-mautic.com/page/landing-slug?utm_source=google&utm_medium=cpc&utm_campaign=spring_sale_2026
```

--------------------------------

### Install n8n from repository clone

Source: https://support.dropsolid.io/troubleshooting-and-support/integrations/n8n/installing-n8n-locally

Steps to build n8n from source for development purposes.

```bash
npm install -g npm@6
npm install
lerna bootstrap --hoist
npm run build
npm run dev
```

--------------------------------

### Use a shell script for environment variables

Source: https://support.dropsolid.io/user-guides/platform-user-guides/devops-developing-with-the-platform/how-to-guides-for-devops/how-to-devops-project/project-type-nodejs/working-on-a-nodejs-project

Configure a custom start script in package.json that executes a shell script to export necessary environment variables before starting the application.

```json
  "scripts": {
    "start": "./start.sh"
  },
```

```bash
#!/bin/bash

export MY_ENV_VARIABLE ${DXP_NODE_PORT}
node docroot/server.js
```

--------------------------------

### Install gdpr-mysqldump via Composer

Source: https://support.dropsolid.io/user-guides/platform-user-guides/devops-developing-with-the-platform/how-to-guides-for-devops/how-to-devops-environment/syncing-environments/sanitize-your-database-when-syncing-between-environments

Command to install the required mysqldump tool for external environments.

```bash
composer require druidfi/gdpr-mysqldump
```

--------------------------------

### Install required Drupal modules

Source: https://support.dropsolid.io/getting-started/getting-started-with-personalization/getting-started-with-the-personalized-dxp-experience-drupal-mautic-and-dropsolid-personalization

Use Composer to install the necessary modules for Unomi, Dropsolid Personalization, Mautic integration, and asset management.

```bash
composer require drupal/unomi:2.x-dev     composer require drupal/dropsolid_personalisation:1.x-dev     composer require drupal/mautic_paragraph:^1.0@beta     composer require drupal/asset_injector     composer require drupal/metatag
```

--------------------------------

### Example of a URL with UTM parameters

Source: https://support.dropsolid.io/user-guides/mautic-user-guides/how-to-mautic-channels/emails/setting-up-utm-tags-in-mautic-emails-for-analytics-tracking

This shows the expected format of a link after Mautic has appended the configured UTM parameters.

```text
https://yoursite.com/promo?utm_source=newsletter&utm_medium=email&utm_campaign=spring_sale_2026
```

--------------------------------

### Token replacement in settings.php

Source: https://support.dropsolid.io/user-guides/platform-user-guides/devops-developing-with-the-platform/how-to-guides-for-devops/how-to-devops-environment/deployment-of-an-environment/general-deployment/switching-from-the-drupal-specific-to-the-general-git-reference-deployment-method

Example of using placeholders for database credentials and environment-specific settings in Drupal configuration.

```php
<?php
      $db_name = '[[ database_name ]]';
      $db_user = '[[ database_user ]]';
      $db_pass = '[[ database_password ]]';
      $db_host = '[[ database_host ]]';
      $db_port = '[[ database_port ]]';
      $db_driver = 'mysql';
      $db_prefix = '';

[...]
      $settings['hash_salt'] = '[[ env_secret_key ]]';

[...]

      // List of trusted IPs (IP numbers of our reverse proxies)
      $settings['reverse_proxy_addresses'] = array_merge(['127.0.0.1'], explode(',','[[ proxy_ips ]]'));

      // Now that token support is in you can also use a token to determine Drupal's deployment identifier
      $settings['deployment_identifier'] = \Drupal::VERSION . '[[ unix_timestamp_at_deploy_time ]]';

      if (file_exists(DRUPAL_ROOT . '/../etc/drupal/additional_settings.[[ environment_name ]].php')) {
        include DRUPAL_ROOT . '/../etc/drupal/additional_settings.[[ environment_name ]].php';
      }
[...]
```

--------------------------------

### Sync database using Drush

Source: https://support.dropsolid.io/user-guides/platform-user-guides/devops-developing-with-the-platform/how-to-guides-for-devops/how-to-local-development/how-to-get-a-project-locally

Example command for synchronizing a remote staging database to a local environment.

```bash
ddev drush sql:sync @<my project>.staging @self
```

--------------------------------

### Token replacement in deploy.sh

Source: https://support.dropsolid.io/user-guides/platform-user-guides/devops-developing-with-the-platform/how-to-guides-for-devops/how-to-devops-environment/deployment-of-an-environment/general-deployment/switching-from-the-drupal-specific-to-the-general-git-reference-deployment-method

Example of using environment tokens within a shell script for configuration management.

```bash
#!/bin/sh
[...]
  # Ensure CMI knows about the split.
  ${DRUSH} config_import_single:single-import ../config/sync/config_split.config_split.[[ environment_name ]].yml
[...]
```

--------------------------------

### Example platform.sanitize.yml Structure

Source: https://support.dropsolid.io/user-guides/platform-user-guides/devops-developing-with-the-platform/how-to-guides-for-devops/how-to-devops-environment/syncing-environments/sanitize-your-database-when-syncing-between-environments

The base configuration file structure for defining sanitization rules.

```yaml
mysqldump_path: <path-to-overridden-mysqldump> (only necessary on externally hosted environments)
structure_only:
  - ^cache.*
  - ^sessions$
sql:
  table name:
    column name:
      expression: "NULL"
    column name 2:
      replace: userName
  table name 2:
    column name:
      expression: CONCAT(column name 2, "-addendum")
    column name 2:
      replace: phoneNumber
```

--------------------------------

### Access n8n interface

Source: https://support.dropsolid.io/troubleshooting-and-support/integrations/n8n/installing-n8n-locally

Example URL format for accessing the n8n interface.

```text
projectname.docker.localhost:5678
```

--------------------------------

### Example of prefixed data format

Source: https://support.dropsolid.io/user-guides/platform-user-guides/products-managing-the-products-you-own/how-to-guides-for-products/how-to-personalization/javascript-api-for-interacting-with-captures

Demonstrates the required prefixing for properties to ensure correct storage in the Unomi Elasticsearch database.

```json
{
    te__dayOfWeek: 'Monday',  
    da__birthday: '2020-09-28T09:26:12.621Z'   
}
```

--------------------------------

### Troubleshooting repository access errors

Source: https://support.dropsolid.io/user-guides/platform-user-guides/devops-developing-with-the-platform/how-to-guides-for-devops/how-to-migrations-and-upgrades/2020-04-16-the-switch-to-gitlab

Example of an error message encountered when attempting to access an outdated repository path.

```text
# remote: The repository url you are looking for is: git@git.dropsolid.com:project/<project_name>.git
fatal: '/var/repositories/customprojects_D8/<project_name>' does not appear to be a git repository
fatal: Could not read from remote repository.

Please make sure you have the correct access rights
and the repository exists.
```

--------------------------------

### Define start script in package.json

Source: https://support.dropsolid.io/user-guides/platform-user-guides/devops-developing-with-the-platform/how-to-guides-for-devops/how-to-devops-project/project-type-nodejs/working-on-a-nodejs-project

Specify the command to launch the application within the scripts section of the project's package.json file.

```json
  "scripts": {
    "start": "node docroot/server.js"
  },
```

--------------------------------

### Install Drupal Personalization Module

Source: https://support.dropsolid.io/user-guides/platform-user-guides/products-managing-the-products-you-own/how-to-guides-for-products/how-to-personalization/setting-up-personalization

Use Composer to install the Dropsolid Personalization module for Drupal 8.

```bash
composer require drupal/dropsolid_personalisation
```

--------------------------------

### SQL Sanitization Expression Examples

Source: https://support.dropsolid.io/user-guides/platform-user-guides/devops-developing-with-the-platform/how-to-guides-for-devops/how-to-devops-environment/syncing-environments/sanitize-your-database-when-syncing-between-environments

Examples of using SQL expressions to sanitize user data fields.

```yaml
 sql:
   users_field_data:
     mail:
       expression: CONCAT(`uid`, "@example.com") or "CONCAT(uid, \"@example.com\")" or CONCAT(uid, '@example.com')
     name:
       expression: uid or "uid" or "`uid`" or 'uid'
     pass:
       expression: "NULL" or 'NULL'
```

```yaml
 sql:
   users_field_data:
     mail:
       expression: CONCAT("uid", "@example.com") or "CONCAT(\"uid\", \"@example.com\")" or CONCAT('uid', '@example.com')
     name:
       expression: "\"uid\"" or "'uid'"
     pass:
       expression: "\"NULL\"" or "'NULL'"
```

--------------------------------

### Configure Environment Variables

Source: https://support.dropsolid.io/user-guides/ai-gateway-user-guides/observability-traceability-langfuse/setup-how-to-set-up-and-connect

Set the required credentials and base URL in your environment, typically via a .env file.

```bash
LANGFUSE_PUBLIC_KEY="pk-lf-..."
LANGFUSE_SECRET_KEY="sk-lf-..."
LANGFUSE_BASE_URL="https://tracing.prod.platform.dropsolid.ai"
```

--------------------------------

### Invalid cron job examples

Source: https://support.dropsolid.io/user-guides/platform-user-guides/devops-developing-with-the-platform/how-to-guides-for-devops/how-to-devops-environment/cron-on-an-environment/configuring-cronjobs-in-the-dropsolid-experience-cloud

These examples demonstrate syntax that is restricted due to the use of bash special characters or unsupported command chaining.

```bash
drush @PROJECT.ENV ev 'shell_exec("cp ../file.default ../file");'
```

```bash
drush @PROJECT.ENV migrate-import products; drush @PROJECT.ENV migrate-import --group=product_translations
```

```bash
drush @PROJECT.ENV cron > /var/www/project_type/PROJECT/ENV/private/files/logs/log.txt
```

--------------------------------

### Direct Asset URL with UTM Parameters

Source: https://support.dropsolid.io/user-guides/mautic-user-guides/how-to-mautic-components/assets/how-utm-tags-work-on-mautic-asset-downloads

Example of a manually constructed asset URL containing UTM parameters for tracking purposes.

```text
https://your-mautic.com/asset/your-file?utm_source=newsletter&utm_medium=email&utm_campaign=spring_sale_2026
```

--------------------------------

### GET /cxs/jsonSchema

Source: https://support.dropsolid.io/getting-started/getting-started-with-personalization/self-hosted-personalization-requirements

Retrieves all registered JSON schemas.

```APIDOC
## GET /cxs/jsonSchema

### Description
Retrieves a list of all JSON schemas currently registered in Unomi.

### Method
GET

### Endpoint
<unomi_url>/cxs/jsonSchema
```

--------------------------------

### Get a JSON schema

Source: https://support.dropsolid.io/getting-started/getting-started-with-personalization/self-hosted-personalization-requirements

Query a specific schema by its unique ID.

```bash
curl --request POST \
  --url <unomi_url>/cxs/jsonSchema/query \
  --header '<authorization_header>' \
  --header 'content-type: text/plain' \
  --data https://unomi.apache.org/schemas/json/events/dataCaptured/1-0-0
```

--------------------------------

### Example landing page URL with UTM parameters

Source: https://support.dropsolid.io/user-guides/mautic-user-guides/how-to-mautic-components/forms/form-actions/how-to-set-up-utm-tag-registration-in-mautic-forms

This URL demonstrates the required format for passing UTM parameters to a page containing a Mautic form.

```text
https://yoursite.com/landing-page?utm_source=newsletter&utm_medium=email&utm_campaign=spring_sale_2026
```

--------------------------------

### Get all JSON schemas

Source: https://support.dropsolid.io/getting-started/getting-started-with-personalization/self-hosted-personalization-requirements

Retrieve a list of all currently registered schemas in Unomi.

```bash
curl --request GET \
  --url <unomi_url>/cxs/jsonSchema \
  --header '<authorization_header>'
```

--------------------------------

### Clone a project repository

Source: https://support.dropsolid.io/getting-started/getting-started-with-platform/deploy-your-code

Use this command in your terminal to download a project repository to your local machine.

```bash
git clone git@<ssh url> my_folder
```

--------------------------------

### Geolocation data format

Source: https://support.dropsolid.io/user-guides/platform-user-guides/products-managing-the-products-you-own/how-to-guides-for-products/how-to-cdp/configure-your-cdp

Examples of primary and secondary geolocation data captured by the add-on.

```text
city: Ghent
country name: Belgium
country code: BE

```

```text
admin sub div1: 3337388 (more information down below)
admin sub div2: 2789733 (more information down below)
city id: 2797656 (more information down below)
location > lat: 51.047
location > lon: 3.7206
country and city: Belgium@@Ghent@@3337388@@2789733

```