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
- 1.9K Product Ideas
- 1.9K Ideas Exchange
- 1.6K Connect
- 1.3K Connectors
- 302 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 2.9K Transform
- 104 SQL DataFlows
- 637 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 761 Beast Mode
- 65 App Studio
- 42 Variables
- 703 Automate
- 182 Apps
- 458 APIs & Domo Developer
- 53 Workflows
- 10 DomoAI
- 39 Predict
- 16 Jupyter Workspaces
- 23 R & Python Tiles
- 401 Distribute
- 116 Domo Everywhere
- 277 Scheduled Reports
- 8 Software Integrations
- 132 Manage
- 129 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 111 Community Announcements
- 4.8K Archive