Issue with Dynamic Schema mapping in azure data factory for JSON Data

Question

Hi Team,

When I am doing dynamic schema mapping for Json data in ADF, that expression is showing me below error. Please let me know what I am missing here and that's the way I am doing. My Source has multiple fields and it is showing the same error for all then I included only one field but still error remains the same may be I am missing something. Could you please let me know. Many thanks.

I am looking forward your response.

Answer 1

Hi pankaj chaturvedi,

Thanks for using Microsoft Q&A forum and posting your query.
Looks like you are wrapping the JSON payload in single quotes which is resulting in the error message. Could you please remove those single quotes as shown in below GIF and see if that helps. Once it is removed try to validate your pipeline and see if you notice any more errors.

Hope this info helps. Let us know how it goes.

Thanks