In n8n, click the "Add workflow" button in the Workflows tab to create a new workflow. Add the starting point – a trigger on when your workflow should run: an app event, a schedule, a webhook call, another workflow, an AI chat, or a manual trigger. Sometimes, the HTTP Request node might already serve as your starting point.
Create custom Flagship and MySQL workflows by choosing triggers and actions. Nodes come with global operations and settings, as well as app-specific parameters that can be configured. You can also use the HTTP Request node to query data from any app or service with a REST API.
List resource
Retrieve all decision API entries.
Update resource
Update an existing entry in the decision API.
Create campaign
This endpoint retrieves all the campaigns that correspond to the specified user and context attributes.
Get campaign assignment
This endpoint retrieves the assignment of your visitor ID with a specific context to the specified campaign ID.
Get campaigns of the account environment
Retrieves campaigns linked to the account environment.
Create a campaign
Creates a new campaign within the account environment.
Get one campaign
Fetches details of a specific campaign.
Delete a campaign
Deletes a specific campaign from the account environment.
Update a campaign
Updates the attributes of a specified campaign.
Toggle campaign state
Toggle the state of a campaign.
Create flag assignment
This endpoint assigns a user to a variation for campaign targeting.
Get flags
Retrieve all flags associated with the account.
Retrieve flags
Retrieves feature flags for the current visitor.
Fetch flag
Fetch flag from the Flagship platform.
Get flag value
Retrieves a flag named 'yourFlagKey'.
Expose flag
Notifies Flagship that the visitor has been exposed to the flag.
Get all flags
Retrieves all visitor's flags as a collection.
List flags
Retrieves all visitor's flags.
Get flag
Retrieves a flag named 'yourFlagKey'.
Expose flag
Directly expose the flag to Flagship without reading the value.
Expose all flags
Expose all of the flags in the collection.
Create activation
Activates a variation for a visitor in a specific environment.
Get projects of the account
Fetches a list of projects associated with the account.
Create a project
Creates a new project in the account.
Get one project
Fetches details of a specific project.
Delete a project
Deletes a specified project from the account.
Update a project
Updates the properties of an existing project.
Toggle project state
Toggles the state of an existing project.
Get variations
Retrieve variations of a specified variation group.
Create variation
Add a new variation to a specified variation group.
Delete variation
Deletes a variation by its identifier.
Update variation
Updates an existing variation.
Get one variation
Retrieves a specific variation by its ID.
Get users
Retrieve a list of users within the account environment.
Update users
Update the details of users in the account environment.
Get targeting keys
Retrieve a list of targeting keys associated with the account.
Get goals
Retrieve all goals associated with the account environment.
Delete goal
Deletes a goal by its identifier.
Update goal
Updates an existing goal.
Get one goal
Retrieves a single goal by its identifier.
Create goal
Creates a new goal.
Generate token
Generate a new access token for the account.
Generate token with expiration
Generate a token with a specific expiration time.
Validate token
Check if an access token is valid.
Create visitor
Creates a new visitor in the system.
Manage visitor consent
Manages the consent settings for a visitor.
Update visitor context
Updates the context information of an existing visitor.
Track data
Tracks specific data points related to a visitor's activity.
Get variation groups
Retrieve the variation groups of the campaign.
Update variation group
Updates an existing variation group.
Delete variation group
Deletes a variation group.
Get one variation group
Retrieves a single variation group by ID.
Create variation group
Creates a new variation group.
To set up Flagship integration, add the HTTP Request node to your workflow canvas and authenticate it using a generic authentication method. The HTTP Request node makes custom API calls to Flagship to query the data you need using the API endpoint URLs you provide.
See the example hereThese API endpoints were generated using n8n
n8n AI workflow transforms web scraping into an intelligent, AI-powered knowledge extraction system that uses vector embeddings to semantically analyze, chunk, store, and retrieve the most relevant API documentation from web pages. Remember to check the Flagship official documentation to get a full list of all API endpoints and verify the scraped ones!
Delete
Delete an entire table or rows in a table
Execute SQL
Execute an SQL query
Insert
Insert rows in a table
Insert or Update
Insert or update rows in a table
Select
Select rows from a table
Update
Update rows in a table
Flagship is a platform for feature flagging that reduces the potential risks associated with launching new features. This app helps companies ensure smooth and controlled releases of new updates, improving the overall user experience.
Break the boundaries of your workflow with SQL and XML in n8n. This extensive tutorial details how to export and import data, style XML with XSLT, and efficiently forward XML files for exponential productivity.
Learn to compare databases automatically, be it SQL tables or data from your favorite CRM. Grab this step-by-step tutorial with a free customizable workflow!
Follow this step-by-step tutorial on how to export SQL tables and queries to Excel using MS Excel itself, SSMS and n8n automation tool.
Learn how to import CSV into MySQL databases using MySQL Workbench, SQL commands, NocoDB and n8n automation tool.
Discover two ways to connect MySQL with Google Sheets, and learn to build no-code workflows for automating it.
Discover our latest community's recommendations and join the discussions about Flagship and MySQL integration.
Mohammadali
Hi guys. I am getting certain data from my SQL database. I want to pass that data to an API. The data I get from the database contains this variable: {{ $input.item }} the problem is that I can not send the value of…
Open topic
Michael Zareno
I have a MySQL table. Test data consists of an "Amount’ field, and three rows with values, 1000, My JSON input is: [ { "row_number": 2, "Amount": -1000 }, { "row_number": 3, "Amount": -52.23 }, …
Open topic
Neal A Richardson Sr
Describe the problem/error/question I’m trying to spin up an n8n instance in kubernetes as a fresh install. I have a database created and the connection works (it created 22 tables) but then the docker container bombs o…
Open topic
GabrielBackend
Greetings, I’m trying to insert null values into my MariaDB using MySQL node. I need to use Execute SQL mode so I can call functions inside my db and do verifications in case of a update, for example IFNULL. There is n…
Open topic
Chaima Belkacem
here is the error details { "errorMessage": "Connection lost: The server closed the connection.", "errorDescription": "sql: undefined, code: PROTOCOL_CONNECTION_LOST", "errorDetails": {}, "n8nDetails": { "no…
Open topic
The world's most popular workflow automation platform for technical teams including
Build complex workflows, really fast