ConversionValue - wrong number format returned by the API

[Marcelo Siqueira]

Hi,

I'm trying to download a PRODUCT_PARTITION_REPORT, API version v201603, with the field ConversionValue. The download format is GZIPPED_CSV. I'm using the .NET library.

The API is returning values like "1,488.79", instead of "1488.79". Since I use the comma to split the report fields, this is breaking my parser routine.

Another user had the same problem about a year ago (https://groups.google.com/forum/#!msg/adwords-api/ZfRfo5XSfpM/_pltzkTxbNMJ). Is there a solution yet?

Thanks

[Joyce Lava]

Hello Marcelo,

Could you please provide the SOAP request and response that shows the value with comma and the clientCustomerId used as well? Please make sure to use reply privately to author option when responding.

Thanks,

Joyce, AdWords API Team

[Chirag]

Hello All,

Yes, I am also facing same issue while any field type is double, like for conversions more than 1000 I am facing same issue.

Please let me know, if there is the functionality.

Thanks,

[Joyce Lava]

Hello,

Could you please send me the example SOAP request/response or report definition that shows the field with Double data type with comma in the returned value? Please use reply privately to author when replying. 

[Anash P. Oommen (AdWords API Team)]

Hi Marcelo, Chirag,

I'll check with the team to see if this is an issue at our end. That said, the values are escaped properly with double quotes, so the CSV itself is well formed. You can use a csv parser library to parse these values correctly. E.g. Java has a library here.

Cheers,
Anash P. Oommen,
AdWords API Advisor.

[Chirag]

Hello Anash,

Yes, this worked for me.

Thanks for your input.