Use of variables within Post message body of a Copy Data Activity

Question

Use of variables within Post message body of a Copy Data Activity

Corey Amoruso 36

I have a similar question to the post found here: https://learn.microsoft.com/en-us/answers/questions/157301/azure-data-factory-web-activity-body.html

My scenario is just slightly different as I am using a Copy Data activity connected to a Rest Data Set rather than the Web Activity itself. I have two variables that I would like to use in the Post message body but they do not seem to be getting translated properly. Is there a way to accomplish what I am trying to do here? According to that linked post, the syntax I am using should work.

Pipeline Variables:

Message Body:

Activity Output:

Jadhav, Karan 10

Hi, I am facing the same issue but I am using copydata functionality of rest identity where I want get input data from different pipeline and then use concat to combine 2 different input values into one json data and want to pass it in the request body. However, my input json consists of "". Can you please help as I keep getting on the same error that json data is invalid.


Output from source:

 
{
    "source": {
        "type": "RestSource",
        "httpRequestTimeout": "00:01:40",
        "requestInterval": "00.00:00:00.010",
        "requestMethod": "POST",
        "requestBody": "{  \n\"commodity_type\":gas,\"token_id\":2Tx2pSLXOCzEcrxxiiJtsSZrcmM4tUtuZ9QG2neQjtqLVoWAUNUZhkZHyuO7U1MUVhfWvrtf8ef36bTyBZBF84rXvKh4dBYToEpS9BQcUdcl1Z91z_sfAOHoOW80c2ilJtTnu-A8nThSmwEldFlXdFXPSzHJ9XLXDKiqqdXHlihMV_9mkbto4Izq1FuZG-3kQg-sNZ39eZXwIVJCU2CY96zeRNHkxbU3NspWumwkkvJyPC0INtQEqC9Wc7N45LJNYLim2N_19JdeLo_xhCa3YBxo-t1AFX6T8iR5galaK9BTRgj4eVwkEWEMpuGZIUnRJVYSfl6V8unlNg3sRETQUxKB6e7o8YGfO2zOjnJiUy_ScOReFad5-GEogM7Yz6JHWHR4hp9J_iCoqjDRgqpUZElq2jUItdv5dgJrEvYbueI}",
        "paginationRules": {
            "supportRFC5988": "true"
        }
    }

 

In our request body, the copy data is wrapping around the json value which we generate "". So, it becomes difficult for us to get the desired input. Instead the input should have been something like this "requestBody": {  \n\"commodity_type\":gas,\"token_id\":2Tx2pSLXOCzEcrxxiiJtsSZrcmM4tUtuZ9QG2neQjtqLVoWAUNUZhkZHyuO7U1MUVhfWvrtf8ef36bTyBZBF84rXvKh4dBYToEpS9BQcUdcl1Z91z_sfAOHoOW80c2ilJtTnu-A8nThSmwEldFlXdFXPSzHJ9XLXDKiqqdXHlihMV_9mkbto4Izq1FuZG-3kQg-sNZ39eZXwIVJCU2CY96zeRNHkxbU3NspWumwkkvJyPC0INtQEqC9Wc7N45LJNYLim2N_19JdeLo_xhCa3YBxo-t1AFX6T8iR5galaK9BTRgj4eVwkEWEMpuGZIUnRJVYSfl6V8unlNg3sRETQUxKB6e7o8YGfO2zOjnJiUy_ScOReFad5-GEogM7Yz6JHWHR4hp9J_iCoqjDRgqpUZElq2jUItdv5dgJrEvYbueI}.
"commodity_type":',pipeline().parameters.commodity_type,  
',','token_id":',pipeline().parameters.token_id,'}' ) 
Thanks,

Accepted answer

0 additional answers

Your answer

Jadhav, Karan 10 Reputation points

2023-01-13T19:09:14.8633333+00:00

Hi, I am facing the same issue but I am using copydata functionality of rest identity where I want get input data from different pipeline and then use concat to combine 2 different input values into one json data and want to pass it in the request body. However, my input json consists of "". Can you please help as I keep getting on the same error that json data is invalid. Output from source: { "source": { "type": "RestSource", "httpRequestTimeout": "00:01:40", "requestInterval": "00.00:00:00.010", "requestMethod": "POST", "requestBody": "{ \n\"commodity_type\":gas,\"token_id\":2Tx2pSLXOCzEcrxxiiJtsSZrcmM4tUtuZ9QG2neQjtqLVoWAUNUZhkZHyuO7U1MUVhfWvrtf8ef36bTyBZBF84rXvKh4dBYToEpS9BQcUdcl1Z91z_sfAOHoOW80c2ilJtTnu-A8nThSmwEldFlXdFXPSzHJ9XLXDKiqqdXHlihMV_9mkbto4Izq1FuZG-3kQg-sNZ39eZXwIVJCU2CY96zeRNHkxbU3NspWumwkkvJyPC0INtQEqC9Wc7N45LJNYLim2N_19JdeLo_xhCa3YBxo-t1AFX6T8iR5galaK9BTRgj4eVwkEWEMpuGZIUnRJVYSfl6V8unlNg3sRETQUxKB6e7o8YGfO2zOjnJiUy_ScOReFad5-GEogM7Yz6JHWHR4hp9J_iCoqjDRgqpUZElq2jUItdv5dgJrEvYbueI}", "paginationRules": { "supportRFC5988": "true" } } In our request body, the copy data is wrapping around the json value which we generate "". So, it becomes difficult for us to get the desired input. Instead the input should have been something like this "requestBody": { \n\"commodity_type\":gas,\"token_id\":2Tx2pSLXOCzEcrxxiiJtsSZrcmM4tUtuZ9QG2neQjtqLVoWAUNUZhkZHyuO7U1MUVhfWvrtf8ef36bTyBZBF84rXvKh4dBYToEpS9BQcUdcl1Z91z_sfAOHoOW80c2ilJtTnu-A8nThSmwEldFlXdFXPSzHJ9XLXDKiqqdXHlihMV_9mkbto4Izq1FuZG-3kQg-sNZ39eZXwIVJCU2CY96zeRNHkxbU3NspWumwkkvJyPC0INtQEqC9Wc7N45LJNYLim2N_19JdeLo_xhCa3YBxo-t1AFX6T8iR5galaK9BTRgj4eVwkEWEMpuGZIUnRJVYSfl6V8unlNg3sRETQUxKB6e7o8YGfO2zOjnJiUy_ScOReFad5-GEogM7Yz6JHWHR4hp9J_iCoqjDRgqpUZElq2jUItdv5dgJrEvYbueI}. "commodity_type":',pipeline().parameters.commodity_type, ',','token_id":',pipeline().parameters.token_id,'}' ) Thanks,

Answer 1

HimanshuSinha-msft 19,486 Microsoft Employee Moderator

Hello @Corey Amoruso ,

Thanks for the ask and using the Microsoft Q&A platform .

The below expression should work out for you . The idea is to build the JSON using the concat function.

@concat( '{  
"UpdatedOn":',variables('LastRun'),  
',','MemberIDs":',variables('Memberids'),'}' )

I did tried this on a setvariable acitivity and it worked fine for me . Please see the animation below Please let me how it goes .

Thanks
Himanshu
Please do consider to click on "Accept Answer" and "Up-vote" on the post that helps you, as it can be beneficial to other community members

Corey Amoruso 36 Reputation points

2021-02-15T21:40:49.707+00:00

Thank you very much. This did work for me.

A note for anyone else following this, make sure to eliminate any white space in the message body before calling @markus.bohland@hotmail.de , I copied the suggested syntax above but accidentally left a space at the beginning of my message body, it did not work until I made sure to trim the white space at the beginning.
HimanshuSinha-msft 19,486 Reputation points Microsoft Employee Moderator

2021-02-16T20:39:40.233+00:00

Hello @Corey Amoruso · ,
It was great to know that you were able to get to a resolution . We expect you to keep using this forum and also motivate others to do that same .
You can always help other community members by answering to their queries .
Thanks
Himanshu

Share via

Use of variables within Post message body of a Copy Data Activity

0 additional answers

Your answer