ADF Dataflow error Parameter stream has parsing errors Parameter(s) with errors: testParam. Not honoring the datatype of parameter(s) could be one of the causes.

Santhi Dhanuskodi 125 Reputation points
2024-03-19T11:52:15.4+00:00

Hi,

I am passing API response to a dataflow to write to a log file.

My api response is

"'<?xml version="1.0" encoding="UTF-8"?>\n<response success="true">\n <messages>\n <message key="warning-unmapped-level">Warning: No data was imported for rows : xyz,abc,def</message>\n </messages>\n</response>\n'"

but my pipeline throws error

Job failed due to reason: com.microsoft.dataflow.Issues: DF-DSL-002 - Parameter stream has parsing errors Parameter(s) with errors: API_Response,<response success, <message key. Not honoring the datatype of parameter(s) could be one of the causes.

I tried to esape '' and '\n' before sending to dataflow....they couldnt be escaped. it has the same text even after trying that. Not able to find whats the root cause?

If I try the same text in dataflow debugging, I can see data preview working fine with no errors. The error appears while running the data flow.

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,489 questions
{count} votes

1 answer

Sort by: Most helpful
  1. BhargavaGunnam-MSFT 25,881 Reputation points Microsoft Employee
    2024-03-19T17:00:30.9533333+00:00

    Hello Santhi Dhanuskodi,

    By design pipeline parameters add extra double and single quotes for string passed.

    Workaround is to replace the quote in the string with blackslash single quote( ' ) when taking pipeline parameter in dataflow activity.

    Please check and see if it resolves the issue.

    0 comments No comments