Retrieve percents fields as decimal from Google Ads report tables

[Alejandro Valdes]

Hi, I'm using a POST request to get the KeywordPerformanceReport info from Ads API. My problem is that some fields related to percents are in the format 'xx.xx%' an I need these fields as decimal. Also the null values are returned as the string '--'. I want to know if exist a way to config my request in order to retrieve the null as null and percents as decimal values. I think there is a way because when i use the default connector of Azure Data Factory to copy this data the fields have my desired format. I would appreciate any help.