Create Util Method to run a query in the CubeJS Server

[freddyDOTCMS]

Parent Issue

• Spike: Define specification and scope to configure Content Analytics and perform raw BE queries on the data #29477

User Story

We need to create a method similar to this one in this same class, but it should take a JSON string directly as a parameter. I'm not sure if we should call this method directly from the endpoint or if we should create an API-level method for it instead.

Acceptance Criteria

Have the Util class needed to use in this issue:

• Create Endpoint to allow running a query directly into CA data #29864

Proposed Objective

Core Features

Proposed Priority

Please Select

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

[freddyDOTCMS]

Blocked by issue #29862

[freddyDOTCMS]

Pass IQA: Work as expected even when we have some point to improve in the Query syntax the ViewTool is working well

Improvement we need in the query syntax:

• Support Or logic operator in CA Query filters #30190
• Support filters arrays multi values in the CA Query #30191

[freddyDOTCMS]

QA Note: this is test with

• Create a ViewTool to retrieve the CA data #29866
• Create Endpoint to allow running a query directly into CA data #29864