👀 Views: 39 💬 Answers: 1 📅 Created: 2025-08-27

azure-data-factory json azure

I'm relatively new to this, so bear with me. I'm working on a personal project and I'm relatively new to this, so bear with me. I'm working with an scenario with my Azure Data Factory (ADF) pipeline where it fails to execute and throws an 'Invalid JSON' behavior when I use dynamic content to pass parameters to an activity. I'm using ADF version 2.0 and have set up a pipeline that reads from an Azure Blob Storage source and writes to an Azure SQL Database. My source JSON file looks like this: ```json { "records": [ {"id": 1, "name": "Alice"}, {"id": 2, "name": "Bob"} ] } ``` In my pipeline, I'm trying to use the `@json()` function to parse this JSON content within a Copy Data activity. Here's a snippet of the expression I'm using: ```json @json(activity('Get Blob Content').output.Content) ``` The 'Get Blob Content' activity successfully retrieves the content from the blob, and I can see the output in the debug view. However, when I run the pipeline, I get the following behavior message: ``` behavior code: InvalidJson behavior message: The content of the JSON is invalid. ``` I've checked the JSON format and it seems valid. I also tried using a simpler JSON structure, but the scenario continues. Additionally, I verified that the output from the 'Get Blob Content' activity is indeed the correct content type, and it shows as 'application/json'. I’m suspecting that there might be a question with how I’m attempting to parse or use the dynamic content. I've tried to explicitly convert it into a string and then back to JSON, but that doesn't resolve the scenario. Here's the expression I used for that: ```json @json(string(activity('Get Blob Content').output.Content)) ``` However, it still results in the same behavior. Has anyone experienced similar issues with dynamic JSON parsing in ADF? Any guidance on how to properly pass JSON data from one activity to another in Azure Data Factory would be greatly appreciated. My development environment is Ubuntu. Has anyone else encountered this? This is part of a larger service I'm building.