Items By Multiple Column Values

This is a module containing: Monday query_items_by_multiple_column_values* tasks

query_items_by_multiple_column_values(board_id, column_id, column_values, monday_credentials, limit=None, page=1, column_type=None, state='active', return_fields=None) async

Get your data from monday.com.

Parameters:

Name	Type	Description	Default
board_id	int	The board's unique identifier.	required
column_id	str	The column's unique identifier.	required
column_values	Iterable[str]	The column values to search items by.	required
monday_credentials	MondayCredentials	Credentials to use for authentication with Monday.	required
limit	int	Number of items to get.	None
page	int	Page number to get, starting at 1.	1
column_type	str	The column type.	None
state	State	The state of the item (all / active / archived / deleted), the default is active.	'active'
return_fields	Iterable[str]	Subset the return fields (as snake_case); defaults to fields listed in configs/query/*.json.	None

Returns:

Type	Description
Dict[str, Any]	A dict of the returned fields.

Source code in prefect_monday/items_by_multiple_column_values.py

@task
async def query_items_by_multiple_column_values(
    board_id: int,
    column_id: str,
    column_values: Iterable[str],
    monday_credentials: MondayCredentials,
    limit: int = None,
    page: int = 1,
    column_type: str = None,
    state: graphql_schema.State = "active",
    return_fields: Iterable[str] = None,
) -> Dict[str, Any]:
    """
    Get your data from monday.com.

    Args:
        board_id: The board's unique identifier.
        column_id: The column's unique identifier.
        column_values: The column values to search items by.
        monday_credentials: Credentials to use for authentication with Monday.
        limit: Number of items to get.
        page: Page number to get, starting at 1.
        column_type: The column type.
        state: The state of the item (all / active / archived / deleted), the
            default is active.
        return_fields: Subset the return fields (as snake_case); defaults to
            fields listed in configs/query/*.json.

    Returns:
        A dict of the returned fields.
    """
    op = Operation(graphql_schema.Query)
    op_selection = op.items_by_multiple_column_values(
        **strip_kwargs(
            board_id=board_id,
            column_id=column_id,
            column_values=column_values,
            limit=limit,
            page=page,
            column_type=column_type,
            state=state,
        )
    )

    op_stack = ("items_by_multiple_column_values",)
    op_selection = _subset_return_fields(
        op_selection, op_stack, return_fields, return_fields_defaults
    )

    result = await _execute_graphql_op(op, monday_credentials)
    return result["items_by_multiple_column_values"]

query_items_by_multiple_column_values_assets(board_id, column_id, column_values, monday_credentials, limit=None, page=1, column_type=None, state='active', assets_source=None, column_ids=None, return_fields=None) async

The item's assets/files.

Parameters:

Name	Type	Description	Default
board_id	int	The board's unique identifier.	required
column_id	str	The column's unique identifier.	required
column_values	Iterable[str]	The column values to search items by.	required
monday_credentials	MondayCredentials	Credentials to use for authentication with Monday.	required
limit	int	Number of items to get.	None
page	int	Page number to get, starting at 1.	1
column_type	str	The column type.	None
state	State	The state of the item (all / active / archived / deleted), the default is active.	'active'
assets_source	AssetsSource	The assets source (all / columns / gallery).	None
column_ids	Iterable[str]	Ids of the columns you want to get assets from.	None
return_fields	Iterable[str]	Subset the return fields (as snake_case); defaults to fields listed in configs/query/*.json.	None

Returns:

Type	Description
Dict[str, Any]	A dict of the returned fields.

Source code in prefect_monday/items_by_multiple_column_values.py

@task
async def query_items_by_multiple_column_values_assets(
    board_id: int,
    column_id: str,
    column_values: Iterable[str],
    monday_credentials: MondayCredentials,
    limit: int = None,
    page: int = 1,
    column_type: str = None,
    state: graphql_schema.State = "active",
    assets_source: graphql_schema.AssetsSource = None,
    column_ids: Iterable[str] = None,
    return_fields: Iterable[str] = None,
) -> Dict[str, Any]:
    """
    The item's assets/files.

    Args:
        board_id: The board's unique identifier.
        column_id: The column's unique
            identifier.
        column_values: The column values to
            search items by.
        monday_credentials: Credentials to use for authentication with Monday.
        limit: Number of items to get.
        page: Page number to get, starting at 1.
        column_type: The column type.
        state: The state of the item (all /
            active / archived / deleted), the default is active.
        assets_source: The assets source (all / columns / gallery).
        column_ids: Ids of the columns you want to get assets from.
        return_fields: Subset the return fields (as snake_case); defaults to
            fields listed in configs/query/*.json.

    Returns:
        A dict of the returned fields.
    """
    op = Operation(graphql_schema.Query)
    op_selection = op.items_by_multiple_column_values(
        **strip_kwargs(
            board_id=board_id,
            column_id=column_id,
            column_values=column_values,
            limit=limit,
            page=page,
            column_type=column_type,
            state=state,
        )
    ).assets(
        **strip_kwargs(
            assets_source=assets_source,
            column_ids=column_ids,
        )
    )

    op_stack = (
        "items_by_multiple_column_values",
        "assets",
    )
    op_selection = _subset_return_fields(
        op_selection, op_stack, return_fields, return_fields_defaults
    )

    result = await _execute_graphql_op(op, monday_credentials)
    return result["items_by_multiple_column_values"]["assets"]

query_items_by_multiple_column_values_board(board_id, column_id, column_values, monday_credentials, limit=None, page=1, column_type=None, state='active', return_fields=None) async

The board that contains this item.

Parameters:

Name	Type	Description	Default
board_id	int	The board's unique identifier.	required
column_id	str	The column's unique identifier.	required
column_values	Iterable[str]	The column values to search items by.	required
monday_credentials	MondayCredentials	Credentials to use for authentication with Monday.	required
limit	int	Number of items to get.	None
page	int	Page number to get, starting at 1.	1
column_type	str	The column type.	None
state	State	The state of the item (all / active / archived / deleted), the default is active.	'active'
return_fields	Iterable[str]	Subset the return fields (as snake_case); defaults to fields listed in configs/query/*.json.	None

Returns:

Type	Description
Dict[str, Any]	A dict of the returned fields.

Source code in prefect_monday/items_by_multiple_column_values.py

@task
async def query_items_by_multiple_column_values_board(
    board_id: int,
    column_id: str,
    column_values: Iterable[str],
    monday_credentials: MondayCredentials,
    limit: int = None,
    page: int = 1,
    column_type: str = None,
    state: graphql_schema.State = "active",
    return_fields: Iterable[str] = None,
) -> Dict[str, Any]:
    """
    The board that contains this item.

    Args:
        board_id: The board's unique identifier.
        column_id: The column's unique
            identifier.
        column_values: The column values to
            search items by.
        monday_credentials: Credentials to use for authentication with Monday.
        limit: Number of items to get.
        page: Page number to get, starting at 1.
        column_type: The column type.
        state: The state of the item (all /
            active / archived / deleted), the default is active.
        return_fields: Subset the return fields (as snake_case); defaults to
            fields listed in configs/query/*.json.

    Returns:
        A dict of the returned fields.
    """
    op = Operation(graphql_schema.Query)
    op_selection = op.items_by_multiple_column_values(
        **strip_kwargs(
            board_id=board_id,
            column_id=column_id,
            column_values=column_values,
            limit=limit,
            page=page,
            column_type=column_type,
            state=state,
        )
    ).board(**strip_kwargs())

    op_stack = (
        "items_by_multiple_column_values",
        "board",
    )
    op_selection = _subset_return_fields(
        op_selection, op_stack, return_fields, return_fields_defaults
    )

    result = await _execute_graphql_op(op, monday_credentials)
    return result["items_by_multiple_column_values"]["board"]

query_items_by_multiple_column_values_column_values(board_id, column_id, column_values, monday_credentials, limit=None, page=1, column_type=None, state='active', ids=None, return_fields=None) async

The item's column values.

Parameters:

Name	Type	Description	Default
board_id	int	The board's unique identifier.	required
column_id	str	The column's unique identifier.	required
column_values	Iterable[str]	The column values to search items by.	required
monday_credentials	MondayCredentials	Credentials to use for authentication with Monday.	required
limit	int	Number of items to get.	None
page	int	Page number to get, starting at 1.	1
column_type	str	The column type.	None
state	State	The state of the item (all / active / archived / deleted), the default is active.	'active'
ids	Iterable[str]	A list of column ids to return.	None
return_fields	Iterable[str]	Subset the return fields (as snake_case); defaults to fields listed in configs/query/*.json.	None

Returns:

Type	Description
Dict[str, Any]	A dict of the returned fields.

Source code in prefect_monday/items_by_multiple_column_values.py

@task
async def query_items_by_multiple_column_values_column_values(
    board_id: int,
    column_id: str,
    column_values: Iterable[str],
    monday_credentials: MondayCredentials,
    limit: int = None,
    page: int = 1,
    column_type: str = None,
    state: graphql_schema.State = "active",
    ids: Iterable[str] = None,
    return_fields: Iterable[str] = None,
) -> Dict[str, Any]:
    """
    The item's column values.

    Args:
        board_id: The board's unique identifier.
        column_id: The column's unique
            identifier.
        column_values: The column values to
            search items by.
        monday_credentials: Credentials to use for authentication with Monday.
        limit: Number of items to get.
        page: Page number to get, starting at 1.
        column_type: The column type.
        state: The state of the item (all /
            active / archived / deleted), the default is active.
        ids: A list of column ids to return.
        return_fields: Subset the return fields (as snake_case); defaults to
            fields listed in configs/query/*.json.

    Returns:
        A dict of the returned fields.
    """
    op = Operation(graphql_schema.Query)
    op_selection = op.items_by_multiple_column_values(
        **strip_kwargs(
            board_id=board_id,
            column_id=column_id,
            column_values=column_values,
            limit=limit,
            page=page,
            column_type=column_type,
            state=state,
        )
    ).column_values(
        **strip_kwargs(
            ids=ids,
        )
    )

    op_stack = (
        "items_by_multiple_column_values",
        "column_values",
    )
    op_selection = _subset_return_fields(
        op_selection, op_stack, return_fields, return_fields_defaults
    )

    result = await _execute_graphql_op(op, monday_credentials)
    return result["items_by_multiple_column_values"]["column_values"]

query_items_by_multiple_column_values_creator(board_id, column_id, column_values, monday_credentials, limit=None, page=1, column_type=None, state='active', return_fields=None) async

The item's creator.

Parameters:

Name	Type	Description	Default
board_id	int	The board's unique identifier.	required
column_id	str	The column's unique identifier.	required
column_values	Iterable[str]	The column values to search items by.	required
monday_credentials	MondayCredentials	Credentials to use for authentication with Monday.	required
limit	int	Number of items to get.	None
page	int	Page number to get, starting at 1.	1
column_type	str	The column type.	None
state	State	The state of the item (all / active / archived / deleted), the default is active.	'active'
return_fields	Iterable[str]	Subset the return fields (as snake_case); defaults to fields listed in configs/query/*.json.	None

Returns:

Type	Description
Dict[str, Any]	A dict of the returned fields.

Source code in prefect_monday/items_by_multiple_column_values.py

@task
async def query_items_by_multiple_column_values_creator(
    board_id: int,
    column_id: str,
    column_values: Iterable[str],
    monday_credentials: MondayCredentials,
    limit: int = None,
    page: int = 1,
    column_type: str = None,
    state: graphql_schema.State = "active",
    return_fields: Iterable[str] = None,
) -> Dict[str, Any]:
    """
    The item's creator.

    Args:
        board_id: The board's unique identifier.
        column_id: The column's unique
            identifier.
        column_values: The column values to
            search items by.
        monday_credentials: Credentials to use for authentication with Monday.
        limit: Number of items to get.
        page: Page number to get, starting at 1.
        column_type: The column type.
        state: The state of the item (all /
            active / archived / deleted), the default is active.
        return_fields: Subset the return fields (as snake_case); defaults to
            fields listed in configs/query/*.json.

    Returns:
        A dict of the returned fields.
    """
    op = Operation(graphql_schema.Query)
    op_selection = op.items_by_multiple_column_values(
        **strip_kwargs(
            board_id=board_id,
            column_id=column_id,
            column_values=column_values,
            limit=limit,
            page=page,
            column_type=column_type,
            state=state,
        )
    ).creator(**strip_kwargs())

    op_stack = (
        "items_by_multiple_column_values",
        "creator",
    )
    op_selection = _subset_return_fields(
        op_selection, op_stack, return_fields, return_fields_defaults
    )

    result = await _execute_graphql_op(op, monday_credentials)
    return result["items_by_multiple_column_values"]["creator"]

query_items_by_multiple_column_values_group(board_id, column_id, column_values, monday_credentials, limit=None, page=1, column_type=None, state='active', return_fields=None) async

The group that contains this item.

Parameters:

Name	Type	Description	Default
board_id	int	The board's unique identifier.	required
column_id	str	The column's unique identifier.	required
column_values	Iterable[str]	The column values to search items by.	required
monday_credentials	MondayCredentials	Credentials to use for authentication with Monday.	required
limit	int	Number of items to get.	None
page	int	Page number to get, starting at 1.	1
column_type	str	The column type.	None
state	State	The state of the item (all / active / archived / deleted), the default is active.	'active'
return_fields	Iterable[str]	Subset the return fields (as snake_case); defaults to fields listed in configs/query/*.json.	None

Returns:

Type	Description
Dict[str, Any]	A dict of the returned fields.

Source code in prefect_monday/items_by_multiple_column_values.py

@task
async def query_items_by_multiple_column_values_group(
    board_id: int,
    column_id: str,
    column_values: Iterable[str],
    monday_credentials: MondayCredentials,
    limit: int = None,
    page: int = 1,
    column_type: str = None,
    state: graphql_schema.State = "active",
    return_fields: Iterable[str] = None,
) -> Dict[str, Any]:
    """
    The group that contains this item.

    Args:
        board_id: The board's unique identifier.
        column_id: The column's unique
            identifier.
        column_values: The column values to
            search items by.
        monday_credentials: Credentials to use for authentication with Monday.
        limit: Number of items to get.
        page: Page number to get, starting at 1.
        column_type: The column type.
        state: The state of the item (all /
            active / archived / deleted), the default is active.
        return_fields: Subset the return fields (as snake_case); defaults to
            fields listed in configs/query/*.json.

    Returns:
        A dict of the returned fields.
    """
    op = Operation(graphql_schema.Query)
    op_selection = op.items_by_multiple_column_values(
        **strip_kwargs(
            board_id=board_id,
            column_id=column_id,
            column_values=column_values,
            limit=limit,
            page=page,
            column_type=column_type,
            state=state,
        )
    ).group(**strip_kwargs())

    op_stack = (
        "items_by_multiple_column_values",
        "group",
    )
    op_selection = _subset_return_fields(
        op_selection, op_stack, return_fields, return_fields_defaults
    )

    result = await _execute_graphql_op(op, monday_credentials)
    return result["items_by_multiple_column_values"]["group"]

query_items_by_multiple_column_values_parent_item(board_id, column_id, column_values, monday_credentials, limit=None, page=1, column_type=None, state='active', return_fields=None) async

The parent item of a subitem.

Parameters:

Name	Type	Description	Default
board_id	int	The board's unique identifier.	required
column_id	str	The column's unique identifier.	required
column_values	Iterable[str]	The column values to search items by.	required
monday_credentials	MondayCredentials	Credentials to use for authentication with Monday.	required
limit	int	Number of items to get.	None
page	int	Page number to get, starting at 1.	1
column_type	str	The column type.	None
state	State	The state of the item (all / active / archived / deleted), the default is active.	'active'
return_fields	Iterable[str]	Subset the return fields (as snake_case); defaults to fields listed in configs/query/*.json.	None

Returns:

Type	Description
Dict[str, Any]	A dict of the returned fields.

Source code in prefect_monday/items_by_multiple_column_values.py

@task
async def query_items_by_multiple_column_values_parent_item(
    board_id: int,
    column_id: str,
    column_values: Iterable[str],
    monday_credentials: MondayCredentials,
    limit: int = None,
    page: int = 1,
    column_type: str = None,
    state: graphql_schema.State = "active",
    return_fields: Iterable[str] = None,
) -> Dict[str, Any]:
    """
    The parent item of a subitem.

    Args:
        board_id: The board's unique identifier.
        column_id: The column's unique
            identifier.
        column_values: The column values to
            search items by.
        monday_credentials: Credentials to use for authentication with Monday.
        limit: Number of items to get.
        page: Page number to get, starting at 1.
        column_type: The column type.
        state: The state of the item (all /
            active / archived / deleted), the default is active.
        return_fields: Subset the return fields (as snake_case); defaults to
            fields listed in configs/query/*.json.

    Returns:
        A dict of the returned fields.
    """
    op = Operation(graphql_schema.Query)
    op_selection = op.items_by_multiple_column_values(
        **strip_kwargs(
            board_id=board_id,
            column_id=column_id,
            column_values=column_values,
            limit=limit,
            page=page,
            column_type=column_type,
            state=state,
        )
    ).parent_item(**strip_kwargs())

    op_stack = (
        "items_by_multiple_column_values",
        "parent_item",
    )
    op_selection = _subset_return_fields(
        op_selection, op_stack, return_fields, return_fields_defaults
    )

    result = await _execute_graphql_op(op, monday_credentials)
    return result["items_by_multiple_column_values"]["parent_item"]

query_items_by_multiple_column_values_subscribers(board_id, column_id, column_values, monday_credentials, limit=None, page=1, column_type=None, state='active', return_fields=None) async

The pulses's subscribers.

Parameters:

Name	Type	Description	Default
board_id	int	The board's unique identifier.	required
column_id	str	The column's unique identifier.	required
column_values	Iterable[str]	The column values to search items by.	required
monday_credentials	MondayCredentials	Credentials to use for authentication with Monday.	required
limit	int	Number of items to get.	None
page	int	Page number to get, starting at 1.	1
column_type	str	The column type.	None
state	State	The state of the item (all / active / archived / deleted), the default is active.	'active'
return_fields	Iterable[str]	Subset the return fields (as snake_case); defaults to fields listed in configs/query/*.json.	None

Returns:

Type	Description
Dict[str, Any]	A dict of the returned fields.

Source code in prefect_monday/items_by_multiple_column_values.py

@task
async def query_items_by_multiple_column_values_subscribers(
    board_id: int,
    column_id: str,
    column_values: Iterable[str],
    monday_credentials: MondayCredentials,
    limit: int = None,
    page: int = 1,
    column_type: str = None,
    state: graphql_schema.State = "active",
    return_fields: Iterable[str] = None,
) -> Dict[str, Any]:
    """
    The pulses's subscribers.

    Args:
        board_id: The board's unique identifier.
        column_id: The column's unique
            identifier.
        column_values: The column values to
            search items by.
        monday_credentials: Credentials to use for authentication with Monday.
        limit: Number of items to get.
        page: Page number to get, starting at 1.
        column_type: The column type.
        state: The state of the item (all /
            active / archived / deleted), the default is active.
        return_fields: Subset the return fields (as snake_case); defaults to
            fields listed in configs/query/*.json.

    Returns:
        A dict of the returned fields.
    """
    op = Operation(graphql_schema.Query)
    op_selection = op.items_by_multiple_column_values(
        **strip_kwargs(
            board_id=board_id,
            column_id=column_id,
            column_values=column_values,
            limit=limit,
            page=page,
            column_type=column_type,
            state=state,
        )
    ).subscribers(**strip_kwargs())

    op_stack = (
        "items_by_multiple_column_values",
        "subscribers",
    )
    op_selection = _subset_return_fields(
        op_selection, op_stack, return_fields, return_fields_defaults
    )

    result = await _execute_graphql_op(op, monday_credentials)
    return result["items_by_multiple_column_values"]["subscribers"]

query_items_by_multiple_column_values_updates(board_id, column_id, column_values, monday_credentials, limit=None, page=1, column_type=None, state='active', updates_limit=25, updates_page=1, return_fields=None) async

The item's updates.

Parameters:

Name	Type	Description	Default
board_id	int	The board's unique identifier.	required
column_id	str	The column's unique identifier.	required
column_values	Iterable[str]	The column values to search items by.	required
monday_credentials	MondayCredentials	Credentials to use for authentication with Monday.	required
limit	int	Number of items to get.	None
page	int	Page number to get, starting at 1.	1
column_type	str	The column type.	None
state	State	The state of the item (all / active / archived / deleted), the default is active.	'active'
updates_limit	int	Number of items to get, the default is 25.	25
updates_page	int	Page number to get, starting at 1.	1
return_fields	Iterable[str]	Subset the return fields (as snake_case); defaults to fields listed in configs/query/*.json.	None

Returns:

Type	Description
Dict[str, Any]	A dict of the returned fields.

Source code in prefect_monday/items_by_multiple_column_values.py

@task
async def query_items_by_multiple_column_values_updates(
    board_id: int,
    column_id: str,
    column_values: Iterable[str],
    monday_credentials: MondayCredentials,
    limit: int = None,
    page: int = 1,
    column_type: str = None,
    state: graphql_schema.State = "active",
    updates_limit: int = 25,
    updates_page: int = 1,
    return_fields: Iterable[str] = None,
) -> Dict[str, Any]:
    """
    The item's updates.

    Args:
        board_id: The board's unique identifier.
        column_id: The column's unique
            identifier.
        column_values: The column values to
            search items by.
        monday_credentials: Credentials to use for authentication with Monday.
        limit: Number of items to get.
        page: Page number to get, starting at 1.
        column_type: The column type.
        state: The state of the item (all /
            active / archived / deleted), the default is active.
        updates_limit: Number of items to get, the default is 25.
        updates_page: Page number to get, starting at 1.
        return_fields: Subset the return fields (as snake_case); defaults to
            fields listed in configs/query/*.json.

    Returns:
        A dict of the returned fields.
    """
    op = Operation(graphql_schema.Query)
    op_selection = op.items_by_multiple_column_values(
        **strip_kwargs(
            board_id=board_id,
            column_id=column_id,
            column_values=column_values,
            limit=limit,
            page=page,
            column_type=column_type,
            state=state,
        )
    ).updates(
        **strip_kwargs(
            limit=updates_limit,
            page=updates_page,
        )
    )

    op_stack = (
        "items_by_multiple_column_values",
        "updates",
    )
    op_selection = _subset_return_fields(
        op_selection, op_stack, return_fields, return_fields_defaults
    )

    result = await _execute_graphql_op(op, monday_credentials)
    return result["items_by_multiple_column_values"]["updates"]