filter in custom connector google analytics

Hi There,
Am trying to create a google analytics connector dataset by applying multiple dimension filter with 'and' condition for the dimensions however am getting 'invalid dimension format error'. Hence could you please review the syntax and let me know whats incorrect here.
- The filter should contain ‘and’ clause – usually it’s the semicolon (;) but when I apply the semicolon, DOMO gives me an error.
- However if I replace that with comma (,) which is used for ‘OR’ clause it is just working fine.
- The data is not specific to what am looking for – I need the filter with ‘and’ condition and not ‘or’ condition.
{
"dimensionFilterClauses": [
{
"filters": [
{
"dimensionName": "ga:pagePathLevel1",
"operator": "EXACT",
"expressions": [
"/en/" ]}
;
{"dimensionName": "ga:pagePathLevel2",
"operator": "REGEXP",
"expressions": ["^/blog/.\/*"]} ]
}
]
}
Best Answer
-
I had raised a DOMO case in the help center to see if they could help here. I just got the correct syntax from them.
Here is the correct syntax that they recommend me to use:
{
"dimensionFilterClauses": [
{
"operator": "AND",
"filters": [
{
"dimensionName": "ga:pagePathLevel1",
"operator": "EXACT",
"expressions": [
"/en/" ]}
,
{"dimensionName": "ga:pagePathLevel2",
"operator": "REGEXP",
"expressions": ["blog"]} ]
}
]
}
]
}
Regards
0
Answers
-
I had raised a DOMO case in the help center to see if they could help here. I just got the correct syntax from them.
Here is the correct syntax that they recommend me to use:
{
"dimensionFilterClauses": [
{
"operator": "AND",
"filters": [
{
"dimensionName": "ga:pagePathLevel1",
"operator": "EXACT",
"expressions": [
"/en/" ]}
,
{"dimensionName": "ga:pagePathLevel2",
"operator": "REGEXP",
"expressions": ["blog"]} ]
}
]
}
]
}
Regards
0
Categories
- All Categories
- 2K Product Ideas
- 2K Ideas Exchange
- 1.6K Connect
- 1.3K Connectors
- 311 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 3.8K Transform
- 657 Datasets
- 115 SQL DataFlows
- 2.2K Magic ETL
- 814 Beast Mode
- 3.3K Visualize
- 2.5K Charting
- 81 App Studio
- 45 Variables
- 775 Automate
- 190 Apps
- 481 APIs & Domo Developer
- 81 Workflows
- 23 Code Engine
- 40 AI and Machine Learning
- 20 AI Chat
- 1 AI Playground
- 1 AI Projects and Models
- 18 Jupyter Workspaces
- 410 Distribute
- 120 Domo Everywhere
- 280 Scheduled Reports
- 10 Software Integrations
- 144 Manage
- 140 Governance & Security
- 8 Domo Community Gallery
- 48 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 114 Community Announcements
- 4.8K Archive