Google Analytics API sends ga:transactionid as a string although parses it as an integer

user16346
Member
in Connectors
Hello All!
I faced an issue, while doing the report via BI: Failed to parse data 'B10109393939' for column Transaction id.
I tried to fix it by applying a filter
{
"dimensionFilterClauses": [
{
"filters" : [
{
"dimensionName" : "ga:transactionid",
"operator":"NUMERIC_GREATER_THAN",
"expressions": [
"0"
]
}
]
}
]
But it didn't help me much, because the goal is to include all transaction IDs and then transform Transaction id column to the string type.
Could anyone let me know how to change the ga:transactionid dimension request so that it won't be parsed as an integer?
Thank you very much!
0
Comments
-
Hi @user16346
Is it possible for your GA instance to contain transaction IDs which start with a character or should it be assumed that it's always going to be a number?
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**0
Categories
- All Categories
- Product Ideas
- 2K Ideas Exchange
- Connect
- 1.3K Connectors
- 308 Workbench
- 7 Cloud Amplifier
- 10 Federated
- Transform
- 661 Datasets
- 117 SQL DataFlows
- 2.2K Magic ETL
- 819 Beast Mode
- Visualize
- 2.6K Charting
- 85 App Studio
- 46 Variables
- Automate
- 193 Apps
- 483 APIs & Domo Developer
- 85 Workflows
- 23 Code Engine
- AI and Machine Learning
- 22 AI Chat
- 3 AI Projects and Models
- 18 Jupyter Workspaces
- Distribute
- 116 Domo Everywhere
- 282 Scheduled Reports
- 11 Software Integrations
- Manage
- 142 Governance & Security
- 9 Domo Community Gallery
- 49 Product Releases
- 13 Domo University
- Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 115 Community Announcements
- 5K Archive