Forum Discussion
deserializing string as json during copy step
I have a copy activity where the source is Salesforce and the sink is CosmosDB. Here is the source - hedge_data__c is a string field, but it's actually json. This is what how it shows up...
Hello,
Since this query is running against Salesforce, no idea of the syntax to treat this column as a json.
But you can use Data Flows instead, choose your table as a source and use "Parse" transformation for hedge_data__c column.
Or if you have already resolved it, please inform how you did it.
Best,
Manish