How to get CSV output from Look Up table activity

Question

How can we get CSV output from Look Up table and and Copy Data activity . I have Look activity followed by Copy Data The output from LookTable activity is below which is a JSON and we need in CSV format . Can some help me get this output please ?

{
	"count": 1,
	"value": [
		{
			"f_ID": 71431952,
			"f_Ctb": 8888,
			"f_isProtected": null
		}
	],
	"effectiveIntegrationRuntime": "selfhostedintegrationRuntime1",
	"billingReference": {
		"activityType": "PipelineActivity",
		"billableDuration": [
			{
				"meterType": "SelfhostedIR",
				"duration": 0.016666666666666666,
				"unit": "Hours"
			}
		],
		"totalBillableDuration": [
			{
				"meterType": "SelfhostedIR",
				"duration": 0.016666666666666666,
				"unit": "Hours"
			}
		]
	},
	"durationInQueue": {
		"integrationRuntimeQueue": 0
	}
}

Answer 1

@Sudarshan Kumar hi, You are right. If you want to read from a table and write to a file, copy data activity is the easiest option. Simply point your source to SQL table you want to lookup, and sink can be a CSV file in Azure storage. As per the q&a guidelines, original poster cannot accept his or her own answer. So I'm reposting your answer here, so that this thread can be accepted and closed.

You should use copy data activity directly.

Please accept this as answer and help the community with similar question. Thanks