Medallia Journey Analytics

Medallia Journey Analytics provides comprehensive customer experience analytics and journey mapping capabilities, enabling organizations to track customer interactions, analyze behavioral patterns, and optimize customer journeys through advanced analytics and insights.

Power end-to-end data operations for your Medallia Journey Analytics API with Nexla. Our bi-directional Medallia Journey Analytics connector is purpose-built for Medallia Journey Analytics, making it simple to ingest data, sync it across systems, and deliver it anywhere — all with no coding required. Nexla turns API-sourced data into ready-to-use, reusable data products and makes it easy to send data to Medallia Journey Analytics or any other destination. With comprehensive monitoring, lineage tracking, and access controls, Nexla keeps your Medallia Journey Analytics workflows fast, secure, and fully governed.

Features

Type: API

SourceDestination

• Seamless API Integration: Connect to any endpoint as source or destination without coding, with automatic data product creation
• Visual Composition & Chaining: Build complex integrations using visual templates, chain API calls, and compose workflows with data validation and filtering
• API Proxy: Expose curated slices of your data securely with a secure and customizable API proxy that validates and transforms data on the fly
• Request optimization with intelligent batching, retry, and caching to minimize API calls and costs

Prerequisites

Before creating a Medallia Journey Analytics credential, you need to obtain your API token from your Medallia Journey Analytics account. Medallia Journey Analytics uses token-based authentication for all API requests, with the API token sent in the Token header.

To obtain your Medallia Journey Analytics API token, follow these steps:

1. Sign in to your Medallia Journey Analytics account using your administrator credentials.

2. Click on the user icon in the top right corner of the Medallia Journey Analytics application.

3. Navigate to your account settings or API settings section.

4. Look for the API Token or Token section in your account settings.

5. If you don't have an API token yet, click Generate Token or Create Token to create a new API token.

6. Copy the API token immediately after it's generated, as it may not be accessible again after you navigate away from the page.

7. Store the API token securely, as you will need it to configure your Nexla credential. The API token provides access to your Medallia Journey Analytics data and should be treated as sensitive information.

The API token is sent in the Token header for all API requests to the Medallia Journey Analytics API. The token authenticates your requests and grants access to Medallia Journey Analytics resources based on your account permissions. If your API token is compromised, you should immediately revoke it in your Medallia Journey Analytics account settings and generate a new one. For detailed information about API authentication, available endpoints, and API usage, refer to the Medallia Journey Analytics API documentation.

Authenticate

Credentials required

Field	Required	Secret	Description
API Token	Yes	Yes	Medallia API Token. Get it from your Medallia Journey Analytics Account by clicking on the user icon in the top right hand side of the application

Create a credential in Nexla

1. After selecting the data source/destination type, click the Add Credential tile to open the Add New Credential overlay.

New Credential Overlay – Medallia Journey Analytics

2. Enter a name for the credential in the Credential Name field and a short, meaningful description in the Credential Description field.

3. Enter your Medallia Journey Analytics API token in the API Token field. This is the API token you obtained from your Medallia Journey Analytics account by clicking on the user icon in the top right corner of the application. The API token is sent in the Token header for all API requests to the Medallia Journey Analytics API and must be kept confidential.

   Your Medallia Journey Analytics API token can be found in your Medallia Journey Analytics account by clicking on the user icon in the top right corner of the application. The API token is sent in the Token header for all API requests to the Medallia Journey Analytics API.

   If your API token is compromised, you should immediately revoke it in your Medallia Journey Analytics account settings and generate a new one. The API token provides access to your Medallia Journey Analytics data and should be treated as sensitive information. Keep your API token secure and do not share it publicly.

   For detailed information about obtaining API tokens, API authentication, and available endpoints, see the Medallia Journey Analytics API documentation.

4. Click the Save button at the bottom of the overlay. The newly added credential will now appear in a tile on the Authenticate screen during data source/destination creation.

Use as a data source

To create a new data flow, navigate to the Integrate section, and click the New Data Flow button. Select the Medallia Journey Analytics connector tile, then select the credential that will be used to connect to your Medallia Journey Analytics account, and click Next; or, create a new Medallia Journey Analytics credential for use in this flow.

Endpoint templates

Nexla provides pre-built templates that can be used to rapidly configure data sources to ingest data from common Medallia Journey Analytics endpoints. Select the endpoint from which this source will fetch data from the Endpoint pulldown menu. Available endpoint templates are listed in the expandable boxes below.

Fetch Project Data using CQL Query

This endpoint template fetches data for a project by submitting a CQL (Cooladata Query Language) query. Use this template when you need to retrieve specific data from a Medallia Journey Analytics project using a custom CQL query. This allows you to filter, aggregate, and transform data according to your specific requirements.

• Enter the project ID in the Project ID field. This is the unique identifier for the Medallia Journey Analytics project from which you want to fetch data. You can find the project ID by using the "Get all Projects" endpoint or in your Medallia Journey Analytics account.
• Enter your CQL query in the Query field. This should be a valid CQL query that retrieves the data you need from the specified project. The CQL query is sent in the request body as a tq parameter. CQL queries allow you to filter, aggregate, and transform data according to your specific requirements.

CQL (Cooladata Query Language) is a powerful query language that allows you to filter, aggregate, and transform data from Medallia Journey Analytics projects. The query is sent as a POST request to the CQL endpoint with the query in the tq parameter. For detailed information about CQL syntax, query examples, and available functions, see the Medallia Journey Analytics Query API documentation.

Project IDs are unique identifiers that can be obtained from the "Get all Projects" endpoint or from your Medallia Journey Analytics account. Ensure you have the correct Project ID before configuring this endpoint.

Get all Projects

This endpoint template retrieves a list of all projects that the authenticated user has permissions to access in your Medallia Journey Analytics account. Use this template when you need to discover available projects, retrieve project metadata, or identify project IDs for use with other endpoints.

• This endpoint automatically retrieves all projects accessible to your API token. No additional configuration is required beyond selecting this endpoint template.

This endpoint returns a list of all projects that the authenticated user has permissions to access, including project IDs, names, and metadata. Use this endpoint to discover available projects before configuring other endpoints that require a project ID. The endpoint returns project information including project structure and available data fields.

For detailed information about project structure, available fields, and API endpoints, see the Medallia Journey Analytics Discovery API documentation.

Once the selected endpoint template has been configured, click the Test button to the right of the endpoint selection menu to retrieve a sample of the data that will be fetched. Sample data will be displayed in the Endpoint Test Result panel on the right, allowing you to verify that the source is configured correctly before saving.

Manual configuration

Medallia Journey Analytics data sources can also be manually configured to ingest data from any valid Medallia Journey Analytics API endpoint, including endpoints not covered by the pre-built templates, chained API calls, or custom request parameters. Select the Advanced tab at the top of the configuration screen, and follow the instructions in Connect to Any API to configure the API method, endpoint URL, date/time and lookup macros, path to data, metadata, and request headers.

The Medallia Journey Analytics API base URL is app.cooladata.com, and endpoints use either the /api/v2/ or /api/v3/ version path (for example, https://app.cooladata.com/api/v3/projects to list projects, or https://app.cooladata.com/api/v2/projects/{project_id}/cql for CQL queries). For CQL queries, the request body format is typically tq={your_cql_query}. In the Response Data Path field, use $[*] to extract all items from a response array, or $ to extract the entire response object.

Once all of the relevant settings have been configured, click the Create button in the upper right corner of the screen to save and create the new Medallia Journey Analytics data source. Nexla will now begin ingesting data from the configured endpoint and will organize any data that it finds into one or more Nexsets.