Not able to pass parameter in azure function activity body inside adf

Question

I am trying to pass parameter to azure function activity and I am getting error.

This is the json.

@markus.bohland@hotmail.de {"{
"job_name": "job1",
"source_table":"xyz",
"target_table": "abc",
"start_time": "2009-01-01 00:00:00.000",
"end_time": "2009-01-01 00:00:00.000",
"count": "activity('Data flow1').output.runStatus.metrics.sink1.rowsWritten",
"layer": "export",
"load_type":"full load",
"load_pattern":"insert",
"extract_query":"variables('Extract Query')",
"load_query":"select * from abc",
"default_engine":"adf",
"status":"success"}"}

This is body of azure function

Can somebody correct me what I am doing wrong?

Answer 1

Hello @Aditya Raj and welcome to Microsoft Q&A.

It looks like the syntax got tangled up. I have cleaned it up below:

@concat('{  
"job_name": "job1",  
"source_table":"xyz",  
"target_table": "abc",  
"start_time": "2009-01-01 00:00:00.000",  
"end_time": "2009-01-01 00:00:00.000",  
"count": "'  
,activity('Data flow1').output.runStatus.metrics.sink1.rowsWritten  
,'",  
"layer": "export",  
"load_type":"full load",  
"load_pattern":"insert",  
"extract_query":"',  
variables('Extract Query'),  
'",  
"load_query":"select * from abc",  
"default_engine":"adf",  
"status":"success"}')  

The changes I made were:

• concat is a function, so the outermost { } -> ( )
• separated the interior into string literals and expressions, so outermost " " -> ' '
• By bringing the expressions out of the literal, added the '", sections