Power BI Connector for Monday

Build 24.0.9060

Tags

Get a collection of tags.

Table-Specific Information

SELECT

The connector uses the Monday API to process some of the filters. The connector processes other filters client-side within the connector. You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false in which case any search criteria that refers to other columns will cause inconsistent data.

  • Id supports the '=','IN' comparison operators.
  • IsPrivate supports the '=' comparison operator.
For example, the following queries are processed server side:
SELECT * FROM Tags WHERE IsPrivate = true
SELECT * FROM Tags WHERE IsPrivate = false
SELECT * FROM Tags WHERE Id = '13327214'
SELECT * FROM Tags WHERE Id IN ('13327214', '13327217')

INSERT

The following inputs can be used in INSERT statements:

Name, BoardId

INSERT INTO Tags (Name) VALUES ('TestTagName')

Columns

Name Type ReadOnly References Description
Id [KEY] String False

The tag's unique identifier.

Color String False

The tag's color.

Name String False

The tag's name.

IsPrivate Bool False

Whether or not the tag is private.

BoardId String False

A private board id to filter by or create a tag at (not needed for public boards).

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060