Skip to content

Filtering Datasources using the "In" Operator #826

Closed

Description

@tuse0708

When attempting to filter using the "In" operator on datasources, I am able to filter a single source using "Equals" but if I switch to "In" and supply a list, I get "400065: Bad Request. The filter query is missing a value for key 'name'."

Versions

Tableau Server Version: 2019.4.2 (20194.20.0119.2058) 64-bit Linux
Python 3.8.4
TSC library version - 0.15

To Reproduce

import tableauserverclient as TSC

username = ""
pw = ""
site = ""
tableau_auth = TSC.TableauAuth(username, pw, site)
server = TSC.Server('https://HOSTNAME/', use_server_version=True)
req_option = TSC.RequestOptions()

jobs_to_refresh = ['Example Job 1','Example Job 2']

with server.auth.sign_in(tableau_auth):
    req_option.filter.add(TSC.Filter(TSC.RequestOptions.Field.Name,
                                TSC.RequestOptions.Operator.In,
                                jobs_to_refresh))
    matching_datasources, pagination_item = server.datasources.get(req_options=req_option)
    print(matching_datasources[0].name, matching_datasources[0].id)

Results
400065: Bad Request. The filter query is missing a value for key 'name'.

Activity

  1. bcantoni commented on Apr 23, 2021

    @bcantoni
    Contributor

    @tuse0708 are you still facing this issue?

    I've not been able to reproduce the problem so far. Can you show what are your actual names you're providing in jobs_to_refresh? I can see some past issues when those names have ampersands or dashes in them.

  2. tuse0708 commented on Apr 26, 2021

    @tuse0708
    Author

    @bcantoni I am still facing the issue. The code reads as follows......

    jobs_to_refresh = ['Stroke and AMI NPOA Extract','Readmission Dashboard Extract']

  3. added
    help wantedA user needs help, may be a mistake, a bug or a feature request
    on Nov 8, 2021
  4. bcantoni commented on Sep 19, 2024

    @bcantoni
    Contributor

    I'll double-check this to make sure our docs/example show it correctly.

  5. github-actions commented on Aug 6, 2026

    @github-actions

    This issue has been automatically marked as stale because it has not had recent activity. It will be closed in 14 days if no further activity occurs. If this is still relevant, please comment to keep it open.

  6. github-actions commented on Aug 21, 2026

    @github-actions

    Closing due to inactivity. If this is still relevant, please reopen or file a new issue.

  7. jacalata commented on Aug 21, 2026

    @jacalata
    Contributor

    Supported. Use TSC.RequestOptions.Operator.In with a list of values.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

No one assigned

    Labels

    help wantedA user needs help, may be a mistake, a bug or a feature requeststale

    Type

    No type

    Projects

    No projects

      Milestone

      No milestone

      Relationships

      None yet

      Development

      No branches or pull requests

      Issue actions