Cannot Pass Multiple Values to Dynamic Variable via API Due to JSON Payload Structure

[aashishvanand]

Description:

When using the API to pass values to a query that uses a dynamic field (which is defined as a query-based dropdown list with multiple values allowed), it seems that the current JSON payload structure restricts the ability to pass multiple values for that dynamic field.

Reproduction Steps:

1. Create a query with the following structure:

{
  "collection": "collectionA",
  "aggregate": [
    {
      "$match": {
       "field1": {
          "$in": ["{{dynamic_field}}"]
        }
      }
    }
  ]
}

2. Use Postman or curl to make a request to the query results API with the following payload:

curl --location 'https://redash.domain.app/api/queries/1/results' \
--header 'Authorization: xxxxxxx' \
--header 'Content-Type: application/json'  \
--data '{ 
    "parameters": {
     "dynamic_field": "ABC123"
    }
}'

3. Try to pass multiple values for dynamic_field, e.g., "dynamic_field": ["ABC123","DEF456"].

Expected Behavior:

The query should understand multiple values for dynamic_field and process them correctly.

Actual Behavior:

Due to the JSON payload structure, the query does not understand how to handle an array of values for dynamic_field.

Workaround:

None found. Limited to one query at a time.

Environment:

• Redash Version: 10.1.0
• Browser/OS: Any
• How did you install Redash: Docker, Ubuntu 22, AWS.
• Database: MongoDB 6.x

Additional Context:

The inability to pass multiple values restricts the utility of the dynamic fields when using the API, particularly for MongoDB queries that may require multiple matching criteria.

Thank you for looking into this issue.