Skip to main content

Jampp Data Source

Nexla's bi-directional connectors allow data to flow both to and from any location, making it simple to create a FlexFlow, DB-CDC, Spark ETL, or Replication data flow that ingests data from a Jampp location.
jampp.png

Jampp

Follow the instructions below to create a new data flow that ingests data from a Jampp source in Nexla.

Create a New Data Flow​

  1. To create a new data flow, navigate to the Integrate section, and click the New Data Flow button. Then, select the desired flow type from the list, and click the Create button.

  2. Select the Jampp connector tile from the list of available connectors. Then, select the credential that will be used to connect to the Jampp account, and click Next; or, create a new Jampp credential for use in this flow.

  3. In Nexla, Jampp data sources can be created using pre-built endpoint templates, which expedite source setup for common Jampp endpoints. Each template is designed specifically for the corresponding Jampp endpoint, making source configuration easy and efficient.
    • To configure this source using a template, follow the instructions in Configure Using a Template.

    Jampp sources can also be configured manually, allowing you to ingest data from Jampp endpoints not included in the pre-built templates or apply further customizations to exactly suit your needs.
    • To configure this source manually, follow the instructions in Configure Manually.

Configure Using a Template​

Nexla provides pre-built templates that can be used to rapidly configure data sources to ingest data from common Jampp endpoints. Each template is designed specifically for the corresponding Jampp endpoint, making data source setup easy and efficient.

Endpoint Settings​

  • 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. Click on an endpoint to see more information about it and how to configure your data source for this endpoint.

    Fetch reports by Query

    Fetch reports of metrics grouped by the dimensions the user is interested in.

    • Enter the GraphQL query in the GraphQL Query field. This should be a valid GraphQL query that defines the metrics and dimensions you want to retrieve from the Jampp Reporting API. The GraphQL query determines what data will be fetched and how it will be structured in the response.
    • The endpoint uses POST requests to https://reporting-api.jampp.com/v1/graphql to execute GraphQL queries. The endpoint URL is automatically constructed based on the Jampp Reporting API base URL.
    • The request body contains the GraphQL query in JSON format: {"query": "{your_graphql_query}"}. The query is sent as a string value in the JSON body.
    • The endpoint does not use pagination (iteration.type: static.url) and returns a single response. The response data path is $.results[*], which extracts all results from the results array in the API response.
    • The date format is yyyy-MM-dd with a time unit of dd (days), which is used for incremental data extraction based on record dates.

    This endpoint retrieves advertising performance reports from the Jampp Reporting API using GraphQL queries. The endpoint requires 2-legged OAuth2 authentication via the Authorization: Bearer {token} header, which is handled automatically by your credential configuration. The access token is obtained using the OAuth2 client credentials flow with your Client ID and Client Secret. GraphQL queries allow you to specify exactly what metrics and dimensions you want to retrieve, making it a flexible way to query advertising data. The query syntax follows GraphQL standards and allows you to filter, group, and aggregate data as needed. For detailed information about GraphQL query syntax, available metrics and dimensions, and API response formats, see the Jampp Reporting API documentation.

Configure Manually​

Jampp data sources can be manually configured to ingest data from any valid Jampp Reporting API endpoint. Manual configuration provides maximum flexibility for accessing endpoints not covered by pre-built templates or when you need custom API configurations.

With manual configuration, you can also create more complex Jampp sources, such as sources that use custom GraphQL queries, different HTTP methods, or custom data transformations.

Content Format​

  1. Select the format in which the data from the Jampp Reporting API will be received from the Content Format pulldown menu. Nexla will automatically parse the data in the selected format. The Jampp Reporting API typically returns data in JSON format.

API Endpoint URL​

  1. Enter the URL of the Jampp Reporting API endpoint from which this source will fetch data in the Set API URL field. This should be the complete URL including the protocol (https://) and any required path parameters. Jampp Reporting API endpoints typically follow the pattern https://reporting-api.jampp.com/v1/{endpoint_path}.

Ensure the API endpoint URL is correct and accessible with your current credentials. You can test the endpoint using the Test button after configuring the URL. The endpoint requires 2-legged OAuth2 authentication via the Authorization: Bearer {token} header, which is handled automatically by your credential configuration. The access token is obtained using the OAuth2 client credentials flow with your Client ID and Client Secret. For detailed information about Jampp Reporting API endpoints, authentication, and available APIs, see the Jampp Reporting API documentation.