[ANALYTICS-364] client-secret key is not resolved for adobe supplier in analytic view Created: 14/Jun/21  Updated: 08/Jul/21  Resolved: 25/Jun/21

Status: Closed
Project: Analytics
Component/s: None
Affects Version/s: 1.1, 1.2
Fix Version/s: 1.1.1, 1.2.1

Type: Bug Priority: Neutral
Reporter: Jonathan Ayala Assignee: Oanh Thai Hoang
Resolution: Fixed Votes: 0
Labels: VN-Implementation, VN-Testing, maintenance
Remaining Estimate: 0d
Time Spent: 2d 1h
Original Estimate: Not Specified

Attachments: PNG File Screen Shot 2021-06-14 at 15.11.18.png     PNG File Screen Shot 2021-06-30 at 11.09.01.png    
Issue Links:
causality
Template:
Acceptance criteria:
Empty
Task DoD:
[X]* Doc/release notes changes? Comment present?
[X]* Downstream builds green?
[X]* Solution information and context easily available?
[X]* Tests
[X]* FixVersion filled and not yet released
[ ]  Architecture Decision Record (ADR)
Bug DoR:
[X]* Steps to reproduce, expected, and actual results filled
[X]* Affected version filled
Release notes required:
Yes
Documentation update required:
Yes
Date of First Response:
Epic Link: Analytics maintenance & partnership support
Sprint: Content Mngmt 6, Content Mngmt 7
Story Points: 5

 Description   

Steps to reproduce

  1.  Use the adobe data supplier in analytic view as explained here

Expected results

The view is correctly show

Actual results

There's an error due to missing client_secret parameter

Workaround

Setting a new parameter in the data supplier: decryptedClientSecret. After setting this property, it is necessary to clear cache by clicking the refresh button in the analytics app



 Comments   
Comment by Oanh Thai Hoang [ 30/Jun/21 ]

Hi jlegendre, here is the sample config for adobe in case user wanna config adobe in Analytic extension view (Currently, our adobe connector does not support filtering by pageUrl, we have a ticket later), I'll update later in docu git :bow.

 

extensionViews:
  - name: analytics
    icon: icon-analytics-app
    view:
      name: analytics
      $type: analyticsView
      chartDefinitions:
        - name: adobe
          label: adobe views
          class: info.magnolia.analytics.amcharts.data.AmChartDefinition
          dataSupplier: adobeSupplier
          chartType: !include:/analytics-ui/chartTypes/line-and-area/line-different-colors-ups-downs.yaml
            series:
              - name: series
                dataFields:
                  - name: categoryX
                    jsonPath: $.rows[*].value
                  - name: valueY
                    jsonPath: $.rows[*].data[0]
      dataSuppliers:
        adobeSupplier:
          class: info.magnolia.analytics.adobe.datasource.AdobeDataSupplier
          credentials:
            parameters:
              serviceUrl: https://analytics.adobe.io/api/exchan213/reports
              clientId: <your-client-id>
              clientSecret: <client_secret_or_path_to_password_manager>
              companyId: exchan213
              orgId: 6AE67B675E217A090A495EE1@AdobeOrg
              technicalAccountId: 1501153F5E44CB8F0A495E4C@techacct.adobe.com
              imsHost: https://ims-na1.adobelogin.com
              imsExchange: https://ims-na1.adobelogin.com/ims/exchange/jwt
              # generate private key file : openssl req -nodes -text -x509 -newkey rsa:2048 -keyout secret.pem -out certificate.pem -days 356
              # Upload the certificate.pem in Adobe IO Console-> Your Integration-> Public keys
              # convert private key to DER format : openssl pkcs8 -topk8 -inform PEM -outform DER -in secret.pem -nocrypt > secret.key
              # private key file should be in DER encoded format now, and config the path like below
              privateKeyPath: /adobe-analytics/analytics/adobe/secret.key
              metascopes: ent_analytics_bulk_ingest_sdk
              tokenExpTime: 3600
          parameters:
            rsid: emagmgnl
            gFilterType: dateRange
            startDate: '2020-01-01'
            endDate: '2020-01-15'
            metricId: metrics/revenue
            dimension: variables/daterangeday
      filterFields:
        - name: startDate
          $type: dateField
          type: java.util.Date
          time: false
          defaultValue: todayMinus7Days
        - name: endDate
          $type: dateField
          type: java.util.Date
          time: false
          defaultValue: today

Additional practice for user, clear cache in Dashboard app will help to clear cache of dataSupplier in extension view

 

Generated at Sun Feb 11 23:18:10 CET 2024 using Jira 9.4.2#940002-sha1:46d1a51de284217efdcb32434eab47a99af2938b.