dynamic expression

Question

dynamic expression

arkiboys 9,706

inside the ADF web activity Body, I have this sample json:

[
{
"id": "007"
"subject": "data/name",
"topic": null,
"eventType": "statusupdated",
"eventTime": "2022-07-26T10:01:00.9584103Z",
"data": {
"firstName": "farshad",
"company": "some"
},
"dataVersion": "1.0",
"metadataVersion": null
}
]

--------------------------

Question:
How is it possible to have dynamic expression inside this sample .json
for example, if I use the following inside the id, the expression does not error but it errors when I run the web activity:

[
{
"id": @{guid()}
"subject": "data/name",
"topic": null,
"eventType": "statusupdated",
"eventTime": "2022-07-26T10:01:00.9584103Z",
"data": {
"firstName": "somename",
"company": "some"
},
"dataVersion": "1.0",
"metadataVersion": null
}
]

Subashri Vasudevan 11,306 Reputation points Volunteer Moderator

2022-07-26T09:11:23.333+00:00

Hi,

You can save the sample payload in a string variable and try to replace id value using below code

@replace(variable, "007", concat('"', @{guid()}, '"'))

Please try and let us know.

Answer accepted by question author

1 additional answer

Your answer

Subashri Vasudevan 11,306 Reputation points Volunteer Moderator

2022-07-26T09:11:23.333+00:00

Hi,

You can save the sample payload in a string variable and try to replace id value using below code

@replace(variable, "007", concat('"', @{guid()}, '"'))

Please try and let us know.

Answer 1

AnnuKumari-MSFT 34,566 Microsoft Employee Moderator

Hi @arkiboys ,

Thanks for using Microsoft Q&A platform and thanks for posting your question.

As I understand , you are trying to run a web activity and passing the sample json as request body in the web activity. However, it's failing when you are passing the values dynamically. Please let me know if my understanding is incorrect.

Could you please check if after "id": @{guid()} , is ',' missing in your json code as it looks.

I tried to reproduce your scenario by calling a web activity to run another pipeline by passing the parameter value dynamically, it worked well for me. Kindly take a look at the image:

Hope this will help. Please let us know if any further queries.

------------------------------

Please don't forget to click on or upvote button whenever the information provided helps you.
Original posters help the community find answers faster by identifying the correct answer. Here is how
Want a reminder to come back and check responses? Here is how to subscribe to a notification
If you are interested in joining the VM program and help shape the future of Q&A: Here is how you can be part of Q&A Volunteer Moderators

arkiboys 9,706 Reputation points

2022-07-26T10:05:04.227+00:00

do you know how I can use one of the existing functions inside my .json as asked in my post?
i.e. @George Wang ()

thank you
AnnuKumari-MSFT 34,566 Reputation points Microsoft Employee Moderator

2022-07-26T10:18:33.337+00:00

@arkiboys ,
Can you please share What is the error you are getting?
arkiboys 9,706 Reputation points

2022-07-26T10:26:06.66+00:00

[
{
"id":@{guid()}
, "subject": "data/company"
, "topic": null, "eventType": "statusupdated"
, "eventTime": "2022-07-26T09:41:00.9584103Z", "data": { "firstName": "testname", "salary": "test" }, "dataVersion": "1.0", "metadataVersion": null
}
]

error when debug is run:

{"error":{"code":"InvalidRequestContent","message":"The request content is not valid and could not be deserialized: 'Unexpected character encountered while parsing value: b. Path '[0].id', line 2, position 5.'."}}
AnnuKumari-MSFT 34,566 Reputation points Microsoft Employee Moderator

2022-07-26T16:36:31.58+00:00

Hi @arkiboys ,

@George Wang () function will return output in alphanumeric format ,for example: '2702c4ac-54fd-4d5c-8953-f21befa1c4f2' . It should be enclosed within double quotes.

Kindly try "id":"@{guid()}" instead of "id":@{guid()}

------------------

If the above answer helped, please do consider clicking Accept Answer and Up-Vote for the same as accepted answers help community as well.

Answer 2

arkiboys 9,706

can I not somehow add the dynamic expression inside the .json?

Share via

dynamic expression

1 additional answer

Your answer