Allow to pass a json as a string for cube js query

[jdotcms]

Parent Issue

No response

User Story

As a developer, I wan to be able to pass a string as a query for doing cube js queries. Currently, there is a bean in the middle but it is not jackson friendlys, so I need to pass the cube js query straight to the client

Acceptance Criteria

We can send a cube js query using the endpoint

Proposed Objective

Core Features

Proposed Priority

Priority 3 - Average

External Links... Slack Conversations, Support Tickets, Figma Designs, etc.

No response

Assumptions & Initiation Needs

No response

Quality Assurance Notes & Workarounds

No response

Sub-Tasks & Estimates

No response

[jdotcms]

In order to test it you can run a curl such as

curl --location 'http://localhost:8080/api/v1/analytics/content/_query/cube' \
--header 'Content-Type: application/json' \
--header 'Authorization: ••••••' \
--header 'Cookie: JSESSIONID=3BF8D482C623963FF6418FFE90684DEC' \
--data '{
  "order": {
    "request.createdAt": "asc"
  },
  "dimensions": [
    "request.requestId"
  ],
  "measures": [
    "request.count"
  ],
  "timeDimensions": [
    {
      "dimension": "request.createdAt",
      "granularity": "day"
    }
  ]
}'

As you can see the body is the actual cube js raw query The results are the same of the just "_query"

[jcastro-dotcms]

INTERNAL QA: PASSED

• Docker image: trunk_98f280e

I created a Postman request with the information provided by @jdotcms , and the REST Endpoint is returning the expected data.

[josemejias11]

Approved: Tested on trunk_a12617a, Docker, macOS 14.5, FF v126.0.1