How to change data type in SAP Data Services

[former_member592211]

I want to change a data type REAL to VARCHAR but i dont know where to change it. I cant change it in SAP Data Services and it is defined by default. I'm trying to get data from a rest web services but I get an error becaus Data Services trys to write "10d" into a REAL data type.

How can I change it?

I'm useing the openweathermap API and I want to change the icon data type.

[Rishabh_Awasthi · Accepted solution]

Hello Miguel
SOAP or REST whichever datastore you are using, go to the imported function and edit the response schema.
Otherwise while consuming the response after un-nesting the response add a query transform and use cast function to change the data type.

Regards,
Rishabh

[former_member592211 · Accepted solution]

Thanks this worked for me.