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

Reply
Highlighted
White Belt

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

 
Hello All!
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!

Highlighted
Major Red Belt

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 the heart icon**

**Did this solve your problem? Accept it as a solution!**
Announcements
Domopalooza 2021 Call for Presenters: We want to hear how Domo is revolutionizing the way you do business!

Click here to submit your story.